cancel
Showing results for 
Search instead for 
Did you mean: 
Kathy GreenBudBooks
Level 3

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.

 
Solved
Best answer August 29, 2020

Best Answers
SarahannC
Moderator

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.

Thanks for getting back to us, Kathy GreenBudBooks.

 

Let me provide additional information in regards to your concern.

 

I can see that you're putting a lot of effort and time to figure out the main reason why there are six transactions not generating in the Chart of Accounts (COA). One more thing, it's important to set the correct dates to ensure we'll be able to view all the transactions in the report or account.

 

If we haven't tried it yet, please consider following these steps:

 

  1. Go to Accounting on the left panel.
  2. Within the Chart of Accounts tab, search for Taxes & Licenses.
  3. Hit Run report under the Action column.
  4. In the Report period, make sure to set your desired dates. Afterward, customize it as you want by clicking the Customize button at the upper-right corner.

 

If the same thing happens, I would recommend contacting our phone support to investigate the issue further. They'll help us figure out why it's happening on your end. Here's how to get in touch with them:

  1. Log in to your QBO account and go directly to the Help icon.
  2. Click the Contact us button and enter a short description of your concern. Something like "Missing transactions in the COA".
  3. Hit the Let's talk.
  4. Select Get a callback. Afterward, someone will call you a few moments from the time you've submitted your information. To make sure one of our specialists will reach you out, let's check their work schedule by going to the QuickBooks Online section.

 

Please visit again if you still need help with this. I hope you're good. Take care and stay safe.

View solution in original post

8 Comments 8
Jovychris_A
Moderator

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!

Kathy GreenBudBooks
Level 3

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

LieraMarie_A
QuickBooks Team

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.

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.

Kathy GreenBudBooks
Level 3

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.

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?

Rejeil_O
QuickBooks Team

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.

 

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. 

Kathy GreenBudBooks
Level 3

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.

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.

SarahannC
Moderator

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.

Thanks for getting back to us, Kathy GreenBudBooks.

 

Let me provide additional information in regards to your concern.

 

I can see that you're putting a lot of effort and time to figure out the main reason why there are six transactions not generating in the Chart of Accounts (COA). One more thing, it's important to set the correct dates to ensure we'll be able to view all the transactions in the report or account.

 

If we haven't tried it yet, please consider following these steps:

 

  1. Go to Accounting on the left panel.
  2. Within the Chart of Accounts tab, search for Taxes & Licenses.
  3. Hit Run report under the Action column.
  4. In the Report period, make sure to set your desired dates. Afterward, customize it as you want by clicking the Customize button at the upper-right corner.

 

If the same thing happens, I would recommend contacting our phone support to investigate the issue further. They'll help us figure out why it's happening on your end. Here's how to get in touch with them:

  1. Log in to your QBO account and go directly to the Help icon.
  2. Click the Contact us button and enter a short description of your concern. Something like "Missing transactions in the COA".
  3. Hit the Let's talk.
  4. Select Get a callback. Afterward, someone will call you a few moments from the time you've submitted your information. To make sure one of our specialists will reach you out, let's check their work schedule by going to the QuickBooks Online section.

 

Please visit again if you still need help with this. I hope you're good. Take care and stay safe.

Kathy GreenBudBooks
Level 3

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.

THANK YOU!!!!!

 

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

Need to get in touch?

Contact us