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