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?