Small Business Bookkeeping

Keep your small business books in one simple spreadsheet and be ready for tax time. Made for US sole proprietors, freelancers and small shops. Log money in, money out and business miles, and the Small Business Bookkeeping spreadsheet builds your monthly profit & loss, a Schedule C summary by line and a dashboard for you. Every expense category is mapped to a Schedule C line you choose, and meals are tracked at the full amount and the 50% deductible amount. WHAT'S INCLUDED • Dashboard: income, expenses, net profit, margin, estimated cash on hand, business miles and missing receipts, with charts • Income log (400 rows) and expense log (800 rows): date, description, category dropdown, amount, payment method, receipt yes/no and notes • Mileage log: start and end odometer or just miles, deduction worked out at the rate you set (sample uses the 2026 IRS rate of 72.5 cents per mile) • Profit & Loss: 12 months by category with totals, net profit and profit margin • Schedule C summary: totals by line from the 2025 form, with mileage added to line 9 and meals at 50% • Quarterly tax set-aside helper: set aside the percentage you choose from each period's profit • Setup tab for your business name, year, starting cash, categories and Schedule C lines • Start Here guide • Two files: a blank workbook and a filled-in example WORKS WITH • Microsoft Excel (2010 or later, Windows and Mac, and Excel online) • Google Sheets (free): upload the file to Google Drive and open it with Google Sheets HOW IT WORKS 1. Purchase and download instantly from your Etsy Purchases page. 2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets. 3. Fill in the Setup tab, then log income, expenses and miles as you go. PLEASE NOTE • This is a digital download. No physical item will be shipped. • Amounts are in US dollars ($). Built around the US Schedule C (Form 1040). • For personal use within your own business. Please don't resell or share the file. • Not tax, legal or financial advice. It organizes your records; confirm deductions and estimated payments with a tax professional. How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed. Questions? Send us a message. We usually reply within a day.