Run QuickBooks Desktop Export

From Management, click Standard Exports. On the eTapestry Standard Exports screen, click QuickBooks Desktop Export under Accounting Exports. On the launch page, select a query. You can use one of the standard queries like one of the Constituent Journal Entry Date queries, or you can create your own Journal Entry query.

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

On the Customer Information tile, select your customer options.

• Select whether QuickBooks desktop should identify constituents by their name or their sort name.

• Indicate if you want QuickBooks desktop to create customer records. If you select "No," QuickBooks desktopwill put constituents in either the Vendor or the Other Name list, depending on our QuickBooksdesktop setup.

  Note: The QuickBooks desktop import will register an error if you attempt to add to the Customer list any donor names that are currently stored in your QuickBooks desktop database on the Other Names or Vendor lists. The error message will indicate that the import cannot be used to change the type of a name. To correct the problem, you can manually change the name record in your QuickBooks desktop database to have the type Customer.

• If you choose to create customer records, indicate whether you want to include optional customer fields. export names and whether you want to create customer records in QuickBooks desktop and export optional customer fields. Optional fields include account number, address, voice and mobile numbers, email address, and customer type.

In the Transaction Information tile, enter details about how to handle transactions in QuickBooks desktop.

• QuickBooks Desktop Transaction Type determines whether donations are stored in your QuickBooks database as deposits or cash sales.

• Select Yes on the Export Individual Transactions field to export each individual eTapestry transaction to a separate QuickBooks desktop transaction. To group transactions together, select No. It is common to import all donations from a single bank deposit together into a single entry in the Cash account, while keeping the detail of each gift in the Income accounts. This option is not available for cash sales, because each donation must be tied to a specific QuickBooks desktop customer.

• If you do not choose to export individual transactions, select the grouping criteria in the Transaction Grouping field. The deposit date grouping can be useful to save transactions to deposit once a week. The deposit ID grouping is usefulto make more than one deposit on a single day. The credit/debit card type grouping combines donations with the same credit/debit card type and gift date into one QuickBooks desktop transaction.

• To combine all donations associated with the same credit account and CLASS value into a single distribution within a transaction, select Yes on the Subtotal by GL Account# field. This option is only available when the Export Individual Transaction option is set to No. Export files created with this option do not include donor information on the transaction.

1. On the Credit/Debit Card Payment Method field, select "Credit/Debit Card" or "Credit/Debit Card Type." When you select "Credit/Debit Card," the words "Credit/Debit Card" appear as the payment method on the QuickBooks desktop transaction for a gift or payment that has a "Credit/Debit card" gift type in eTapestry. When you select "Credit/Debit Card Type," the credit/debit card type that you select on the gift page is placed in the QuickBooksPayment Method field.

2. In the Track Sales Tax field, select whether you want to include sales tax information on the import.

You can customize three fields in your export.

• Transaction Name: Select the value to be used to identify transactions in the export.

• Transaction Memo: Select the value to be displayed in the Memo field for the transaction line in the input file.

• Distribution Memo: Select the value to be displayed in the Memo field on each detail line of the import file.

Select your delivery options. The Report Format field defaults to a .iif file, which is the file format needed to import the data into QuickBooks desktop.

Click Submit to run the export or Schedule for Off-Hours to run it later or to set up a recurring export.