Customer Transactions Report

What This Report Is

This report shows all customer activity during a selected date range. It lists both sales and payments made by each customer, with details like the date, receipt number, and amount. You can filter by customer and export the data or create an invoice.

Why It Matters

• Lets you track customer balances and account activity.
• Helps you spot missing or incorrect payments.
• Useful for creating invoices or reviewing disputes.
• Supports bookkeeping and tax records.

What to Look For

• Account ID – The customer’s account number.
• Business Date – When the sale or payment happened.
• Sales Type – Tells you if it's a Sale or a Payment.
• Amount – Positive numbers = sales; negative = payments/refunds.
• Total Transaction – The overall balance for that time period.

What to Do

• Check for missing payments: Make sure regular customers are up to date.
• Review large amounts: Confirm any big payments or refunds are correct.
• Create an invoice: If needed, click the “Create Invoice” button for billing.
• Export your records: Use the Excel export to keep for accounting or audits.
• Investigate account errors: Negative totals may need attention if they don’t match expected balances.