What to do when Balance Sheet does not balance?

After 3 hours of anxiety, cursing (under the breath) and a pair of strained eyes, I have finally managed to balance my balance sheet.

Background: I am required to do a valuation model for a single business segment based on a fully consolidated model - so I did the usual extraction, reference etc. Also required to conduct some analysis hence the full model of statements etc.

Following my sweet success, I would like to share my personal steps to folks new to full modelling who have a hard time balancing B/S:

1) Find the net difference of Net Assets and Equity.
2) Eyeball the figure with every line item to see if they are exact match (most encounter would be the lack of cumulative effect in the b/s)
3) If exact match found, you should pat yourself at the back and go rectify the mistake.
4) If Step 2 is unsuccessful, start simplifying your model in steps – take out complex assumptions, eliminate different tax/debt structure, and observe how the net difference changes.
5) Once net difference is eliminated when an item/assumption is removed – Voila! You hit the jackpot and you can go home on time (hopefully).

As said, I find these steps useful for amateurs. If you have a better methodology of balancing the B/S in general, do share!

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (51)

Apr 15, 2014 - 6:14pm

LDNBNKR:

hardcode "TRUE" at the bottom always works

E=A-L. Works every time.

In all seriousness, if my BS doesn't balance it is usually due to me stupidly forgetting to capture some amort of intangibles or financing fees at some point (deduction before pretax income, addback to CFS, decreases the BS account). So I always check those first.

Apr 15, 2014 - 7:34pm

in an internal model i onced received from a very large utility player in Germany, the balance sheet also did not balance, and who ever did that just created a line item called "magic balancing number" to make it work.

I'm talking about liquid. Rich enough to have your own jet. Rich enough not to waste time. Fifty, a hundred million dollars, buddy. A player. Or nothing.

See my Blog & AMA

  • 6
Jan 12, 2018 - 3:13pm

Unfortunately, there are a million things that could have gone wrong. Adding a few things as I referenced this post within the last day or two. Here are a few checks that helped me:

  1. Check the Deferred tax liability / Intangible Assets / PP&E and other formulas that depend on the previous year. I have definitely made the mistake of linking to the change on the cash flow statement without adding that number to the previous year (referencing deferred tax liability specifically here). You probably already know these (PP&E = Beginning PP&E + Capex - Depreciation) and (Intangible assets = Beginning IA - Amortization of IA)

  2. Another solid check is making sure you hit Ctrl+R on all of your formulas. I've gone back to change a formula in the initial projection year and forgot to drag it over to later years. You can eyeball for figures that don't necessarily make sense or have a logical trend. If you find any, you can use Ctrl+` to show the formulas and make sure they are correct

  3. Don't waste too much time on checking growth, etc. assumptions as those wouldn't impact whether the balance sheet balanced. Typically, there is either a formula error in the balance sheet itself or on the cash flow statement

I hope this helps someone out. A few of the other comments defintely helped me. Happy balancing.

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Jan 12, 2018 - 4:14pm

Hey AlrightAndre, sorry about the delay, but are any of these useful:

  • Simple model won't balance. Would love some expert advice items. I am stuck...I really don't understand why my balance sheet won't balance. Is it related ... projected changes to the company in order to identify the problem. 3 statement financial model ...
  • Model won't balance. a model won't balance in projected years if the historical year balances. For the projected years, it ... this? I know that I would have to make historical assumptions for some sections like the balance sheet ... , however when I do, my model sometimes doesn't balance unless I have and EXACT number in some sells ...
  • Valuation- need help- balance sheet won't balance having some trouble getting my projections to balance out. I'm not sure as to why things are not ... balancing but I'm in need of some assistance. All assumptions are my own- first time doing everything ...
  • Expertise needed: FSM Won't Balance The model is incomplete but I believe my projected B/S should balance where it is right now.I have ... help balance sheet Advice ...
  • Valuation Model Balance Sheet Won't Balance. I have uploaded my model. Just need to know what I am doing wrong. Any comment would be helpful. Thanks. ...
  • Help with a merger model.. Balance sheet won't balance acquirer and target balance sheets are balancing, but the pro forma balance sheet doesn't in three of ... the last years. Time period is 2017 to 2023 (2021, 22, 23 is out of balance). I wiped out debt ...
  • Please help- Balance sheet won't balance be greatly appreciated. Please note columns N and P have been split out to see every balance sheet ... balance is jumping by about 5k a year, i have split it out into full change in difference and half change ...
  • More suggestions...

Or maybe the following pros can chime in... Solstice3 wallstreetfool DaAnswer

Fingers crossed that one of those helps you.

Jun 10, 2018 - 10:27am

Urgent Help Valuation - Can't get Pro forma balance sheet to balance (Originally Posted: 05/23/2016)

HI everyone,

I can't get my to balance, any help would be GREATLY appreciated!

Please find model attached. It might be a small problem i'm missing, but i can't seem to figure it out, in this instance.

Many many thanks if someone can help.

Jun 10, 2018 - 10:30am

Balance sheet imbalance impossible to solve (Originally Posted: 10/03/2016)

Hello,
Could somebody help me to balance financial statement please ? I am completely lost. Especially about what to put in cash and equivalent.

Best regards,
mio

Jun 10, 2018 - 10:33am

Who can help me balance balance sheet? Will pay. (Originally Posted: 08/09/2017)

Having a lot of trouble getting BS to balance from SCF inputs. IF you can help, I will pay, Need ASAP. Thanks!

Jun 10, 2018 - 10:40am

Shoot em over and ill check why the balance sheet ain't balancing.

**How is my grammar? Drop me a note with any errors you see!**
Jun 10, 2018 - 10:42am

New question. Anyone can help me please. Sorry for being a noob.

Is it possible that even if the links between balance sheet and cash flow statement are done properly but from cash flow statement, the ending cash flow (after adding to beginning cash flow), which will flow back to balance sheet is still negative?

Can this be resulted from assumptions (drivers)? After I increase values for drivers, no more negative cash.

Big thanks to whoever help.

Jun 10, 2018 - 10:45am

Quick Balance Sheet Unbalanced Favor (Originally Posted: 12/29/2014)

Hey guys,

Long time lurker here. Anyone around to take a look at my model for a case study interview? I can't figure out why my model can't balance :( TIA!

Jul 10, 2018 - 8:11am

Hello buddies,
I got this financial model problem, it's a 3 year forecast. the first year balances perfectly but the remaining two years wont. Shows a constant balance when I change Liabilities or Capital but the balance increases when I input a figure in the assets. What could be wrong?

Jul 10, 2018 - 10:08am

If it is a small error - less than 0.02 - I consider it a rounding error and either ignore or add a couple cents to the other side to make it balance. After that I divide the error by 9. If the result is a whole number it is likely a transposition error. From there it is just a line-by-line check to see what digits were switched.

Jul 10, 2018 - 10:09am

Intern problems - balancing the balance sheet (Originally Posted: 04/05/2014)

I've been trying to balance this balance sheet for a DCF I'd like to build for IBM, but have been running into some problems. Was wondering if I could get some help from anyone.

Here are some of the questions I have:

  • I've projected out "short-term financing receivables" and "long-term financing receivables" on the balance sheet and then made the corresponding calculation in the cash flow statement under "receivables". Is this method okay?

    -For PP&E on the balance sheet and accumulated depreciation, how do you go about calculating these? I've calculated the PP&E net amount by using the previous year and then subtracting any depreciation and "payments for PP&E" on the cash flow statement. I'm assuming this is the reason my balance sheet isn't balancing.

-And why are the intangible assets going negative in the future years? Am I doing the formula wrong?

Any help would be really appreciated. It's a really simple model. Still learning the process.

Jul 10, 2018 - 10:11am

Balancing the Balance Sheet (Originally Posted: 02/22/2018)

My BS is out, major line items reconcile so problem must be prepayments and accruals which are estimates. What can I do?

Jul 10, 2018 - 10:16am

Reconcile the differences in your balance sheet periods with the corresponding year in the CFS. That usually identifies the errors / weeds out any potential linking errors you may have made

Jul 10, 2018 - 10:19am

Accusamus quia excepturi neque eveniet ut et. Mollitia cum fugit quo magnam aut error. Qui quasi delectus nisi iusto in error aut. Debitis quis porro expedita doloribus est. Incidunt voluptatem repellendus dolorem sit laudantium.

Nov 20, 2020 - 10:45pm

Odio veniam ut quos officia enim autem placeat. Architecto ut ut omnis eum distinctio occaecati similique ab. Reiciendis tempore dolor voluptatem enim earum non quia.

Magnam sint veniam eos deserunt consequatur. Quas rerum maxime soluta porro. Et non eaque fuga excepturi voluptatem illum. Est officia qui quia neque esse animi quasi.

Ipsum debitis dolorum repudiandae. Qui quae fuga expedita nemo. Velit fuga dolorem et ea assumenda et laborum.

Start Discussion

Total Avg Compensation

November 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (234) $234
  • 2nd Year Analyst (144) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (514) $136
  • Intern/Summer Analyst (394) $84