Support Positive Pay CSV File Format in Accounts Payable

Support Positive Pay CSV File Format in Accounts Payable

Release Date: 05/26/21
Revised Date: 03/15/22
Version: 8.5 & Up

Positive Pay can send printed check information to the bank to prevent fraudulent checks (invalid check number or check amount) from being cleared by the bank. Elliott currently supports "Positive Pay" in the Accounts Payable (AP) module by going to AP -> Report -> Check History Report -> Export. 

Bank Book Module
You need to use Elliott's Bank Book module together with Positive Pay. In Bank Book, under Bank File Maintenance, you need to cross-reference the Elliott GL account with the bank account which is required in the exported CSV file.


Three Supported CSV Format
Elliott currently supports three CSV file formats:
  • Regular Format
  • Cole Taylor Bank Format
  • First Bank Format
See sample screen below:


If your bank does not use any of these formats, you can either contact us for programming enhancement, or you can transform the exported CSV file in Excel -- either manually or through a macro -- to your desired format. The following is a list of details for these three formats:

Regular Format (With Header Row)
  • Account# (your bank account number)
  • Check#
  • Amount (show zero amount if action is to void)
  • Date (check date in MM/DD/YYYY format -- if voided, use void date)
  • Action (e.g., V=Void, Blank=Regular, I=Manual Check)
  • Payee (i.e., vendor name)
Cole Taylor Bank Format (No Header Row)
  • Account# (your bank account number)
  • Check#
  • Amount (show zero amount if check will be voided)
  • Date (check date in MMDDYYYY format -- if voided, use void date)
  • Action (e.g., V=Void, Blank=Regular, I=Manual Check)
  • Payee (i.e., vendor name -- replace comma symbol "," with space)
First Bank Format (No Header Row)
  • Account# (your bank account number)
  • Check#
  • Date (in MM/DD/YYYY format)
  • Amount (no decimal -- e.g., amount 123.56 will be shown as 12356)
Note - At the moment, Elliott does not have the Positive Pay feature in the Payroll module.  

EMK




    • Related Articles

    • AP0000 Accounts Payable Overview

      Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...

    • AP0202 Accounts Payable Transaction Processing

      Processing A/P Transaction Processing Advanced Features The A/P Modules includes many features and functions, not applicable to all business, which we let you Pick & Choose to enhance your functionality and processing needs. These are detailed in the ...

    • AP0100 Accounts Payable Vendor File Maintenance

      Maintenance Vendor File Maintenance Application Overview The Vendor File is used to store information on all companies and individuals from whom materials, supplies, and services are purchased. This application allows entry of information into this ...

    • AP1600 Accounts Payable A/P Setup

      Utilities Setup A/P Setup Application Overview A/P Setup allows you to turn certain features of the A/P package on and off and set package-wide defaults. This allows you to tailor the package to your own needs and increase throughput. The features, ...

    • Common Issues with Importing CSV Files Into Elliott

      Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...