Skip to Main Content
Sage BusinessWorks Ideas Portal
Status Great Ideas Delivered
Created by Kim Crabtree
Created on Jul 19, 2023

Add the ability to create a positive pay file

As a check to prevent fraud, more banks are requiring the use of this file to provide a check between the checks that were printed and those processed by the bank.

  • Attach files
  • Angela Ingold
    Reply
    |
    Sep 8, 2023

    We have this as well. We go to Utilities -> Custom Exports, or AP ->Transfer -> Custom Exports. However, I do not know if the PP file was made for us, or if it came standard. It might not be standard in BW's because each bank may require different formatting. Unfortunately, I have to format the export each time to match my bank's needs: change the date from xx/xx/xxxx to xx/xx/xx. Change the format of the dollar amount to make sure every number has two digits for cents. Add a column for the bank account number and copy paste the bank account number to each row. Delete duplicated checks numbers (one row per invoice). So it is not entirely "run" and "upload" but it's way faster than hand typing into the bank's website.

    The columns selected for our PP is:

    <cmcheck> CheckNo
    <cmcheck> CheckDate
    <cmcheck> Amount
    <cmcheck> Nschk_PayeeName

    and it will select all CM checks (instant checks) and AP checks.

  • Guest
    Reply
    |
    Aug 31, 2023

    I am not sure which Sage you have but in BW, we have it under cash management (CM), then transfer, custom exports. Then you need to create your file according to your banks requirement. Ask your bank to help you create this file. I have 2 different banks & the require different things.