Please use this link if the embedded video isn't displaying:
OVERVIEW
The Cash Receipts visualization provides an overview of the amount predicted and collected in the form of a bar graph. This data is viewable in both a monthly breakdown (Last 12 months and upcoming 2 months) and weekly breakdown (Last 8 weeks and upcoming 8 weeks.) This data is updated during the sync process when the aging process is run. The last time the data was updated is notated right below the Cash Receipts title.
By hovering over a previous month, you will see the amount that was projected for that month as well as the actual dollar amount collected.
MONTHLY:
By hovering over the current or subsequent two months, you will see the amount that is projected for that month as well as the actual dollar amount collected so far.
The "Projected" field is the total sum of 5 different categories of predicted information. Adding these 5 categories together should equate the total projected amount for that month.
PROMISED - The expected payment amount where the customer promised payment by a certain date.
EXPECTED - The expected payment amount where the customer DID NOT promise payment by a certain date.
PREDICTED - Amount projected based on the customer's payment history.
DUE - Amount projected that is based on the due date if no payment history is available.
UNRESOLVED - Past due invoices without an expected or promised date.
Below that is the "At-Risk" field, which shows you the total amount that is left open that is not being paid for an undetermined reason. Adding these 3 fields should add up to the "At-Risk" total.
DISPUTED - The total amount of all invoices in dispute that are due that month.
OPEN CREDITS - The total balance of invoices with an open credit associated with the account.
UNAPPLIED PAYMENTS - The total balance of invoices with an unapplied payment associated with the account.
WEEKLY:
Additionally, you can select "Weekly" right below the bar graph to switch to a week by week overview of the same information.
This will allow you to see the last 8 weeks of projections and how much was actually received and also the upcoming 8 weeks of projections. The weeks will run from (Monday - Sun).
DRILL DOWN:
Clicking on any of the bars in the graph will allow you to see the information used in the calculation. This data will be a combination of predicted payment records and actually accepted payment records for that time period. This works on both the Monthly and Weekly breakdowns.
The page you are taken to is unique to the dashboard and cannot be accessed by other means. Once you are on the page, you can see the predicted payment date, payment amount, payment reason, and payment days for each record.
The Predicted Payment Reason will give you insight as to how that projected payment was created for that invoice.