Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I recently realized that I have been doing the reconciliation of our corporate bank card for many years, I have been reconciling the main card, instead of individual cards. I need to know how to fix this mistake, I tried journal entry, but didn't balance everything out. There are 5 cards under one account. Do I reconcile each one, not sure where to start, I know the main heading has been getting reconciliation each month. Next question from here forward, which card do I put the interest charge to, Main heading, or pick an individual card?
Hello, @friendshipinc. I'm happy to provide insight into reconciling multiple accounts in QuickBooks.
You can set up the individual cards as sub-accounts of your main card. This way, your books will be organized and when reconciling, you would reconcile the parent account, so this would reconcile all the sub-accounts at once.
Here's how:
I'd suggest consulting your accountant on which card you put the interest charge. They can provide further guidance on how to properly reconcile the multiple credit cards to ensure your books will be accurate.
Also, before connecting to online banking, you need to figure out how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent one.
I've included a few articles you may find beneficial that cover reconciles, sub-accounts, and credit card accounts in QuickBooks Desktop below.
You can always get back to us if you have any other questions, I'd be happy to answer any questions you may have. Have a great day!
Thank you for your response, however that is not the issue, accounts where setup separately, however for all these years, reconciliation were done on the main account, not each individual account, trying to correct this.
We have a high balance on a couple of the accounts, however the top-level account has the correct balance.
setup like so.
Corporate_ 2000.00 balance is correct
carda thru cardd are credit that has accumulated over the years because of improper reconciliation. How can I fix it?
We are a small non-profit organization that only use an accountant for taxes.
Thanks for making it here, friendshipinc.
I can provide guidance on how to correct the balances of your individual accounts.
A discrepancy in balance can be caused by an edited or deleted transaction. You can review your Reconciliation Discrepancy report to check if this is the case. I also suggest reaching out to your accountant to guide you with the correct accounts for debit and credit. You can also find an account by clicking on this link: Find an accountant.
Here's how to run the Reconciliation Discrepancy report:
If there are transactions that cause the discrepancy between your balances, edit them with the correct details (or recreate deleted ones). Before doing this, back up your company file.
Once done, undo the previous reconciliation:
You may find these articles helpful in case your accounts in QuickBooks Desktop don't match your bank statements at the end of reconciliation:
Feel free to visit this guide when reconciling your account: Reconcile an account in QuickBooks Desktop.
For more questions, while reconciling, just drop me a reply below. I'm always here to help. Have a good day ahead.
Credit card accounts that have both parent and subaccounts should have both the parent and the subaccounts reconciled. Setting the accounts up to mimic the bank's process of transferring the subaccount balances to the parent account can help increase efficiency and ease of reconciliations.
Before you connect the bank feed, be sure the chart of accounts is set up correctly to reflect the credit card parent and subaccounts. You’ll want to have each individual card as a subaccount of the Parent Account:
After you’ve confirmed the chart of accounts is set up correctly, you’ll need to connect the bank feed for each credit card subaccount to its respective bank account. Do not connect the bank feed for the main parent account to the bank account since doing so will result in duplicate entries.
The transactions will post to the bank feed for each subaccount. When the statement period comes to an end, the remaining open balances for each individual subaccount is then transferred to the main parent account, creating a consolidated account statement.
To Reconcile:
To post the transfer from the subaccount to the main (parent) account:
To reconcile the main (parent) account
Once you’ve reconciled all the subaccount balances to $0, it’s time to reconcile the parent account.
Hi Jen,
Thank you for a explanation that makes sense, I have been searching for a long time.
But if the main account is not linked to the bank then how do the balance come in?
Ralf
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here