How to Reconcile Cash Flow With the Balance Sheet

Two checks, in that order. First, opening cash plus the net movement on the statement must equal the closing cash the balance sheet prints. Second, every difference between the two balance sheets must be traceable to a line on the statement or to a movement disclosed as involving no cash. Run both. When the tie breaks, the size of the break is the first clue.

A cash flow statement never stands on its own. The statement is stretched between two balance sheets, anchored at the cash line of the earlier one and expected to land precisely on the cash line of the later one, and it has no independent existence outside that span. Reconciling is nothing more elaborate than walking the span and confirming that both anchors hold.

The reason this check earns a place in the routine is that a cash flow statement can be wrong while looking entirely reasonable, and the two balance sheets are the only witnesses that will contradict it. Nothing inside the statement itself is going to raise a hand. The subtotals will add. The sections will be sensibly labelled. The figures will be in the right shape. Set that same statement against the two dates it claims to connect, though, and a single missing or misdirected line shows up as a gap that will not close.

Think about a shopkeeper who counts the cash box on the last evening of March and finds Rs 7,000/-, then counts it again a year later and finds Rs 5,000/-. In between there is a notebook recording what came in and what went out. If that notebook adds to anything other than a fall of Rs 2,000/-, the shopkeeper does not stand in the shop wondering whether money is missing. The two counts are known. The notebook is the doubtful item, and the shortfall in the notebook is where the search starts. A cash flow statement is that notebook at a larger scale, and a balance sheet is the count at each end.

The worked pass runs on Anjani Stationers, an invented supplier of stationery to schools, at its second reporting date. Its balance sheet at the first date showed cash of Rs 7,00,000 among total assets of Rs 1,33,00,000. Its balance sheet at the second date shows cash of Rs 5,00,000 among total assets of Rs 1,80,00,000. Between the two sits the year two cash flow statement, and the work that follows is the act of checking whether the statement genuinely joins those two figures.

The statement being checked is set out in full below, and each step returns to particular lines of it.

Step one: what has to be true before any checking begins?

Three documents are needed and not one: the balance sheet at the earlier date, the balance sheet at the later date, and the cash flow statement that claims to join them. Two figures then go at the top of a sheet of paper. The opening balanceThe amount standing in an account at the very beginning of a period, carried in unchanged from the end of the period before it. of cash, taken from the earlier balance sheet, and the closing balance of cash, taken from the later one. Both of those figures come from the balance sheets. Neither is read off the statement.

A statement checked against its own arithmetic will always agree with itself. Everything that follows depends on the two anchor figures being taken from somewhere other than the document under suspicion. The rule sounds obvious written down and it is broken constantly. A preparer looks at the bottom of the statement, sees the closing cash printed there, sees it matches the closing cash printed just above it, and calls the statement reconciled. Both of those figures came from the same spreadsheet cell. Nothing was tested.

For Anjani Stationers the two anchors are Rs 7,00,000 and Rs 5,00,000, and the second one carries a further duty. The Rs 5,00,000 must be the cash line inside total assets of Rs 1,80,00,000 on the published balance sheet, the same document that shows Rs 38,00,000 of liabilities and Rs 1,42,00,000 belonging to the shareholders. Once both anchors can be pointed at on documents the statement did not produce, step one has passed and the right to compare has been earned.

Step two: does the cash line tie at both ends?

One addition. Take the opening cash from the earlier balance sheet, add the net movement the statement reports, and compare the result with the closing cash on the later balance sheet. Write down whether the two are equal. If they are not, write down the difference and carry that number, not a vague sense that something is off, into step six.

The addition is the check that most statements pass and the one nobody is entitled to skip. Of every test in the routine, it is the only one that can be settled in ten seconds and cannot be argued with. Notice that it is deliberately blunt. The addition says nothing about whether the sections are sensibly classified or whether the working capital lines are right. The check says only that the span reaches both banks.

Anjani Stationers: Rs 7,00,000 of opening cash, a net decrease of Rs 2,00,000, and Rs 7,00,000 less Rs 2,00,000 is Rs 5,00,000. The later balance sheet prints Rs 5,00,000. The two are equal, so step two passes and the difference to carry forward is nil. Worth noticing what that pass does not establish. Two errors of opposite sign and identical size would produce exactly the same clean tie. Steps three, four and five exist for that reason, rather than the routine stopping at step two.

Step three: does every balance sheet movement appear somewhere?

Now the sweep, and it is the longest step by some distance. Set the two balance sheets side by side and list every line where the amount changed. Then give each movement a destination: a named line on the statement, or a movement disclosed as involving no cash. A movement with no destination is the error. Step three has already put a finger on it, and step six is not needed.

The sweep works because a balance sheet cannot hide a movement, so any change the statement fails to explain has nowhere left to go. A household that ends the year with a scooter it did not have in January cannot leave the scooter out of the year's account of itself. Either money was paid for it, or somebody gave it, or it came with a loan attached, and one of those three has to be written down. The one thing not permitted is for the scooter to appear silently.

Thirteen movements separate the two balance sheets of Anjani Stationers, and all thirteen have a home. Two of them are worth pointing out now because they behave differently from the rest. Property, plant and equipment moved Rs 8,00,000 while the statement records only Rs 12,00,000 of spending on it, and the lease liability appeared at Rs 6,00,000 while the statement records only Rs 1,00,000 of repayment. Both are handled at step four rather than here. Step three notices them and refuses to move on until each has somewhere to sit.

Step four: are the movements with no cash left out and disclosed?

Take the movements that step three flagged and confirm two things about each: that it appears in no section of the statement, and that it appears in the disclosureA statement of fact set out in the notes behind the financial statements rather than as an amount on the face of them. behind the statement. Both halves are needed. A non-cash movementA change in an asset or a liability that happened without any money entering or leaving a bank account. that has been kept out of the sections but never disclosed leaves the reader unable to explain the balance sheet. One that has been disclosed but also written into a section breaks the tie.

The reliable way to run step four is a roll-forwardA line by line reconstruction of how a balance moved from its opening amount to its closing amount, listing every addition and subtraction in between. of the line in question. A roll-forward makes any movement carrying no cash appear as the one figure needed to make the opening and closing amounts meet. Property, plant and equipment for Anjani Stationers stood at Rs 28,00,000 and ends at Rs 36,00,000. The statement records Rs 12,00,000 of buying and the year charged Rs 11,00,000 of depreciation on this class. Rs 28,00,000 plus Rs 12,00,000 less Rs 11,00,000 is Rs 29,00,000, and the balance sheet says Rs 36,00,000. The roll-forward is short by exactly Rs 7,00,000. The missing Rs 7,00,000 is the right-of-use assetAn asset recognised for the right to use something held under a lease for a period, recorded alongside a liability for the payments promised in return. recognised during the year with a matching lease liability of Rs 7,00,000 against it.

Now confirm the other half. No section of the statement contains Rs 7,00,000. Investing records Rs 12,00,000, Rs 1,00,000 and Rs 21,00,000, and financing records Rs 20,000, Rs 1,00,000 and Rs 3,50,000. The Rs 7,00,000 appears only in the disclosure, where the statement notes that an asset and a liability of that size were recognised without any money moving. The lease liability rolls the same way from the other side: nil, plus Rs 7,00,000 recognised, less the Rs 1,00,000 repayment that financing does record, giving the Rs 6,00,000 the balance sheet shows. Step four passes on both counts.

Step five: is the tax line the amount paid or the amount charged?

Find the tax line in operating activities and hold it against the tax figure at the foot of the income statement. Then find the deferred tax liabilityAn amount of tax recorded as a cost of this year's profit but not payable until a later year, shown among liabilities until it falls due. on both balance sheets and take its movement. The statement's tax line must be the payment. The movement in the deferred amount must be the difference between the payment and the charge. Two figures, one subtraction, and the check is over.

The tax line earns its own step because it is the one line where the correct figure and the wrong figure are both printed, both are labelled tax, and only one of them ever moved through a bank account. Every other line on the statement has to be built. The tax figure is sitting in two places, waiting to be confused.

For Anjani Stationers the income statement carries a total tax of Rs 8,00,000, made up of Rs 6,20,000 current and Rs 1,80,000 deferred. The statement deducts Rs 6,20,000. The deferred tax liability moved from nil to Rs 1,80,000 across the two balance sheets, and Rs 8,00,000 less Rs 6,20,000 is Rs 1,80,000. The three figures agree, so step five passes. Anything else, and the size of the problem is known before the search for it begins.

Step six: if it still does not tie, where does the search go, and in what order?

Recomputing is the wrong first move. The difference the failed check reported goes in the middle of a clean sheet, and is then held against three things in turn: the movements the balance sheet shows for the items that carry no cash, half of the difference, and the single largest line in investing. Only when none of those three matches does the search go line by line, and by then it has cost about two minutes rather than an afternoon.

Reading the difference before recomputing works because a cash flow statement fails in a small number of specific ways, and each of them leaves a mark of a very particular size. A locksmith does not take a lock apart to find out why a key will not turn. The way the key stops tells him which of four or five things is wrong, and he goes to that one. The difference on a failed tie carries the same information.

Halving the difference deserves its own mention. The halving catches the one error the other tests miss. A sign conventionThe rule that decides whether a movement is written as an addition or a subtraction, keeping inflows and outflows apart. entered the wrong way round does not omit an amount but counts it twice in the wrong direction. The gap it creates is therefore double the amount involved. Anjani Stationers' receivables rose Rs 17,00,000 and entering that as an inflow rather than an outflow puts the statement out by Rs 34,00,000. Reading Rs 34,00,000 and hunting for a Rs 34,00,000 line finds nothing. No such line exists. Halving it first names the line in seconds.

The four outcomes are also set out here as plain text. Deduct the Rs 8,00,000 charged rather than the Rs 6,20,000 paid and operating falls to Rs 34,50,000, closing cash comes out at Rs 3,20,000, and the gap is Rs 1,80,000. The deferred tax movement is Rs 1,80,000 exactly. Write the right-of-use asset into investing as though it were a purchase and investing rises to Rs 41,00,000, closing cash comes out at minus Rs 2,00,000, and the gap is Rs 7,00,000. Enter the receivables rise as an inflow and operating jumps to Rs 70,30,000, closing cash comes out at Rs 39,00,000, and the gap is Rs 34,00,000. Twice Rs 17,00,000 is Rs 34,00,000. Leave the Chitra Binding purchase out and investing falls to Rs 13,00,000, closing cash comes out at Rs 26,00,000, and the gap is Rs 21,00,000. Four errors, four gaps, and not one of the four gaps could have come from any of the other three.

Who actually runs this check, and at what point?

A routine nobody reaches for is a routine only on paper. Knowing the order of the six steps and running them at the right moment are different things.

A statement that has not been tied is not yet evidence of anything, and reading it carefully is wasted effort. In practice, then, the check runs before anybody forms a view, not after. A lender's credit officer working through a small supplier's accounts ties the cash line first, in about a minute, and only then asks whether Rs 36,30,000 of operating cash is comfortable against what falls due. An analyst rebuilding a business's history across four years runs the tie at each year end and treats a year that will not tie as a year whose figures are not yet usable. The sweep is what surfaces a purchase or a lease that the statement quietly failed to mention, so somebody buying into a private business runs the movement sweep specifically. In every one of those cases the tie is the gate, not the conclusion.

The habit that makes it stick is small: keeping the two balance sheets and the statement in one place, physically or on one screen, and never working on the statement alone. The opening cash and the closing cash go at the top of the working sheet before anything else is touched, both taken from the balance sheets. Then the addition is run. Somebody doing this thirty times a year develops a useful reflex. A cash flow statement circulated without the balance sheets that bracket it starts to look uncomfortable.

There is a household version of the same discipline and it is worth trying once: taking a bank passbook or a statement for a period, noting the balance at the start and the balance at the end, then listing every movement that can be remembered or traced to a record, and adding them up. Most people find a difference on the first attempt. A rent payment is a familiar amount and so is a salary, so the size of the difference almost always names it. Naming a gap from its size is the same reasoning step six asks for, run on figures already known by heart.

Anjani Stationers Private Limited and Chitra Binding Works Private Limited are invented.
Educational material. Not advice on any investment, tax, budget or market position.