Payments Report

Overview

This report displays customer payments applied to invoices, including payment method and receipt date, within the selected date range.

This is useful for determining which of your customers are actually paying for work done and how they are paying.

If you have customers paying with cash or cheque, you can also use this report to create a bank deposit slip.

Learn more in How to Apply Payment to Invoices.

This report can be beneficial when performing reconciliation between Simpro Premium with your accounting package.

Learn about other Sales reports in Sales Reports.

In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System A screenshot of a schedule icon with a grey calendar icon and an arrow. > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:

Reports

A screenshot of the Sales Payments report.

To run the report:

  1. Go to Reports A screenshot of a schedule icon with a grey calendar icon and an arrow. > View Reports.
  2. Click Sales > Payments.
  3. Select the date range under Payment Date.
  4. Select the Display Format.
  5. You can also filter according to Payment No., Customer, Payment Method or Payment Type.
  6. Click Search.

The report displays the following information:

Payment No. The payment number, generated when the payment is applied in Simpro Premium.
Customer Click to open the customer card file.
Invoice No.(s) The invoices that the payment was applied to. Click the invoice number to open the invoice.
Date The date the payment was made.
Payment Method The payment method used to make the payment.
Cheque No. The cheque number entered in the payment, if applicable.
Credit Card Surcharge The credit card surcharge on the payment method, if applicable.
Total The total value paid.

If you need to deposit cash or cheque payments at a bank, you can use the Payments report to print a bank deposit slip.

To print a bank deposit slip:

  1. Run the report as normal. Make sure Bank Deposit is selected as the Display Format, and the right payment methods are filtered.
  2. At the bottom of the report, click Print Bank Deposit Slip.
    • The bank deposit slip opens as a PDF file in a new tab.
  3. Check that the information is correct and print the PDF.

To ensure the correct information is included in the bank deposit slip, you need to complete the necessary banking details in Profile > Settings > Banking in the customer card file.

You can download the information in the report as a spreadsheet in CSV format, viewable in Microsoft Excel and other spreadsheet software.

To download the report:

  1. Generate the report as required.
  2. Click the A grey arrow pointing downwards towards a CPM pictogram. icon in the top right, then click CSV.
  3. View, print or save the CSV, as required.