Standard Report - Cash Receipts

Overview

Updated 07/16/2021

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
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	The date in which staffing company received payment from customer.
Posted Date	The date in which AR Batch is posted.
Invoice Number	Invoice Number from Invoice
Invoice Date	Invoice Date from Invoice
Invoice Amount	Invoice Amount from Invoice
Check Number	Check Number of a check
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	ID of 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	List outs all choice codes with category InvoicePaymentReason like Auto Correction, Bad Debt, Billing Error, Regular Payment, etc. 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.

Back to Top