Export Pledges into QuickBooks Desktop as Invoices

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

Then create a query to identify the transactions in eTapestry which should be exported. Limit the transactions to Journal Entry Type Pledge. For example, you may want to only export pledge transactions for the previous week which were not finalized. Refer to Queries.

1. From the Management, click eTapestry Standard Exports.

2. Under Accounting Exports, select Quickbooks Desktop Export. The Launch QuickBooks Desktop Export page appears.

3. Select the category and query which identifies the transactions in eTapestry which should be exported.

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

5. Select to create customer records.

6. Select whether to export optional customer fields.

7. Under Transaction information, select Cash Sale for the QuickBooks® Transaction Type.

8. Select whether to export individual transactions.

9. Select a transaction grouping option.

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

11. Select a credit/debit card method.

12. 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.

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.

20. To modify the export file, use spreadsheet software (such as Microsoft Excel) to open the IIF file.

21. Change every instance of the phrase “CASH SALE” to “INVOICE.” This appears in the TRNSTYPE column. Consider using a "Find and replace" feature to identify every instance and make mass changes.

22. Save the file. For Save as type, select Text type and ensure that the file name ends with suffix "IIF" (for example: eTapestryExport2-18-14.iif).

23. Confirm that you want to keep the file in the same format.

24. Close the file. You are ready to import the file into QuickBooks® desktop.