Table of Contents
- Why Is My Balance Sheet Not Balancing?
- Balance Sheet Not Balancing? Start With the First Month It Breaks
- Issue 1. Net Income Doesn't Match Retained Earnings
- Issue 2. Depreciation Expense doesn't match change in Accumulated Depreciation
- Issue 3. The Statement of Cash Flows is Missing a Reference to the Balance Sheet
- Other Reasons a Balance Sheet Doesn't Balance (Honorable Mentions)
- Please Don't Plug Retained Earnings
- Zooming Out: Balance Sheet Not Balancing Checklist
- FAQs
Why Is My Balance Sheet Not Balancing?
Balance sheet not balancing? Trust me, I know how frustrating it is when your balance sheet doesn't balance.
So let's keep it short and tactical today.
These are the top three reasons I usually see in client models that lead to a busted Balance Sheet.
But before we get into them, there's one thing I'd do first.
Balance Sheet Not Balancing? Start With the First Month It Breaks
Add a balance check row right below your balance sheet: Total Assets minus Total Liabilities & Equity.
I put this check in every single column, and I like to wrap it in a ROUND so tiny rounding differences don't set it off (something like =ROUND(Total_Assets - Total_Liabilities_and_Equity, 0)).
Then scroll right and find the first period where it isn't zero.
That's where the issue starts (anything thereafter just compounds from this point).
Whatever changed in that period (a new account, a distribution, an asset sale, the flip from actuals to forecast) is usually the culprit.
It sounds simple, but I think it saves more time than anything else in this post. Way better than scrolling through 10,000 rows hoping something jumps out at you.
(I also roll this check into an error checking tab, so I know the second something breaks. And I promise, at some point it will happen.)
The "Divide by 2" Trick
Once you know the period, look at the size of the difference.
If it's exactly double a number you recognize, you probably flipped a sign somewhere.
For example, say you're out by $40,000, and Accounts Payable went up $20,000 that month. There's a good chance the change in AP on your Statement of Cash Flows has the wrong sign. It's going the wrong direction, so it's off by 2x.
Not foolproof, but it's kind of amazing how often it works.
Try to multiply by two as well -- sometimes that number triggers something. I usually run both checks.
Issue 1. Net Income Doesn't Match Retained Earnings
What should be happening:
The Net Income from your Income Statement should match the change in Retained Earnings on your Balance Sheet.
If there's a difference, here's what you can try:
1a. Determine if any Distributions were made
An equity distribution comes out of Retained Earnings, and the journal entry looks like this:
Debit (decrease) Retained Earnings Credit (decrease) Cash
So, the difference you're looking for just might be an equity distribution.
Some companies will have a separate negative account called "Distributions," whereas others will keep everything in Retained Earnings.
Here's what that looks like with numbers:
| Retained Earnings, beginning | $2,000,000 |
| (+) Net Income | $500,000 |
| (-) Distributions | ($50,000) |
| Retained Earnings, ending | $2,450,000 |
If your model only does "prior period + net income," it's expecting $2,500,000. The balance sheet says $2,450,000.
That $50,000 gap is the distribution. Add a line for it (and the matching cash outflow in the financing section of your Statement of Cash Flows), and you should be back in balance.
1b. Check that all entries were recorded correctly in the P&L
Happens more often than you think: an entry in the P&L might not be correct, which disconnects the Net Income from the Balance Sheet.
And if you're refreshing financials in your model, make sure to refresh both the Income Statement and the Balance Sheet. Often times, a refresh of just one leaves you with mismatched data that you won't be able to chase down.
1c. Confirm Balance Sheet balances in Reporting System
This is less common (since systems usually have checks for this) but it does happen.
Confirm your raw data is correct first. Any error here would show up in your model as well.
Issue 2. Depreciation Expense doesn't match change in Accumulated Depreciation
What should be happening:
The Depreciation Expense from your Income Statement should match the change in Accumulated Depreciation on your Balance Sheet.
If there's a difference, here's what you can try:
2a. Check to see if any assets were sold or disposed
When a company sells or disposes of a depreciable asset, it removes the book value of the asset from the Fixed Assets section of the balance sheet, and it also removes the accumulated depreciation associated with that asset from the accumulated depreciation account.
The exact cash proceeds may not always be clear, so you'll want to ask the Accounting team:
- Was anything sold, and if so, what were the cash proceeds?
- Did the company recognize a gain or loss?
The cash received from the sale would show up in the Investing Section of the Cash Flow Statement, whereas the Gain or Loss would show up in the Operating Section.
2b. Check that all entries were recorded correctly in the P&L
Similar to above, sometimes there are errors in the journal entries. Reach out to the Bookkeeper or Controller who is making these entries to double-check.
(less common but it happens).
Issue 3. The Statement of Cash Flows is Missing a Reference to the Balance Sheet
This would be a modeling error.
Since 3 Statement Models use the indirect method to calculate cash, sometimes as modelers we can miss something.
Things to try:
- Trace all of your SCF references to ensure you've captured every line item on the Balance Sheet (except for cash).
- Make sure all changes in Assets are Previous Period - Current Period
- Make sure all changes in Liabilities and Equity are Current Period - Previous Period
- If you want to get fancier, you could use formulas to capture changes in the entire Balance Sheet, instead of hand-picking the individual line items. Here's an example.
Other Reasons a Balance Sheet Doesn't Balance (Honorable Mentions)
Not quite top three, but I see these enough that they're worth a quick look:
- A flipped sign on the Statement of Cash Flows. One line going the wrong direction is all it takes (see the "divide by 2" trick above).
- A new balance sheet line that never made it into the SCF. Someone adds a new loan or a new accrual, and nobody links it to the Statement of Cash Flows (again, this can be mitigated with formulas).
- A hardcode in the forecast. A typed-in number sitting where a formula should be (you can use Go To Special, select Constants, and highlight them to identify where someone fat-fingered something).
- The opening balance sheet doesn't balance. If your starting point is off, everything after it will be too. Check your historicals (or your pro forma balance sheet) first. Uncommon but happens.
- Iterative calculations got turned off. If your model has circularity (like interest on an average debt balance), this can throw everything off. A circularity breaker helps a lot here.
Please Don't Plug Retained Earnings
One more thing.
When the balance sheet won't balance, it's really tempting to just force it. Type a number into retained earnings (or cash, or goodwill), it balances, move on.
I've been there -- but all that does is hide the error. The mistake is still in there, and now it's even harder to find.
If the rest of your model is built right, it really only takes two steps to make the balance sheet balance:
- Link ending cash on the balance sheet to ending cash on the Statement of Cash Flows.
- Make retained earnings equal the prior period plus net income (less any distributions).
If it's still off after that, one of the issues above is hiding somewhere.
Zooming Out: Balance Sheet Not Balancing Checklist
I would say 80-90% of the time, one of the three culprits above is to blame for a broken Balance Sheet.
So be sure to add this checklist to your financial modeling toolkit:
- Add a balance check row (in every column) and find the first period it breaks.
- Look at the size of the difference. Exactly 2x a line item? Probably a flipped sign.
- Compare net income to the change in retained earnings. Look for distributions.
- Compare depreciation expense to the change in accumulated depreciation. Look for asset sales or disposals.
- Trace every balance sheet line (except cash) into the Statement of Cash Flows.
- Still stuck? Run through the honorable mentions. And don't plug it.
If you're building the balance sheet from scratch, my free guide walks through it in 10 steps. Grab it here.
That's it for today. See you next time. —Chris
📕 p.s. VLOOKUP or XLOOKUP?
Spoiler Alert: your boss doesn't care.
Focus on what matters.
I've helped over 91,000 FP&A and Private Equity professionals master Financial Modeling in just one week without the high cost of traditional education.
A quick note: I wrote the original version of this post (the three culprits are the ones I run into in client models). More recently, I used AI to help refresh it for search, and in a few spots it helped add to it (like the honorable mentions and the checklist at the end). Fundamentals first, AI second.