Applied Payments report template

Overview

The Applied Payments report template is used to create custom reports on payment details. It allows you to track information such as payment type, method, amount, and the associated invoice, as well as job, customer, and employee details. This report helps you monitor and analyze payment data.

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 all credit card payments received for completed jobs within a specified date range. This helps you track and reconcile credit card payments, ensuring all completed jobs have associated payments within a specific timeframe. 

• Run a report detailing payments made by check, filtered for specific business units. This helps you analyze payment methods across various business segments. 

• Create a report that lists cash payments, categorized by customer type and location, along with the date the payment was applied. This helps you analyze cash payment trends, identify patterns based on customer type and location, and verify when these payments were applied. 

Create an Applied Payments report

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

The template has the following columns selected by default:

• 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. 

• Amount: The amount of the payment. 

• Invoice Number: The invoice number of the invoice to which the payment record is applied. 

• Memo: The contents of the memo field on the payment record.

  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:

• Dates: Details about dates related to the payment, including Paid On, Invoice Date, Completion Date, and Scheduled Date. 

• Job and Invoice Details: Details about the jobs and invoices related to the payment, such as Job type, Job Business Unit, Job Status, Invoice Status, Invoice Total, Invoice Balance, and more. 

• Technician/Employee Details: Details about the technician or employee associated to the payment, such as Created By, Assigned Technicians, Primary Technician, or Sold By. 

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

• Tags: Details about the tags that can be associated with the payment, such as Job Tags, Customer Tags, or Location Tags. 

Run an Applied Payments report

1. Click the Filter By field to select the type of date you want to report on. You can select Completion Date, Invoice Date, or Paid On. By default, this filters for Completion Date.

2. Click the From - 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.

3. Click the Business Unit dropdown and select the business units (BUs) you want to report on. By default, the report runs for all BUs. You can filter your report by business units or business unit categories:

   • Click the dropdown to select individual BUs.
     

   • To report on BU categories such as trade or division, click Filter , select the BU categories you want to include, and click Filter.
     

     Note: How BU filters are applied depends on the key performance indicator (KPI). Hover over a column header for details.
     

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

Want to learn more?

• See Edit custom reports

• See Run, filter, and export reports

• See Schedule reports