Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
mwright6
Level 1

Historical transactions that used “Inclusive of Tax” (in my case, GST/PST BC) contain incorrect stored decimal values that cause $0.01 reconciliation discrepancies.

Using QBO Accountant. This just started happening to me. Seemingly random transactions in the reconciliation view have their Net Amount value off by $0.01 where the expenses are categorized Tax Inclusive. When I track them down manually, I can fix it by opening the transaction, tabbing over from the amount field, and re-saving the transaction, which forces QBO to recalculate the correct Net Amount. The only material change in my process is that I recently started using RightTool to batch-clear reconciliation status flags that did not clear after undoing my original reconciliations to redo my reconciliations after some expense classification fixes broke my original reconciliations. When I run a Transaction Detail by Account report for the reconciliation period with transaction amount, tax amount, and net amount, and use a checking formula to check where they add up, they all appear to add up correctly. This suggests that the QBO reconciliation is calculating values on-the-fly instead of pulling already-calculated values in the register. Is anyone else experiencing this issue or be able to suggest what may be happening here? Is this a known behaviour?

1 Comment 1
GlinetteC
Moderator

Historical transactions that used “Inclusive of Tax” (in my case, GST/PST BC) contain incorrect stored decimal values that cause $0.01 reconciliation discrepancies.

Hello there, mwright6.

 

QuickBooks Online (QBO) calculates taxes based on the selected code and applies them according to the transaction's tax setup. I see that you’re using a third-party application for batch-clearing reconciliation status flags, but this doesn't impact reconciliation discrepancies.
 
You may be experiencing an internal rounding difference in QuickBooks. Manually tabbing forces QuickBooks to re-evaluate and refresh the transaction details based on the current tax setup, resolving minor calculation mismatches. Make sure all tax settings are consistent across your client’s account, as these are common sources of minor rounding differences.

 

If the issue persists, I recommend contacting our live support team for further assistance. They can securely access your account and examine any unusual behavior that may be causing the issue.

 

Here's how to contact them during their available time:

 

  1. Click the (?) Help icon to open the Help page.
  2. Head over to the Search tab and type in a keyword related to your question or issue.
  3. Once you've explored the options, click Contact Us to get in touch.
  4. Choose the way that works best for you, either Chat with us or Get a callback.

 

Please don’t hesitate to share any other questions in the comments, and we’re here to help.

Need to get in touch?

Contact us