This option provides you with a way to export information for use in other software. Select Export File lets you select the export file name and the type of export. Currently, a comma-delimited file, the Quicken "QIF", QuickBooks "IIF", "MAS90 Standard", "Jenzabar", and “Sage" (Peachtree) formats are supported.
- Select Manage, Finances, and then Finance Export
- The Step 1 : Select Criteria screen displays. Select the desired Fund (optional)
- Select the sort order (Fund Name or Donation ID)
- Choose the Limit Export By. Your choices are Items stored since last export (based on a timestamp when the donation was entered), by Batch, or by Fund Item Stored Date (based on a timestamp when the donation was entered).
- If Batch is selected, choose the Select Batch button. For instructions on locating a batch, see the article, Searching for an Existing Batch.
- If Fund Item Stored Date is selected, type the desired date/time range (all Date Fields reflect the date format for the country you previously selected) or choose the Calendar button, select the desired date.
- Once the criteria have been set, select the Next button.
- The Step 2: Preview, Exclude, and Modify Data screen displays. The data is displayed for review. Select the checkbox next to any record that you do not wish to export. Click to select the magnifying glass to view the donation in greater detail and edit content if necessary. Edit it in the export report, not in the original donation).
NOTE: only non-zero transaction amounts display in the results.
- Choose the Next button.
- The Step 3: Save Export File displays. In the Export File Name text box, name the file to be exported.
- From the Export File Type, select from the drop down menu the desired file type.
- The Export Options section will change based upon the selection made in step #10.
NOTE: The Quickbooks IIF Format, Version 3 is the preferred export for desktop versions of Quickbooks. The one labeled Quickbooks IIF Format is for backward compatibility and is no longer supported.
- Select the Export button.
- Select the Finish button. The Export Wizard closes. The data should now be available in the designated file.