cancel
Showing results for 
Search instead for 
Did you mean: 
Shalea Wolski
Level 1

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

 
6 Comments 6
Teri
Level 9

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

Ya, don't hold your breath on that fix, but would be good if it showed as closest match for you to choose or not, then if you agree, could help you fix that penny right then and maybe it does.  I have not had that issue in so long, can't say I ever had to fix on QB, but maybe others here do.

 

QB cannot decide for you what to do with that penny of your money or 5 cents or any amount. Some people would say 5 cents or 10 cents and I might say $10 is close enough to fix for me. 

 

The correction required could & would be unique in each situation for millions of QB users.

Some people want to fix one way or another which would require deciding accounting entry.

 

QB should not do that in my opinion because I do not want QB guessing where to put money.

 

To eliminate that issue at the source in any accounting system first requires you to know the source of entries and which ones you control or do not.  Easy example is if my payroll rounds to 4 decimals and I round in accounting system to only 2 decimals, we may be a penny different.

 

Since I cannot change how payroll service rounds, I will adjust entry I make in accounting system to match if I know it is just rounding of a penny.

BettyJaneB
QuickBooks Team

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

Good day, @Shalea Wolski.

 

I'm here to help share some information about fixing the penny difference in your QuickBooks Online account when matching payments.

 

The best way to fix a payment differences when matching transactions is to use the Resolve Difference button. This helps match your transactions by resolving its difference until it will be equal zero. 

 

Let me guide you how: 

  1. On the Banking page, select the For Review tab.
  2. Select the transaction to open it.
  3. Select the Find other records or Find match button to open the Match transactions window.
  4. By default, the Match transactions window lists All transactions within the date range, but you can narrow the results.
  5. Use options on the Show drop-down menu to specify the type of transaction you're looking for.
  6. If the transaction you're looking for is outside the default date range, select the From and To date fields to change the dates.
  7. If the amounts are different, you can locate additional matched transactions, or select Resolve Difference to open the Add resolving transactions fields to add the Category and Amount (and, optionally, Payee) of a resolving transaction until the difference equals zero.
  8. If necessary, you can use the Add new transaction button to add multiple resolving transactions.
  9. Select Save.

For more insights about this process, please refer to these articles:

However, if you need further assistance with this concern, feel free to reach out to our Customer Care Team. They have the tools to check on your account securely and verify your transactions and match it accurately.

 

To reach them: 

  1. In your browser, navigate to https://help.quickbooks.intuit.com/en_US/contact
  2. Choose QuickBooks Online.
  3. Select the issue or topic.
  4. Click the Green Phone button to get the support number.

This should help you resolve the tax payment difference on your QuickBooks.

 

Please know that I'm just a reply away should you need anything else. I'll be around to help. 

Annie8854
Level 1

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

Hello, What is the fix for this for QB Desktop Pro 2017? Thanks in advance!

MaryGraceS
Moderator

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

Hello there, @Annie8854.

 

QuickBooks tries to match downloaded transactions to any entries that have the same transaction number, amount, date, or payee from the downloaded transaction. Since there's a penny difference, it won't show the match.

 

To fix this, you can delete the transaction you already created, and add the downloaded instead. This way, it harmonizes the transaction that shows in your bank statement, as well as to avoid duplicates in QuickBooks. 

 

First, delete the transaction you created in QuickBooks. 

  1. Select the transaction you want to delete.
  2. Go to the Edit menu and click Delete (transaction), where it can be any valid QuickBooks transaction.
  3. Click OK to confirm the deletion.

After that, go back to the bank feeds page and add the transaction to the bank register in QuickBooks.

 

Here's how:

  1. From the Banking menu, select Bank Feeds then Bank Feeds Center.
  2. Choose the bank account, then click Transaction List.
  3. On the Transaction List page, put a checkmark on the box column to select the transactions you want to add.
  4. Assign the payee, class, and appropriate account(s).
  5. Go to the Action drop-down and select Quick Add. If you want to work on multiple transactions and add them all at once, select the Batch Action drop-down and click Add/Approve.

I've attached an article you can use to review, categorize, and save bank feeds in QuickBooks Desktop: Manage Downloaded Bank Transactions

 

Drop me a comment below if you have any other questions.  I'll be happy to help you further. Have a great day.

info320
Level 1

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

The match transactions rarely shows me all transactions within the specified date range.
It will only show transactions up to the amount that I am trying to match. This isnt helpful when trying to match ebay/paypal/stripe/amazon transactions where the transaction amount from Sales is higher than the amount that comes into the bank as the fee's are taken at source, resulting in me needing to match a higher amount and using the resolve button to add the fee allocation to balance the transaction, but not actually being able to do this.

I find myself having the add the entire transaction from scratch, then the fee's, all using the resolve button before I can match the transaction. However, this means that the transaction appears twice in my chart of accounts reports.

This is less than ideal and is a problem that I have had for the entire 2 years I have been using quickbooks. I have reported this issue multiple times and havent even got so much as an acknowledgement from quickbooks.

ZackE
Moderator

I want to understand why Quickbooks can't match a transaction that is .01 penny off. When I do manually go and find it and match what are the best practices to resolve?

Thanks for joining this thread, info320.

 

After downloading transactions into your books, there's three possible things that can display in the ACTION column. It will say Match if QuickBooks was able to connect it with one you've already entered. You'll see a View option in the event more than one matching record was found. If it shows Add, a new transaction will have to be created for it since no matches exist.


After matching, you can review your work in the Categorized and Reviewed tabs to confirm everything's entered correctly.

 

When using the date range filter, you'll see all of the relevant transactions for your search. If it's not showing some, I'd recommend checking your browser. It's possible such a problem could have something to do with temporary internet files. Browsing applications store these types of records, but sometimes they can cause display issues on certain webpages. You can open a private window and try using the filter again to see if it works properly.

 

Here's how to access incognito mode in some of the most commonly used browsers:

  • Google Chrome: Ctrl Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Safari: Command Option P
  • Internet Explorer: Ctrl + Shift P

 

If it displays all of the relevant transactions for your search, it's safe to say this problem's being caused by temporary internet files. It can be fixed by clearing cached data and Intuit-specific cookies.
 

In the event it continues not showing all of your results, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up your account in a secure environment, conduct further research, and create an investigation ticket if necessary.
 

They can be reached while you're signed in:

  1. Use the Help (?) icon.
  2. Click Contact Us.
  3. Enter a description of your situation in the What can we help you with? field, then click Let's talk.
  4. Select Start messaging or Get a call.


Be sure to review their support hours so you'll know when agents are available.
 

I'll be here to help if there's any questions. Have a wonderful Tuesday!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us