After you've completed the QuickBooks feature setup, run the QuickBooks export.
QuickBooks Export Basics
The QuickBooks export generates an IIF (Intuit Interchange Format) file to import deposit entries into QuickBooks. It includes donation, recurring donation payment, and pledge payment entries. Pledge entries are not included.
To run an export:
- Click , QuickBooks Export.
- On the QuickBooks Export Options page, set filters and options. See "QuickBooks Export Options."
- Click Save and Run to download the export file.
QuickBooks Export Options
The QuickBooks export automatically groups transactions by their cash account and the transaction date, like this:
Set filters on the Filter tab to export a set of transactions. For example, if you run the export each morning, you might set the Created Date = Yesterday filter.
Group Deposits by Transaction Method in Addition to Date
Select Group Deposits by Transaction Method in Addition to Date to group transactions by the cash account, transaction date, and transaction method.
Export Split Details for Each Transaction
Select Export Split Details for Each Transaction to add more information to the SPL line:
- MEMO column: Constituent's name
- DOCNUM column: The check number or last four digits of the credit card
Use this option to list the constituent's name on the transaction in QuickBooks.
Open an IIF File in Excel
To view the exported file in Excel before you import it into QuickBooks:
- In Excel, click File and then Open.
- Navigate to the folder where you saved the export file.
- Click the file type menu and click All Files. Your QuickBooks export should appear.
- Click the file.
- In the Text Import Wizard, click Next twice, and then click Finish.
Warning: If you make changes to the file, QuickBooks might be unable to import it. The QuickBooks import mechanism requires that the file be in a specific format.
Import the File into QuickBooks
Deposit transactions can only be imported into the desktop version of QuickBooks. This feature is not yet available in QuickBooks Online.
To import your file in QuickBooks:
- Click File.
- From Utilties, click Import, and then IIF Files.
- Navigate to the folder where you stored the QuickBooks Export file and select it.
- Click Open.
You see a success message when the file is imported.
Here is an example of a deposit that was imported using the Bloomerang QuickBooks Export file: