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.
Note: This report is part of the INSIGHTS product, please contact your Account Manager to learn more.
|
Click on the links below for more information:
If you don't have access to INSIGHTS/Analyze, please reach out to your Account Manager. |
CHAPTERSLegend |
Legend
Filter Panel
Locating the Analyze Report
- Click on Analyze Tab
The Reports Sub Tab will automatically be selected - In the Search Reports field, type CASH
- Click on the Cash Receipt Report
Logic
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.
Filter Options
| Parameter Name | Options | Description | |
| Division | All available Employers | Use this filter to refine Employer of Invoice | |
| Region | All available Regions | Use this filter to refine Region of Invoice | |
| Office | All available Offices | Use this filter to refine Office of Invoice | |
| Company | All available Companys | Use this filter to refine the Company of Invoice | |
| AR Batch ID | Free Text | Use this filter to refine the AR Batch ID of Invoice | |
| Payment Type | All available AR Batch Types (Payment Types) | Use this filter to refine the AR Batch Type (Payment Type) of Invoice | |
| Reason Code | All available Invoice Payment Reasons | Use this filter to refine the Payment Reason of Invoice | |
| Date Type | Accounting Period Date, Invoice Date, Date Posted, Date Received | Use this filter to refine the Date Type of Invoice/AR | |
| Date From | Use this filter to refine Invoice/AR falling under the date range as per the Date Type selected. | ||
| Date To | |||
| Date Range | None, Yesterday, Today, Tomorrow, Last Week, This Week, Next Month,etc. | When 'Date Range' is selected, 'Date From' and 'Date To' will be automatically disabled. The user will need to select either 'Date Range' or enter 'Date From' and 'Date To'. |
Graphs/Widgets
Field Details
- Click here to go to the Invoice and Accounts Receivable Category (list of Analyze Reports)
- Click here for more information on Terms and Filters (Analyze Reports)
- Click here for more information on System Terms (Glossary)
| Field Name | Description | Notes |
| Invoice Employer | Invoice Employer | |
| Invoice Region | Invoice Region | The field is hidden but it can be selected from top to display in the report |
| Invoice Office | Invoice Office | |
| Receipt Date | Invoice Payment Received Date | |
| Invoice Date | Invoice Date | |
| Days Out | No. of Days difference between Invoice Date and Payment Received Date | |
| Company ID | Invoice Company ID | |
| BO Company ID | Company ID from Back Office/Classic | The field is hidden but it can be selected from top to display in the report |
| Company | Company Name | |
| Department | Company Department | |
| Invoice Number | Invoice Number | |
| Invoice Amount | Invoice Amount | |
| Payment Amount | Invoice Payment Amount Received | |
| Date Posted | Invoice AR Batch Posted Date | |
| Payment Type | AR Batch Type (Payment Type) | |
| AR Batch Payment Amount | Total Amount Received on the AR Batch | |
| Check Number | AR Batch Check Number | |
| AR Batch ID | AR Batch ID | |
| Reason Code | Invoice Payment Reason | |
| Total No Of Days Aged | Sum of days difference between Invoice Date and Due Date of the Invoice filtered on the Date Range | |
| Total Balance Amount | Total Balance Due of the Invoice filtered on the Date Range | |
| Total Invoice Amount | Total Invoice Amount of the Invoice filtered on the Date Range | |
| 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. | |
| Avg Supplier DSO | Sum of DSO per Employer / Count of Invoice related to the Employer | |
| Avg Grand DSO | Sum of Total DSO / Count of Total Invoice for the date range |
Comments
0 commentsPlease sign in to leave a comment.