Super Easy Bookkeeping Spreadsheet Google Sheets – All-in-One Income & Expense Tracker + Dashboard

Keep your numbers crystal clear with a beginner-friendly Google Sheets bookkeeping template made for small businesses and online sellers (Shopee, TikTok Shop, Lazada, FB/IG Shops, freelancers, makers, etc.). Log sales and costs in minutes and let the dashboard automatically calculate profit, margin %, and show charts so you always know how you’re doing.

What you’ll get

• Google Sheets template link (make your own copy – lifetime access)
• Quick-start PDF with steps & tips

Key features

• Setup Page: choose your currency, start date, list your income streams & expense categories, and set a monthly/annual profit goal.
• Income Log: date, category, total income, sales tax, and net income (auto-calc).
• Expense Log: date, category, tax, and net expense (auto-calc).
• Monthly Overview: instant summary of Income vs. Expenses, Profit, Profit Margin %, and Expenses by Category (donut & bar charts).
• Annual Overview: year-to-date performance, visual graphs, and a detailed table to review every month.
• Clean & Editable: no macros; built entirely in Google Sheets—duplicate for multiple businesses.

Perfect for

• Side hustles, creators, service providers, and ecommerce sellers who want fast profit insights without complex software.

How it works

1. Purchase and download the PDF.
2. Click the link to open the template in Google Sheets and Make a copy.
3. Enter your income and expenses—dashboards update automatically.

Notes

• Digital product only — no physical item will be shipped.
• Requires a free Google account; best used on desktop/laptop.
• This template is for light bookkeeping and planning; it’s not tax or accounting advice.