Page tree

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.

Note

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

  1. Under Manage Records, click the Contributions tab.
  2. Select Enter/Post Contributions from the drop-down list and click Go.
  3. In the Enter/Post Transactions window, click Import Transactions, then File Import.
  4. In the File Type drop-down list, select the file you want to import (dBase, Paradox,  FoxPro; Comma Separated Values; or ACH).
  5. 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.
  6. In the Gift Date drop-down list, select the transactions' gift date.
  7. 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.

Field

Length

Envelope Number

Up to 9 digits

Fund Code

Up to 12 characters (can be alpha, numeric, or an alphanumeric combination)

Amount

Up to 16 (13 digits, a decimal point, and two more digits, for example 9999999999999.99)

Check Number

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.

Additional Field Information

Select Open Batch - Select the batch you want to import the transactions into. If you haven't already set up a batch in ACS, click Start New Batch.

Gift Date - Select the date the contributions were given.

Omit First Record - Select if the file you are importing is a CSV file and the first record is a header.

Import all transaction codes - Select to import all detail lines from the ACH file, regardless of the transaction code. If cleared, only detail lines with a transaction code of 27 (Automated Payment for Checking Accounts) or 37 (Automated Payment for Savings Accounts) are imported.

Import Check Number - Select to import check numbers with the ACH file.

Check Number Starting Position - If importing check numbers, enter the column number where the check numbers start.

Fund - Click Lookup to select the fund you want to post the imported transactions to.

Select Payment Type - If your transactions are the same payment type (ACH, Check Card, Credit Card), select this option. Then, choose the payment type in the drop-down list.

Transaction Type - Click the drop-down arrow to select a transaction type.

Print Error Log - Click to print a list of transactions that ACS cannot import so that you can enter them manually.