Skip to main content
T
travelqueen
February 17, 2021
Solved

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

  • February 17, 2021
  • 1 reply
  • 0 views

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!

Best answer by BettyJaneB

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:

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

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

 

Here's how:

  1. Open your QuickBooks Online account, then go to the Banking tab at the left pane.
  2. Select Banking, then look for your account.
  3. Click on the Categorized column.
  4. 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!

1 reply

BettyJaneB
BettyJaneBAnswer
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:

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

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

 

Here's how:

  1. Open your QuickBooks Online account, then go to the Banking tab at the left pane.
  2. Select Banking, then look for your account.
  3. Click on the Categorized column.
  4. 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!

    T
    travelqueenAuthor
    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.

    T
    travelqueenAuthor
    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!!!

    Terms & ConditionsAccessibility statement