“But my BAD debt isn’t really that bad… is it?”

Unless you get money from customers up-front before you give them the product or service they purchased from you, you will likely get shafted now and then from customers who will never pay.

In spite of your best efforts, these receivables end up getting older and older and you realize that you will never collect from them. Everyday people might call this “hopeless” but in accounting lingo, it’s called “bad debt“.

It’s tempting to just ignore your bad debt. (Hey, no business owner wants to be reminded of a customer who pulled a fast one on them). Unfortunately, doing that will artificially inflate the assets on your balance sheet while also misstating your profit.

But you do need to do something with these numbers! Here’s what to do:

Read More »

But HOW do You Make Sure Timing is Correct?

Last week we talked about timing and making sure that certain costs were entered when they are relevant. This is a very difficult territory for some and confusing for others.

I am going to try to make it simple (and I hope I’m able to do so!)
Read More »

Transform Your Business With Spreadsheet Accounting – Part 3

In the first blog post in this series I introduced you to the 3 key spreadsheets that every business needs and I gave you a really quick-and-dirty way to set up the three spreadsheets in one Excel file. In the second blog post in this series, I talked about the relationship between all three spreadsheets.

I’m realistic enough to realize that financial statements can seem complex and unwieldy at the best of times, which I’ve been walking you slowly through the details that I felt you needed to know. And I was planning to show you how to build the three spreadsheets yourself. But I’ve got good news for you: In the last blog post of this series, I’m going to make it really easy for you! I’m going to link you to one free file that you can download that will GIVE you all three spreadsheets in a single Excel file. Here’s how to get it and use it:
Read More »

Transform Your Business With Spreadsheet Accounting – Part 2

In a previous blog post I showed you a way to put together a single file consisting of your three most important financial reports – the reports that every business should have.

I’ll be talking to you over the next couple of blog posts about these spreadsheets and how to put them together but in this post I want to pause momentarily to talk to you about the all-important question of WHY.

Why do we need those three financial reports? When we answer that question, understanding HOW the spreadsheets work falls naturally into place.
Read More »

Transform Your Business With Spreadsheet Accounting – Part 1

When a new client approaches me to do their accounting for them, they often bring in their previous financial “system”… which usually consists of cardboard box overflowing with files, receipts, envelopes, and notebooks of spreadsheets. The first thing I do, before I start any official “help-them-save-money-and-make-more-money” accounting work, is to roll up my sleeves and systematize the avalanche of papers.

If your small and growing business doesn’t have an accountant yet, or if you want to make it really fast for your accountant to get through your records and start delivering the meaningful insight that you are hiring them to provide, you need to build and implement a spreadsheet-based accounting system as early as possible.

Read More »