Use the Positive Pay Export to create a report showing all checks that have been cut and sent out during a particular time period. The system will generate a text (.txt) file you can forward on to your financial or banking institution. Positive Pay Export allows you to transmit a list of issued checks to the bank each day as needed.
Generate a Positive Pay Export
- Go to Checks from the Home page
- Select PositivePay Export from the left-side of the screen
- Choose the Start Date and the End Date, this can be any date range even one day
- Click the Export button when done
Note: Each of your Accounts will need the account number filled in under Description to complete the export.
The system will automatically download a TXT file with all checks in a single string - the string will contain the following data:
date, check number, account number, grantee/vendor and amount followed by a capital I
Each line of data will look like this:
01102017 2000 43432222223434 Bills Campaign 100.00 I04302017 4005 43432222223434 Fur & Feathers 4-H 40000.00 I
To change the order of the columns, open the file in CSV and move the columns around in Excel.