Cash Charts

Note: When importing data from MYOB or Sage 50 Accounts, please be aware that due to a limitation in the Cash data available from these accounting systems 'Cash' charts may show erroneous values. If this occurs, please use accrual-based charts.

Cash in and out

Explanation

Shows month by month comparison of cash coming in vs. cash going out. Please note that this chart is only available for Xero users.

Formula

Cash In: Bank Accounts (Debit)
Cash Out: Bank Accounts (Credit)

Report codes used

ASS.CUR.BAN

Cash on hand - daily

Explanation

Allows you to track cash on hand, at the close of business, for each day of the month.

Formula

Bank Accounts (Daily balances)

Report codes used

ASS.CUR.BAN

Note: This chart is not suitable for entities that have foreign currency bank accounts, as these values are not imported into Spotlight so will be excluded.

Cash on Hand - with High and Low Balances

Explanation

Shows the bank balance highs and lows during the month, which allows you to track how often you are dipping in to overdraft. The dot represents the closing bank balance at the end of the month.

Formula

Bank Accounts (Highest and Lowest balance)

Report codes used

ASS.CUR.BAN

Cash Target Monitor

Explanation

Shows how close the organisation is to meeting cash targets set for the year - allows you to monitor cash levels.

Formula

Bank Accounts (Debit and Credit) compared to the set KPIs.

Report codes used

ASS.CUR.BAN, KPI.CAS, KPI.CASH.INF, KPI.CASH.OUT

Current Month's Cash

Explanation

Shows cash in flows (green) and cash out flows (orange) for the month. This demonstrates where the profit is being spent, and why the profit and bank balances don't match.

Formula

Trading Revenue, Other Revenue, Loans, Cost of Sales, OPEX, CAPEX, Dividends, Wages, Drawings, Tax, Other Assets, Equity, Other Liabilities

Report codes used

REV.TRA, REV, LIA.NCL.LOA, LIA.CUR.LOA, EXP.COS, EXP.COS.WAG, EXP, EXP.TAX, EXP.WAG, ASS.NCA.FIX.OWN, LIA.CUR.PAY.DIV, LIA.NCL.ADV.DRA, LIA.CUR.TAX, ASS, ASS.CUR.BAN, EQU, EQU.RET, LIA

Expense Cover Trend

Explanation

Shows how many days' worth of expenses can be covered by the closing bank balance and receivables. Can help to evaluate whether a bank overdraft facility is need.

Formula

(Bank + Receivables) / Average Monthly Expenses excluding Tax (12 months) * 30

Report codes used

ASS.CUR.BAN, ASS.CUR.REC, EXP, EXP.TAX

Future Cash

Explanation

Shows the expected future cash inflows and outflows.

Formula

Trading Revenue, Other Revenue, Loans, Cost of Sales, OPEX, CAPEX, Dividends, Wages, Drawings, Tax, Other Assets, Equity, Other Liabilities

Report codes used

REV.TRA, REV, LIA.NCL.LOA, LIA.CUR.LOA, EXP.COS, EXP.COS.WAG, EXP, EXP.TAX, EXP.WAG, ASS.NCA.FIX.OWN, LIA.CUR.PAY.DIV, LIA.NCL.ADV.DRA, LIA.CUR.TAX, ASS, ASS.CUR.BAN, EQU, EQU.RET, LIA

YTD Cash

Explanation

Shows cash inflows (green) and cash outflows (orange) for the year to date. Helps to show where cash is being spent, and if this could be streamlined better.

Formula

Trading Revenue, Other Revenue, Loans, Cost of Sales, OPEX, CAPEX, Dividends, Wages, Drawings, Tax, Other Assets, Equity, Other Liabilities

Report codes used

REV.TRA, REV, LIA.NCL.LOA, LIA.CUR.LOA, EXP.COS, EXP.COS.WAG, EXP, EXP.TAX, EXP.WAG, ASS.NCA.FIX.OWN, LIA.CUR.PAY.DIV, LIA.NCL.ADV.DRA, LIA.CUR.TAX, ASS, ASS.CUR.BAN, EQU, EQU.RET, LIA

‍

Still need help?

Get in touch!