You can import an electronic file from a bank that displays electronic fund transfers from contributors to church accounts. All records in the file will be imported as regular entries. They are considered entered but not posted. You can edit the entries before posting them if you need to make changes.
The import file can be a dBASE, Paradox, FoxPro, Comma Separated Value (CSV), or an ACH file. ACH payments are electronic, direct-deposit transactions from one account (the contributor) to another (your church or organization). The ACH file uses NACHA industry-standard record formats.
If a record does not import properly, click Print Error Log to print a list of the transactions that ACS cannot import. You can enter these transactions manually.
Before importing contributions from an ACH file, you must enter the contributor's bank routing number and account information into ACS. For more information, see Manually Entering Bank Account Information.
To import contributions using file import
- Under Manage Records, click the Contributions tab.
- Select Enter/Post Contributions from the drop-down list and click Go .
- In the Enter/Post Transactions window, click Import Transactions, then File Import.
- In the File Type drop-down list, select the file you want to import (dBase, Paradox, FoxPro; Comma Separated Values; or ACH).
- In the Select Open Batch drop-down list, select the batch you want to import the transactions into. If you didn't create a batch yet, click Start New Batch.
- In the Gift Date drop-down list, select the transactions' gift date.
- Select the appropriate options for your import, then click Import. Some options may be unavailable, depending on the file type you are importing.
The following table lists the specifications for a dBASE, FoxPro, Paradox, or CSV (ASCII) import file. When creating a CSV file, the fields should appear exactly as they are in the table below. If additional fields are added or existing fields rearranged, the file is not accepted when you try to import. For CSV files, the first record may be a header record.
Up to 9 digits
Up to 12 characters (can be alpha, numeric, or an alphanumeric combination)
Up to 16 (13 digits, a decimal point, and two more digits, for example 9999999999999.99)
Up to 15 characters (can be alpha, numeric, an alphanumeric combination, or blank). If the field is left blank, enter a comma to separate the Amount field and Check Number field for proper import.