Skip to content
logo Knowledgebase

How to create an ACH, Positive Pay or csv file

Created on  | Last modified on 

Summary

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

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 an option to include voided 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 to appear in the report, check the following options and uncheck all other options.
    • 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