Tag Archives: bookkeeping

Use Business Lines to Read Warnings in Numbers

Are you minding your business? I’ve found through the years of minding my business that most of the important insight in the numbers comes in lines, not dots. I mean that tracking the change in key indicators over time, with lines, is much more valuable than looking at them at any specific point, as a dot.

For example, if your business sells to other businesses, you probably deliver the goods or services along with an invoice that establishes what your customer or client owes you. We call that money your customer owes you Accounts Receivable. The sales you make like that, delivering an invoice instead of getting paid immediately, are called sales on credit.

For business that deal with sales on credit the Accounts Receivable balance can be critical to a healthy cash flow. Every dollar in that balance is a dollar that’s already in sales, but not in the bank. You are waiting to get paid. The higher the Accounts Receivable, the more the danger.

You can’t measure Accounts Receivable with a single number. $32,812 in Accounts Receivable might be way too much or way too little, depending on how long it’s been there, how it’s trending, how that compares to other balance items, and the original sales amounts.

I like to watch the number as a line chart so I can see how it’s trending. Your accounting or bookkeeping software might be able to do this, and if not then any of the leading spreadsheet software applications can. I recommend you generate a line chart showing sales on credit on one line and Accounts Receivable on the other. If sales go up quicker than Accounts Receivable, that’s good. That’s the case in the second line chart here. If Accounts Receivable go up quicker than sales, that’s bad. That’s the case in the second line chart here.

The sales in both line charts are identical, but the behavior of the Accounts Receivable balance is different. In one, there might be reason to worry. You start with the line chart, which is like an alert. Then you go into the details, like who owes your business how much, and how long have they owed it to you. You call, you ask, you investigate, you deal with a problem. In the second case, seeing how Accounts Receivable is behaving, you probably look at the chart and go on to deal with something else.

With most of your business numbers the trends — the line — tell you much more than the specific numbers — the dot — at any one point. If you manage inventory in your business, draw the line of inventory turnover. Every business should watch the lines of the trade payments you have to make (called Accounts Payabe), and of course sales vs. costs, sales vs. expenses, sales vs. profits, sales vs, employees, and so on.

It’s not the numbers you watch as much as the change in numbers. Draw your line charts. Every month.