How to fix transaction discrepancy? Expense/Vendor - 8 transactions listed in Category A. All have same Category. COA Expense/Category A, only 2 transactions show up.

Hi there, @Kathy GreenBudBooks.

Let me share some insights on how you can fix the discrepancy between recorded expenses and what transactions registered in your COA.

You can run the Expenses by Vendor Summary report to see the transactions that affect the expenses. This way, you can trace them by clicking the amount and see if this has been categorized into a different account.

Here's how:

1. Go to Reports and then type Expense by Vendor Summary.
2. Select the Expense Summary report.
3. Click the amount and review the transactions.

Once you've seen that the transactions place to a different account, you can follow these steps below:

1. In your Chart of Accounts, find the account and then click on View register.
2. Click the expense transaction.
3. On the PAYEE ACCOUNT column, change the expense account.
4. Hit Save. 

This way, you're able to resolve the discrepancy.

For additional information, you can check this article: Track your cash flow in QuickBooks Online.

Also, you can visit our Help Articles page for QuickBooks Online if in case you need to learn some "How do I" steps.

Feel free to place a comment if you have more questions. I'm always here to help. Take care!

Hi Jovychris.

Thanks for your response.  Unfortunately what you said to do is what I'd already done.  That's how I found the discrepancies.  Problem is that the 2 transactions that are showing up in the Tax Expense are categorized to the same category as the 6 transactions that aren't showing up in the Tax Expense.  That's why I'm struggling to figure this out.

Thanks for getting back to us, @Kathy GreenBudBooks.
 

I'd love to help you but I just need some more details about your concern.
 

Can you share with us where you can see the 6 transactions that aren't showing up in the tax expense? Have you added them from the bank feeds, or did you enter them manually?
 

Any additional information is greatly appreciated. I'm looking forward to your reply.

I replied previously but I'm not seeing it here so maybe it didn't go through.

In the Pammies Sammies LLC file, Expenses, Vendor, Fl Dept Rev, there are 8 transactions listed.  All with the same categorization:  Taxes & Licenses and each is a payment that was sent from PS LLC to FL Dept Rev.

However, when I go to Accounting, COA, Taxes & Licenses there are only 2 transactions for Fl Dept Rev.  Where did the other 6 go?  Why don't these 2 accounts have the same information?

Hi there, @Kathy GreenBudBooks.

You can check the Expense by Vendor Summary report if there's a Cash or Accrual accounting method on it. If yes, please toggle the accounting method to make the transactions show on the statement. 

Once done, you can perform basic troubleshooting on your browser to check if it's a browser issue or not. Please open your QuickBooks Online account through incognito/private browser. To open a private browser, here's how:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Safari: Command + Shift + N
• Microsoft Edge: Ctrl + Shift + P

After that, you can check the missing transactions on your categories. If it works, you can clear the cache on your browser to delete some outdated files on your browser that might cause a small problem when using your QuickBooks Online account. You can refer to this article for clearing the cache: Clear cache and cookies to fix issues when using QuickBooks Online.

You might want to use this article to learn more about the Chart of Accounts: Understand the chart of accounts in QuickBooks.

Please know that I'm always around here in the Community to help. Keep safe, and have a good day. 

Rejeil_O thanks for your support.  Unfortunately, although I tried all that you suggested, I've still got the same problem.  I hope someone can help me figure this out.

THANK YOU!!!!!

Basic issue got overlooked....the dates weren't the same.  Once the dates were corrected, 8 transactions in each account.