Standard Report - Cash Receipts

Report Description

This report gives the details of the amount of cash incoming and the source of those payments. It gives a great snapshot of accounts receivable and can be helpful when posting payments.

Parameters

Parameter Name	Options	Explanation
Date Type	Accounting Period, Date Posted, Invoice Date, Date Received	Parameter’s dates from AR Batch Payment
Group By	All, Branch, Customer, Date Posted
Start Date
End Date
Payment Type	All, AR Adjustment, Bill Correction, End of Year, Payment	Lists out all choice codes with category ARBatchType
Reason Code	All, Auto Correction, Bad Debt, Billing Error, etc.	Lists out all choice codes with category InvoicePaymentReason
Branch	All available branches	Filters results by Invoice branch
Batch ID		Filters results by Batch ID.
Customer Name		Filters results by Customer Name.

Report Fields

Field Name	Explanation
Branch Name	Branch from Invoice Will be visible when Branch is selected under Group By Parameter.
Date Posted	Date Posted from ARBatchPayment Will be visible when Date Posted is selected under Group By Parameter.
Customer Name	Customer Name from Invoice Will be visible when Customer is selected under Group By Parameter.
Date Received	Payment Received Date from the Customer
Posted Date	AR Batch Posted Date
Invoice Number	Invoice Number
Invoice Date	Invoice Date
Invoice Amount	Invoice Amount
Check Number	Payment Check Number
Check Amount	The total payment amount by a check
Payment Amount	The total payment amount received from a customer
Batch Type	List outs all choice codes with category ARBatchType like Payment, Bill Correction, etc.
Batch ID	AR Batch
DSO	If invoices are partially paid then it’s the number of days between invoice date and End Date parameter If invoices are fully paid then it’s the number of days between invoice date and last payment received date.
Reason Code	Invoice Payment Reason Code Will be hidden when Customer is selected under Group By Parameter.

Notes

The Subtotal for check amount only sums the check amount for individual check numbers. From the screenshot above we can see that the subtotal only shows the total for individual checks and does not sum the duplicate check amount of the same check number.