I really need someone who can help me with my dilemma because I've been stuck with this for how many weeks now. So here it goes..
I'm almost done reconciling this particular month. However, there's only one transaction left that I'm confused about. It's a deposit transaction with 'split' on the account column amounting to 5,100.00. But it appears in the bank statement as 2,550.00. When I click 'edit', it directs me to the bank deposit window and it showed me the 2.550.00 transaction which is the same with the bank statement.
How can I reconcile them? This is the only transaction left for this certain month and I cannot move on to the next. I've been reading articles and tutorials but I'm still confused. Please help. :(
Thank you so much for your kind assistance.
Hello @blueberry123! Thank you for reaching out to the Community for help on this issue. We are always more than happy to help:)
We always say that the bank statement is the source of truth, so if the amount is recorded incorrectly or showing the wrong amount within Quickbooks, we can definitely make it right again. I do wonder, because it is split, if the same bank account was used on the other split amount? Using two asset accounts on a transaction such as this can sometimes cause things to look unusual. Feel free to provide a screenshot of that transaction and I am more than happy to take a look.
Another option would be to simply delete that split transaction and then re-enter that Bank Deposit fresh and with the right amount recorded. I will happily walk you through how to accomplish this.
After that has been deleted we will want to re-enter that bank deposit.
Please feel free to reach back out with any updates on this fix. Would love to hear you are now officially reconciled and can move on to another month. Have a great rest of your day !
Hi there, blueberry123.
Thanks for dropping by the Community this evening, based off of your screenshot provided (which was very helpful) I believe you may have included an additional transaction or transactions that made that deposit $5100. I suggest checking the Chart of Accounts to see if you may have accidentally added the deposit. To do so, follow these steps:
1. Go to Accounting and select Chart of Accounts.
2. Choose the bank name where the deposit is located and click View register.
3. Select the deposit and click Edit.
4. On the Bank Deposit screen, scroll down to Add funds to this deposit.
5. Change the Account to Accounts Receivable (A/R).
6. Click Save and close.
If you have any other questions, feel free to reply again down below, We'll respond as soon as possible. Thank you for your time and have a nice evening.
I can't edit it though. I don't think I can also delete it and make a new one. Please see screenshot I attached.
Please help me with this. I really need to reconcile this asap. :(
Thank you so much.
Hello there, @blueberry123.
I understand the importance to get your account reconciled in QuickBooks and appreciate you for following the steps shared by my colleagues to get this sorted out.
Let's do some browser troubleshooting steps to get rid of any cache-related issues. Piled-up cache files can sometimes cause display issues in QuickBooks Online.
To start, let's log in to your account via a private browser and perform the steps shared by my colleague Nick_M to edit the deposit.
To open a private or incognito window, you can follow these keyboard shortcuts:
Also, if you can void the payments, I'd suggest voiding it to. This way, you can recreate the transaction properly in QuickBooks.
Upon sharing this suggestion, I still recommend consulting with an accountant first before making any changes to your account. They might have specific instructions on how to handle these transactions to ensure your book is accurate.
Let me share these articles for more details about reconciliation:
Please don't hesitate to reach back out to me if there's anything else you need. I want to ensure that everything has been taking care of. I'm always here to help. Have a good one!
Good morning, @blueberry123 ! A big thank you to @Nick_M and @Joesem M for jumping in to help. So glad we were able to come together and get to a solution for you. If one of the answers above helped, feel free to mark it as the solution so others can get the help if they are experiencing a similar issue. Have a wonderful week everyone:)