Skip to main content
GenerateInvoice

Business Finance Workbook

See profit, cash and what comes next

For owners who want their numbers in one place.

Enter invoices, bills and bank movements once, and the reports fill themselves in. The workbook has sales and purchase ledgers with ageing, a general journal, a monthly profit and loss, a 12-month cash-flow forecast, a balance sheet, budget vs actual with variances, and a dashboard with eight ratios, from gross margin to months of cash runway. Each row can be in its own currency and is converted to your base currency. Formula cells are locked, there are no macros, and it works in Excel and Google Sheets. A short guide explains the set-up and every sheet.

Who it's for

For owners who want profit, cash and what is owed in one place without paying for accounting software, and for anyone preparing figures for a bank, an investor or an accountant. It works in Excel and Google Sheets, in any currency.

What's in the kit

Editable files you download and keep. Word files open in Google Docs and Excel files open in Google Sheets.

  • Business Finance Workbook (12 linked sheets)

    Excel · XLSX

  • Set-up and user guide

    Word · DOCX

How to use each file

  1. Business Finance Workbook (12 linked sheets)

    Set your base currency and opening balances once, then enter invoices, bills and bank movements as they happen. The profit and loss, cash-flow forecast, balance sheet, budget comparison and ratio dashboard update themselves.

  2. Set-up and user guide

    Read it first. It walks you through the set-up, explains each of the 12 sheets and shows how to read the ratios.

An example

Imagine Yuki, who runs a small design studio in Osaka with clients paying in yen and US dollars. She enters each invoice and bill in the ledgers in its own currency. Before applying for a bank loan she checks the dashboard and the balance sheet, and the cash-flow forecast shows a tight month in the summer, so she moves a large equipment purchase to the autumn.

An illustration of how it is used, not a customer story.