Export Deposits into QuickBooks Desktop

Before you export deposits, ensure that your eTapestry database is set up with correct funds. Refer to Funds for QuickBooks Desktop.

Based on how your QuickBooks® database is set up, you may need to create one or more User Defined Fields. Refer to User-Defined Fields for QuickBooks Desktop.

After GL accounts on your funds and transactions ready to export, you are ready to run the QuickBooks® desktop export.

  1. From Management, click Standard Exports.

  2. Under Accounting Exports, click Quickbooks Desktop Export. The launch screen appears.

  3. Select the category and query which identifies the transactions in eTapestry which should be exported. Consider using a query such as Constituent Journal Entry Date: This Week if you run the export weekly.

    Note: If you are tracking donations with gift types other than cash and check, specify the gift type to be exported in the query. Cash and check donations should be exported together. This gives you control over the way each gift type is exported.

  4. Under Customer Information, select whether to export the name or sort name.

  5. Select whether to create customer records.

    If you create customer records, the top of the export file shows your constituents on the Customer record in your QuickBooks® desktop database for each new constituent.

    Otherwise, constituents appears in the Vendor or Other Name list, based on your QuickBooks® import setup.

    Note: An error will occur with the QuickBooks® import if you attempt to add donor names to the customer list and the names are already stored in your QuickBooks® desktop database on the Other Names or Vendor lists. The error indicates that the import can't change the type of a name. To correct the issue, manually change the name record in your QuickBooks® desktop database to be the customer type.

  6. If you create customer records, select whether to export optional customer fields.

    The optional customer fields include the account number, address, voicemail number, mobile telephone number, email address, and customer types. Select Yes to export these fields.

  7. Under Transaction information, select Deposit for the QuickBooks®Transaction Type. This determines how to store donations in your QuickBooks® desktop database.

  8. Select whether to export individual transactions.

    • Yes - Each individual eTapestry transaction is exported as a separate QuickBooks® transaction.

    • No - eTapestry transactions can be grouped together. For example you can import all donations from a single bank deposit together into a single entry in the Cash account, and keep the details of each gift in the Income accounts.

  9. Select a transaction grouping option.

    • If you deposit all donations from the week on Friday, we recommend you select Deposit Date.

    • If you make multiple deposits per day, we recommend you select Deposit ID.

    • If you want to combine donations with the same credit/debit card type and gift date into one QuickBooks® transaction we recommend you select Credit/Debit Card Type.

  10. Select whether to create a subtotal by GL account.

    This enables you to combine donations associated with the same credit account and CLASS value into a single distribution within a transaction. Export files created with this option checked will not include any donor information on the transaction. If you want to create a subtotal, you can't export individual transactions.

  11. Select a credit/debit card method.

    • Credit/Debit Card - The words "Credit/Cebit card" appear as the Payment Method on the QuickBooks® transaction for a gift or payment that has the gift type set to "Credit/Debit Card" in eTapestry.

    • Credit/Debit Card Type - The credit/debit card type that you selected on the gift page appears in the QuickBooks® Payment Method field.

  12. Select whether to track sales tax. Select whether to track sales tax. If you track sales tax in QuickBooks, select Yes. Otherwise, select No.

  13. Under Customizable Fields, select a transaction name.

    • Account Name - Select this if you choose to export individual transactions.

    • Export Date - Select this if you choose not to group transactions.

  14. Select a transaction memo.

  15. Select a distribution memo.

  16. Select a date format.

  17. Select your delivery options.

  18. Click Submit to export the items or click Schedule for Off-Hours to run the export later. When the export is complete, the export file will be in the Intuit® Interchange Format (IIF).

  19. Save the file. You are ready to import the file into QuickBooks® desktop.

    Note: QuickBooks® desktop cannot import from an open file.

  20. Before you import data into QuickBooks® desktop, backup your QuickBooks® desktop database. For more information, refer to your QuickBooks® desktop help documentation.

  21. To import transactions into QuickBooks® desktop, open QuickBooks® desktop. Click File, Utilities, and Import. Then select the name of the IIF file. The import begins when you select the file.

  22. After the import is complete, verify the results to ensure the imported data matches your expectations. If it doesn't you can use the backup to restore the QuickBooks® desktop database to its previous state while you adjust the export process.

  23. After the donations are successfully imported into QuickBooks® desktop database, mark each eTapestry record as Final to help avoid duplicates. This ensures that donations from eTapestry are only recorded one time in your accounting package. To finalize the journal entries, run a mass update using your export query.

    To remove transactions that have already been exported from your export query, specify that Journal Entry Status is "Pending". This enables you to reverse a finalized transaction instead of deleting it. When you create a reversal transaction for that constituent you can then include it in your next QuickBooks®desktop export to keep the two systems in sync.