Lessons from the “Later” Tab: Mastering Small Business Bookkeeping
Managing the finances of a small business often starts with humble tools—sometimes just a simple spreadsheet. I once maintained a spreadsheet with three tabs: income, expenses, and a catch-all tab I named “later.” This tab was a repository for receipts I couldn’t decipher, Stripe payouts that didn’t match invoices, and expenses like flights that I suspected were business-related but wasn’t ready to confirm. Updating this spreadsheet happened only on Sundays, reducing the business’s financial reality to a once-a-week snapshot shaped by what I could remember. If I missed a Sunday, it was as if the business had skipped a week entirely. This fragile system never crashed, and therein lay its danger: a bad system that doesn’t fail can quietly run for a year, accumulating errors and confusion.
While I knew the rough financial picture—I could say whether the month was better or worse than the last—I couldn’t easily answer specific questions about what I owed, which invoices were late, or which clients had paid deposits but not the full amount. This rough number was enough for a general mood but insufficient for critical conversations about taxes, hiring, or profitability. The receipts, meanwhile, lived in a kitchen folder and my phone’s camera roll. Photographing receipts felt like organization, but without proper filing, those photos remained lost. At tax time, the folder emerged, accompanied by a sense of shame common to those who have been both busy and sloppy. I had used “busy” as an excuse for “sloppy.”
The Limits of Spreadsheets and the Importance of Clear Books
Before this spreadsheet, the “books” lived in my head because looking at them felt worse than guessing. A spreadsheet is a step up from guessing, but it is not a set of books. Real books can be handed to someone else; a spreadsheet with a “later” tab can only be shared if you’re willing to sit beside the person explaining what all the mysterious entries mean.
Several simple rules could have saved me from this Sunday-only bookkeeping routine, and none of them require technical genius.
Practical Rules for Better Financial Management
Separate business and personal finances. A dedicated business bank account—even a basic one—is a clear boundary a spreadsheet cannot create. Client payments should go into this account. Personal expenses, like groceries, should not. If a personal card pays for a business expense, transfer the money to the business account in the same week, with a note explaining the transfer. The transfer itself is the record; memory is not reliable.
Photograph and file receipts promptly. Take a photo of every receipt on the day you spend the money and send it to your filing system immediately. A phone’s camera roll is not a filing system. Unattached photos are lost receipts. Even small expenses deserve this attention; they quietly turn a folder into a confession of disorganization.
Don’t count deposits as earned income until work is complete. Treat deposits as liabilities—money you’re holding until the project is done. I inflated months by counting partial payments as income only to face the “future problem” when the rest of the work happened. This led to overspending on months that felt good but weren’t truly profitable.
Track unpaid invoices as rigorously as income. An invoice overdue by 30 days isn’t just a vague feeling; it’s a name. Reviewing unpaid invoices weekly is more valuable than adding another tab of expense categories. Avoiding this list means avoiding the hard job of following up and writing to clients.
Clean one month at a time. Attempting to reconcile a full year at once leads to overwhelm and abandonment. Start with one month, fully reconciled against bank statements. This teaches you your categories and builds momentum. Twelve months tackled on a tired Thursday won’t.
Upgrading to Real Bookkeeping Software
Once your money is “real enough to be confusing,” the best advice is to stop building ever-smarter spreadsheets and start putting transactions into software that already understands categories. I recommend QuickBooks—not so you become your own accountant, but so your payouts, expenses, and invoices don’t rely on a Sunday update that might not happen. Other popular options include Xero, favored by many operators outside the typical small-business defaults; FreshBooks, simpler and invoice-focused; and Wave, a free option that many use as a first step.
The key isn’t the software brand but the founder’s ability to transition from “feeling” the month to showing the month with actual data. Getting the money right is a bigger job than software alone. The software is what keeps that bigger job from becoming an impossible reconstruction.
The first month in a new tool is frustrating. Transactions land in wrong categories, transfers look like income, and Stripe fees appear separately from payouts. It’s tempting to call it all rounding errors, but persistence pays off. Reconciling one month against bank statements—not memory—will reveal misclassified expenses and double-counted income. After that, spreadsheets should serve as notes, not the books themselves.
Additional Tips for Financial Success
Set aside tax money the same week your tool is connected. Moving a percentage of each payout to a separate account beats a last-minute estimate come March. I learned this the hard way when my tax bill wasn’t a surprise—it was a number I chose not to face. Monthly visibility is key; software won’t spare you the sting, but it will help you prepare.
Once your files are somewhat organized, hand them over to a bookkeeper—even if you’re not ready to hire full-time. A bookkeeper who can open your month’s records without calling you is a true test of whether you have books. If they need to ask what “later” means, you don’t. Pay for this hour; it’s cheaper than the reconstruction later.
If you sell bookkeeping services or inherit messy files, write about the “later” tab—not just the software dashboard. The Write for Us page welcomes that kind of insight. QuickBooks and others are named already; pricing tables won’t increase your reach.
Today, my receipt folder is thinner. I still photograph every receipt, but now they go somewhere. That’s the whole fix.
For more details on preparing your business finances before hiring your first employee, see Here.
