Clean Up Your Books in Eight (or Nine) Steps – Cleanup ChecklistBookkeeping is more than just a record of money in and money out. It helps businesses assess their past performance, evaluate their current operations, and plan wisely for the future. At least, it should. And you should follow a bookkeeping cleanup checklist – So in this post I share my thoughts on how I approach cleaning up books for hundreds of clients a year. If you would like to discuss your case in particular, please submit your case for evaluation here. When a business’s accounting records fall out of order, its books no longer provide the guidance they were meant to. Nor do they provide compelling support for the business’s tax return filings in case of an audit. Sloppy or incomplete books may even prevent a business from qualifying for the loans, lines of credit, and investor funding on which its future growth rests. This guide is meant to walk you through the stages of a comprehensive accounting clean-up project, from the initial what-am-I-looking-at-here stage to steps you can take to ensure that your books remain accurate, comprehensive, and useful. It is addressed to small business owners, but the advice found here can help anyone faced with poorly maintained financial records, including independent bookkeepers. Too often, clients seek help with their books after years of doing their accounting in a shoebox. This can be an honest mistake—simple cash-basis accounting may be fine for a side hustle, but when business picks up, the old approach simply doesn’t work. Divorce and other major life events can also make a good-enough approach to finances suddenly appear painfully inadequate. Whatever the reason for getting a handle on the books, whether you own a small business or are helping someone who needs a more complete and accurate view of their finances, this guide can help you map out a successful strategy.
Identify the Problem(s)
Here are some of the most common signs of significant recordkeeping issues.
- Cash-balance discrepancies
- Negative cash balances
- Unexpected interest charged on credit accounts
- Fees or penalties charged by lending institutions
- Inaccurate asset valuation and capitalization
- Incomplete or inconsistent invoices
- Unauthorized withdrawals
- Non-updated inventory level statements
- Changes in payment terms from suppliers
Stop Further Damage
Bookkeeping Cleanup Checklist most overlooked item.After locating the source of your problems, you’ll probably be tempted to jump right in and begin fixing them. It’s wiser, though, to take a breath at this point and ensure that your books suffer no further damage. The key to this step is making sure that all incoming documents are handled by a reliable accounting system under the eye of a reliable bookkeeper. This can be as much a personnel decision as an accounting one. Too often, small business owners continue to manage the books themselves, even after the business has grown and its accounting needs have changed. If keeping your records in a shoebox was a good enough system three years ago, it’s clearly not enough at this point. Other businesses assign bookkeeping responsibilities to employees who lack the experience to follow through correctly. If you’ve been outsourcing your bookkeeping, it’s time to find a new accountant. If you’ve been keeping the books yourself or with in-house personnel, it’s time to get some extra training for the person who’ll be managing things from here on out. For now, you may well need to take control of the process yourself, at least for a little while. For most small businesses, a simple accounting software package is all you’ll need to get things back on track. If that means investing in new software, choose a program that allows you to create retrospective ledger entries (more on that in step 5). No bookkeeping cleanup checklist will ever be enough if you do not stop the systematic errors that got your books to this point.
Centralize Management of Source Documents .
Analyze Each Problem Area
Establish a Clean System Moving Forward
Reconcile Your Cash and Credit Accounts
- Each transaction must be verified against a source document.
- Each transaction should be verified against your bank statements.
Your bank statements are the fundamental records for your books, and crucial for your bookkeeping cleanup checklist.Not only should they describe your full cash flow, both incoming and outgoing, they should also be accompanied by images of each deposit slip and check. Start by collecting every source document you can, even if it’s stored in a shoebox, and correlating each with an entry in a bank statement. Cross off each bank-statement entry that matches a source document, and create an entry in your software’s journal reflecting the details of each transaction. Some of your source documents will have been issued too recently to match up with your bank statements. These should all fall into one of two categories: unpaid supplier invoices, or accounts payable, and unpaid customer invoices, or accounts receivable. Then flip the script and start with the items you haven’t crossed off your bank statements. Some of these might seem too trifling to bother documenting—if you’ve been keeping your own books, you might remember most of them—but don’t consider anything fully accounted for until you have a source document to confirm it. You might need to contact customers or suppliers to see if they have copies of a missing invoice or billing statement. Don’t be shy. Get the documentation.
Once you’re done, it’s wise to make a plan to reconcile your cash accounts regularly. Some accounts may warrant a monthly reconciliation, but cash accounts that are used heavily, or for a wide variety of purposes, may warrant biweekly or even weekly reconciliation.When you’ve reconciled your cash accounts, do the same for any lines of credit. This should be a quicker process, in part because there ought to be a close relationship between the payments you have made on your credit lines and your newly reconciled bank records. Be sure to record any interest paid on lines of credit as an expense, and keep an eye out for especially unusual activity, such as negative balances. As with your cash accounts, plan to reconcile each credit account once a month going forward. This step might take a few days, and it might take much longer. If your books have been in disarray for years upon years, you might be tempted to draw the line and stop the reconstruction process. It’s vital that you clean up the last three years of records, and best if you go back seven years. Beyond that, you might not get much practical value from the exercise, and it’s unlikely that anyone else will ask you to go back any farther.
Correct Additional Issues
- Assign Proper Valuations to Your Fixed Assets You should be able to establish the basis for the value you claim for any fixed asset. Make sure that this basis is documented. You must also choose a depreciation method to claim tax advantages against each asset’s basis throughout its expected useful life. Include the method you used, and a full depreciation schedule, in the documentation you retain for each asset.
- Record All of Your Assets, Not Just Fixed Assets Assets like intellectual property may not be subject to depreciation schedules, but they certainly represent value to your company. Tangible or intangible, your assets should be regularly valued, and those values should always be recorded as positive: if your liabilities exceed the value of your assets, you may have negative net assets, but the value of any given value should never be negative.
- Confirm Your Inventory Levels Inventory may be the lifeblood of a retail business, but it also represents assets that can be converted to cash. In that sense, inventory is a critical element of bookkeeping.
- Document Inter-Business Activity If you own multiple businesses, you’ve likely moved cash between them. This is especially common for very small businesses whose net profits are reported as pass-through income. Even if the combined revenue streams for multiple companies will ultimately be joined in a personal tax return, you’ll want to keep their books separate, and to document all inter-business financial activity clearly. You might never be audited, but if you are, you’ll want to be able to prove that every penny was accounted for properly.
- Match Retained Earnings with Tax Returns Speaking of tax audits, you’ll want to finish your analysis by comparing the business’s retained earnings with its tax filings. If the business is especially small and its retained earnings are recorded as pass-through income, this can be a straightforward process. If multiple owners hold shares in the business, calculate the funds remaining after the owners have received their proceeds and compare it to the earnings reported on the business’s tax return.
- Customize your own bookkeeping cleanup checklist based on the above.
Create New Financial Reports – Second to Last item on your Bookkeeping Cleanup Checklist
Move to the Accrual Basis