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

  • Starting in Sage BusinessWorks 2025, you can filter the Positive Pay report to include voided checks. Prior versions don't allow this filtering
  • Sage BusinessWorks Positive Pay report doesn't include reconciled checks
  • Positive Pay is a fraud prevention service that helps your bank catch fake checks
  • Your business sends the bank a check list, which the bank matches to received checks
  • If something doesn't match, the bank flags it for review

 

 

 

Resolution

  1. CM, Reports, Positive Pay Report.
  2. Select the desired filters.
    Image
     NOTE: If you don’t see the option to include voided checks, upgrade to Sage BusinessWorks 2025 or higher. 
  3. Click Preview.
  4. Click Print to XLS Data Document.
    Image of Print to XLS Data Document.
     NOTE: This report doesn't include 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
       NOTE:       Filters values of 0 and 32 select unreconciled checks 
  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.
     NOTE: The CM Check Register shows “Voided: Direct Deposit” for direct deposit checks because they’re zero-amount checks that won’t clear during bank reconciliation. Because individual direct deposit checks don’t appear on the bank statement, the system marks them this way. 
  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