The Payment Records Report displays all payment and refunds by date and Operation. Any payment that shows in this report is already applied to an invoice, so payments not yet applied will NOT display in this table. For net YTD/monthly totals that account for refunds, see the Payment Totals Report.
In this article:
Navigate the Payment Records Report
Reports > Sales and Payments > Payment Records
Filters
Date | Selects payments based on the date the payment was made. |
Operation | Operation associated with the Invoice that payment was applied (e.g. maintenance, design/build, tree service, etc.) If none are selected, all will be included in the report. |
Sales rep | Filter by Sales Rep associated with the Invoice that payment was applied. |
Include records from QuickBooks checkbox | Payment records from QuickBooks are not included by default. Checking this box will include payments synced from QuickBooks in the report. |
Only Refunds checkbox | If checked, only refunds will be displayed. For how refunds and surcharges are applied, see Apply Payments, Voids & Refunds. |
Summary Data for Business Insights (Premier Tier Only)
Summary Data for Business Insights enables you to take all of the information in a report and summarize it to develop powerful insights into your business.
Search
Search this report based on Client's name, Payment Method, Job name, Payment Record notes, Operation, User's name or the Reference Number for the Job, Visit, Invoice or Payment.
Columns
Click Columns and select one or multiple column types. To add and remove columns, the columns in blue will display in the report.
Rearrange Columns by clicking and holding the column header, move to the left or right and drop. Sort rows by clicking the up & down sort arrows icon, click once to sort from low to high, and again to sort from high to low.
Operation | Operation associated with the Invoice that payment was applied (e.g. maintenance, design/build, tree service, etc.) |
Invoice # | Invoice reference number that links to the Invoice information page. |
Invoice Date | Invoice date (month, day, year) |
Client | Client name that links to Client information page. |
Job | Job name that links to Job information page. |
Payment # | Payment number |
Payment Date | The date the payment was made (month, day, year) |
Payment Method | Payment method type (credit card, cash, check, etc.) |
Is Prepay | ✅ will indicate if payment was taken as a prepayment |
Is Deposit | ✅ will indicate if payment was taken as a deposit |
Amount | Total dollar amount paid |
Sales Tax Amount | Tax amount applied for payment |
Processing Fees | Total processing fee paid in dollar amount |
Less Tax & Fees | This is the subtotal before taxes/processing fees are added to the payment. |
TXN ID | Transaction ID |
Notes | Notes associated to payment |
User | User who added the payment |
Sales Rep | Sales Representative associated to that Job |
Zip Code | Regional postal code based off the Job's geographical location |
⚠️ This report does not include job/visit completion status. To review payments alongside job status, cross-reference the Jobs Report or Invoices Report.
Total / Average
At the bottom of the page, totaled amounts for four columns - Amount, Sales Tax Amount, Processing fees, Less Tax & Fees - can be found.
⚠️ These Totals reflect the sum of the displayed Payment Records on this page only (<10), not the entirety of search results. Additional Payment Records results can be accessed by clicking through the additional pages at the bottom right of the screen.
Payment Reports Video
Note: Some of the content in this video may reflect a previous version of SingleOps. For a more accurate guide, please refer to the steps listed above.