QuickBooks Export Using Bravo

Bravo supports the creation of an .IIF export file for a company’s general ledger, which can later be imported into QuickBooks. This guide will show you how to export the file from Bravo and how to import the file into QuickBooks.

Prerequisites

In order to successfully import Bravo’s .IIF export file into your company’s QuickBooks, you must first configure your general ledger accounts in Bravo to match up with your accounts in QuickBooks. Unless new general ledger accounts are introduced in Bravo, or you restructure your account mapping in QuickBooks, this setup only needs to occur once. To complete this setup, first navigate from the Bravo Dashboard to System Configuration. See screenshot below:

 

The store to which you are signed in will be automatically selected on the left panel, but you will be configuring at the company level. Select the company header from the left panel. See screenshot below:

 

Select the General Ledger Accounts tab. The Account Number field in Bravo needs to match up to the Account Name in QuickBooks. If you put in your actual account number, QuickBooks will not accept the file. Some accounts in Bravo may be disabled if your store will not make use of them; typically, these accounts are either meant for international users or they are Cash Disbursement accounts. See screenshot below:

 

To designate the store enter *STORE* with your account number.  This can go before or after the account number.  You can separate by a space, a hyphen or any other symbol.  Whatever you type is how Bravo will enter the info.  

 

For example, Account # 12345 (CASH ON HAND) for 3 stores - Store001, Store002, Store003

Enter in Bravo

• 12345-*STORE*

The account number will appear as

• 12345-Store001
• 12345-Store002
• 12345-Store003

 

For all other Bravo accounts which you might not track, but cannot be disabled, simply enter in a place-holder Account Number, such as “N/A”.

 

 

For Example: if your store/company is buy/sell only, and you do not write loans, then it would be reasonable for you not to configure general ledger accounts in QuickBooks for the “LOAN INTEREST” or “LOAN PRINCIPAL” accounts in Bravo. Even if you do not set up an associated account in QuickBooks, you must enter some text in Bravo, otherwise you will not be allowed to produce a ledger export; this is why you must enter “N/A” or some other place-holder text.

 

If your company has more than one store, and you track a general ledger account separately for each store, you will want to make use of the *STORE* identifier, which will be replaced in all instances with the [GL Store Number] on each store’s Information tab.

 

For Example: with two stores using GL Store Numbers EX1 and EX2, you could enter “CASH ON HAND – *STORE*”, and your export would produce two separate lines in your general ledger export – one for “CASH ON HAND – EX1” and one for “CASH ON HAND – EX2”. This would allow you to track how much cash is on hand at each individual store in your company.

 

If your company has more than one store, and you track a general ledger account as a global account for the company, simply do not use the *STORE* identifier in your general ledger account setup.

 

For Example: you could enter “BANK – CASH” to the general ledger account for [Bank – Cash], and all stores would post to a single “BANK – CASH” entry on your general ledger export. None of the stores’ GL Store Number values would appear in the export because you did not use *STORE*. See screenshot below:

Exporting from Bravo

 

Once you have finished setting up your General Ledger Accounts in Bravo, you are ready to export the .IIF and import it into QuickBooks.

 

• From the Bravo Dashboard, select the Post to Accounting button:

• In the upper-right corner, select from the dropdown on of the three QuickBooks export options: Quickbooks IIF, Quickbooks IIF per Store, or QB IIF, per Store, per Deposit.
  • QuickBooks IIF
    • Sum up all the ledgers that had activity within the corporation. Saved as an IIF formatted file.
  • QuickBooks IIF per Store
    • Sum up all the ledgers that had activity within each store of the corporation. Saved as an IIF formatted file.
  • QB IIF, per Store, per Deposit
    • Sum up all the ledgers that had activity within each store of the corporation. Expand and report all banking transactions (Deposits and withdrawals) and report them as individual transactions. Saved as an IIF formatted file.
  • QB 2019 IIF
    • Designed specifically to meet the requirements for QuickBooks 2019 version. This also works with the Quickbooks Desktop 2020 version.
  • QB 2019 IIF, per store
    • Sum up all the ledgers that had activity within each store of the corporation. Saved as an IIF formatted file.
    • Made to work specifically with the QB 2019 and QB 2020 versions.
  • QB 2019 IIF, per Store, per Deposit
    • Sum up all the ledgers that had activity within each store of the corporation. Expand and report all banking transactions (Deposits and withdrawals) and report them as individual transactions. Saved as an IIF formatted file.
    • Made to work specifically with the QB 2019 and QB 2020 versions.

• For the business date to be exported, select either Post for new dates to post or Export for previously-posted dates. When producing .IIF export files, you may only export one business date at a time. Selecting Consolidated General Ledger from the right panel will only produce an export file in Bravo’s non-IIF spreadsheet format:

• Now that the export file is saved, switch over to the QuickBooks.

Before performing your import, you will need to ensure that:

• All other QuickBooks users save their work and sign out.
• That you are using QuickBooks in Single-user Mode. This can be done from the File menu:

• To import the .IIF file, navigate in QuickBooks to [File] > [Utilities] > [Import] > [IIF Files…]:

• When prompted to choose a file from your computer, select the file that you exported from Bravo. After QuickBooks imports the file, a confirmation dialog should pop up:

• To view your general journal in QuickBooks, navigate to [Reports]>[Accountant & Taxes]>[Journal]: