Small Business Bookkeeping Spreadsheet for Excel and Sheets

Small-business bookkeeping can feel overwhelming when transactions and totals live in different places. This bookkeeping spreadsheet for Excel and Google Sheets helps bring your income and expenses into a clearer routine, so you can spend less time sorting numbers and more time understanding your business. Use it as an organized starting point and review the listing for included sheets and compatibility.

Know what your business really makes. Log the money in and the money out, and the profit, the tax to set aside and who still owes you work themselves out.

Made for makers, Etsy and online sellers, freelancers and service businesses.

WHAT YOU GET (instant download)

• Small Business Bookkeeping spreadsheet (.xlsx) for Microsoft Excel and Google Sheets

• A Start Here tab that walks you through setup in about 10 minutes

10 TABS

• Setup: your business details, the month your financial year starts, payment terms, and your own income and expense categories

• Dashboard: the year and this month at a glance (income, expenses, net profit, margin, tax to set aside), unpaid and overdue invoices, missing receipts, and charts

• Income: every sale, payout and paid invoice, with drop-downs for client, category and payment method

• Expenses: everything the business spends, with a receipt column that flags what is missing

• Invoices: every invoice you send, with due dates, Paid / Open / Overdue status and days late worked out for you

• Invoice Maker: pick a client and their details fill in; type the items, add a discount or tax, and print or save as PDF

• Clients: contact details, what you have invoiced each client, what they have paid and what they still owe

• Profit & Loss: every category, every month, net profit, margin, profit so far, and tax to set aside by quarter

• Pricing Calculator: enter materials, time, overhead, marketplace fees and the margin you want, and see what to charge at least, plus what you really make at your current price

GOOD TO KNOW

• Works in Microsoft Excel and Google Sheets (upload to Google Drive and open with Google Sheets)

• Your financial year can start in any month

• Cream cells are for typing; everything else is calculated, and calculated tabs are protected against accidental edits (no password)

• Amounts have no currency symbol, so it works in any currency

• The tax set-aside is a savings rate you choose, not tax advice; ask your accountant what rate fits you

• The listing images show sample data; your file starts empty apart from a few example rows to delete

• Digital file, nothing is shipped

• For use in your own business. Please do not share or resell the file.

Created by UpVire: the ideas, structure and content are our own. Some illustrations and design elements were made with the help of AI tools.