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 ...

    • BB2100 Bank Book Bank Reconcile File Maintenance

      Bank Reconcile File Maintenance Application Overview This is a maintenance file for each bank account defined in Bank File Maintenance. It contains all the deposits and checks that have been merged (Processing menu) and/or reconciled for this cash ...

    • BB0000 Bank Book Overview

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

    • BB17S4 Bank Book Cash Projection Report

      Cash Projection Report Application Overview Without needing the use of extensive financial analysis software the Cash Projection Application allows for a compact view of future cash needs. The application looks at the current cash requirements ...

    • BB1700 Bank Book Bank File Maintenance

      Bank File Maintenance Application Overview The Bankfile is used to store information on all banks that the company may have an account with. This application allows entry of information into this file and then maintenance of this data. This bank file ...