Need some assistance on how will I resolve the issue above issue. The company I am working with has a multiple bank account. I was reconciling bank transactions and I came across one cash deposit that was applied to incorrect bank account. I did my research and tried the ff. suggestion:
Chart of Accounts >> Select the account where the funds was incorrectly applied >> Edit >> and select the desired account where the funds was supposed to be applied.
However, this doesn't seem to work for me. I'm getting an error message that says:
"This transaction is matched to a downloaded transaction. If you want to change the account, you need to unmatch the transaction first."
I am not sure if its because initially the deposit hasn't been reconciled and is still sitting on the bank register? Need some help. Hope this makes sense.
I already unmatched the transaction and followed the steps however, after undoing the matched transaction, the deposit is still sitting on the For Review section. So i am unable to change the posting account.
One thing I noticed is when I add the transaction to remove it from the "For Review" section, it automatically adds another deposit entry to match the transaction. I am not sure if that's how QB's behave.
I have attached a screenshot of what i'm trying to work on.
I appreciate your quick reply, @girlie16. Let me chime in and help you so we can get this matter resolved together.
I couldn't find your attached screenshots. Anyhow, the experience you've shared after following my colleague @BettyJaneB advise are clear. And yes, that's ideally how QuickBooks behave.
As an overview, when you unmatched the transactions in the bank feeds, it will also unlink the cash deposit in the bank register. Hence, you can also exclude the cash deposit downloaded in the bank feeds instead. Then, let's manually edit that cash deposit and change the bank account in the chart of accounts. Here's how:
While you're still in the For Review tab, mark the checkboxes of the transactions to exclude.
From the Batch actions drop-down, choose Exclude Selected.
Excluded transactions are moved to the Excluded tab. It won't be tracked nor reported as part of your business finances anymore and will not appear in any associated account registers or reports.
Now, to move the incorrect funds to the correct bank account, let's manually edit the bank deposit and change the posting account. Here's how:
Go to the Accounting tab in the left menu.
Choose Chart of Accounts.
Find the account where you deposited the funds incorrectly.
Click the View register in the Action column.
Select the transaction you want to edit to open the fields.
In the Deposit to drop-down list, change the posting account.