AR Statistics with Invoice details as a CSV file for Excel import. **This information can also be found in the ID770 Financial Insights Power BI Report.**
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
**This information can also be found in the ID770 Financial Insights Power BI Report.**
This is just a data dump of AR data and measurements for your use and review. It can, for instance, be used to benchmark customers' late payment tendencies or to provide overall metrics on your AR process. It's designed to give you a handy spreadsheet to play with so you can 'eyeball' potential problems and quickly sort against different fields to 'gut check' certain trends.
Run Schedule: First of the month at 7:30 AM
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Look Back Days - Enter the number of days to look back for the data on the report.
* * *
Alert Functionality
Alert Functionality
1. Included data:
Customer Name
Invoice #
Due Date
Invoice Date
Total - face value of invoice
First Pay Date - date of first payment applied to this invoice (assumes possibility of partial payment)(this is NOT the date it was applied, but the date monies were received)
Pay Full Date - date invoice was paid in full (assumes possibility of partial payment)(not date applied, as above)
Due day - When final payment was received relative to due date (negative # means before, positive # means after)
Billed da(te) - # of days after invoice date that last payment was received
Terms - of individual invoice
Days late - How many days after the due date was the last payment was received
Last update - system record, irrelevant, and please disregard
* * *
Best Practices & Tips
Best Practices & Tips
All of the data contained in this Excel file can be accessed in the ID770 Financial Insights Power BI report. We would recommend using Power BI instead of this monthly report.
* * *
Related Alerts
Related Alerts
ID770 - Financial Insights Power BI Report
* * *
0 Comments