Skip to main content
Question

Write off an AR invoice and reverse the HST — Credit WO won't take the invoice, and a credit memo shows no tax (Canada, 2025 R2)

  • Nov 18, 2026 2:36 PM UTC
  • 1 reply
  • 5 views
  • Translate All

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.

1 reply

Steve Milner
Varsity III
Forum|alt.badge.img+7

My replies are created in part with the help of proprietary AI, built with my AI skills, curated and maintained myself. Most replies are tested on local instances before they go up, and all are reviewed before posted.

@smanoj Yes, the credit memo works. So does the Balance WO, as long as you add a tax adjustment next to it.

On the credit memo, the Tax Category on an AR line comes from the Inventory ID. A line with no item can only get one from the Default Tax Category on the memo’s tax zone. If the zone has none, the line stays blank and no tax calculates. The line account has nothing to do with it. Set the Tax Category on the line to the one on the invoice lines and check that the memo’s Tax Zone matches the invoice’s. Then apply the memo to the invoice on the Applications tab and release it. Once it’s released, its tax goes into the tax report as a negative on its own.

On Write Off Balances and Credits (AR505000), Credit WO only lists payments, credit memos and prepayments, because it clears credit balances. Balance WO is the type for invoices. It posts the whole open balance, HST included, to the reason code’s account. To take the HST back out:

  1. Run the Balance WO the way you already did.
  2. On Tax Adjustments (TX301000), add an Adjust Output for your HST agency and tax period. On Details, add the HST tax ID with the pre-tax part of the written-off balance as a negative Taxable Amount. Enter the negative tax total in the Amount box. On the Financial tab, set the Adjustment Account to the account the write-off hit. Remove Hold, then Release.

The adjustment credits that account and debits HST payable for the tax, so the write-off nets down to the pre-tax amount. It flows into the tax report, and a report that’s already prepared updates on its own.

Try either path in a test tenant first. A released tax adjustment can only be reversed while its tax period is still Prepared.

Translate