You are here: Management > Exports > Standard Exports > Accounting Exports


Accounting Exports

If you need to export your data from eTapestry to your accounting software, use an eTapestry export. For your convenience, eTapestry includes predefined exports for some common software programs, including The Financial Edge, FundWare, and others. For other programs, use eTapestry's Custom Report Writer to create your own export definition. If you create your own export definition, be sure to review the user manual for your accounting software to ensure the import file has the necessary format and content.

Before you set up an accounting export, ensure your eTapestry database is set up correctly.

Identify at least one query to use to select transactions to include in the export file. If you import your data at the end of each work day, consider using the Today query in the Constituent Journal Entry Date category. If you import more frequently, create a query that excludes items that have already been exported. To do this, for exported transactions, mark the Journal Entry Status as "Pending." If you want to use different export options for gifts than for pledges, use different queries for each.

After you create the export file, save it to your computer on your network so you can import it into your accounting system. You can also email the export file to your accountant. To import the transactions, follow the instructions your accounting software provides.

After a transaction is exported, you should mark it as Final. This prevents anyone other than an administrator from modifying it and helps to keep your accounting system and eTapestry in sync. To quickly finalize exported transactions, you can run a mass update using the same query that you used to create the export file.