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. Excel can be purchased for about $90 at software stores or online.
Most of our tools are Excel Add-ins. The tools are supported under various versions of Excel, from Excel 97- 2010 for Windows. Several are also supported with Excel 2004 and 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 addins’ home page indicates the supported versions of Excel.
Excel 2008 for Mac is not supported as Microsoft removed support for add-ins (and other important features) from Office 2008 on the Mac. They reintegrated support for addins in Excel 2011.
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.
Excel 2010: 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 usually be the same as the last place you installed the addin.
Your product key & other 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 including the name of the products you’ve purchased and the keys 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.
Using Windows, 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 firstname.lastname@example.org, add the email to your spam-blocker’s white list or to your address book. If you need a replacement key, start here.
When purchasing you will 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 as well as PayPal payments.
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 2012, 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 2012 and they fully support the latest versions.
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 can import most data using IIF files. Different types of IIF files can be created using our tools.
QuickBooks will import most types of Transactions, most types of List records, and also Budgets and other data.
It can also import and export memorized reports, but not using IIF files. Instead, you can export these reports directly from the Memorized reports list using Premier and Enterprise versions (most recent versions.)
It can import and export Custom Templates for sales transactions (Invoices, Credit Memos, …) from the Templates list. (We’re not sure if Premier and above is required for this.)
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.