3 Ways to Spring Clean Your Accounting – Purge Your Chart of Accounts (Part 2)

June 18, 2014

Purge Your Chart of Accounts.

Think of your chart of accounts as the backbone of your entire accounting infrastructure. If your millions of financial transactions are like printed photos, your chart of accounts are the photo albums that keep things organized.

90% of the chart of accounts I see are both too generic (resulted from the template chart of accounts provided by the company’s first accounting software) and over-complicated (resulted from after-thoughts and nice-to-have accounts that were never part of a bigger vision.) An easy way to keep things under wrap without a major overhaul is the annual purge of accounts that helps keep the structure clean, lean, and mean. Here’s a few step to get started:

1. Print out your profit & loss statement for on a monthly basis for the last 12 months. If your company does less than $10 million in revenue last year and your top level profit & loss statement is longer than 1 page long – it’s a good sign that accounts need to be purged.

2. Look across the entire sheet – are there any lines that are just straight 0s across the last 12 months? That means you haven’t used that account at all over the past year. Get rid of them.

3. Now look down the column that shows your last 12 months total. Are there any line on this sheet with an amount less than $1000? Yes? Is there a specific reason why you need to see this number by itself at this level? If this number changes between $1 to $1000 -> would you do anything differently in your business? No? Purge.

4. By now, you should have really leaned out your chart of accounts and the reports are starting to clean up a lot. 2 more steps until we are done. Step 4 -> if your chart of accounts have sub-accounts, you shouldn’t go past 2 level deep. Yes, it’s possible, so don’t let your accountants tell you otherwise.
Example:
Cleanest Travel
Clean Travel -> Travel – Lodging
Too Complex Travel -> Travel – Lodging -> Travel – Lodging – SPG Hotels

5. Finally, print out your newly modified better version of chart of accounts and read through each account name. Identify everything that you either don’t understand what it means (dues & subscription,) sounds similar (travel – hotel vs. lodging,) or does not apply to your business (advertising accounting when you don’t do any advertising.) Work on grouping related accounts and merging similar accounts to avoid confusion. Purge any accounts that don’t belong.

There you have it. You now have a clean and mean chart of account that’s better than 90% of the accounts I see out there with agencies. Don’t worry about the newer and cleaner version – we can always add more later if needed. But if you keep a good habit of reviewing your accounts on an annual basis – it’ll really help keep you focused on the metrics that really matters.

DeepSky works with entrepreneurs who own digital agencies or law firms to keep their chart of accounts clean and aligned with their business operations and goals all the time. Give us a shout if you have any questions.

See part 1 of our 2014 Accounting Spring Clean series where we talk about measuring what you want done in accounting

Untitled Banner (2)

3 responses to “3 Ways to Spring Clean Your Accounting – Purge Your Chart of Accounts (Part 2)”

  1. […] part 2 of our Spring Clean Your Accounting series this year where we talk about purging your chart of accounts to keep your accounting aligned with your agency […]

  2. […] Purge – Don’t keep accounts that you don’t understand, accounts that haven’t been used or have less than $1,000 in them. […]

  3. Very helpful tips. Thankyou.

Leave a Reply

Your email address will not be published. Required fields are marked *