You Better Reconcile

When we meet with new clients, one of the first things we like to determine is how recently their books have been reconciled to the bank accounts. Sometimes, (rarely), the books have been reconciled to the prior month. Sometimes it's been a few months, or a few years. Sometimes a bank reconciliation has never been performed, and the client's not really even sure what that means.

Since "knowing is half the battle", I'm going to explain what a reconciliation is, the basics of how it's performed, and why it's important.

What's a monthly bank reconciliation?


To clarify, there are many types of reconciliations, for bank accounts, credit cards, petty cash, inventory, sub-ledgers, etc. For this article, we're referring to bank reconciliations. A bank reconciliation is like balancing your checkbook, for your business. Most accounting software programs now come with a reconciliation tool (instead of the spreadsheets we used in the days of yore). Since it is the most popular accounting software in small business, I'll be referencing the QuickBooks reconciliation tool.

 

How is a reconciliation performed?


First, you need to see when the account was most recently reconciled, and then obtain a copy of the bank or credit card statement for the following month. Second, after ensuring that the prior month's ending balance matches the following month's beginning balance, you'll note the statement's ending date and ending balance.

From there, you go line-by-line through that month's transactions, matching each one to its equivalent entry in your accounting software, to make sure that all transactions are properly entered and that your cash balance in the software matches the balance in the bank, for the same ending date.

 

That sounds very time-consuming and tedious. Why would anyone want to do that?


Monthly bank reconciliations are a very useful tool for ensuring accuracy in your books. They can:

Show you what's missing. Sometimes, transactions do not make it into the books, either because they did not download correctly, or weren't manually entered. If a transaction is on the bank statement but not in the software, you know it needs to be added. Also, sometimes there will be things recorded in the software which aren't on the bank statement. These could be inaccuracies, or it could be something like checks which have not yet cleared the bank. If there's a large number of uncleared checks, it's helpful to know that, for cash-flow purposes.

Show you what's duplicated. If you have a large number of uncleared checks, particularly if some of them are months-old, it could mean that an expense was added without being matched to the written check, and was therefore duplicated. The same thing can happen with income. I once found where a new client's prior-year annual sales were overstated by about $50,000, due to deposits not being matched to previously-recorded payments. The uncleared payments showed up on the reconciliation report, and helped the client avoid overpaying on his taxes.

"Lock down" errors to one period. If your books were accurately reconciled last month, and something is wrong on this month's bank reconciliation, you only have to go through about the last 30 days to find the error. If your books have not been reconciled in a long time, or ever, it's going to be a lot more work to find where the inaccuracy occurred.

Maybe accounting professionals are a little weird, but many of us even find bank reconciliations to be fun (or, at least very satisfying when accurately completed). If you're having trouble with your bank reconciliations, if you need help learning how to perform them, if something looks wrong but you're not sure what, or if you're just sick of doing them and want to pass the job off to someone else, contact us. We happily provide a free 1-hour initial consult to answer your questions.


Staying (Financially) Fit Over the Holidays

With Halloween only 12 days away, we are officially in the holiday season. This is my favorite time of year, and I understand the temptation to let work slide as I give into the distraction of Thanksgiving, Christmas, and vacation.

But holiday season coincides with year-end and, for businesses, this needs to be a time of focus. Just as it's easy to undo months of dedicated diet and exercise with the wild abandon of the holidays, it's easy to let your business financials slip at the time when you really need them at their peak.

Here are a few common bookkeeping issues we see in Q4 year after year, and how to avoid them.

Missing Deductible Expenses

Christmas GiftsThe holidays are a great time to let loose and be more sociable with co-workers, clients, and referral partners. But just as you lose count of how many calories you're taking in, you can lose track of the money you're spending. Not only can this result in overspending, of course, but you can also be missing out on deductible expenses that will save you money in just a few months at tax time.

Perhaps you're planning an office Christmas party for your staff. Not only would those expenses be deductible, even food purchased for a potluck, but any staff appreciation gifts you'd like to hand out, as well. The same goes for client or vendor appreciation gifts. (If you have someone external doing your books, be sure they're asking about purchases for things like massage gift cards and fruit baskets, and recording them as business expenses, not draw activity.)

Many networking groups hold a special holiday party. Not only would any food and drink you purchase for that be deductible, but also mileage to the event. If you're having trouble keeping up with your mileage, something as simple as a mileage log (free to download here) in your vehicle or as sophisticated as an app can do wonders to help you track that.

Whatever you do, be sure you're keeping proper record of your business expenses, even while you party it up.

Falling Behind on Bookkeeping

Christmas TravelBetween parties, travel, and employees being out sick from all the germs they picked up partying and travelling, it's easy for certain tasks to get a bit behind in the later part of the year. However, bookkeeping is not like cleaning the house; you can't just plan to catch it all up at once. If I don't clean my house for a month, it's not that much more difficult, proportionately, than if it's not cleaned for a week. Bookkeeping doesn't work that way. If your bookkeeping takes four hours a month and you fall three months' behind, you now have twelve hours worth of bookkeeping to do. (And finding twelve hours for a task you like is difficult enough; imagine trying to find half an entire day to dedicate to a task you dislike.)

Many business owners who find themselves in the position of staring down months of untouched financials make the decision to get some outside help, just to catch things up. The problem is that they're in good company. Beginning in November, professional bookkeepers get very busy with new clients who are hoping to get their books cleaned up for year-end. Not only is there an influx of new clients, but existing clients continue to need service, and we're busy getting all of their year-end documents ready as well. Many of my friends who work solo or operate smaller firms do not take on any new work during this time of the year.

If you aren't certain that you'll be able to keep up with your financials on your own during the holiday season, begin seeking assistance now, before you get too busy.

Not Preparing for Next Year

(NOTE: If you are one of those people who files an extension out of habit, this is for you.)

Get Fit NowYou may not realize it, but there is a lot you can be doing right now to get ready for next year's tax season.

Just like you don't have to wait to make a New Year's resolution to start getting fit, you don't have to wait for January 1st to start getting your books in shape for tax season. For starters, you can be preparing for the January payroll reporting rush. In the chaos of year-end, many business owners forget that 1099s and W-2s are due at the end of January, and not in April. To prepare, you can be sure that you have W-9s, W-4s, and any required state tax documents on hand now, instead of trying to get them from workers later. (This is especially true of 1099 contractors, as they may work for you for a much shorter season and can be harder to track down later.)

If you have been using an outsourced payroll system, be checking now to ensure that the payroll reports in your financials match those provided by the vendor. Sometimes errors do occur, and you will need to alert the payroll company right away if their totals are incorrect. (Like bookkeepers, they are getting very busy this time of year, too.)

You want to check to make sure that your sub-ledger totals, such as your Accounts Receivable and Accounts Payable, match your General Ledger balances. You also want to be sure that you are up-to-date on any reconciliations.

Finally, it's a good idea to take some additional tax-sheltering steps. For example, if you had a good year and are cash-basis, consider making a large business purchase in December instead of January, to reduce your taxable income. Or maybe you have not been paying enough into your withholdings or your quarterly estimated self-employment taxes, and need to increase those in December. There are many options available to you, but you need to act now.

Fortunately, you still have some time to make the most of your holiday season. Stay on top of your books as you go, and you will have a restful and relaxing January (at least compared to everyone who didn't put in the work during December). If you need help, we are always available.