FP Academy · INSIGHTS

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.

Mohammad Amar · Founder & Owner · 08.10.2026

Make the workbook understandable next month

A colleague should be able to trace the numbers, understand the calculations and see what the reader needs. Three sheets provide a repeatable workflow without advanced functions.

Sheet 1 — Data

Use one row per observation, such as an expense or budget entry. Columns might include Month, Department, Category and Amount. Use consistent labels. Excel can treat “Transport” and “Transport costs” as separate categories. Avoid merged cells and blank rows in the list. Store amounts as numbers and dates as dates.

Select the range and choose Insert → Table to add filters and make the list easier to extend.

Sheet 2 — Calculations

Summarise the data and calculate variances. If budgeted costs are DKK 50,000 and actual costs are DKK 53,500, the difference is DKK 3,500. The relative variance is 3,500 / 50,000 = 7%.

With actual costs minus budget, a positive variance indicates overspending. Explain the convention in words as well as colour. Reconcile the total with the source. A correct total can still contain a misclassified expense.

Sheet 3 — Report

Show budget, actual spending, variance and a brief explanation for each relevant category. Label the period and unit, for example “October, DKK excluding VAT”. Identify exceptions and give the last update date.

Finish each update consistently

Check the period, reconcile totals and review the largest variances. Save a dated copy when a record is needed and share only the data the reader needs. FP Academy’s Excel for Finance and Reporting course teaches these workflows to beginners and learners with some experience.