Advanced Computer Services LLC
ACS 5 updatesCustomer support
ACSUtility billing software

Software help

Create Bank Draft CSV File | ACS Utility Billing Help

Create a CSV file of customer bank drafts and a supporting report. The Utility Billing EFT option is required. You may also choose to post the drafts as collections in ACS.

Using this option

  1. Check customers' bank-draft flags, bank details, and Bank Draft Group assignments.
  2. Enter Billing Date and Payment Date. Choose a Group or [All] and review the displayed output File location.
  3. Leave Post Collections unchecked if you only want the export and report. Select it only when these drafts should also be recorded as payments in ACS.
  4. Choose Create and review the report and CSV. If Post Collections was selected, a separate OK/Cancel confirmation controls whether collections are posted.
  5. After checking the file with the bank's required layout, upload it through your bank's service. File creation alone does not send any payment instruction.

Notes

Only customers with the matching stored billing date, a positive current balance, a Y bank-draft flag, and the selected group are included. The draft amount is the full positive current balance.

Current export layout issue: the CSV column headed Bank Account receives the stored routing number, and Bank Routing receives the stored account number. Have ACS check/correct the layout with your bank before uploading this file.

Posting collections changes customer balances and records payment transactions. Do not post the same drafts twice. When posting is enabled, this program also replaces the current user's temporary collections batch; finish any other pending collection entry first.

Related help