importing transactions into quickbooks with iif files

#Importing transactions into quickbooks with iif files update#
#Importing transactions into quickbooks with iif files download#

Also only export after the event is closed and all transactions have been finalized.ģ. If you export from each event, make sure you do not also export event transactions from the Dashboard > Financial. If you export by dates from the Dashboard > Financial, once you have imported transactions for a certain date make sure you do not overlap that date in the future. For example, only export once a month for the previous month from Dashboard > Financial.Ģ. To prevent duplicate transactions, we recommend exporting in such a way that you would not overlap any transactions from one export to the next.

#Importing transactions into quickbooks with iif files update#

There is also no way to update an existing transaction in QuickBooks Desktop, for example to reflect a subsequent refund. There is no way for QuickBooks Desktop to determine if the transaction has previously been imported. IMPORTANT: Do not import the same transaction twice into QuickBooks - this will create duplicate transactions. From each form under Forms Carts Donations, you can click on 'Export QuickBooks' to export the payments for just this form. From each event's dashboard, you can click on 'Export QuickBooks' to export the event payments for just this event.ģ.

You will be prompted to select the types of transactions (membership, events, cart, donation, other) to export.Ģ.

#Importing transactions into quickbooks with iif files download#

From the Dashboard > Financial page, you can select a date range (at the top left corner) of transactions to export, and click on 'Export QuickBooks' to download the IIF file. You can export an IIF file from several places:ġ.

Once you have configured your settings, remember to click on 'Save & Continue' at the bottom of the page. Any account or item in these settings that does not exist in QuickBooks would be automatically created by QuickBooks when the IIF file is imported, no error will be reported by QuickBooks. However your accountant may have setup your accounts differently, so please consult with your accountant if you are unsure about these settings. Our default settings match the typical default settings in QuickBooks. Under Organization Settings > Accounting, select 'QuickBooks IIF' to customize the accounts and items used to generate the invoices and payments in QuickBooks. Before importing any transactions with an IIF file, please read through this article and backup your company file in QuickBooks, as imports are not reversible. For QuickBooks Desktop products, you can download an IIF file to import transactions into QuickBooks.