When the bookkeeping was still a spreadsheet

The spreadsheet had a tab for income, a tab for expenses, and a tab I had named “later.“

Later was where I put the receipt I could not read, the Stripe payout that did not match the invoice, and the flight I was pretty sure was the business and not quite ready to swear to. I updated the sheet on Sundays, which meant the business only existed, on paper, once a week, and only in the version of the week I could remember. If I had been out on the Sunday, the business skipped a week. Nothing crashed. That was the danger. A bad system that does not crash will run for a year.

I knew the rough number. I could tell you if the month had been better than the last one. I could not tell you, without opening four tabs, what I owed, what was late, or which client had paid the deposit and not the rest. The rough number was enough for a mood. It was not enough for a tax conversation, or for a hire, or for the afternoon a partner asked what the margins were and I answered with a sentence instead of a figure.

The receipts lived in a folder in the kitchen and in the camera roll. I would photograph one at a table and feel organized, then never send the photo anywhere. At tax time the folder came out, and with it the particular shame of a person who has been busy and also sloppy. Busy was true. Sloppy was also true. I had been using one to excuse the other.

We had already written the personal version of this, the stretch where the books lived in my head because looking at them felt worse than guessing. A spreadsheet is a step up from guessing. It is not a set of books. A set of books can be handed to someone else. A spreadsheet can be handed to someone else only if you are willing to sit next to them and explain the tab called later.

A few rules would have saved that Sunday, and none of them are clever.

Separate the money before you separate the software. A business account, even a plain one, is the line a spreadsheet cannot draw for you. Client payments go there. Groceries do not. If a personal card paid for a business expense, move the money across and note why, in the week it happened, not in April. The transfer is the record. Your memory of the transfer is not.

Photograph the receipt the day you spend the money, and send it the same day. A camera roll is not a filing system. A photo you did not attach is the receipt you will not find. If the amount is small, it is still worth the thirty seconds. The small ones are what turn a folder into a confession.

Do not count a deposit as earned when it hits the bank. A deposit is money you are holding until the work is done. I inflated more than one month by treating the first half of a project as income and the second half as a future problem. The future problem arrived, and the month I had felt good about had already been spent.

Look at who owes you, not only at what came in. An invoice that is thirty days late is not a vibe. It is a name. Once a week, the list of unpaid invoices is worth more than another tab of categories. I avoided that list because it meant writing to someone. Writing to someone was the job.

Keep one month clean before you try to clean the year. The year is how people quit. They open January, see the mess, and go back to the sheet, where the mess at least has their handwriting on it. One reconciled month against the bank statement will teach you the categories. Twelve will not, if you attempt them on a tired Thursday.

What I tell people now, once the money is real enough to be confusing, is to stop building a smarter sheet and put the transactions somewhere that already knows what a category is. I send them to QuickBooks. Not so they can become their own accountant. So the payouts, the expenses, and the invoices stop depending on a Sunday I might not have. Xero is the one a lot of operators prefer if they came up outside the usual small-business default. FreshBooks is simpler if the work is mostly invoices. Wave is the free door people try first. If one of those is the place you will actually connect the bank, use that one. I point here because the failure I kept seeing was not the brand. It was a founder who could feel the month and could not show it.

Getting the money right is a bigger job than software. Software is the part that stops the bigger job from being a reconstruction.

The first month in a real tool is annoying. Things land in the wrong category. A transfer looks like income. A Stripe fee shows up separate from the payout and you will want to call the whole thing a rounding error. Stay long enough to reconcile one month against the bank, not against your memory. That single month will show you the expense you had been calling marketing and the income you had counted twice. After that, the sheet can be a note. It should not be the books.

Set a tax set-aside the same week the tool is connected. A percentage, moved to a second account when the payout lands, beats a brilliant estimate in March. I did not do this, and the bill was not a surprise so much as a number I had agreed not to look at. Looking at it monthly is the value. The software will not feel the sting for you.

Hand the file to someone else once, even if you are not ready to hire them. A bookkeeper who can open the month without a call is the test. If they have to ask what “later” means, you do not have books yet. Pay for the hour. It is cheaper than the reconstruction.

If you sell this, or you are the bookkeeper who inherits these files, write about the tab called later, not a tour of the dashboard. The Write for Us page is where that goes. QuickBooks is already named. A pricing table in the first line will not go up.

The folder of receipts is thinner now. I still photograph them. They have somewhere to go, which is the whole fix.