How Do I Reconcile My Bank Account & Credit Cards in QuickBooks?




“Quicklet” - A Podcast for QuickBooks Pro, Premier, Enterprise Solutions & Point of Sale users featuring helpful information, tips, tricks and suggestions for bookkeepers, business owners, and consultants. Got a QuickBooks Mess? Ask The QuickBooks Gal!
Ask the QuickBooksGal!
Hi, I'm Jayne Miller, The QuickBooks Gal. Welcome to another in our series of “Quicklets” – informational podcasts about QuickBooks and related bookkeeping topics.

Today, I’m going to talk again about Reconciling Bank Accounts and Credit Card Accounts in QuickBooks®. I've gotten a lot of queries recently about the reconciliation process in QuickBooks. If you listened to my last podcast, you know that one of the significant issues addressed in QuickBooks 2008 R3 update pertains to the bank reconciliation process. I think this is a good time to review the reconciliation process.

Nothing is so important and so overlooked in the bookkeeping process as performing monthly bank reconciliations. QuickBooks makes this process as easy as it could possibly be. Everyone should be in the habit of reconciling each checking, savings, credit card, or other financial accounts when they get a statement from the bank or issuing institution that holds these accounts.
Monthly reconciliations allow you make sure your that books are accurate, on-track, and gives you the opportunity to head off problems at the pass… before they become HUGE problems.

To do your bank reconciliation, just grab your statement, open your QuickBooks file, go to the “Banking” menu and select “Reconcile.”
Now you should be able to enter the date of your statement, the ending balance, the date for your service charges and interest (this should be the same date as your statement), and the accounts you want to code your interest and service charges to. The beginning balance is already filled in for you and either comes from the ending balance of your last bank reconciliation or is zero because you’ve never done this before.

There are only three places where you can have errors in the bank reconciliation, and two of them are right here – the beginning and ending balance. If those are right, the only place left where you can have errors is in the actual activity, which you’ll see once you press “continue.”
Once you press continue, you’ll see a new “split” window with checks and deductions in the left window and deposits and credits in the right window. At the top, you will also see a check box where you can select the option to view only activity before or as of the date of the statement you are reconciling to…put a check mark in the box to make reconciling easier. Now you simply put check marks next to each deposit, check, withdrawal, etc that matches with your bank statement. Generally, you will be able to check off everything that is on your statement, everything will match and you’ll just about be done.

However, a few complications can pop up:
One I see a lot stems from the use of outside payroll services. Users often record the expenses as a single Payroll check without the detail of each individual check. If your payroll system clears individual checks through your checking account, it’s nearly impossible to reconcile. To get around this I suggest creating a “Payroll in Transit” account which can be used to reflect the difference between the bank activity that clears and the unidentified individual payroll checks that are a part of the bulk transaction that was entered from Payroll company reports.

The best way to avoid this, however, is to open a separate checking account for payroll and then just transfer funds from the operating account to the payroll account just before payroll. I like this method because I only fund the payroll account when needed and it prevents putting the entire operating account funds at risk. Whenever there is an outside source accessing my accounts, I consider all funds at risk…whether malicious or accidental. When I have a dedicated account, I can control the potential loss.


Another potential problem or difficulty in reconciling is Credit Card deposits. Some processors take the discount off the deposit as it occurs…others discount at the end of the month. Additionally, just as it happens with payroll, sometimes you close your credit card system out at the end of the day and only part of the daily activity clears and reflects on the bank statement…could be dating, could be the time of day, could be that you have AMEX and Discover mingled with Visa and MasterCard. At any rate, you may have to create an account for “Credit Cards in Transit” against which you can make adjusting entries that allow you to balance. This is why I have the same policy for accepting credit cards as I have for payroll. I have a dedicated checking account for my credit card processing. I move the funds to the operating account weekly…it makes reconciling both accounts simple.

Back to reconciling:
When your statement balance and your cleared balance agree and your discrepancy balance in the lower right-hand corner of the reconciliation window is $0.00 you can tell QuickBooks to “Reconcile Now” and after a moment of processing it will congratulate you on completing a successful reconciliation and give you the option to print out a summary report, a detailed report, or both. I like to print the report and store it with my bank statement; however you can always print a copy from the Reports, Banking menu. Just select previous reconciliation report and follow on-screen instructions. This is a handy tool should any transactions that were previously cleared be deleted or altered…use this archived report to find discrepancies.

If you have questions about reconciling your accounts in QuickBooks, drop me a line at www.quickbooksgal.com. Don’t forget that we are now serving Reno, Lake Tahoe, The Carson Valley and Truckee California.

Our online & phone support subscription service is expected to be available by January 2008. Just in time for tax season! We will be offering per incident support as well as subscription services.


Enter to win a $50K Just Start grant!

The best idea could score $40K in cash and over $10K in expert resources. Plus, two first prize winners walk away with $5K. Enter the contest, it's easy. Good luck!


Well, that’s it for now. I appreciate your time and hope you will join us again next time for another in our Quicklet© series. If there are topics you would like me to cover, send me an email at jayne@quickbooksgal.com. I welcome your ideas, questions, and comments.

Got a QuickBooks Mess? Call The QuickBooks Gal!


I’m Jayne Miller, The QuickBooks Gal. Thanks for listening.


Jayne Miller, is the owner of Custom Business Solutions, is a consulting firm in Reno, NV that specializes in providing bookkeeping and software support. © 2007

Comments

Popular posts from this blog

QuickBooks Password Protection

How to "Un" Apply Credits In QuickBooks

Employee Salary/Wage Rate Report