QuickBooks Export Settings

Wild Apricot gives you the ability to export your financial information to a Quickbooks compatible file ( .IIF). Before you start a Quickbooks Export (see Quickbooks ), you need to configure the settings of your export file via Settings > Quickbooks export settings.

Export File Limitations

• Imported IIF files do not create links between transactions. For example, if one transaction is an invoice and another transaction is a payment for the invoice, these transactions will not be linked after importing the data. To reconcile this in QuickBooks after importing the data, you would have to manually open each payment in the Receive Payments window and apply it to the invoice.

• You must be in single-user mode to import or export data. This is to prevent other users from accessing data as it is being imported.

• You must be logged in as the Admin user. The QuickBooks Administrator is the only user that can import or export data. If you have not created users and roles in your company file, you are logged in as the Admin user by default.

• QuickBooks has certain limits on the maximum number of records for list items and transactions: http://support.quickbooks.intuit.com/support/Articles/INF12412

Wild Apricot technical support team can not provide support for importing the data into Quickbooks. For more help with the import process, please visit the Intuit QuickBooks Community site in the Importing and Exporting Data forum: http://community.intuit.com/category/importing-exporting-data

Mapping Data to Quickbooks Classes

Preparing Quickbooks

If you're already using Quickbooks you may be familiar with the ability to use "Classes" to classify transactions. You will need this option enabled to import the IIF file that is exported by Wild Apricot. You can check this setting from Quickbooks via - Quickbooks > Preferences > Accounting > Company Preferences ' Accounts ' - Use Class tracking .

Editing Settings in Wild Apricot

To get started click on the [Edit] button Edit When setting up the export file, you should use Classes to classify your transactions. (Ensure that "Use class tracking" preference is turned on in QuickBooks). Use colon (":") to separate Account or Class levels - corresponding SubAccounts or SubClasses will be created. Each level of Account or Class is limited to 30 characters max.

Macro List

The following is a list of macros that you can use to export you data to Quickbooks.

Related Topics

• Quickbooks
• Exporting members and other contacts
• Bulk changes using import and export