Monthly Archives: September 2011

The IRS, the AICPA, QuickBooks, and You

Earlier this year the IRS announced that it would begin demanding a business’ QuickBooks data file during all future audits conducted by the agency.  In the past, CPAs and their clients would often export the accounting software’s general ledger and other financial information to Excel, and then provide this information to the IRS during an audit, as a way to limit IRS access to non-accounting information.  IRS was satisfied with this until recently when it began to realize the wealth of information that is contained within a company’s software data file – much of which may be unrelated to the year being audited, but may in fact reveal information that could be useful to IRS in evaluating information reported on tax returns.

The IRS has long regarded electronic records as being suspect:  “Electronic records, are, in general, considered less reliable than their paper counterparts due to the ease with which they can be manipulated” according to the recently updated Internal Revenue Manual.  Bingo.  What is so helpful about having the QuickBooks file to audit is the existence within the file of an “audit trail” – a function which cannot be disabled by the users, and which records every keystroke by date, time, and user name.  By studying this audit trail, IRS can determine whether transactions were altered, deleted, or modified, and how often, by whom, and when.

Many CPAs have expressed concern over this new approach because their clients routinely make errors in QuickBooks which have to be corrected after the fact.  They were worried that IRS would regard these errors and corrections as indicative of deceit or fraud, when in fact they are only indicative of incompetence.

Enter the AICPA.  Earlier this year, the AICPA sent a memo to IRS asking for their clarification on their position regarding providing “an exact copy of the original electronic data file…and not an altered version” to IRS auditors.  The AICPA wanted to know whether such a file could be condensed so as not to provide prior year data, but only the data for the year under audit, and whether CPAs are being exposed to potential malpractice claims by inadvertently turning over unrelated data contained within a client’s QuickBooks file.  Some CPAs have gone ahead and either condensed the QuickBooks file or had a software company perform a “redaction” of the file, to remove prior year information.  Anecdotal evidence indicates that this is okay with the IRS, however, it has yet to officially comment on the AICPA’s questions.

So far, the IRS is only training its auditors on the use of QuickBooks and Peachtree during an audit, but it may expand its training to other software packages if it sees a need.  Since QuickBooks has the market share, with a reported 85% of the total, IRS was smart to choose QuickBooks as its first software package to use in its new approach to auditing electronic records.

Now you can count the IRS as yet one more reason not to use QuickBooks.  But, if you are already using QuickBooks or Peachtree and you are about to be audited, but sure to contact your CPA so that they can help you in providing only the information that IRS is entitled to receive during the audit, and nothing more.  And, since QuickBooks is kind enough to provide you with an audit trail, make good use of it by strictly adhering to user log-ins and passwords for each unique user of the system.

How Gross Are Your Gross Wages?

It is amazing just how much difficulty business owners and bookkeepers have in understanding how to post payroll entries.  A common misconception is that somehow a business’ gross wage expense is altered by decisions that the employees make as to how to spend their salaries.  Part of the cause is the way in which businesses must assume responsibility for some of these decisions, such as turning over 401k contributions, Section 125 cafeteria plan deferrals and the like.  Another part of the cause is that accounting software makes bad bookkeepers out of good business owners.

But here is the accounting, legal and tax reality of employee wages:  the salaries recorded on your books must always be the amount which your employee has earned for the period in question.  This must always be the “gross” amount, not reduced by ANY deferrals made by the employee.  What the employee decides to do cannot impact the expense that you as an employer incur when you pay your employees the wages they have earned.

The next challenge is trying to create a journal entry from the payroll reports you receive from the payroll service bureau.   I follow the practice of using a “payroll clearing account” which is an account in your general ledger meant to always end up having a zero balance at month end.  Using a clearing account makes it easier to post payroll entries, especially if you use direct deposit for your employees’ paychecks.  Here is an example of how this works.

A direct deposit comes out of your business checking account to pay your employees, usually accompanied by a report called a “check register” which should be familiar sounding.  The check register shows each direct deposit amount, with a total amount debited from your business account usually a day or two before payday.  Let’s say this amount is $25,000.  Remember, this is your employee’s net pay.  Then, your bank account gets hit for another sum, which includes employer payroll taxes and employee withholdings.  We’ll say this amount is $10,000.  And, you also need to turn over employee retirement plan contributions and Section 125 plan contributions to a 3rd party administrator, in the amounts of $3,000 and $1,000 respectively.  You will also receive reports that indicate how these amounts have been determined.  Usually, the payroll journal and the cash requirements report are the most helpful in generating the format for the journal entry.

Using a payroll clearing account allows you to post the bank debits in lump sums without needing to know at the time how these amounts are to be spread and “grossed up” to employees’ wages and employer payroll taxes.  Here’s how this looks, using “T-accounts”:

Clearing account                                Cash                 

Dr          |          Cr                                Dr          |    Cr       

25,000                                                                  25,000

10,000                                                                  10,000

As you can see, we’ve just dumped the entries into the clearing account, but now we can reconcile cash easily at month end because the totals entered will match the bank statement.

At month end or before, we need to “clear” the clearing account with a journal entry.  We can look at the payroll journal and find the amounts for gross wages for the month,  and total employer payroll taxes.  Here’s what the entry looks like:

                                    Dr                                    Cr                                       Type of account

Gross wages                $34,000                                                                       expense          

Employer taxes               5,000                                                                      expense

Payroll clearing                                     $35,000                                          clearing          

Retirement plan payable                        3,000                                            liability

Section 125 plan payable                        1,000                                           liability

I realize this seems too easy, but there’s really nothing more complicated to it.  When the checks were written to pay the retirement plan and 125 funds to 3rd party administrators, you posted those to the same liability accounts noted above.  At the end of the month, those account balances would be zero, since no further funds are owed.  The clearing account is now zero.  And, gross wages are really, really gross.

The 10 Minute Bank Reconciliation

Yes, there are times when I can do a bank reconciliation in 10 minutes, even for clients with hundreds of transactions per month.  Over the years, I have developed a number of techniques to help me quickly identify bank reconciliation errors and potential causes. But before I get to the “how” of performing bank reconciliations, what are they and why should you do them?

The purpose of a bank reconciliation is to allow you to determine the accuracy of cash balances on a specific period-end date (usually monthly) as recorded in your general ledger.  You should always perform your bank reconciliation as of the last day of the accounting period, not mid-month, because that’s not the date that you are closing the accounting period.  So, get the bank to give you statements with a month-end cut off.  The bank statement tells you which transactions have cleared the bank, regardless of whether such transactions are known to you.  Your books have the complete record of all of your known transactions, but items can appear on your bank statement that you don’t know about.  These are, generally:  NSF checks, interest earned, bank fees, other automatic debits, and deposit errors.  Likewise, items that you know about may not be known to the bank, such as outstanding checks and deposits in transit.  So, the bank reconciliation ties together these two separate sets of records, with your own books trumping everything, because that’s what will be reflected in the general ledger.

Bank reconciliations before the existence of accounting software were often performed in a “4 column” format, with the following column headings:  Beginning Balance, Deposits, Checks, Ending Balance.  This format allowed the accountant or bookkeeper to quickly identify reconciliation issues because each column would then be totaled to agree to the bank’s totals.  This would mean that you could tell if your error was in the checks or in the deposits section of your bank reconciliation.  With accounting software, even though the process is the same, your ability to identify errors is reduced.  A lot of software packages will try to give you hints, but sometimes the hints add to the confusion.  In addition, with accounting software, you can fail to mark items that have cleared and still appear to have correctly performed a bank reconciliation.  This occurs when you or your CPA make journal entries to correct errors, but the journal entries and the errors themselves never get marked as cleared.  I have seen bank reconciliations with un-cleared transactions going back 5 years!  Obviously, this cannot be even factually true, and it means that whoever is performing the bank reconciliations does not understand their function very well.

Aside from ensuring the accuracy of your general ledger cash balances, timely and accurate bank reconciliations are one of the most important elements of your internal control system.  Stale items or unusual outstanding items at period end can indicate financial fraud.  Cash accounts are involved in 93% of all frauds, which is why auditors are trained to search for and identify unusual transactions when reviewing bank reconciliations.  Management review of bank reconciliations is a critical function, but often managers don’t actually know what to look for.  If this describes you, contact your CPA and ask them to show you how to perform this kind of review and what to document, and I’ll offer a few tips below.

Now, back to the 10 minutes I have allotted for the bank reconciliation:  open up your reconciliation tab in your accounting software and enter the period end date and the bank statement balance where indicated.  Make sure that you have the software set up NOT to show transactions for periods after this date.  Mark all of the transactions as cleared.  Now, working backwards, take your bank statement and identify the last check which cleared, and breaks in the check sequences and unmark those checks which haven’t cleared.  Then, enter any automatic debits that you haven’t yet recorded in your books, but which are shown on your bank statement.  Check the last deposit in your books to see if it has cleared the bank.  If not, unmark deposits that have not cleared.  Enter your interest earned and any bank charges shown on the bank statement.  Not in balance yet?  Scan the bank statement for any surprises, such as NSF checks and deposit errors.  Most of the time, the bank reconciliation has now been balanced and is ready to be printed (yes, always print or pdf it because certain software may not allow you to do this later, and your CPA wants it and so does the IRS if you are ever audited).

If you are still out of balance at this point, it is now time to check each item from the books to the bank, one by one.  Again, I usually start backwards because it is generally the month-end transactions that are the culprit.  Remember that your books trump all, so you use your book transactions as your source and compare that to what has cleared the bank, not vice versa.

Once in balance, the bank reconciliation is now ready for management review.  The business owner or manager should confirm that only current transactions are listed in the outstanding checks.  Checks older than 6 months are considered stale.  Usually, these are errors or duplicates that have not been corrected, but if not, Oregon businesses are required to turn over any unclaimed payments to the State Department of Lands.  If you see any unusual outstanding checks, or any “corrections” entered immediately after month end, this could indicate fraud.  Likewise, outstanding deposits or transfers among accounts that are from a prior period or are immediately reversed after month end could also indicate fraud. Scan through all the transactions listed and make sure that the totals appear reasonable in comparison to your typical monthly volume and dollar amounts of transactions, and that check sequences make sense.  Scan check payees to make sure you recognize the vendors.  Review the payroll entries and trace them back to the payroll reports provided by your service bureau.  And, even though most bank reconciliations are performed by the same person who recorded the transactions (your bookkeeper), make sure that this person IS NOT a check signer.

The internal control function of the bank reconciliation is where you should spend your time.  The routine part involving doing the reconciliation itself should not be a hassle, and if it is – get in touch with your accountant for their advice on how to make the process more efficient.