Understanding the Cashflow Graph
The cashflow graph displays several kinds of data to give you a comprehensive view of your cashflow:
Cashflow Bars (Red & Green)
Inflows (Green Bars): Represent the cash coming into your business.
Outflows (Red Bars): Represent the cash going out of your business.
Each bar can be composed of different shades:
Dark Filled Bars: Stand for the total amount of paid inflows or outflows.
Light Filled Bars: Stand for the total amount of expected inflows or outflows.
Light Hashed Bars: Represent the gap to forecast for inflows or outflows.
👉 Note - The bars:
Do not include ignored transactions.
Do include transactions on ignored accounts.
Only display data related to the selected bank account(s), or all accounts if in consolidated view.
Cash Balance Curve (Blue Curve)
Purpose: Represents the evolution of your cash balance over time.
Computation: Based on successive cash balances.
The curve is:
Solid Line in the past (for paid transactions).
Dotted Line in the future (for expected transactions and forecasts).
👉 Note - The curve:
Does not include ignored transactions.
Does include transactions on ignored accounts.
Only displays data related to the selected bank account(s), or all accounts if in consolidated view.
Tooltips
When you hover over a point on the curve or a bar, a tooltip appears with detailed information for that period:
Cash Balance at Start and End: Shows the balances at the beginning and end of the period.
Adjusted Cash Balance: If applicable, displays the adjusted balance (consult the help center article for adjusted cash balance for additional info)
Inflows and Outflows: Breaks down paid, expected, and gap to forecast amounts.
Setting a Balance Overdraft
You can set a balance overdraft to visualize your overdraft facility:
Setting the Overdraft:
Navigate to Banks & Integrations.
Click on the three dots next to the account name.
Enter the overdraft amount (enter a positive value; Agicap will adjust it).
Visual Representation:
The overdraft appears as a light blue dotted curve at the bottom of the graph.
Hovering over the curve displays the overdraft value.
If multiple accounts with overdrafts are selected, their overdrafts are summed.
Adjusted Cash Balance (Purple Curve)
Adjust your cash balances to account for specific KPIs:
Purpose: Customize your cash balance to reflect factors like financial instruments, short-term liabilities, etc.
Defining an Adjusted Cash Balance:
Display a single account on the cashflow graph.
Hover over the current balance card (top left) and click the ➕ button.
Select the KPI to add or subtract from the actual balance.
Adjusted Cash Balance Figure:
Single Account: Adjusted balance = account balance +/- selected KPI.
Multiple Accounts: Sum of adjusted balances of selected accounts.
Adjusted Cash Balance Curve:
Displayed in purple.
The curve is:
Solid Line in the past.
Dotted Line in the future.
Disabling Adjusted Balance Card:
To disable the card next to the graph, please contact the support team via chat.
The purple curve will still be displayed on the graph.
Synchronization of Financial Investments
Invested Cash Display:
The total currently invested cash amount is shown in a box on the left of the graph.
The evolution of invested cash over time is represented by a purple curve on the graph.
Exclusive Display:
Adjusted Cash Balance and Invested Cash are exclusive; only one can be displayed at a time on the cashflow graph.
💡 Tips
Check Your Selections: Ensure that the correct accounts are selected to display the most relevant data.
Use the Tooltip: Hover over the graph elements to see detailed breakdowns of your cashflow for specific periods.
Customize Your View: Adjust the cash balance or set overdrafts to tailor the graph to your specific needs.
Q&A ❓
Why can't I see one of the bars on my cashflow graph?
Ensure that the bars are selected in the graph options. If a bar is still not visible, check the scale of the graph. If one data point is significantly smaller compared to others, it might not be visible due to the automatic scaling.
Why isn't the blue cash balance curve appearing on my graph?
Make sure the cash balance curve is enabled in the graph options. If it's still not visible, verify that the selected accounts have transactions that impact the cash balance.
How do negative values appear on the graph?
If any bars represent negative values (e.g., negative inflows), they will appear below the zero line on the graph. This helps you distinguish remaining amounts needed to complete the gap to forecast.
What is the light blue dotted curve at the bottom of the graph?
This curve represents your balance overdraft. It visualizes any overdraft facilities you've set for your accounts. The curve only appears if accounts with overdrafts are selected.