Dark Mode Bookkeeping Spreadsheet, Small Business Income Expense Tracker, Profit Loss, Business Ledger, Excel Google Sheets

Dark Mode Bookkeeping Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Simple small business bookkeeping in dark mode: ledger, invoices, clients and profit & loss on dark tabs that are easy on the eyes. Perfect for freelancers, Etsy sellers, consultants, cleaners, photographers and coaches.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/MFRwEua6X-c

✨ 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

★ PERFECT FOR ★
✓ Freelancers, Etsy sellers, consultants, cleaners, photographers and coaches
✓ Anyone who does the books at night

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the file right after purchase.
2. On Setup, enter your business name, year, payment terms, tax set-aside % and categories.
3. Log income and expenses on Ledger and invoices on Invoices.
4. Open Profit & Loss to see each month's results.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• This is the dark mode edition: the same tool as our standard version, styled with dark backgrounds, light text and dark charts.
• This is a bookkeeping tool, not tax or legal advice.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.