A simple structure for financial reporting in Excel
Keep data, calculations and reporting on separate sheets to make the workbook easier to check and update.
Read article →FP Academy
Understand the numbers. Use the knowledge in practice.
Keep data, calculations and reporting on separate sheets to make the workbook easier to check and update.
Read article →Use simple calculations to distinguish a relative change from the difference between two percentages.
Read article →Separate activity, prices and costs in a budget you can update by changing its assumptions.
Read article →Use a fictional service business to distinguish its performance over a month from its position at month-end.
Read article →The budget records the plan. The forecast gives the latest expectation. A simple example shows how both support financial reviews.
Read article →Calculate the difference between budget and actual in DKK and percent, then explain what the sign means.
Read article →