Minimum Requirements for Accounting Solutions and Software


One of the highlights of my summer was going to the MLS All Star Game and getting to see FC Bayern Munich and many of the German World Cup winners. I enjoyed booing Clint Dempsey and other Seattle Sounders, witnessed “Pepgate”, and don’t forget the amazing assist by Deigo Valeri.

Much like the way FC Bayern Munich has dominated German and European football over the last few years, QuickBooks has long been the top accounting solution for small businesses. It is easy to learn, flexible, and it provides all the features needed for a complete accounting system that works for both the small business owner and their tax preparer. It is by no means a perfect small business accounting solution, as I have a lengthy list of suggestions & complaints for Intuit, but it is the best solution you are going to find for the price.

In recent years, some low-cost, online accounting solutions have emerged to challenge QuickBooks for the sole proprietorship market by offering more simplistic accounting and integration with other online services like Ebay, Etsy, and PayPal. While I am all for simplicity and keeping accounting work efficient, I am strongly against the use of some of these services, as many of them lack basic reporting features that should be part of even the most simplistic accounting system.   To help you avoid these inferior accounting solutions, below are the minimum requirements you should look for before committing to a specific solution.

Balance Sheet Report

If an accounting solution only provides a profit and loss report, you are missing out on crucial accounting information and an important tool that enables you to verify that your accounting records are accurate and complete. In fact, if a balance sheet report is not provided as a standard report, it should be an outright deal-breaker and “go-time” to find a different solution.

A balance sheet report provides the balances of your assets, liabilities and equity as of a specific date. This would include all your bank and credit card accounts, loans, fixed assets and accumulated depreciation accounts, payroll liabilities, and most importantly – your accumulated draws taken from the business. Even if you have a small sole proprietorship, you likely have a number of these accounts, as most business owners use credit cards and PayPal, but even if you only have one bank account and no debt, you still need to be able to generate a balance sheet so that you can see how much net profit you have withdrawn from the business. After all, one of the most difficult issues for a small business owner is determining how much cash needs to be left in the company and how much can be safely withdrawn.

In addition to providing you with account balances and your remaining equity in the company, the balance sheet report is also an important tool, and the document that most CPAs and tax preparers use to confirm that your accounting records are correct. If you have a quality tax preparer, they will take a balance sheet approach when doing the accounting work for your tax return, which means they will reconcile each balance sheet account to third party and other verifiable documents and reclassify any differences to profit and loss accounts. Once all the accounts on the balance sheet are reconciled and tied out, you can be confident the profit and loss is correct. Without the balance sheet, you would not know if changes were made to the prior year, if transactions were missing, or if there were duplications and other errors. Most CPAs and tax preparers require a balance sheet to prepare a tax return – even for sole proprietorships and small LLCS – so do not use a service that does not offer a balance sheet report.

Bank & Credit Card Account Reconciliation

I love technology and the fact that you can save hours of input work by importing transactions from banks right into accounting solutions. Even better, most accounting solutions remember expenses categories for vendors, so the input side of bookkeeping work is becoming easier. However, that doesn’t mean you can neglect basic accounting procedures like reconciling your bank and credit card accounts. It is still the best way to verify that the data in your accounting system matches the bank and that there are no duplications, stale checks, or other input and/or import errors, and your accounting solution should make the process a quick and painless.

Reconciling is the process of matching the individual transactions input and/or imported into the accounting system to a bank statement until the cleared balance in the accounting system matches the ending balance per the bank statement. The reconciliation report is important verification that your accounting records are complete and not missing any transactions, and most CPAs and tax preparers will want a copy when preparing your return, as the IRS’s most effective audit technique is their bank account analysis. Reconciliations also help identify old outstanding checks and duplications and errors that need to be voided. Without reconciliations, there is no guarantee that your accounting records are correct.

The overconfidence in imported data in an accounting system often leads to duplication errors and grossly misstated financial statements, which makes the reconciliation process even more important. Importing works great for straightforward expense transactions, but bank transfers and balance sheet transactions often create problems. Much care needs to be taken when you are reviewing and categorizing the imported transactions, and the accounting solution is not always correct in its categorization. Plus, always keep in mind that only cleared transactions are downloaded and imported – you still have to manually input any transactions that have not cleared the bank, as expenses are deductible when the check is written or charge is made, not when it clears the bank, so do not miss out on tax deductions by taking bookkeeping shortcuts. Take the time each month to reconcile all your bank and credit card accounts and review your outstanding transactions, and you will dramatically improve your accounting records and maximize your tax deductions.

All quality accounting solutions have a reconciliation feature where you can check off each deposit and check/charge as you match them to the bank statement. For example, QuickBooks, has a very easy to understand reconciliation feature that hides all transactions after the statement date, tracks the difference between the cleared balance and the bank statement balance, and allows you to click through to transactions if corrections need to be made. There are accounting solutions out there that do not offer such a feature in the name of “simplicity”, or they have a very limited reconciliation feature – please avoid these solutions at all cost. Reconciliation of bank and credit card accounts is a basic accounting function, and failure to reconcile your accounts each month results in accounting records that are simplistically inaccurate.

Statement of Cash Flows

Like the balance sheet, a statement of cash flows is an essential report that that is a minimum requirement for an accounting system. The report begins where the profit and loss report ends and shows you the inflows and outflows of cash unrelated to income and expenses, which often include loan payments, owner draws, equipment acquisitions, and loan proceeds. Even with a simple business, the statement of cash flows is just as important as the profit and loss report, so make sure an accounting solution offers a cash flow report before deciding on it.

Drill-Down Reporting and Transaction Attachments

The ability click on a transaction and quickly view the transaction is crucial for an accounting solution. As a decision maker reviewing financial statements, you are often looking for variances of concern, and you need to be able to quickly find the reasons for the differences without too many steps. You should also be able to go to the source transaction and related transactions quickly, and have the option to attach pdfs of receipts to the transactions. Make sure you use a sample company in an accounting solution before deciding on purchasing it, as minor issues with drill-down capability can cause major aggravation and waste time you could spend growing your business.

Reporting for All Entity Types

An accounting solution should have flexibility for future growth and not be limited to a specific business entity type like a sole proprietorship or simple LLC. Granted, a simplistic accounting solution may sound great for your small Schedule C business, but what about a few years later when you are looking to elect to be taxed as an S corporation? Are you going to wish you had just gone with QuickBooks so you do not have to deal with the hassle of a software migration? Businesses can grow quickly, and you need an accounting solution that is flexible enough to handle any changes. I spend much of my time assisting business owners with changes to their business structure – everything from adding new owners to converting to an LLC or S Corporation for tax savings purposes, and these changes are complex enough without having to worry about accounting software, so make sure you think long range before deciding on an accounting solution.

There you have it – my minimum requirements for an accounting solution. I am sure there are many more, so feel free to share. Also, if you have any bad experiences with particular solutions, please share with my readers. My parting advice (in case you missed my not so subtle hints)– steer clear of accounting solutions offered by web hosting companies. They are outright horrible.