Rounding / Migration issue

Hey there, @pezza.

You have the option to use the Resolve Difference feature to fix discrepancies when matching transactions. It opens the Add resolving transactions field where you can use to adjust the amounts.

Let me walk you through the steps:

1. On the Banking page, select the For Review tab.
2. Select the transaction to open it.
3. Select the Find match button to open the Match transactions window.
4. Use options from the Show drop-down menu to specify the type of transaction you're looking for.
5. If the amounts are different, you can locate additional matched transactions. As another option, select Resolve Difference to open the Add resolving transactions field. Then, add the Category and Amount of a resolving transaction until the difference is zero.
6. You can click the Add new transaction button to add multiple resolving transactions.
7. Select Save.

For additional reference, you can check this article: Add and match downloaded banking transactions.

Please let me know if you need further assistance. I'll be around to help. Have a good one.

Hi @LieraMarie_A 

Thanks for the reply.

These have already been reconciled.  They are mainly expenses that had been submitted using Expensify, but as mentioned, in the old QB system, the payments made matched the expense total bill and were zero.

Now that they have been imported in to QBAO, a couple of them are now showing as the odd pence outstanding on the bill, but they did match before.

Is there some different rounding setting in QBAO compared to QBO?

I no longer see any way to do what you suggest.  I could unmatch all the items so that it forces me to review and match again, but something seems wrong in that it had ended up with these odd amounts.

Thanks

Andrew

I appreciate the additional details you've shared, @pezza.

I am here to share some information on how you can resolve the incorrect customer balance in your QuickBooks Online account.

Just to clarify, are you getting this incorrect balance after converting your QuickBooks Desktop company file to QuickBooks Online? If so, these usually happen when you used journal entry in applying payments to your invoices.

There are two ways to fix these.

• Turned on the automatic credits in QuickBooks.
• Matching the journal credits to existing invoices.

You can refer to this article for more detailed instructions: Fix errors when converting from QuickBooks Desktop to QuickBooks Online (Issues after conversion).

Keep me posted if you have other questions about managing your transactions. I'm always here to help.

Hi @IamjuViel 

Thanks for your reply.

This was exporting data from QuickBooks Online and importing it in to QuickBooks Accountant Online.

I have just checked one as an example and the Expense/Bill total excluding VAT matches but the VAT amount is 1p more in QBAO than it is in QBO.  I have checked the data in the csv file and the csv doesn't have the VAT amount, it just has the line total excluding VAT and the VAT rate, so the QBAO is calculating the VAT amount when it is being imported.

Original VAT: £13.09

New VAT: £13.10

The actual true value should be £13.13! But IF in excel, I tell each line item to round down (which I believe is what QB does) then I get to £13.09, as per the original QBO amount.  So it seems to be pointing to something not quite right in QBAO.

IF I just round (true rounding where it rounds up if over 5) does come to £13.10.  So it would seem that QBO rounds down regardless whereas QBAO rounds normal (down when less than 5 and up when 5 or more).

That explains why the discrepancy but doesn't really help when I now have 4 Bills dating back 2 years now suddenly with balances owing of between 1p and 4p.

And the main frustrating part is that QB tells me I cannot change this now for something that has been submitted, yet the VAT amounts submitted was actually for the amount that I am trying to change it to, so there would be no difference anyway.

I think there should be a way to overrule QB especially when I know it has no affect whatsoever on the submitted VAT return.

Andrew

Thanks @RCV 

Yeah, support was able to give me some tips on how to "tweak" some VAT settings temporarily to allow me to update the VAT figures on the bills.

There wasn't a need to adjust any VAT returns as they were correct.  They were all paid 2 years ago, and the discrepancy was only caused by the fact that QBAO rounded differently leaving the balances.  Whether QBO was correct in rounding down, or whether QBAO is correct in rounding up at .5 I am going to leave for another debate ;) but the bills are now back to matching what they were in QBO, and therefore my balances have gone and no difference to VAT.

Thank you.  And thanks to Francis on support for his help to resolve.

Andrew