Positive Pay Exporting
Overview
Access your bank accounts in the chart of accounts by taking menu options Accounting > Settings > Chart of Accounts. From the chart of accounts screen, you can filter the list to show only the GL accounts that are designated as bank accounts. When the mouse hovers over a row in the grid that is for a bank account an icon of a building is shown. All other accounts will not have this icon. When clicked it will open a popup window to allow you to configure the export layout required by that specific bank for positive pay exports. This allows each bank to have their own unique layout.
Creating or Modifying a Layout
The below screen will appear once you have clicked the Bank icon. This allows you to select which columns the data needs to be placed in when exported. There are currently a fixed set of fields that can be exported. They are as follows:
| DATA FIELD | PURPOSE |
|---|---|
| Account Number | This is the bank account number associated with the GL Account. |
| Issue Date | This is the date of a check. |
| Check Number | This is the check number. |
| Payee Name | This is name of the vendor being paid printed on the check. |
| Amount Cents | This is the check amount in pennies (Check Amount multiplied by 100). This may be required by some banks. This is the default |
| Amount Dollars | This is the check amount shown on the check in dollars. This may be required by some banks. |
| Blank | This will leave a column blank. |
| Fixed Value | This will export a constant value on each row of the export. When this is selected the columns for Type and Fixed Value will open up for editing. You will be able to define if the value is to be a Boolean (Yes/No or True False), Date, Number, or Text. |
At the top of the window is a checkbox to indicate if a header row should be created to show the titles from the Headings column. When unchecked only the data will be in the export file. This is the default.
Once the settings are set to meet the requirements of the bank you may click confirm to save them permanently.
Related Articles
Viewing Payments
Overview Payments can be accessed from the sidebar menu by selecting the options Accounting >Accounts Payables>Payments. This option will allow you to view and maintain invoices payments including positive pay export. Permission In order to perform ...Paying Invoices
Overview Invoice payments are processed through the invoice maintenance screen which can be accessed from the sidebar menu by selecting the options Accounting >Accounts Payables>Invoices. Permission In order to perform any of the basic maintenance ...Unapplied Payments
Overview A customer can have unapplied payments on account for a variety of reasons. Some of the most common: Overpayment on an A/R check Payments entered by sales employees without access to apply to invoices A/R Adjustment that increases balance ...