Creating a positive pay file
After you issue checks, you use the 1-11 Positive Pay File window to generate a positive pay file for the account from which you made the payments.
Before you start
-
Find out what format your bank requires for the positive pay file.
-
Set up the general ledger checking account to use positive pay.
Important! To be included in a positive pay file, the transaction number assigned to a check needs to be numeric. Checks with check numbers that include non-numeric characters or spaces are not included in positive pay files.
To create a positive pay file:
-
Open the 1-11 Positive Pay File window.
-
In the Checking Account box, select the general ledger account number.
-
If you have not set up the account to use positive pay, click the [1-11 Positive Pay Settings window where you can specify the required format and other settings for your positive pay file.
] button to open the -
Select options to include AP checks, payroll checks, and other checks, as needed.
Note: If your company uses Payroll Admin security, you need Payroll Admin rights to create a positive pay file for payroll checks.
-
Select the range of checks you want to include in the positive pay file. You can select one of these options:
-
Include only unreported checks starting from check date, and then specify the earliest check date you want to include. The positive pay file will include all checks that you have not submitted previously that were processed on the specified date to the current date.
-
Include checks dated and then specify the start and the end of the check date range. If you select this option, you can also select Include previously reported checks.
You would select this option to create a replacement positive pay file, for example.
-
-
Click [
].Alternatively, you can click
] to save the information in an Excel file, where you can edit it, as needed. (For example, if your bank requires additional information that is not captured in the Create File process, you can add another column.)Note: Sage 100 Contractor marks transactions as reported when you select [ ].