QBO - Bank Registry Missing Transactions showing on Banking "Categorized" tab

travelqueen · ‎February 17, 2021

I'm using Quickbooks Online. I've confirmed all credit card transactions have downloaded from the AmEx CC sync. After categorizing all my transactions, my card balance and QB balance doesn't match.

When I export the bank registry transactions and compare with the categorized banking transactions, I notice 3 CC payments are missing in the bank registry, yet are showing on in the categorized banking tab.

What should I do to resolve this? Why would categorized transactions be missing from the bank registry?

Thanks in Advance!

BettyJaneB · ‎February 17, 2021

Welcome back to the Community, @travelqueen.

I've got the help that you need in finding the three missing bank entries on your register.

Let's make sure that you pull up the right date of your transactions. This can be the reason they're not showing up in the register.

To do that:

Go to the Accounting menu at the left pane.
Refer to the Chart of Accounts.
Locate the bank, then click the View register at the right under the Action column.
Click the Funnel icon above the Date column.
Select the transactions' Status and its Type. Then, enter the date afterward.
Hit on Apply.

If the problem continues, I recommend undoing the categorized transaction from the banking page and add them again.

Here's how:

Open your QuickBooks Online account, then go to the Banking tab at the left pane.
Select Banking, then look for your account.
Click on the Categorized column.
Choose the item/transaction, then tap on Undo under Action.

I've added this screenshot for your visual reference.

To guide you in categorizing your bank transactions and on what to do if entries are missing, you can always scan through these resources below:

Please let me know how it goes by leaving a comment below. If you need anything else, don’t hesitate to ask. I’ll be here to help. Have a most pleasant day!

View solution in original post

BettyJaneB · ‎February 17, 2021

Welcome back to the Community, @travelqueen.

I've got the help that you need in finding the three missing bank entries on your register.

Let's make sure that you pull up the right date of your transactions. This can be the reason they're not showing up in the register.

To do that:

Go to the Accounting menu at the left pane.
Refer to the Chart of Accounts.
Locate the bank, then click the View register at the right under the Action column.
Click the Funnel icon above the Date column.
Select the transactions' Status and its Type. Then, enter the date afterward.
Hit on Apply.

If the problem continues, I recommend undoing the categorized transaction from the banking page and add them again.

Here's how:

Open your QuickBooks Online account, then go to the Banking tab at the left pane.
Select Banking, then look for your account.
Click on the Categorized column.
Choose the item/transaction, then tap on Undo under Action.

I've added this screenshot for your visual reference.

To guide you in categorizing your bank transactions and on what to do if entries are missing, you can always scan through these resources below:

Please let me know how it goes by leaving a comment below. If you need anything else, don’t hesitate to ask. I’ll be here to help. Have a most pleasant day!

travelqueen · ‎February 17, 2021

Hi @BettyJaneB ,

Thanks for taking the time to respond to me. I did "Undo" the transactions and recategorized them, and that seems to have worked.

I tracked why my account won't balance and its because a credit card refund credit keeps adding a debt line. When I attempt to delete the debt entry from the registry it removes the accurate credit entry.

I've tried this with downloaded transaction. I even excluded those transactions and created a new credit card credit entry and the duplicate entries occur in the registry still.

Is this a known issue? I don't know what else to try.

travelqueen · ‎February 17, 2021

Hey @BettyJaneB,

User error! I figured it out. I was refunding the CC itself and not the category of the charge.

All resolved. Thanks so much for your assistance!!!

DanishAltaf · ‎July 13, 2022

Hi there, My transactions do show up in the Bank register and also when I check them through Chart of accounts. But When I check in "Categorised" those transactions don't appear there!! Would you please be able to help me out !! I have to match my bank's closing balance with my original pdf bank statement.

Many Thanks!!

greenphoto · ‎March 15, 2024

Thank you so much for letting us know about this!! I thought I'd need to import the transaction again or something time consuming! Hitting the Undo, finding it in For Review and hitting Add did the trick!!! Thank you, thank you!!

SheandL · ‎March 15, 2024

Hi there, @greenphoto.

It's great to hear that my colleague's answer has resolved your concern about viewing the missing transactions on your banking For Review tab.

Don't hesitate to post any concerns or issues you encounter in QuickBooks Online here in the Community. We will ensure to help you resolve all of it. Have a great one!

Topics

Training

Community

Resources

QBO - Bank Registry Missing Transactions showing on Banking "Categorized" tab