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.

CashReceipts.png

 

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.

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share