The Goal: Run the Accounting Transaction Report configured to show all payments and overpayments for a given month.
Before You Begin:
- Staff access to Reports is required.
- Decide the month you are reporting on before beginning.
Step-by-Step Instructions
- Go to Reports in the left-hand rail, click Accounting Transaction Report.
- In the Transaction Type dropdown, select Overpayment and Payment.
- In Transaction Date Range, select the month you are working for — for example, June 1st to June 30th.
- Under Additional Criteria/Filters, set Account Name > Contains > Receivable.
- Set Summarize By to Account Name.
- Click Run Report.
Common Pitfalls
- Forgetting to include Overpayment in Transaction Type: Overpayments affect A/R and must be included alongside Payments for an accurate monthly payments report.