Skip to content

FAQ

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.

General

What are OFX files? QFX files? QBO files?

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.

Are your tools supported on the Mac?

Several tools are supported on the Mac Using Excel 2004 or Excel 2011.

If you see a Mac logo for the addin to download, then the Mac is support.  See the Latest Version Info page for your download options.

Excel

Can I use MS Works spreadsheet or other spreadsheet programs with BRC Addins?

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.

What version of Excel do I need?

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.

After I load the Add-in, no menu appears

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.

I get a message saying the addin is file losing it’s VB Project when I open Excel or load an Addin.

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.

Excel 2013 Addins Tab does not appear after install

Once you’ve installed it then it should appear on the Addins tab in Excel. 

If it doesn’t appear when you start Excel, but the addin appears to be loaded in the addins list, then you may be seeing a known Excel 2013 issue.  This issues is caused when addins Excel ships with block displaying the Addins tab, if they are loaded. 

You can work around this by unloading the other addins and then restarting Excel.  To work with addins using Excel 2013, start in Excel and select File, then Options from Excel’s menu.  In the Options dialog, select Add-ins.

 

Privacy & Security

Do you sell your customer list?

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

Can I download the new version of my purchased addin for free?

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.

I’d like to share your tool with a friend or co-worker. May I do that?

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.

I lost my product key. What can I do?

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.

 

I receive an error when entering my product key.

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.

I purchased but did not receive my product key.

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 bigredconsulting@gmail.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 I purchase one or more addins, what should I expect?

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.

 

Are the tools limited when in trial mode?

Each is limited in some way. For example the IIF Transaction creator will create up to 100 transactions during its trial.

What payment options do you offer?

We accept major credit cards including Visa, MasterCard, and American Express as well as PayPal payments.

Quicken

Can I include Category and Split information in OFX files?

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.

Can I create OFX Files that Quicken will import?

Yes.  Use our QIF to OFX Converter to create QFX files, a type of OFX file that Quicken will import.

Can newer versions of Quicken import QIF files?

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.

What are QIF files?

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.

Can I import security price history information into Quicken?

Yes. Our Excel to QIF Converter now supports import of security price history details as well as security account transactions.

Can newer versions of Quicken import QIF files?

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.

Will your tools for Quicken work with the latest versions of Quicken?

Yes, we’ve tested them with Quicken through 2012 and they fully support the latest versions.

QuickBooks

What can’t be imported into QuickBooks?

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.

 

What types of data can be imported into QuickBooks?

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.

 

What are IIF files?

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.

Can QuickBooks import opening balances for lists?

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.

Can QuickBooks export transactions?

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.

Can QuickBooks import transactions?

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.

In QuickBooks terms, what is a list and what is a transaction?

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.

Getting Help

I have a suggestion. Where do I send it?

Use the support request form on the Support menu to send a suggestion.

I’ve encountered a bug! What should I do?

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.

 

I’m trying to use a tool, but I’m seeing errors or other issues. What should I do?

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.