Write off a customer account

Are you ready to write off the customer account?

If you want to reclaim VAT that you've paid on outstanding invoices on this account back from HMRC, you must write off these individual invoices before you write off the customer account.

Dealing with customer bad debts

Find this screen

Open: Customers > Credit Control > Write Off Customer.

How to

Write off an account

  1. Select the customer account using the Code, Postcode, or Short Name drop-down lists.
  2. Enter the amount that you want to write off in the Goods value field.

    The remaining account balance is written off as VAT and shown in the VAT value box.

    If you don't want to include a VAT element, enter the full account balance here.

  3. Choose the nominal account to post the VAT element of the write off to.

    Your VAT Output default nominal account is selected by default.

  4. If required, select a Transaction Analysis code for the write off transaction.

  5. Click Write Off.

Useful info

When to write off a customer account

This writes off the entire debt on a customer account and set its balance to zero. This is something you'd normally only want to do when you have ceased trading with the customer. You would do this:

  • After you have written off individual invoices and reclaimed the VAT paid on them.
  • If you do not want to reclaim the VAT on the outstanding invoices.
  • If there is no VAT to reclaim on the outstanding invoices.

Tip: Once you've written off the account balance, if you want to make sure that no further transactions are posted to this customer account, put the account On Hold using the Amend Account Status screen.

Dealing with bad debts and VAT

If you've paid the VAT on any outstanding invoices on a customer's account, you can reclaim the VAT paid as long as the debt is more than 6 months old. If you want to do this, you'll need to write off those individual invoices before you write off the customer account.

You do this using the Write off Bad Debt screen. Using this process creates a credit note which Sage 200 allocates to the invoices you're writing off and also appears on your VAT Return.

See Dealing with customer bad debt.

If you don't want to reclaim the VAT on the outstanding balance, but do want to reduce the balance of your VAT nominal account on the balance sheet, you choose how much of the outstanding balance is VAT and how much is goods and enter these values here


What happens when

An account is written off?

  • A credit note is with a reference of ACCWRTOFF is created and posted to the following nominal accounts:

    Nominal Account Debit Credit

    Debtors Control

    (Balance sheet)

    Account balance

    VAT output

    (Balance sheet)

    Remaining balance

    (VAT amount)

    Bad Debt Write Off

    (Profit and Loss)

    Goods (Net) Value
    Note:

    If you have specified a cost centre and department for the default sales nominal account on your customer 's account, you must create a nominal account for bad debts with the same cost centre and department.

    For example, if a customer has a default salesaccount of 4000 MAN, the transaction is posted to the Bad Debt Expense account 9101 MAN on the P & L. If there is no bad debt nominal account with the relevant CC or CC / Dept combination, then this is posted to the suspense account.

  • The credit note is allocated to the invoice.
  • The customer's account balance is updated.

Next steps

To ensure that no further transactions are posted to the customer account, put the account On Hold.

Note - information

Sage is providing this article for organisations to use for general guidance. Sage works hard to ensure the information is correct at the time of publication and strives to keep all supplied information up-to-date and accurate, but makes no representations or warranties of any kind—express or implied—about the ongoing accuracy, reliability, suitability, or completeness of the information provided.

The information contained within this article is not intended to be a substitute for professional advice. Sage assumes no responsibility for any action taken on the basis of the article. Any reliance you place on the information contained within the article is at your own risk. In using the article, you agree that Sage is not liable for any loss or damage whatsoever, including without limitation, any direct, indirect, consequential or incidental loss or damage, arising out of, or in connection with, the use of this information.