RKL eSolutions Blog Trends and Insights

How to Create a Positive Pay Report in Sage Intacct

In this post, we'll go through how to create a positive pay report in Sage Intacct using the scenario below to get to our end result. 


Setting up Positive Pay with the bank and need to generate a csv file that contains Bank account number, check number, Vendor name, payment date, and amount. File will be uploaded to the bank after each check run so that bank can verify each check that is cashed.

Note: This report may not be able to accommodate all positive pay bank requirements, validate requirements with your bank. Report cannot be auto-uploaded to the bank. RKL has an advanced Positive Pay module available for purchase if this will not meet your requirements.

End Result:


Report: Positive pay

Export as a csv file

csv file export

Steps to Create a Custom Report for Positive Pay

  1. Go to Platform Services > Custom Reports (If you don’t have Platform services, then go to Customization module). Click Add to add a new report.
  2. Walk through each step of the Wizard. If a step is not listed below, then nothing needs to be done on that step.
      1. Data Source: AP Record
        step 1
      2. Key Fields- confirm with your bank which fields are required, but typically you will need Check #, Check Date and Amount at a minimum. You may also want vendor name and account number. Audit date can be added while testing the report to confirm the data being pulled.
      3. key fields
        multiple accounts
      4. Put columns in the sequence as requested by the bank

        select column sequence
      5. Determine how to Sort Records – for example by Account and then Check #

        sort records
      6. Filter the data to only return Check payments. Note: there may be multiple Payment methods in column drop down, select the one that allows the Value to be a drop down list of payment methods.
        filter report
        refine filters
      7. Reporting period can be set to “Today” if the pospay report will be run the same day as the checks are printed.

        reporting period
      8. Include additional prompts if Needed, for example, may want to filter to Account number if you have multiple.

        additional prompts
      9. Give report a Name & Add report to your menu.

        Name report
  3. Refresh your screen and then go to AP> Custom Reports to run report. Validate the report against the AP check register to make sure the correct information is being pulled.

    validate report

    Export report as csv

    export as csv


Karen Hanley

Written by Karen Hanley

Karen Hanley is a Sage Intacct Senior Solution Architect with RKL eSolutions, LLC. Karen is an accomplished professional services consultant with over 25 years’ experience managing the implementations of accounting/ERP software through all phases of the project life cycle. Her areas of expertise are in software configuration, project management, data conversion, documentation, process improvements, reporting, and training. When not working, Karen enjoys traveling, sailing, golfing, and spending time with family and friends.