Edit order After partial refund to show correct VAT amounts

Hi @sunderlandstationmodels,

Thank you for your message; it is an interesting one! I tried and tested editing an order and changing its shipping and billing addresses to another tax zone, and I was able to use the “Recalculate” button to get the proper values.

I had to put the order on hold first, though. Please try changing the order status to on hold, then changing the shipping and billing address, and using the recalculate button! ??

I hope this helps!
-OP

Hi, thanks, i think that helps, but i have also the issue where after that, all the amounts are correct, except for the Net payment amount, which shows as ￡3.51, is there a way to correct this to the right figure?

Basically and as well want the correct figures to be reported in my revenue reports so i don’t have to make any manual changes/edits

These are now showing as correct:

Items Subtotal: <bdi>￡6.79</bdi>

Shipping: <bdi>￡3.75</bdi>

Standard Rate: <bdi>￡2.11</bdi>

Order Total: <bdi>￡12.65</bdi>

Refunded:-<bdi>￡9.14</bdi>

This should not be this amount : Net Payment: <bdi>￡3.51 </bdi>

At least i don’t think it should be, will the VAT rate and other totals shown above be reflected in a revenue report, or will the original amount be reflected there? As i don’t want the revenue report to reflect only ￡3.51 from this sale when it actually was ￡12.65 if you follow me?

Thanks

Hey @sunderlandstationmodels,

The Net Payment value is calculated as the Order Total minus any Refunds. In this case, it is ￡12.65 (Order Total) minus ￡9.14 (Refunds) which equals ￡3.51. This is why your Net Payment is showing as ￡3.51.

As for your revenue report, it should reflect the final amount of ￡12.65, as this is the actual amount the customer paid for the item, excluding the refund. The original amount before the refund will not be reflected in the revenue report.

If you notice any discrepancies in your revenue report, I suggest you manually adjust it for this particular transaction. I understand this is not the ideal solution, but due to the unique circumstances of this order, it might be the best approach to ensure your accounting and VAT returns are accurate.

I hope this clarifies your concerns. If you have any more questions, feel free to ask.

Thanks, that seems to have sorted it, will still need to check the revenue report to be sure but it looks ok on the app so, thanks for your assistance ??

Hi @sunderlandstationmodels,

Glad to hear it.

Please do take your time to confirm the resolution by checking the revenue report. If you come across any discrepancies or if you need further assistance, don’t hesitate to get back to us.

We’re here to help!