Sales Expenses Profit Dashboard Excel Template, English & Finnish Edition, Finland VAT ALV Tracker, Small Business KPI Report

See your shop's month at a glance: revenue, expenses, net profit, margin, VAT payable and unpaid sales, with charts and short written insights that update from your own data. Pick a month from one dropdown and the whole dashboard changes with it. Works in English or Finnish (Suomi): switch the language on the Settings sheet.

WHO IT'S FOR

• Small shops, minimarkets, cafés, salons, online sellers and freelancers who want a clear monthly overview without accounting software

• Businesses in Finland that need ALV-aware figures (Finland VAT 25.5% / 13.5% / 10% / 0%), and businesses anywhere: the VAT rates and currency are editable

• Finnish-speaking owners and staff: every label, menu, chart title and insight is also available in Finnish

FEATURES

• Dashboard with 6 KPI cards: Revenue, Expenses, Net profit, Profit margin %, VAT payable, Unpaid sales. Each card shows the change vs the previous month with a green or red arrow

• Month selector: one dropdown drives every card, chart and insight (month names work in English or Finnish)

• 6 charts: revenue vs expenses (12 months, with target line), net profit trend, top 5 products, expenses by category, payment methods, sales target progress

• Smart insights written by formulas, for example "Expenses up 8% vs last month", "Best day: Saturday", "Top product: …", "Target 97% reached", the number of overdue unpaid invoices and unpaid supplier bills

• Finland VAT (ALV) sheet: monthly and quarterly summary by rate. Output VAT minus input VAT = VAT payable or refundable

• Sales sheet: pick a product and enter the quantity. Category, price and VAT % fill in automatically (you can override them). Paid/Unpaid status, due dates and days overdue

• Expenses sheet: enter the amount incl. VAT. VAT % comes from the expense category if left blank

• Products, Categories & payment methods lists that feed the dropdowns

• Settings: language (English / Suomi), shop name, currency, fiscal year and start month, prices incl./excl. VAT, payment terms, VAT rates, 12 monthly targets

• Yellow cells = your input. Formula cells are locked and hidden to prevent accidental changes

• Print-ready dashboard (one A4 page)

WHAT'S INCLUDED (ZIP with 2 .xlsx files)

• Sales_Expenses_Profit_Dashboard_EN-FI_DEMO.xlsx: filled with 12 months of fictional sample data (an imaginary minimarket), so you can explore every feature

• Sales_Expenses_Profit_Dashboard_EN-FI_EMPTY.xlsx: ready for your own data

• A Guide sheet inside each file (English and Finnish)

REQUIREMENTS

• Microsoft Excel 2016 or newer (Windows or Mac) or Microsoft 365 desktop. No macros, no add-ins

• It also opens in LibreOffice Calc. Charts and fonts may look slightly different there

• Not designed for Google Sheets, Apple Numbers or Excel mobile apps

• Ready for 3,000 sales rows and 1,500 expense rows

PLEASE NOTE

• This is a digital download. No physical item will be shipped

• This is a planning and monitoring tool, not bookkeeping software and not an official VAT return. Please check your VAT figures in OmaVero or with your accountant

• The VAT rates are set to Finland's rates from 1 January 2026 and can be edited

• The demo shop, its products, customers and numbers are fictional

• Table column headers (the small grey row) stay in English so the formulas keep working. Every column has a translated label above it

• After switching language, the month box keeps the old-language month name until you pick a month again. It still works

• Need an Arabic right-to-left version? See the separate "Arabic RTL Edition" listing

• Because of the digital nature of the product, refunds are not offered, but message me if anything doesn't work and I'll help

SUOMEKSI

Myynnin, kulujen ja tuloksen kojelauta Exceliin pienyrityksille. Valitse kuukausi yhdestä valikosta: KPI-kortit, kaaviot ja havainnot päivittyvät. Alv-yhteenveto (ALV) kuukausittain ja neljännesvuosittain, Suomen verokannat 1.1.2026 alkaen (25,5 % / 13,5 % / 10 % / 0 %). Kieli: englanti tai suomi. Ei makroja, Excel 2016 tai uudempi. Suunnittelutyökalu, ei virallinen alv-ilmoitus. Esimerkkitiedot ovat keksittyjä.