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. ✨ 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 pa