Easy Accounting Workbook

How I Handle My Own Bookkeeping Without Losing My Mind

I've been tracking my own finances with spreadsheets for years now. What started as a simple income and expense log turned into something more structured when I realized I needed actual numbers I could pull up when tax season came around. That's when I built what I now call my Easy Accounting Workbook. It's not fancy. It doesn't connect to any bank feeds or auto-categorize transactions. But it gets the job done for small business owners or side-hustlers who don't need QuickBooks at their level of complexity. The first thing I want to address is the structure. Most people just throw everything into one sheet and call it a day. That works until you have 300 transactions and can't find where your software subscription went. I broke mine into four tabs: Transactions, Categories, Summary, and Setup. The Transactions tab is where every entry lives. Columns are Date, Description, Category, Type (income or expense), Amount, and Notes. That's it. No need for twelve columns with half of them empty. Category logic matters more than you'd think. I learned this the hard way. Early on, I created a category called "Business Stuff" for anything ambiguous. Within three months, I had forty-three entries in that bucket and no idea what half of them were. The fix was setting up a reference list in the Categories tab with main headings and subcategories. Revenue splits into Sales, Refunds, and Interest. Expenses split into COGS, Software, Marketing, Travel, and Admin. You can use VLOOKUP or just type the full category path directly when entering data. I use a data validation dropdown pulling from that reference list so I don't accidentally create "Travel," "travel," and "TRAVEL" three separate categories.

Getting Started With Easy Accounting Workbook

If you're building this from scratch, open a blank spreadsheet and set up those four tabs immediately. Don't start entering data first. I know that sounds backwards. But entering data without a category system means you'll spend more time cleaning it up later than building it upfront. I've watched people waste entire Saturday mornings doing exactly that. In the Setup tab, I put things like my business name, fiscal year start date, and a list of my recurring monthly expenses. The recurring expense list has a formula that auto-fills entries at the start of each month based on that list. It's not perfect. Sometimes I forget to adjust it when a bill changes amount. But for fixed costs like rent or software subscriptions, it saves me about ten minutes per month. That's not a lot, but over a year it adds up to something noticeable. The Summary tab is where the actual reporting happens. I use SUMIFS formulas to pull totals by category. The key formula structure looks like this: SUMIFS(Amount column, Category column, "specific category"). Each major category gets its own row, and the formulas run across the entire Transactions tab. For a running total that filters by month, I add a third condition for the date range. This gives me a clean profit and loss snapshot without needing pivot tables, which I find slower and more prone to breaking when someone accidentally deletes a row.

Here's something nobody warns you about: transaction deduplication. I imported bank statements once using CSV export and realized twenty transactions appeared twice because the download had duplicates. The workbook didn't catch it. I ended up with inflated expense totals that threw off my quarterly review. My workaround was adding a unique transaction ID column using the formula =TEXT(A2,"mmddyy")&B2, combining the date and description. Then I'd filter for duplicates before finalizing any month. It's an extra step, but catching duplicates early prevents headaches later. I do this check every two weeks now instead of waiting until month-end. Another thing to watch is the rounding issue. Spreadsheets are notorious for floating point errors. I had a case where my transactions totaled $4,999.99 when they should have been $5,000.00. A penny off from a rounding glitch, but it made reconciliation impossible. The fix was wrapping my SUM formulas in ROUND(value, 2). It's a small change that eliminates the phantom cent problem entirely. Not glamorous, but it works. For tax purposes, I keep one additional column marked "Tax Deductible" with a yes or no value. This lets me run a quick filter during tax time to pull all deductible expenses in one go. The old version of my workbook didn't have this, and I spent an evening manually going through seventeen months of entries just to figure out which receipts could be claimed. Never again.

There are honest limitations to this approach. It doesn't reconcile automatically. If your bank statement doesn't match your spreadsheet, you're the one who has to dig into it. It has no multi-user access, so if you're working with an accountant or partner, they're either sharing the file or asking you to send updates. And the formulas can break if someone inserts a row in the wrong place. I learned that one when my summary tab stopped calculating correctly after a colleague added a note row inside the data range. The workaround is freezing the header row and protecting the sheet from edits outside the designated data area. For most solopreneurs or micro-businesses doing under a hundred thousand in annual revenue, this setup handles everything you actually need. If you're processing hundreds of transactions per month or need inventory tracking and multi-entity management, you're probably outgrowing a spreadsheet at that point. But that's a different problem entirely. For now, the Easy Accounting Workbook has been enough. I update it weekly, export the summary before taxes, and move on with my life.