Skip to content
English
  • There are no suggestions because the search field is empty.

Export to QuickBooks

 

We recommend for your first few exports that you not immediately mark the transactions as exported until you have performed a successful import into QuickBooks. We strongly recommend making a backup copy of your QuickBooks database before performing the import so any duplication can be corrected.

 

Choose Transactions to Export

  1. Navigate to the Accounting Centre and click the Export to QuickBooks button.

  2. In the Transactions To Export area, if you would like to Export All transactions, click the checkbox. If you would like to export transactions for a paritcular period instead, select the period from the dropdowns. 

  3. Choose the Transaction Types you would like to export.

  4. If you would like to filter your export by Customer Category, you can make your selection from the drop-down.

  5. The Consolidated Export option will change the display and as such this preference will be covered in its own section below. The section below will also explain Consolidate Line Items which is found in the Invoices section of this screen.

  6. To force the import to update the information on all customers in QuickBooks regardless of whether the customer has new information, check the Update All Customer Details checkbox.  

Consolidated Export

If you select the Consolidated Export option, the display will change and will show all transactions grouped by GL Account. If you are keeping your AR in FlexiBake, this will allow you to keep the quantity of data in QuickBooks lower, which will help with the speed and performance of QuickBooks.

If the Consolidated Export option is not selected, you still have the ability to Consolidate Line Items for Invoices. This will create the invoice in QuickBooks, with the itemized line items consolidated into a single item. Unlike the previous consolidation option, this allows you to see the individual invoices, by customer, and the totals. Again, this can be done to try and save space in your QuickBooks.

Performing the Export

  1. In the Export Transactions window, click the Export button.

  2. This will bring up a window prompting you where to Save the .IIF file. You will need to remember where you save the file, as you will need the file to import into QuickBooks.

  3. Once you have saved the file, a new message box will appear asking if you want to mark the transactions as exported. Once transactions are exported you will not be able to make any further changes to the trasnactions, and marking the transactions as exported cannot be undone. This is because once QuickBooks has imported the transactions, FlexiBake does not have access to update the transaction in QuickBooks.