Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
SamanthaSB
May 4, 2021
Question

Matching transactions

  • May 4, 2021
  • 1 reply
  • 88 views

Hello, 

 

I am having a difficult time matching transactions from the bank feed. The transactions either don't show up at all, or the dates that they cleared are incorrect. I have been manually categorizing transactions instead of matching them and I noticed many invoices still say unpaid. 

 

I am assuming this is occurring because I did not match them so technically they still stand unpaid. This has happened for about 3 months, which I have reconciled already, and I just want to clean this mess up before it gets worse. 

 

I am not sure how to approach this issue. I tried undoing the transactions I categorized and then matching them, but I find the same exact issue, the dates are way off, it will reflect several incorrect vendors, or it won't show at all. 

 

Thank you in advance for the help! 

 

Samantha Breeden

    1 reply

    A
    AileneAModerator
    Moderator
    May 4, 2021

    Hello, SamanthaSB. 

     

    When you use the bank feed in QuickBooks Online, you'll be able to add or match your transactions to ensure QuickBooks Online matches what's in your real-life bank account.  

     

    1. Go to the Banking menu, and then hit the Banking tab.
    2. If QuickBooks has found a possible match for the bank transaction, QuickBooks displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
    3. Tick the boxes next to the transaction and then Accept.
    4. For multiple invoices, click the deposit transaction and then tap the Find match radio-button. This will open the Match transactions page where you can choose the transactions to match.
    5. For duplicate records, mark the box next to the transaction and then choose Exclude. 

     

    For details about matching downloaded transactions, check out these guides:

     

     

    Additionally, you can set up a bank rule to automatically categorize your transactions. Please refer to this article for the steps: Set up bank rules to categorize online banking transactions in QuickBooks Online. 

     

    Feel welcome to message me anytime if you still have questions or concerns. I'm always here to help. Take care and have a lovely day ahead.

    S
    SamanthaSBAuthor
    May 4, 2021

    Thank you so much for your feedback @AileneA 

     

    The problem I am facing is when I match transactions it automatically sets the category to Undeposited funds. Is there a way to update the category after matching transactions from the bank feed? 

    AlcaeusF
    AlcaeusF
    Level 14
    May 5, 2021

    Thank you so much for your help.

     

    I attempted to follow those steps and when I am viewing the bank register to update the category this message shows. Once I press the edit button there is no way to update the category. I'm confused on how to move forward.


    Thanks for getting back to us, @SamanthaSB.

     

    To check this is a browser-related (cache and cookies) issue, try signing into your QuickBooks Online (QBO) using a private browser (incognito). There are times that the browser is already full of frequently accessed page resources, causing some unusual responses.

     

    Here's how:

     

    • Press Ctrl + Shift + N (Google Chrome).
    • Ctrl + Shift + P (Firefox).
    • Control + Option + P (Safari).

     

    Once logged in, try to update the category of transactions again by following the steps shared by my colleague above.

     

    If it's successful, return to your default browser and perform a clear cache to refresh the system. However, if the issue persists, try using other supported browsers.

     

    To learn more about reviewing downloaded bank and credit card transactions in QBO, visit this article: Categorize and match online bank transactions in QuickBooks Online.

     

    Please leave a comment below if you have any additional concerns. I want to make sure everything is taken care of for you. I'll be here to help. Have a wonderful day!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement