Tab layout, including contents
Legend Reference | Description | Long Description | Content | Points for discussion |
L | Legend | Indexation for tabs within the workbook
Model architecture
Checks / Flags
View / Edit rights | - Model Legend
- Model checks
- Model Architecture | |
A | Assumptions | Assumptions sheet for model - all general assumptions should go here as inputs | - Key details (including VAT number, Tax reference number etc)
- Bank account details
- Recurring Revenue assumptions (that drive the Forecast)
- Revenue recognition assumptions
- Other assumptions (that drive the Forecast) - VAT | |
S | Summary | Summary sheet used for monthly cash flow calls and monitoring | - We will still require this tab for MB Master unless we embed the renewals process into FS (I don’t think it has this functionality). Suggestion: 1) Aged debt should be covered through reports that are generated from Xero (by Meriel) and 2) Upcoming POs and renewals to be managed manually / using FlowRev | |
PL | Profit and Loss | PL summary which uses both the R and C tab | ||
F24 | ||||
F23 | ||||
C | Costs | Breakdown of costs used for budgeting and forecasting | ||
RR | Recurring Revenue | Details of all contracts and invoices - important sheet used to calculate RR and Def/ Acr income | To come from FlowRev/ Xero in new process | |
R | Revenue | Breakdown of revenue used for budgeting and forecasting | ||
NR | Non-Recurring Revenue | Details of all contracts and invoices - important sheet used to calculate NR and Def/ Acr income | To come from FlowRev/ Xero in new process | |
OUTPUTS | ||||
KPipe | Known Pipeline | Pipeline from freshsales used in forecasts | ||
KPipe - FY24B | Known Pipeline | |||
UPipe | Unknown Pipeline | Estimated pipeline used to budget sales targets | To remove | |
CFP | Cash Flow Forecast (Including Pipeline) | Cash Flow forecast including pipeline | ||
CFNP | Cash Flow Forecast (Excluding Pipeline) | Cash Flow forecast excluding pipeline | ||
CF - Graphs | To remove and combine directly to the CFP and CFNP tabs | |||
TB | Trial Balance | Preparation of the TB using information from Xero and making adjustments where required | ||
MKT | Marketing | Marketing tab | Measure the marketing outturn vs the budget | To combine into the F24 tab |
INPUTS | ||||
Xero | Xero | Data input using extract from the Accounting system | ||
FY23B | FY23 Budget | FY23 financial budget. Used for the FY23 outturn | ||
FY24B | FY24 Budget | FY24 financial budget. Used for the FY24 outturn |
- A
- S
- PL
- FY24 Budget
- FY23 Outturn
- L
- C
- RR
- R
- NR: No longer requried. All invoices to be entered into Xero or Flowrev
- Pipeline: Keep. Needed for the purposes of the CF forecasting
- Pipeline - FY24 Budget
- UPipe?: Remove
- TB - To remove. TBC how we treat accrued liabilities, but these should be able to be entered into Xero / Flowrev
- CF - Base (With Pipe): Keep
- CF - Base (Exc Pipe): Keep
- CF - Graphs: Keep
- XERO-INPUT: Keep as required for the Outturn
- FY23B: Legacy so can be removed
- MKT
- FY24B