Small Business Bookkeeping Spreadsheet 2027, Profit and Loss Statement, Income Expense Tracker, Monthly Ledger, Google Sheets & Excel
Bookkeeping without the accounting software. Type each sale and expense once, pick a category, and this workbook builds your monthly Profit & Loss statement, compares it to your budget, tracks your cash, and tells you in plain English how the year is going. Made for makers, shop owners, freelancers, and service businesses who want clean numbers at tax time.
★ WHY IT STANDS OUT
• Monthly P&L with % of income, cost of goods, gross profit, net profit, and ending cash
• Budget vs. Actual with year-to-date pace and a sales goal
• Receipt and owner-pay checks on every transaction
• 15 business categories that match the Side Hustle Income & Tax Tracker
• Plain-English Insights panel with live, formula-driven sentences
• What-If inputs so you can test a change before you make it
• 10-minute numbered Quick Start on the Start Here tab
• Quick Entry tab sized for your phone in the Google Sheets app
• Business categories shared across every LeafLedgerCo Small Business Tool
• Free 2028 update
★ WHAT'S INCLUDED
SPREADSHEET (one .xlsx file that works in Google Sheets and Microsoft Excel)
• Start Here: a numbered 10-minute Quick Start and a color key
• Dashboard: income, expenses, net profit, margin, owner pay, and cash, with a month-by-month table, chart, and a What-If (raise prices, cut expenses, add monthly sales)
• Plain-English Insights like "Biggest cost: Cost of goods at $4,930, 19% of income."
• Transactions: date, description, account, money in or out, income source or expense category, owner pay, receipt check, and a missing-info check
• P&L: every month plus the year, with % of income
• Budget vs. Actual: monthly budgets by category, pace, and a sales goal
• Quick Entry: add money in or out from your phone
• Settings and Categories: business name, starting cash, year, and shared business categories (edit freely)
PRINTABLE PAGES (6 pages, in both US Letter and A4)
• Cover, Transaction Ledger, 12-month Profit & Loss (2 pages), Receipt Log, and a Year-End Checklist
★ HOW TO USE IT IN GOOGLE SHEETS
1. Download the files from the link in your purchase receipt email.
2. In Google Drive, click New > File upload and choose Small-Business-Bookkeeping-PL-2027.xlsx.
3. Open it and choose File > Save as Google Sheets. Work in that copy.
4. On your phone, open that copy in the free Google Sheets app and use the Quick Entry tab.
★ HOW TO USE IT IN MICROSOFT EXCEL
1. Open Small-Business-Bookkeeping-PL-2027.xlsx in Excel (desktop, web, or mobile).
2. If you see a Protected View bar, click Enable Editing.
3. Save a personal copy, then follow the 10-minute Quick Start on the first tab.
★ PRINTING
Print the PDF at home or at a print shop. Choose "Actual size" or "Fit" in your print settings. Print every page or only the ones you need. The pages use thin lines and little color to save ink.
★ PART OF A SET
LeafLedgerCo's Small Business Tools share the same 15 business categories (and the Side Hustle Income & Tax Tracker uses them too), so your numbers line up across the Pricing Calculator, Inventory & COGS Tracker, Bookkeeping & P&L, Invoices, Client & Project Tracker, Craft Fair Tracker, Marketing Planner, and Launch Planner.
★ PLEASE NOTE
• This is a DIGITAL DOWNLOAD. Nothing will be shipped to you.
• Download your files from the link in your purchase receipt email (a computer is easiest).
• FREE 2028 UPDATE: when the 2028 edition is ready, I'll add it to this listing and you can download it at no extra cost from your original purchase download link. I'll also email buyers when the update is ready.
• Amounts are shown in US dollars. You can change the currency format in your spreadsheet app.
• You need a free Google account or Microsoft Excel to use the spreadsheet, and a PDF reader to print.
• The listing photos show example data so you can see how it works. Your file arrives blank.
• This is cash-basis bookkeeping for small businesses. Check with a tax professional for your situation.
• This is an organizing and planning tool, not tax, legal, or accounting advice.
• For personal use only. Please do not share or resell the files.
• Colors may look slightly different on screen than on paper.
★ ABOUT HOW THIS WAS MADE
This product was designed with AI assistance under my direction. I planned it, set its features and look, and reviewed and tested the spreadsheet formulas and printable pages before listing.
Questions? Use the contact form on this store, or reply to your receipt email. I'm happy to help you get set up.