|
|
|
5 Home Office Essentials
Once you've settled into the idea of running a business from home you need to make a choice. What type of office setup do you need? It's beyond the scope of this article to detail each and every item required for the perfect home office. Instead...
A Real Estate Investing Primer
There are a great many books and web sites devoted to real estate investing out there, but most of them concentrate on one specific area of investing. It's often hard to find a general description of real estate investing, one that lists the...
Bringing the World to Your Door
“The key to your success on the web is the ability to get surfers to stop at your site, look around and ultimately to buy something.” – Heidi Richards According to Internet.com , by the year 2008 nearly 30% of offline purchases will be...
Create Digital Children's Books
---------------------------------------------------------- Permission is granted for the below article to forward, reprint, distribute, use for ezine, newsletter, website, offer as free bonus or part of a product for sale as long as no changes are...
TOP 8 Ways To Make Your Business a Success
Do you remember that day when you decided that you would go into business for yourself? The day that you decided that you want to control your own destiny. The day when you decided that your job is not what you expected in your life and wanted...
|
|
| |
|
|
|
|
|
|
When Quickbooks Doesn’t Balance
After you’ve been using QuickBooks for while and have been balancing your account regularly, you will only irregularly have trouble reconciling it. However, if you are just getting started, you may have trouble getting your QuickBooks bank account to balance. For that reason, let me offer some suggestions for balancing a bank account that’s causing you trouble.
Check for missing transactions
Account balance trouble stems from only three causes:
Reason 1: You cleared a transaction the bank hasn’t recorded
Reason 2: You forgot to record a transaction, or perhaps several transactions
Reason 3: Either you or your bank incorrectly recorded a transaction
Therefore, when you find yourself with reconciliation troubles, first make sure that you are not missing some transaction. Go through the bank statement line for line, comparing each of the transactions listed there with the contents of your account register. If you find the bank statement lists a transaction that your QuickBooks bank account register does not, then you need to record it in QuickBooks.
Confirm you haven’t incorrectly cleared transactions
Once you confirm that the QuickBooks bank account register includes all transactions, verify that you have not incorrectly cleared transactions that are still outstanding. To do this, thoroughly review the QuickBooks account register and make sure that each transaction marked with a “C” does, in fact, appear on the bank statement.
Compare amounts
If the two reviews described in the preceding paragraphs don’t explain the difference between your records and the bank’s, you need to check the actual transaction amounts that you have recorded against those shown in the bank register. In other words, if the bank register shows a check to your mortgage company for $500, you need to make sure that your account register also records the check as $500.
Unfortunately, it is easy to incorrectly record transaction amounts in the QuickBooks account register. All it takes is pressing the wrong key. And, in fact, two data entry errors are particularly difficult to see: transposition errors and sign errors.
Keep a sharp lookout for transposition errors
Transposition errors occur when you transpose, or flip-flop, the numbers in an amount. If you write a check for $123, but record the check as $132, for example, you’ve transposed the 2 and the 3. And this error is hard to spot later. You look at the bank statement, for
example, and see the digits 123. Then when you look at the account register, you see the digits 132. Unless you are looking not just at the digits used but also at their order, you may miss this error.
Don't miss sign errors
Sign errors occur when you enter a deposit as a withdrawal, or a withdrawal as a deposit. All this really means is that you have entered some transaction amount in the wrong column. Again, this error is sometimes tough to spot because the transaction appears both on the bank statement and in your register—just in the wrong column in the QuickBooks bank register.
If you come up with some difference with your records and the bank’s that is irreconcilable, try dividing the error by 2. Then look for a transaction equal to this result. For example, if you have a $200 error, divide $200 by 2 to get the result $100. Then look for a $100 transaction that is entered in the wrong column.
Some problems account reconciliation won’t fix
There are several common errors that account reconciliation won’t catch. Reconciliation won’t catch when you forget to record a transaction and the transaction hasn’t yet cleared the bank. If you forget to record a check and the check is still outstanding at the end of the statement month, for example, the check doesn’t appear in your register and it doesn’t get listed on your bank statement.
Another kind of error that a bank reconciliation won’t catch stems from entering a fictitious transaction in the account register. For example, if you enter a check in the QuickBooks bank account register that you never wrote or a deposit you never made, the check or deposit will never clear the bank.
Unfortunately, there is not much you can do to find these sorts of errors. Mostly, you need to apply simple common sense to prevent them. In the case of forgotten uncleared transactions, your only recourse is to be careful in your record keeping. Try to establish a system whereby you regularly record the checks you write and the deposits you make.
About the Author: Seattle tax CPA & author Stephen L. Nelson wrote Quicken for Dummies and more than 100 other books as well. Nelson holds an MBA in Finance and an MS in taxation. His web site is http://www.stephenlnelson.com
Source: www.isnare.com
|
|
|
|
|
|