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.
Comments
0 comments
Please sign in to leave a comment.