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
  • Admin
    Kim Crabtree
    Reply
    |
    Aug 7, 2024

    Hi all,

    Thank you for your feedback. We are excited to announce that we have added a positive pay report to Sage BusinessWorks 2024. This report can be found under Cash Management (CM), Reports, Positive Pay Report. You can filter this report for a specific cash account, check date, to include EFTs and Payroll Checks. Once you preview this report you can select the Print to XLS data document option to export the report to Excel.

    For further information about upgrading see our article how to upgrade Sage BusinessWorks.

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