For monitoring your cash flow projection and alerting when cash shortages or too high balances are coming up.
The out of the box template plots (GL Cash Today) + (Open AR) - (Open AP) - (GL Projected Payroll) + (user-input adjustments, ex.: a loan payment).
Popular Customizations:
-
This template requires adjustments to capture the correct GL accounts for Cash Today and Payroll Projection.
-
It's easy to add other cash flow transactions (such as recurring revenues and expenses) from your ERP and other data silos such as Excel.
Chart
-
Bars: In/outbound cash (such as inbound for open Receivables or AP Credit Memos).
-
Line: Based on the Due Date filter, it accrues daily net balances. The line turns reds when crossing below the Line of Credit (LOC) limit indicating a potential cash flow issue.
Slicing and Dicing
-
Clicking a single or multiple bars to filter the detail panel.
-
Use the Filters and Parameters on the right panel to fine tune your analysis.
-
Cash Flow Adj: will add one user-entry record to your projection. Ex.: big loan payment coming due but not in AR yet.
-
-
Undo/Redo (top left).
-
Revert (top left) will bring the default back to its pre-saved settings.
-
Full Screen (top right).
-
Download (top right).
-
Regular keyboard and mouse standards apply (such as press and hold the Ctrl button to select multiple data points).
Alerts
-
Automatically emailing the dashboard only if the trend line crosses a threshold - for instance, when the trend line goes below the LOC limit.
-
Click the Y axis on the left, then Alert on the top right, fill out the form.
Emailing on a Schedule
-
Click Subscribe on the top right and fill out the form.
Commenting
-
Click Comments on the top right. Tagging a person with @ will email them the comments.
Embedding it in other Applications
-
Search for "embed" on the top right box to find articles aboiut embedding this dashboard into other applications.