Small Business Bookkeeping Spreadsheet – Income & Expense Tracker, Monthly Profit & Loss, Dashboard with Charts, Invoices Owed + Mileage Log (Excel + Google Sheets)

Organization tool only, not accounting or tax advice.

Want one tidy place for the money coming into and going out of your small business? Log each payment and purchase once, and this spreadsheet builds your monthly profit & loss, a year-to-date dashboard with charts, a list of invoices still owed to you and a mileage log.

The bookkeeping spreadsheet (Excel + Google Sheets)

• Setup: your business name, the month your bookkeeping year starts (January or any other month), your money symbol, miles or km, and your own lists of income categories (up to 20), expense categories (up to 40), accounts and customers.
• Income log: up to 1,000 payments with date, customer or source, category, invoice number and the account it was paid into.
• Expense log: up to 1,500 purchases and bills with vendor, category from your own editable list, account and a "receipt kept?" column.
• Monthly profit & loss: every category by month, year totals, each category as a % of income, net profit, profit margin and a running total.
• Budgets: add a monthly budget per expense category and see the budget left for the year.
• Year-to-date dashboard: 16 live numbers (income, expenses, net profit, owed to you, overdue invoices, distance and more), a month-by-month table, your biggest expense categories, money in and out by account and three charts.
• Receivables: up to 300 invoices. Paid so far, still owed, status (Open, Part paid, Paid, Overdue) and days late fill in from the income log, with an age summary on the dashboard.
• Mileage log: up to 1,000 trips by odometer readings or distance, with vehicle and purpose, plus an optional cost at a rate you choose.
• Row checks: each log flags rows that need a look, such as a missing category, a date outside the year or an invoice number that is not on the list.
• Blank file plus a filled-in example for a made-up studio, so you can see every feature working.

Good to know

• Works in Excel 2010 or newer (Windows, Mac, web), Google Sheets (upload, then File → Save as Google Sheets) and LibreOffice. No macros, no add-ons, no sign-ups.
• Clear color coding: green headers are for typing, grey headers are calculated.
• Instant digital download. Nothing is shipped.
• Your information stays in your own file. Nothing is sent anywhere.
• This is a record-keeping workbook. It does not give accounting or tax advice. For questions about taxes or filing, please talk to a qualified professional.

License: use it for your own business, with as many copies as your own business needs. Please don't resell, share or give away the file.

Refunds: because this is a digital download, sales are final. If a file won't open or something is broken, contact me through the link in your receipt and I'll fix it or refund you.