Cash Flow Projection

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

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.