The Goal: Run the Accounting Transaction Report configured to show all sales (credits, invoices, sales receipts, and write-offs) for a given month, excluding receivable accounts.
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 Credit, Invoice, Sales receipt, and Write off.
- 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 > NOT Contains > Receivable.
- Set Summarize By to Account Name.
- Click Run Report.
Common Pitfalls
- Refunds as anomalies: Refunds work differently — their accounting flows from accounts payable (debit income, credit cash) and do not impact A/R unless they refund an overpayment. They will not appear in this report.