How to reconcile a credit card account
Note To reconcile your Credit Card Account, you must have set up a credit card liability account, and you must have entered your credit card transactions through the Credit Card option.
Credit Card Reconciliation Process
To begin your Credit Card Reconciliation, go to Process → Reconciliations → Credit Card Reconciliation and either pull up an existing reconciliation or create a new reconciliation.
When creating a new statement, you must choose the credit card account, enter the statement date, and enter the statement balance.
You cannot change the Statement Date, or the Ending Balance once you click submit. Later if you determine that the statement date or balance are incorrect, the only option is to Delete the reconciliation and start over (if you do not see Delete, you do not have the necessary permissions set up in the system and must talk to your system administrator. The Support Team may not change permissions).
In the reconciliation screen, you will not see the Reconcile button until the difference is zero.
If your Credit Card Reconciliation will not balance
- Make sure the Statement Date is correct. The Statement Date determines which transactions display on the Credit Card Reconciliation and if it is not correct, some pertinent transactions may not display.
- Ensure you have entered all credit card transactions including credits, refunds, and service charges.
- Ensure you have entered the correct Statement Balance.
- Check your transactions to ensure they do not debit and credit the liability account. A credit card transaction should credit the liability account and debit an expense account.
- If you are on an accrual basis, when you enter the bill to pay the credit card company, the bill date must be after the statement date. To correct any bills and checks that had an incorrect date:
- Void each check, making a copy of the bill. Edit the date of the bill so that it is dated after the statement date. If you have delete privileges, simply delete the check, and edit the bill date.
- Pull up the new bill you just created through the voiding or deleting process and click assign check number.
- Enter a check number for that bill, adding a letter to the end of it (because you cannot re-use a number you have voided, if you’ve deleted the original check, you can re-use the check number).
- Return to the credit card reconciliation process to verify you’ve made the correct changes.