All Payments report template

Overview

The All Payments report template allows you to create a report to review collected payments, identify payments made by customers, and see which invoices they are tied to. It provides details on applied amounts, remaining unapplied amounts, and other payment specifics.

Things to know

• If you’re unsure which columns you want to include in your report, use the Reporting Dictionary to search for appropriate data fields.

• You can use this template to create as many custom reports as you need. Each report created from the template is independent and can be run or scheduled without needing to recreate it from the original template.

Report examples

• Create a report that shows the employee who created a payment. This can be used in place of the Accounting Audit Trail to show specific payment activity, such as who created the payment, when it was created, the paid-on date for the payment, and more. 

• Create a report of all payments received from a specific customer within a given date range. This allows you to see all payment details, applied amounts, and unapplied amounts for that customer’s transactions. 

• Run a report of all pending payments across all customers for a particular batch number. This could help in reconciling payments that have been initiated but not yet posted or exported. 

• Create a report showing all payments made with credit cards, including transaction status and the employee who created the payment. This can help you audit credit card transactions and track their processing status.

Create an All Payments report

Follow the steps to create a custom report based on the All Payments template and select the columns to include in your report. 

The template has the following columns selected by default:

• Payment ID: The ID of the payment.

• Payment Business Unit: The business unit associated with the payment. 

• Payment Type: The name of the payment type that is tied to the payment record.

• Payment Method: The name of the attribute tied to the payment type in Settings. Can be Credit Card, Bank Account (ACH), Check or Cash. 

• Payment Amount: The amount of the payment. 

• Amount Allocated: The amount applied to invoices from the payment amount. 

• Credit Remaining: The remaining amount from the payment after applying the payment to invoices. 

• Batch Number: The batch number under which the payment is batched. 

• Payment Status: The export status of the payment. Can be Pending, Posted, or Exported. 

• Transaction Status: The transaction processing status. Used when the Payment Type is Credit Card or Check. Can be Pending, Successful, or Error.

  Tip: Hover over the name of the column to see a short description.

You can customize the report by selecting additional columns from these sections:

• Technician/Employee Details: The name of the employee or technician who created the payment. 

• Dates: The Payment Date and the Created On date. 

• Customer Information: Details about the customer who provided the payment, such as Customer Name, Customer Address, Customer Phone, Customer Email, and Customer Type. 

Run the All Payments report

1. Click the Payment Date (from) - Payment Date (to) field to set date filters. You can:  

   • Use the calendar to select a specific date range and then click Apply.
     

   • Use the left menu to select a preset date range:

     • Today: From 12:00 AM to the current time.

     • Yesterday: Previous day, from 12:00 AM to 11:59 PM.

     • This Week: From Monday through Sunday of the current week.

     • Week to Date: From Monday through the current date of the current week.

     • Last 7 Days: Previous seven days, including today.

     • Last 14 Days: Previous 14 days, including today.

     • Last 30 Days: Previous 30 days, including today.

     • Month to Date: From the first of the current month to the current day.

     • Last Month: Entire month before the current month. For example, if the date is February 5, the entire month of January.

     • Last 90 Days: Previous 90 days, including today.

     • This Quarter: Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.

     • Last Quarter: Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.

     • Quarter to Date: From the first day of the current quarter to the current day.

     • Year to Date: From January 1 of the current year to the current day.

     • Last 365 Days: Previous 365 days, including today.

     • Last Year: From January 1 of the previous year to December 31.

2. Use the Payment Status dropdown to select the status you want to report on. You can filter on Pending, Posted, and Exported.  By default, all statuses are selected.
   

3. Use the Batch Number field to search for a specific batch number to report on.
   

4. Use the Customer field to search for a specific customer to report on.
   

5. Select Include deleted payments to include any payments that were deleted in the report results. 

6. When you’re finished, click Run Report. 

Want to learn more?