What I’m showing here in the illustration might look like it’s a self-contained table, but it’s really just the bottom half. This is where the money goes (or technically, where you plan to send it). The top half, on the previous pages, was where the money was coming from.

It starts with money you spend on operations. That’s what you spend in cash, and what you spend to pay bills. These, between them, are the universe of things that happened on the income statement. The split between cash and payment of bills can be confusing, but we have to keep track of that to do a real cash flow.

0

Share this image
more
Slingpic
Powered by

The Other Side of Sales on Credit
This paying the bills portion of the cash flow is where you get the other side, the good side, of sales on credit. This is where you are a business, so you get to wait a while before you pay the bills. The calculations are a lot like the ones for accounts receivable, based on the days of waiting, and the bills coming in. By the way, between what you pay in cash and what you pay as paying bills, you have to include all the payments on the income statement. That means all the costs, all the expenses, plus interest, and taxes, all go through the filter of either cash spending or bill payment. That includes inventory too.We’ll look in detail at calculating these payments shortly.

And, just to make that even more fun, bill payment has to include payment for inventory, which is particularly tricky because inventory isn’t directly on the cash flow. As we discussed in cash traps, inventory is money spent on assets first, and those assets become cost of goods sold when they are in fact sold. We’ll look at that in a few pages, so bear with me.

Much like with the money received and accounts receivable, the first two rows of this table show money spent in cash and bill payments. Money spent in cash is frequently payroll, for example, for which you pay people directly, not after a few weeks. Sometimes there are other cash payments, such as petty cash.

The second obvious use of cash is bill payment. This accounts payable balance is money you owe. Every month, you pay off most of this, depending on how quickly you pay. As with receivables, there are some calculations in the background, like those shown in the illustration below:

In the example here, the calculations start with the ending balance of accounts payable from the previous month, then add new obligations, then subtract obligations paid directly in cash, as well as this month’s bill payments, to calculate this month’s ending balance. This month’s bill payments depend on the assumption of waiting 30 days, on average, before paying bills.

Tim BerryTim Berry

Tim Berry is the founder and chairman of Palo Alto Software and Bplans.com. Follow him on Twitter @Timberry.