Group finance controller
Group Finance Reporting
★
Deadlines & status
Every report, its deadline, and whether it was sent on time.
Cash by company
Bank accounts
Each balance = opening balance (or the last book balance typed) + In − Out from Transactions.
Day by day
Red = balance below zero or below the minimum
Expected items
From the Forecast sheet (company items)
Personal accounts
Latest balances
Personal movements
Coming up (next 7 days)
Personal items from the Forecast sheet
4-week projection
Loan and tax payments due are shown for information (add them to the Forecast sheet to include them in the totals)
Net cash flow by company
Inflows minus outflows per week
Large payments this week
Loan & tax deadlines (next 14 days)
From the Loans & tax sheet
Report submissions this week
From the submission log
Exceptions
Incidents this week, accounts below minimum, open reconciliation items
Book vs bank
Unreconciled items
Open items with an explanation
Discrepancies requiring action
Difference not explained by open items
1. Group cash position
Balance at month end
2. Group revenue
From Monthly results
3. Group expenses
All companies
4. Group profit / loss
Revenue minus expenses
5. Debt position
Loans and tax from the Loans & tax sheet
6. Tax position
Owed, paid to date, remaining
7. Net worth
Assets minus liabilities
$
Compensation & accountability
✎
Data sheet
Type, paste or import the figures here, like a spreadsheet. Every report is calculated from this sheet.