When using QuickBooks, a common misconception is an income account that appears too high. In most cases, the total is twice the amount of what it should be. Upon review and a thorough reconciliation, usually at month-end, a trail of duplicate entries is discovered.
New users to QuickBooks will likely be creating unintentional duplicate postings. This involves processing two different transactions to record income on two separate occasions. In so doing, accounts receivables may also be carrying higher balances than forecasted.
The first transaction to increase the income account is in creating a customer invoice. This entry increases the customer balance (accounts receivable) while simultaneously increasing the income account. The duplicate entry arises when payment is received from the customer at a later date.
A common error is the payment will be posted directly into the bank account rather than applied to the customer’s open invoice. Typically, a debit is posted to the bank account and a credit is posted to the income account thereby creating a duplicate entry to income. While doubling up on income, the customer’s invoice is left unpaid.
To post the transaction correctly, the payment needs to be recorded directly into the customer’s ledger. And depending on how many checks will be included on the deposit slip, the user may select one of two choices in the next step of the transaction.
If you have only one check, under the “deposit” pull-down menu in the customer ledger screen, select the bank account to which the deposit will be made. This will complete the transaction. The income account will not be changed, the bank account will be increased, and accounts receivable will be decreased leaving the invoice for the customer marked paid. The transaction is complete.
If multiple checks are being prepared for the deposit slip, select “undeposited funds” from the pull-down menu. This will allow QuickBooks to calculate the final total of the deposit in the following step allowing for a more accurate bank reconciliation.
Lastly when all payments are properly applied to the corresponding customers, under the “banking” pull-down menu from the home screen, select “make deposits.” A list of all the payments entered will appear. Select all payments included on the deposit slip and collectively deposit into the proper bank account. This transaction will transfer all ‘undeposited funds” to the selected bank account and complete the transaction.
Receiving and recording payments by following the steps above leave the income account unchanged and credit the customer balance(s) providing an accurate balance of accounts receivables in the process.
The importance of a thorough month-end reconciliation can never be stressed enough as your small business progresses throughout the year. And attention to the smallest of details will ensure accuracy of your financial statements.