We are on Acumatica 2025 R2 in Canada (Ontario, HST 13%).
Our goal: a customer invoice has become uncollectible. We want to write off the full open balance AND reverse the HST that was charged on the original invoice, so the HST can be recovered on our GST/HST return. Under Canadian rules the debt must actually be written off in the books before the HST can be claimed back.
What we have tried:
1. Write Off Balances and Credits (AR505000) with type Credit WO — when we select Credit WO, we cannot select the customer / invoice that carries the debit balance. Balance WO does select it, but it posts the full gross amount (tax included) to the write-off expense account with no tax reversal, so we lose the HST.
2. Credit Memo on Invoices and Memos (AR301000) — we created a credit memo for the customer, entered one detail line for the net amount of the invoice, and set the line account to our bad debt / write-off expense account instead of a revenue account. But the Tax Total on the memo stays 0.00 and no tax appears anywhere, even though the original invoice had HST charged on it. The memo total therefore does not match the invoice balance.
Questions:
- Is the credit memo the correct approach for writing off an invoice balance with the tax reversed? If yes, what are we missing so the tax calculates on the memo — the tax category on the detail line, the tax zone, or a setting somewhere else?
- Once the credit memo is released with tax on it, does that tax flow into the tax report automatically so it can be claimed on the GST/HST return?
- Is there a better or more standard way to do this in 2025 R2?
A step-by-step explanation would be very helpful. Thank you.