Skip to content
logo Knowledgebase

Create an ACH, Positive Pay or csv file for your bank

Created on  | Last modified on 

Summary

Instructions for how to export check register details to create a Positive Pay report in Sage BusinessWorks.

Description

  • Sage BusinessWorks Positive Pay report doesn't include voided or reconciled checks
  • Positive Pay is a fraud prevention service that helps your bank catch fake checks
  • Your business sends the bank a list of issued checks, and the bank compares it to the checks it receives
  • If something doesn't match, the bank flags it for review

 

 

 

Resolution

Sage BusinessWorks 2024 or newer

  1. CM, Reports, Positive Pay Report.
  2. Select the desired filters.
    Image of Positive Pay Report options.
  3. Click Preview.
  4. Click Print to XLS Data Document.
    Image of Print to XLS Data Document.

 NOTE: This report doesn't include voided or reconciled checks   

Sage BusinessWorks 2023 or older

▼ Export vendor and non-vendor (instant) checks
  1. CM, Transfer, Custom Exports.
  2. Click the New button and enter a name for your template.
  3. Select CM All Checks for the Data Source.
  4. Select the following fields to include both Vendor and Instant checks. 
    • CheckNo
    • CheckDate
    • Amount
    • RemitName (This is an optional field)
    • Nschk_PayeeName (This is an optional field)
  5. Click Next.
  6. Select CheckNo in the Set Sort screen to sort by check number.
  7. Next.
  8. Set your filters to filter by check date for the day you create the file. Include both vendor and non-vendor checks.
    • Field Name: CheckDate
      Operation: Between
      Values: (Enter your date range in the mm/dd/yyyy format)
    • AND
    • Field Name: Status
    • Operation: =
    • Values: 0
    • OR
    • Field Name: Status
    • Operation: =
    • Values: 32
  9. Click Done.
  10. Select Export.
  11. Accept the default to export to Microsoft Excel and View on Screen.
  12. In Excel, select File, Save As.
  13. Save as type CSV (MS-DOS) (*.csv).
    Image
To include payroll checks, vendor and non-vendor (instant) checks
  1. CM, Reports, Check Register.
  2. Primary sort by: Check #.
  3. Type of Check Register: Summary.
  4. Include what entries: Select Today's checks/EFTs or Specific date range and enter the desired date.
  5. Select which checks you wish to include in the report.
     NOTE: To include only outstanding and voided checks in the report, check the following options and uncheck all others.
    • Include outstanding checks
    • Include voided checks (This is an optional field. Some banks require voided checks)
    • Include other checks
    • Include payroll checks

      Image
  6. Preview to screen.
  7. Right-click on the report and Select All.
  8. Right-click on the report and Copy.
  9. Open MS Excel and Paste.
  10. Save as type CSV (MS-DOS) (*.csv).
    Image
  11. Make any edits to your file in Excel.

 

 

 

Need more help?

Chat now