This is our general FAQ page where we’ve included the most common questions we received. Many of the answers apply to several of our tools. Click on the questions to see our answers.
OFX stands for Open Financial Exchange. It is an XML format used to import financial transactions into Quicken, QuickBooks, and other applications for reconciliation purposes. Our QIF to OFX Converter can help you create OFX, QBO, and QFX files. It creates these files locally (on your machine) which can be imported by these applications.
For tools that are Excel addins, MS Excel is required.
MS Works is not Excel and does not support add-ins.
Most of our tools are Excel Add-ins. The tools are supported under various versions of Excel, from Excel 2000 – 2013 for Windows. Several are also supported when using Excel 2011 on the Mac.
Not all addins will work when using all of these Excel versions. Some require features only available in newer Excel versions. Each of the tools’ home pages indicates the supported versions of Excel.
Some relatively unusual settings can impact loading add-ins, as they disable the ability to run them:
Excel 2003: Choose Tools | Macro | Security | Trusted Publishers and then make sure the two available check-boxes are checked.
Excel 2007: To see this setting, go to Excel Options from the Office button in the upper-left corner of Excel, then Trust Center, Trust Center Settings, Add-ins, then make sure all three of the options there are unchecked. Pick both Com addins and Excel addins from the pick list at the bottom of the windows, and then make sure none are loaded Except BRC Addins. Then restart Excel.
Excel 2010: Use steps similar to Excel 2007 to find the Trust Center Settings.
Excel 2013: Use steps similar to Excel 2007 to find the Trust Center Settings.
Excel 2011 Mac: Use steps similar to Excel 2003.
The message reads, “This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.“
This happens when VBA for applications is not installed with Office. It is installed by default in most cases. To resolve the situation, reinstall Office or Excel and install the Visual Basic for Application components.
Excel 2011 on the Mac is known to not install VBA by default.
Why do I get a prompt for a “BRConsulting” password when closing Excel or taking some other action in Excel?
This is an Excel bug that happens to some Excel uses at different points. It is no longer very common and is generally caused by virus checker’s that try to decompile the addin. This triggers Excel to put up a password prompt. The fix is to teach your virus checker to stop checking Excel addins for viruses in this way or to get a different virus checker that behaves properly as it interacts with Excel.
Privacy & Security
No. We don’t use your purchase information for any purpose except to process your order & to send you information (such as update notices) about the tool or tools you purchased.
Note if you get an update notice and want to opt out of them, just reply and indicate that.
Trying & Buying
Yes. New builds of our addins are currently offered free of charge.
To update your addin, download the latest version and install it on top of the older version of the tool while Excel is not running.
When using the Windows installer the default folder will be the same as the last place you installed the addin. Your product key and preferences are not lost during updates.
You may send a copy of the tool to anyone for trial use. Or, send a link to our site so they can download the free trial.
However, please do not share your product key. A product key is issued for each product purchased and is intended for one user. If you have multiple users who have access to the tools purchased, please purchase multiple copies. See the End User License Agreements (EULA) within each tool.
You may request a replacement key and we will automatically send you an email with your purchase history with the products you’ve purchased and the key for each product. To use this service you must have access to the original email used to make your purchases.
This is caused by entering the key into the wrong addin or mistyping the key.
The key is alpha-numeric & will contain both your name and a number, surrounded with Quotes, like “John Doe-1234567890”.
– Enter or paste everything between the quotes.
– Don’t includes spaces around the “-” character. “Tim – 1234567890” and “Tim-1234567890” are not the same thing.
– When using Windows, you can use Ctrl-C to copy the key from your email notification and Ctrl-V to paste it into the About dialog.
Spam blockers are the most common reason key codes aren’t received via email. If you have a junk email folder, check that for the confirmation email.
Also, to make sure you can receive email from email@example.com, add the email to your spam-blocker’s white list or to your address book.
If you need a replacement key, start here.
When you complete your purchase, you’ll immediately be sent a purchase confirmation receipt and & your new product key(s). These are sent via email to the email address you use when you place your order. You should receive the email within a few minutes, usually faster. If you do not see it in your inbox, check your spam folder.
Each is limited in some way. For example the IIF Transaction creator will create up to 100 transactions during its trial.
We accept major credit cards including Visa, MasterCard, and American Express.
No. The OFX file format doesn’t contain any fields for a category or for split detail information. However, you can use the QIF file format to include this information.
Yes. Use our QIF to OFX Converter to create QFX files, a type of OFX file that Quicken will import.
Yes. While there have been many claims that Quicken can’t import QIF files, or the import is limited to cash accounts, this is not true. When using our Excel to QIF Converter you can import transactions into most any account type including Checking and Credit Card accounts.
QIF stands for Quicken Interchange Format, and is a text-file-based standard for importing data into financial software. Many applications support QIF, including Quicken. Notably, QuickBooks does not import QIF files. Use the QIF to IIF Converter if you have QIF files you need to import into QuickBooks.
Yes. Our Excel to QIF Converter now supports import of security price history details as well as security account transactions.
Yes. While there have been many claims that Quicken can’t import QIF files, or the import is limited to cash accounts, this is not true. When using our Excel to QIF Converter, you can import transactions into most any account type including Checking and Credit Card accounts. This works for Quicken versions through at least 2015, though Quicken’s low-end Essentials appear to not have full QIF import features. Be sure to try the trial of the Excel to QIF Converter with your version of Quicken.
Yes, we’ve tested them with Quicken through 2015 and they fully support the latest versions. Tools that create QFX files, such as our QIF to OFX Converter work only with Intuit-supported versions of Quicken, which are typically the last three version years of Quicken.
QuickBooks does have some limits in the import area. This is a partial list of limitations:
– QuickBooks will import most transaction types, but not all. Paychecks & Sales Orders are two transaction types that can’t be imported.
– For those using Advanced Inventory, QuickBooks does not support Advanced Inventory fields for import, but also requires them to be filled out on transactions. To import you need to first turn off Advanced Inventory, then import, then turn it back on.
– QuickBooks won’t import custom fields on transactions.
– QuickBooks will import transactions using your home currency only.
– For Employee records, only basic information such as Name and Address and a few other fields common to other types of names can be imported.
– For Lists, such as Items, Customer, & Vendors, some lesser used and newer fields are not supported. These fields include credit card fields for names and units of measure, the MPN, and location information for items.
– QuickBooks Windows will import time records, but QB Mac will not.
QuickBooks can import most data using IIF files. Different types of IIF files can be created using our tools.
QuickBooks will import most types of financial transactions, time records, most types of list records, and budgets using IIF files.
We offer tools that can help you import import transactions (e.g. the IIF Transaction Creator, Transaction Copier, and QIF to IIF Converter), time records (using the XL Timesheet Link), and may types of lists (using the QB List Importer.) We don’t offer any tools that work with budgets.
QuickBooks will also import QBO files (a type of OFX file) for use in the online banking feature. Use our QIF to OFX Converter, OFX Cleaner, or the Excel to OFX Converter to create QBO files.
Import and export memorized reports, but not using IIF files. Instead, you can export these reports directly from the Memorized reports list using Premier or Enterprise.
Import and export Custom Templates for sales transactions (Invoices, Credit Memos, …) from the Templates list.
IIF stands for Intuit Interchange Format, a file format for importing data into financial software. QuickBooks will export IIF files that contain lists & will import IIF files that contain both lists & transactions. The format is daunting for many non-programmer types. Several of our tools make it easier, including the IIF Transaction Creator, the List Importer, and the Transaction Copier.
QuickBooks doesn’t support my bank or credit card for online banking. How can I import my Online Banking data into QuickBooks?
The IIF Transaction Creator can use CSV and other text files opened in Excel. It will help you convert these files to IIF files for import into QuickBooks. This is a good way to imported banking or credit card transactions where you don’t enter them as you go. They’re imported directly into your register.
The QIF to OFX Converter will import QIF files or use worksheet data downloaded from your bank. It will create OFX, QFX, and QBO files you can import into the online banking center in QuickBooks or Quicken. This is useful is you enter most transactions as you go, and want to reconcile them against the bank’s data.
Yes. Opening balances for lists are created by importing transactions in combination with lists. For import, this means both a new list item & an accompanying transaction must be imported.
Setting this up manually is rather cumbersome, though it’s easy when using our List Importer where all you have to do is specify the opening balance amount for each account or name and the rest is taken care of.
No, it does not include built- in export for transactions. However, QuickBooks does expose its data to 3rd party tools and that can be used to create IIF files with transactions. Then those files can be imported into another QuickBooks file. Our Transaction Copier takes advantage of this capability and so allows you to copy transactions from one QuickBooks file to another.
Yes! QuickBooks can import transactions using the IIF file standard. Generally, this can be quite complicated to setup and is considered ‘programming’ by Intuit, and they don’t support questions about IIF. Several of our addins can help with this task, allowing you to convert simple spreadsheets into IIF files.
List items include Accounts, Customers, Vendors, Sales Items, and so on.
Transactions use list items as well as currency amounts to track financial activity involving money. Transactions include things like Invoices, Checks, and Bills.
Use the support request form on the Support menu to send a suggestion.
This happens from time to time. To date, we’ve fixed nearly everything ever reported. We will work with you to resolve product errors.
Please send a support request using the Support menu that describes what is happening.
Be sure you’ve reviewed the in-product documentation and available examples. Together, these resources create a picture of what the tool does, what it expects, & what to do in some specific cases.
If none of this works, you can send a support request from the Support menu. We usually respond to support requests on the same business day, and some weekends.