An invoice that adds itself up and prints on one page: line items, discount, tax, total, due date from terms. Pro fills the client's details and item prices from lists, and keeps a register of every invoice — outstanding, days overdue, status, aging buckets, next number. No macros.
Your details, invoice number and date, terms and due date, client block, twelve line items with qty × price, subtotal, discount %, tax %, total, payment details. Print area set to one page.
One row per invoice: total, paid, outstanding, due date from the client's terms, days overdue, status (Paid / Overdue / Part paid / Open). Aging buckets, total outstanding, invoiced and collected this year, next invoice number.
Name, address, email, payment terms — the invoice dropdown reads this and fills the client block.
What you sell with a default price; pick on the invoice and the price fills in.
Tax rate and default terms.
Ten formulas explained.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Twelve line items, qty × price, a discount, tax on the discounted amount, a total, and a due date that is the invoice date plus the client’s terms. Discount and tax are rounded to cents so the total is a number a bank will accept. The print area is set so it comes out on one page.
Choose the client from a dropdown and the address, email and payment terms fill in from the Clients sheet. Choose an item and its default price fills in — type over it for a one-off. The Register keeps every invoice: what’s paid, what’s outstanding, how many days overdue, a status that says Overdue before it says Part paid, aging buckets, what you’ve invoiced and collected this year, and the next number in your sequence.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample invoice and register and compares fifteen values — subtotal, discount, tax, total, the client lookup, the register’s outstanding total, an aging bucket, two statuses, the next number — against numbers computed outside Excel.
Need one invoice right now, as a PDF, without a spreadsheet? The invoice generator makes one in the browser; Bill is for when you want the register.
First release
A week of trading, one row a day: card, cash, how much of it carried VAT, and how many people came in. Takings, the VAT already inside those sales and the spend per head are calculated. Pro adds the month's running costs with a budget, a variance and an On plan / Watch / Over status on every line, plus a summary that reads the week back to you. No macros.
Thirteen weeks across, cash in and out down: the balance carries forward, weeks below your buffer turn red, and the lowest point and its week are found for you. Pro fills the grid from a dated list of expected receipts and payments and shows what's still outstanding from past weeks. No macros.
One row per unit: property, tenant, rent, due day, lease dates, deposit. Vacancies, leases ending in ninety days, occupancy and monthly rent are calculated. Pro adds the rent payment log with a balance per tenant, an expense log, and a month-by-month view of rent due, collected and spent. No macros.