Daily Cash Receipts Report Overview

Last reviewed: June 9, 2026

llms-full.txt
On this page

The Daily Cash Receipts Report shows customer payments received on one selected date.

What this report is for

Use Daily Cash Receipts Report to review payments recorded for a single day.

This report is useful for daily cash review and payment reconciliation. It is not an AR aging report and does not show invoices with no payment activity on the selected date.

Screen path

Dashboard > Sales > Reports > Daily Cash Receipts Report

Filters and actions

Control What it does
Date Payment date to report. Defaults to today.
Run Report Loads payments for the selected date.
Copy for Excel Copies report data and totals to the clipboard.
Print Opens the report content in the browser print flow.

Report columns

Column What it shows
Pay # Payment ID.
Customer Customer code.
Name Customer name.
Invoice # Invoice number, or Prepayment for unlinked prepayment rows.
Method Payment method.
Reference Payment reference.
Amount Net cash amount shown as payment amount less fee.
Fees Fee amount when fees exist in the selected data.
Early Disc Early payment discount when present.
Manual Disc Manual discount when present.
Recorded By User who recorded the payment.

The report also shows payment method summary cards and a gross receipts total.

What happens behind the scenes

PAX reads payment records for the selected payment date and joins customer and user data.

The report excludes payments where payment method is Customer Credit or Return Credit. Those methods represent credit application or return credit activity rather than new cash received.

Report totals include:

  • Payment count.
  • Gross receipts.
  • Fees.
  • Early payment discounts.
  • Manual discounts.
  • Net amount, calculated as gross receipts less fees.
  • Totals by payment method.

Running, copying, or printing the report does not record payments, apply credits, update invoices, or post accounting.

Troubleshooting

No payments are found

Likely cause: No payment records have the selected payment date, or the only activity was customer credit or return credit.

Safe fix: Confirm the payment date used when payment was logged.

Contact support if: A payment with the selected date appears in payment history but not in this report.

Amount differs from gross receipts

Likely cause: The Amount column shows net cash after fees. Gross receipts show the original payment amount before fees.

Safe fix: Use net amount for cash received and gross receipts for total payment amount before fee reduction.

Contact support if: Fee values are incorrect.

Was this page helpful?

Vote *