Accounting Export

The Accounting Export screen is accessed from the Accounting Export button on the Gift Batch Manager. It is used to create a text file, in CSV format, for importing into an accounting system.

If you are using QuickBooks, use the Export to QB button instead.

Before exporting a batch, you need to create a template that contains the fields that your accounting system expects for importing transactions. You select the fields and the order they should appear.

To use the Accounting Export, do the following:

1. On the Batch Manager tab in the Gifts Manager, select the batch to export.
2. Click on the Accounting Export button.
   1. A list of existing templates appears.
3. Click on the + at the top of the list to create a new template.
4. Enter a name for your template.
5. From the list on the left, select a field to add to the export file.
6. Click on the right arrow to move the field to the list on the left. This is the list of fields that will appear in the export.
7. If your system requires certain headings for the fields in the export file, you can change the field caption.
8. Use the up and down arrows on the right to move a field into a different position in the export file.
9. When you have finished moving fields, naming the captions, and setting the order, click on Save to save the template.
   1. Once a template is saved, you can use it again for each batch you use in the future.
10. From the Gift Accounting Export screen, make sure your template is selected.
11. Click on the spreadsheet icon at the top of the list (Export to CSV) to create the text file.
    1. The file is opened in Excel as a text file. Save it so you can import it into your accounting system.