Accounting for Rookies


Permit me to start this article with a confession: It took me more than a decade to make friends with accounting.

Not that accounting didn’t try to become my friend. It kept coming around my freelance business saying that I needed to deal with it. After all, I did need to know how much profit or loss I was generating so that I file a tax return.

So, I hired a bookkeeper to generate quarterly financial reports. Then, when tax time rolled around, she generated a year-end report for me and my tax accountant.

When it came to accounting avoidance, this system was superb.  But there was a problem. The bookkeeper’s reports were seldom correct. I had to go through them, line by line, to see which income and expense items had been incorrectly logged or omitted. Little did I know, but my accounting education had begun.

After nearly a decade of scrutinizing the bookkeeper’s erroneous reports, I asked her to teach me how to use the software she used, and she did. And that was the end of our business relationship.

Unfortunately, I was never able to wrap my head around this software. I don’t know why, but I just couldn’t.

Then I decided to change tax accountants. The new accountant was a tough-as-nails type who brooked no dissent when it came to software. I was to learn how to use the accounting software she used, and that was that.

Fortunately for me, it wasn’t the software that I had so much trouble getting my head around. But I still had to be trained in the proper use of this new software. And that took seven months.

The good news is I can now use the software to get up-to-the-minute reports on the state of my business. Here’s an example from Real Life: The first quarter of this year just ended. And I’ve been looking at the financial reports from January through March.

They’re showing that, as compared to last year, income and profits are up, and expenses are down. Hooray, right?

Unfortunately, no.

I’m in one of those situations where I’m making money on paper, but I need, cash, baby! Oh-h-h-h, do I need some cash flow.

You see, I live and work in a 53-year-old house. And it’s an emotionally needy house. Seems that every time I get a few bucks ahead, the house presents me with a nice, big surprise. With a lot of dollar signs attached.

This past weekend, the surprise was noticing that my 1950s-vintage water line is leaking. Replacing it will require hiring plumbing and paving contractors. Which means that Martha gets an opportunity to put her construction and project management experience to work while she acts as her own general contractor.

Since I gazed down at my leaking water line, I’ve been spending a lot of time calling and e-mailing prospective design clients. And one of those calls hit pay dirt in a big way. It was a project that a client invited me to participate in earlier this year.

His funding’s come through, so we’re going to get started later this week. (Guess where a good part of the up-front payment from this one’s going? If you guessed “To the plumbing and excavation contractors!” you’re right.)

So, the sequence has been:

  1. Martha pulls profit and loss statement. As compared to last year, it looks nice .
  2. Then she takes a quick look at her accounts receivable. Hmmmm, that’s where a lot of the income from the first quarter is.
  3. A look at the bank balances confirms her suspicion: A cash flow problem is developing. Time to…
  4. …Make some sales.

Not that I’m the type to wait for some household crisis to come along before I start hitting the sales prospecting trail. I’m always on that trail. Matter of fact, I’ve got a nice list of leads to start calling after I finish this article.

I’m also on the “call for stock photography” list that a local magazine publisher puts out. So, I’m going to be donning my photographer’s hat this weekend. They’re looking for bicycling-related photography, and that’s one of my specialties. And it just so happens that there’s a big bike race coming to town.

So, maybe I should add an Item #5 to the above sequence: Figure out ways to make more money while diversifying one’s income streams. In addition to my design and stock shooting, I’m working on setting up an online store to sell my photography. I used to have an e-bookstore, and let me tell you, it was nice to wake up and find that sales had happened overnight.

Since this article has taken a “Martha had trouble dealing with accounting, she got over it, and now she’s an accounting evangelist!” tone, let’s go back to the rookie level. How do you get started with this numbers stuff? Here are three tips:

  1. Find an accountant and have him or her set up your business books. Be sure that you are comfortable using the accounting software that your accountant recommends. You may not develop this comfort level right away. I sure didn’t. But, over time, it did happen. Be patient with yourself.
  2. Get training in using that accounting software. Much of this training will be of the “how to do data entry properly” variety, and, trust me, you’ll get bored with it in a hurry. (Hey, we’re creatives. Mundane things like data entry tend to make us yawn and fall asleep.) Despite your boredom, stick with the training, because…
  3. …that data that you’re learning to enter is yours. It’s based on what you’re doing in your business. (Much more interesting than an accounting class exercise, isn’t it?) Won’t be very long before you’ll be generating reports and thinking up ways of making business better so that your reports will look better.

PG

Martha Retallick is a freelance designer and photographer in Tucson, Arizona.



  1. PG Joe

    Did you have to tell me this? DANG. I guess I have to get my accounting in line too. I’m about half way through where you were at and had the talk with my accountant today. Got chastised for using Excel instead of QuickBooks…and I knew she was right. But I love Excel.
    Thanks for the tips – I was really wanting to put this off as long as possible, but knowing the actual health of my biz sounds wonderful.

  2. PG Blake

    Your accountant shouldn’t be so picky about the accounting software you use, you should have found a new one. I work with a dozen or so accounting programs day to day, If a client asks what they should use I tell them which ones I prefer. The catch is cost, its a lot easier for me to setup maintain a program I already know.

    My clients have a choice though, if they are using a program that I’m not familiar with, we have compulsory training, I spend an hour or two every month (and charge them for it) going through their software, looking at their entries and makring sure both the software is working properly and the client uses it correctly.

  3. I too put off accounting! I think we all do as freelancers we want to be gods of design, web, photography anything but accounting. I agree with your post, get a good tough-love accountant, I got one too, he sets things up for me so I can follow and do things easily, so my tax status is all crystal.

    I think controlling your business finances, being CFO of your work is essential and something different from doing it for tax poipoises. It’s critical! I got 3 sets of figures on one excel sheet, a) work completed & invoivced b) work in progress c) projects pitched on. So you can see your cash position. Also doing a project costing before, and analyising afterwards (what you really spent) is useful too.

    Nice post. I’m with ya.

  4. PG Robin Cannon

    The free online version of Quickbooks can be a handy choice for something easy to administer and will give you a general idea of your financial situation. You’re exactly right that having control over your financial situation, your tax liability, etc is vital for any successful business. A good accountant is a must, but also important to be able to maintain a reasonable overview yourself.

    > Figure out ways to make more money while diversifying one’s income streams.

    That would be a great article in itself.

  5. PG Colin Wright

    I highly recommend getting control of cashflow in general (which solid accounting is definitely a part of, but not everything). Check out iwillteachyoutoberich.com for a logical, down-to-earth, highly-attainable advice on the subject, and consider reading the book, too (I just finished it a week or so ago and already it’s changed my entire approach to saving).

  6. PG Martha Retallick

    @Blake: Thank you for your thoughts.

    When I first started with this accountant, I was at a point in my personal and business life where I needed to be told what to do. I And that included being told what accounting software to use.

    In short, my accountant’s firm approach was *exactly* what I needed.

  7. PG Daniel Finley

    What a weird coincidence. I’ve just taken the initiative to learn more about accounting and discovered a few recommend books on http://www.personalmba.com, including Accounting Made Simple, which I’m reading now.

    The free version of Quickbooks was mentioned in the comments, are there any other accounting software that someone can recommend for someone learning?

  8. PG Nichelle

    If you are currently using an Excel spreadsheet, the best thing is try Outright.com which drops you income and expenses into a Schedule C. It’s free and easy, and I use it for my business. Quickbooks is often hard for people to understand, and the online version is not as robust as the PC version.

Leave a Comment