Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there,
Our company has been in business for a few years now, but implemented QB starting January 1st of this year. We have a truck loan that originates October 02, 2020 and payments continue into this year. So I created a Loan Account in QB with the date and amount of deposit and the dates and payment amounts of the two payments made in 2020. Loan amount is 13,505.00, payments total 631.12 for 2020.
We chose not to back track any farther than this year for all other expenses as taxes have already been filed and it is unnecessary, but this loan continues to 2021 so needs to be tracked. Each month reconciliation for this year has balanced fine. My bank account balance in QB is showing 12,873.88 higher than the true balance. (This is the 13505.00 minus the 631.12 paid in 2020).
My question is, how do I right this in QB?
Any help will be greatly appreciated!
I’m here to help ensure account balance will be accurate in QuickBooks, @kenglund.
An incorrect opening balance is one of the common reasons why QuickBooks balance is higher than the actual one. Also, there may be other expenses that you still need to record in the program.
You can use your bank statement to review your transactions in the register as well as the balances. An account register gives you the history of an account. It lists all past and current transactions associated with it.
Here’s how:
If you need to make quick edits, you can do them right from an account register. Just select Record, then enter the necessary details.
I’ve attached resources to track your loans efficiently and about resolving balances in QuickBooks:
Let me know if you have other account concerns. I’m always here to help. Have a good one!
Hi! Thank you for the response, and apologies for my delay in replying. My opening balance is correct, I had input what the opening balance was on January 1st, 2021. The loan for the truck does not count towards the opening balance of the checking account. So I am still at a loss as to why the proceeds for the loan are causing my balance in quickbooks to be so much higher than what it is.
Thank you for your reply, kenglund1.
I want to share some information about your concern.
When the QuickBooks Balance is higher than what is in the actual bank balance, it's possible that a payment for the loan was not recorded or was deleted.
Let's check your checking account if there are missing payments.
If no payment was recorded to reduce the loan deposit, you'll want to run the Audit Trail or Transaction Detail report. This report is used to see if there are any transactions changed.
To run a Transaction Detail report, here's how:
Search for any discrepancies or transactions that don't match what's on your bank statement. If someone edited of deleted the transaction, I suggest reaching out to the person who made the change. There might be a reason why they made the change. Once you know, you can edit or re-create the transaction as needed.
For reference in recording the loan, you can read this article: Manually track loans in QuickBooks Desktop.
Please feel free to leave a comment letting me know how things go after giving this a try. I'll keep an eye out for your reply. Stay safe.
I do not see an answer to this question. Were you ever able to solve this issue? I have been struggling with the same issue and can not seem to get help with it. If you were able to resolve this, could you please share the information? I'm almost out of hair lol
Ensuring that your bank balance in QuickBooks matches your actual balance is important for a smooth reconciliation process, AffordableB. I'm here to make sure you get connected to the right support to help you with your account balance and loan concerns.
Based on the scenario, we recommend reaching out to an accountant for further guidance. They can provide advice on effectively tracking loans and payments in QuickBooks Desktop (QBDT), especially for previous years' entries. Furthermore, they can review your banking data to identify any discrepancies and offer solutions to address the issue.
In case you're using the current QBDT version and want to be reminded of upcoming payments, use the QuickBooks Loan Manager to manage the transactions. Alternatively, you can manually track loans in the program.
Additionally, utilize the solutions in these resources to reconcile your account and handle any discrepancies:
Fill me in if you have additional questions about loan management and balancing your account. The Community is always ready to lend a helping hand.
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