Small Business Bookkeeping Spreadsheet, Income Expense Tracker, Profit and Loss, Bookkeeping Template, LLC Ledger, Excel Google Sheets

Small Business Bookkeeping Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Simple bookkeeping for freelancers, side hustlers and small business owners. No accounting software subscription required.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/1J7FZfwIr3k

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a color key (yellow = you type, everything else calculates)
• Business Dashboard: pick any month to see revenue, expenses and profit for that month, plus year-to-date revenue, expenses, net profit, profit margin, cash on hand, money owed to you, overdue invoices, tax set-aside and missing receipts
• Top expense categories with a budget check, top clients by revenue, a 6-point business health check (margin, cash cushion, late invoices, receipts, next tax payment, budgets) and a receivables aging summary
• 6 dashboard charts: revenue vs. expenses, net profit by month, top expense categories, where revenue comes from, cash on hand, money owed by age
• Setup: business info, tax year, payment terms, mileage rate, estimated tax rates, vehicle method, cash cushion and profit target, plus your income categories, expense categories (each with a Schedule C line and deductible %), payment methods and accounts
• Income ledger with room for 1,000 entries: client, category, invoice #, payment method and account from drop-downs
• Expense ledger with room for 1,000 entries: vendor, category, payment method, account, receipt status (Saved / Missing / Not needed), business-use % and an automatic deductible amount and Schedule C line
• Invoice tracker with room for 1,000 invoices: due dates, amount paid (pulled from your Income entries), balance, Paid / Partial / Open / Overdue status, days late and aging bucket
• Receivables: who owes you money by client in Not due / 1-30 / 31-60 / 61-90 / 90+ day buckets, plus your most overdue invoices listed first and a chart
• Clients (up to 100): invoiced, collected, balance owed, overdue, revenue for the year, % of revenue and average days to pay
• Vendors (up to 100): purchases, spending for the year, % of spending, last purchase date and missing receipts
• Profit & Loss: every income and expense category month by month, gross profit, net profit, profit margin and an estimated tax view, with a chart
• Annual P&L: a yearly summary by quarter laid out like IRS Schedule C (gross receipts, cost of goods sold, Lines 8 to 27a, estimated net profit) with a mileage memo
• Cash Flow: starting cash, income, expenses, owner contributions and draws, loans, estimated tax payments, month-end balance and a low-cash warning, with 2 charts
• Budget vs Actual: monthly income targets and expense budgets for any month and year to date, with progress bars and Over / Close / OK flags
• Quarterly Estimated Tax: how much to set aside for each payment period, due dates, what you've paid, status and your next payment (a planning estimate, not tax advice)
• Mileage log with room for 500 trips: round trips, total miles, deduction at your rate and a monthly summary with a chart
• 14 built-in charts, conditional formatting, drop-downs and progress bars throughout
• Sample data version plus a blank ready-to-use version

★ SAVE WITH A BUNDLE ★
Get this template plus 4 more in the Small Business Spreadsheet Bundle and save 50%: https://www.etsy.com/listing/4600189442/small-business-spreadsheet-bundle
Get this template plus 2 more in the Budget + Trading + Bookkeeping Starter Bundle and save 25%: https://www.etsy.com/listing/4599980883/spreadsheet-bundle-budget-planner

PLEASE NOTE
• DIGITAL download only.
• This is a bookkeeping tool, not tax or legal advice.
• For personal or single-business use. Not for resale.