In this instructional video, CPA Bill Hanna shares a four‑step framework for turning a chaotic set of startup accounting records into clean, reliable financial statements. He begins by explaining why clean books are essential for raising capital, securing loans, and making sound business decisions. The first step is to locate the most recent “anchor” period where the books fully reconcile to external records and the owner trusts the numbers. Using a fictional company, Harper and Pine Candle Company, he demonstrates how to assess the anchor. The second step is a month‑by‑month cash reconciliation, matching bank, credit‑card, and loan statements to the ledger and recording any missing transactions. The third step involves tying out all other accounts—revenue, payroll, rent, inventory—against external evidence, making adjusting entries where necessary, and applying a materiality threshold rather than insisting on penny‑level precision for every line item. The fourth step is to close the month, lock in the reconciled figures, and repeat the process for subsequent months until the books are fully caught up. Throughout, Bill offers practical tips (e.g., using cash accounting for simplicity), highlights the difference between material and exact accuracy, and provides downloadable resources such as an Excel template and a month‑end close checklist. He concludes with a recap of the four steps and promotes his Controller Academy and Controller Lab for deeper learning.
Chapters
A few years ago, one of the jobs I took in my career was at a startup, and the books were a mess. Not a little messy, but a real mess. The cash on the books didn't reconcile to the bank, revenue didn't match the sales from Stripe, and payroll expense, that didn't tie to anything at all. So I had to figure out, where do I even begin? Now, why does any of this matter? Well, because clean books is what lets a business do the big things. You want to raise money from an investor, they're going to want to look at your books. You want a loan from the bank, same thing. And if you're the owner, you can't make good business decisions off of numbers you don't trust. This is like driving with a foggy windshield and hoping that you won't crash. So in this video, I'm going to show you how to clean up a messy set of books step by step using a real company example. We're going to walk through the books period by period, clean up the cash, revenue, and expenses. And we're going to do it in 4 simple steps. Because here's the thing, any big messy job gets a lot less scary once you break it into steps. You stop staring at the whole mountain and just take one step forward. And by the end of the video, you'll know exactly where to start and which order to do things in. Let's get right into it. First, what are we actually aiming for here? What does a clean set of books look like? Here's how I think about it. A clean set of books is one that you can hand over to investors, a lender, or anyone outside of your company and feel confident about it. They are solid enough that if you wanted to go through your first audit with a CPA firm, you could. And the way you get that confidence is pretty simple. Your numbers tie to records that come from outside your company. Your cash balances tie to bank statements. Your sales tie into Stripe or whatever you use to take payments. Your loan ties to statements from your lender. When your numbers match somebody else's records, that's real proof. So how do we go from a mess to clean? Step number 1, find the last time the books were right. Accounting works in periods, months, quarters, and years. So before you fix anything, you want to find the most recent period where you know the books were correct. I call that your anchor. And correct means 2 things. One, numbers tied to an outside record like your bank statement or your loan statement. And 2, the owner looks at the numbers and says, yep, that's exactly what was going on back then. But if the owner looks at the number and squints and says, Hmm, where did all that money go? That's not your anchor. You need to keep going back and find that period. Everything up to that anchor is something you can stand on, but everything after it is going to be something you need to check. Let me show you what this looks like with an example. Meet Harper and Pine Candle Company. It's a made-up company that sells online candles and takes payments via Stripe for Harbor and Pine, 2024 is our anchor. Let me walk you through why. Okay, so here's our financial statements. We have income statement, revenue $1.2 million, which ties to a Stripe sales report. Cost of goods sold $480,000. We can back that up with supplier invoices and an inventory count, so we feel good. Salaries and wages $310,000. That ties to a report from payroll provider. Marketing, $140,000. Those are the invoices from Meta and Google, so we have those and we feel good. Rent, $60,000, matches the lease agreement, and an interest expense that ties into the loan statement. Now, for software and other expenses, we can back up most of it, not every single receipt, but most of it, and that's okay, and you'll see why in a minute. Net income comes out to $140,000 for the year. Now, the balance sheet. Cash is $185,000, ties into December bank statement, which sounds great. Stripe receivable, $22,000. That's money Stripe owed us at the end of the period that didn't hit the bank yet, and we have a payout report to show. So we feel good about that as well. Inventory, $96,000, which matches our year-end physical count. So we feel solid about that. Equipment, $58,000, and we have a list of the fixed assets that make up that number. Solid there. And on the other side, we have a loan, $120,000, which matches a lender statement. So the numbers tie out and the owner agrees that they're real. So 2024 becomes our real anchor. Okay. Harbor and Pine had a clean year to start from, 2024. But what if there is no clean period? What if you have no anchor period? What do you do? If the books were never correct to begin with, well then unfortunately you have to start from scratch. If the business started in 2022, you go back to 2022, rebuild the year's financial statements, and then work your way forward from there through 23, 24, 25, and build it up from there. It's more work, but it's the only way you can stand on a solid ground. And if you're in that spot and you want to practice how to build financial statements from business transactions, I made an Excel template that walks you through. The process of building financial statements from transactions. You can download it. It's in the description down below. And by the way, if this is already helping you think about your own books, gently tap that like button and subscribe if you want more videos like this one. It really helps out the channel. Okay, so 2024 is solid and now we can move on to 2025. And that brings us to step number 2, reconcile cash One month at a time. That means you start with January 2025, and the first thing you do is reconcile the bank statement. Cash always comes first. Why monthly? 2 reasons. First, the bank sends you a statement every month, so every month gives you an outside checkpoint. Second, the month is your accounting period. You get comfortable with January, you close that out, and then you move into February. One period at a time, no jumping around. Closing out a month is a process of its own, and it's easy to miss a step. So I put together a month-end close checklist. You can go ahead and download it from the description below. As you're going through your bank reconciliation, you're going to find stuff on the bank statement that never made it to the books. So there is a $2,000 vendor payment in March that nobody recorded. So now you're going to go ahead and book it. You're going to debit expense and credit cash for that amount. Same with deposits. If money came in and nobody recorded it, you're going to be debiting cash and recording revenue on the credit side. Now, here is a pro tip. If your company is small enough that cash accounting is an option, stick with cash accounting for the cleanup. Going back and figuring out accruals after the fact can get complicated real fast. If you have to do accruals, you can, but just know that payment in January doesn't automatically mean an expense in January. You have to match it up to when the service was performed by the vendor. So keep it simple where you can and do the same reconciliation for credit card statement and your loan statements as well. Reconcile them every month to the statement from the bank. Okay, so once cash is reconciled for the month, we move on to step number 3, which is to tie out everything else for that month. So revenue, you tie it out to Stripe or a warehouse shipment report or whatever gives you an outside record of your sales. Payroll, go to the payroll provider and download the payroll register for the period and compare it to the payroll expense on your books. For rent, you can tie it out to a lease agreement. Inventory, tie it out to the warehouse report And this is where sometimes you're going to run into some adjusting entries. Let's say the books show $5,000 more in inventory than what's actually sitting in the warehouse. First, look into it. Maybe some orders shipped and the sales never got recorded. Maybe a supplier delivery got booked twice. But if you check everything and it's still short, you will have to write it off. You're going to debit cost of goods sold and credit Inventory. Now, here is something that trips a lot of people up. How close is close enough? Let me show you something. This is a part from the audit report, the letter the CPA firm gives you when an audit is done. Look at this line. It says the financial statements represent fairly in all material respects. In all material respects, not to the penny, but the auditor is saying the numbers are right. So here's a pro tip. Your bank, your credit cards, your loan statement, those have to match to the penny, no exceptions. But with revenue, payroll, they just need to be materially close. If Harper and Pine revenue is off by $1,500 on $1.2 million in revenue, that's about a 10th of a percent, and that's fine. You can pass an audit with that. Okay. Don't burn a week trying to chase that kind of difference. This brings us to step number four, which is to close out the month. Cash ties to the penny. Everything else is materially correct. So you lock that month and you move on. January is done. You move on to February, and then you repeat steps two through four month after month until you're caught up on your financials. And quick question for you. If you've ever had to clean up a messy set of books, what was the hardest part? Tell me in the comments. I read them and I'd love to hear your stories. All right, let's recap. Step number 1, find your anchor. That is the last period where the books tie out to an outside record and the owner agrees that they are correct. If there isn't an anchor period, go back to the beginning of time and rebuild the financial statements from there. Step 2, reconcile cash one month at a time. Every bank account, credit card, and loan to the penny. Book whatever is missing along the way. Step number 3, tie out the rest of the accounts for the same period— revenue, payroll, rent, inventory— and make adjusting entries where needed. Step 4, close out the month and move on to the next and repeat until you're caught up. That's how I tackled it at the startup, and it's the same approach I would take today. If you want to go deeper, check out the Controller Academy. It's my set of career-focused courses for accounting and finance professionals who want to grow their controller-level work. And if you learn best by doing, check out the Controller Lab. That's where you can practice things like bank recs, month-end close, hands-on in real ERP environment. Link in the description below. And if you got value from this video, hit the like button and subscribe and drop your story in the comments. I promise to read it and reply back, and I'll see you in the next video.
