NOTE: If you're writing off a foreign transaction, or if you want to process the write off manually, please refer to our other helpful guide.
Using the wizard- On the navigation bar click Customers or Suppliers then click Write offs & returns.
- Select the required option then click Next.
NOTE: For further information about the areas available, please refer to the relevant sections later in this article. - Follow the on-screen prompts using the buttons to navigate.
When you've selected all of the required options, a summary of the information you've selected appears. - Ensure the information is correct then to post the write off, refund or return click Post.
If required, to modify any of the choices made, click Back, or to cancel the wizard, click Cancel.
NOTE: If you need to delete transactions created via the Write Off, Refunds and Returns Wizard, you should first edit the transaction, delete the reference and save the changes. You can then delete the transaction. When editing or deleting transactions the Customer Record Month To date (MTD) and Year To Date (YTD) may be affected.
Options in the wizardCustomer or Supplier Invoice RefundsUse this option when you have an invoice that has been paid and, for whatever reason, a credit is to be raised and the cheque returned. For example, if goods have been returned and a full refund given. Read more >CustomersThis routine posts a sales credit to reverse the effects of the original sales invoice and a sales payment to correct the balance on the bank account. The sales payment is automatically allocated to the sales credit. Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 4000 | Orig Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | SR | 1200 | Customer Receipt | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SC | 4000 | Refund | Date | REFUND | 50.00 | 10.00 | T1 | SP | 1200 | Sales Payment | Date | REFUND | 60.00 | 0.00 | T9 |
SuppliersThis routine posts a purchase credit to reverse the effects of the original purchase invoice and a purchase receipt to correct the balance on the bank account. The purchase receipt is automatically allocated to the purchase credit. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 4000 | Orig Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | PP | 1200 | Supplier Payment | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PC | 4000 | Refund | Date specified | REFUND | 50.00 | 10.00 | T1 | PR | 1200 | Purchase Receipt | Date specified | REFUND | 60.00 | 0.00 | T9 |
NOTE: If you are using the VAT Cash Accounting scheme, the transactions are posted using the same tax code as the original transactions.
Customer or Supplier Cheque ReturnsUse this option for cheques that are returned from your bank marked Refer to Drawer or cheques that have bounced. Read more >CustomersThis routine posts a sales payment to the customer's account to show an outstanding balance and reduce the bank balance. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 4000 | Orig Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | SR | 1200 | Customer Receipt | 01/02/2011 | CANCEL | 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SP | 1200 | Cancelled Cheque | Date specified | CANCEL | 60.00 | 0.00 | T9 |
Suppliers
This routine posts a purchase receipt to the supplier's account to show an outstanding balance and increase the bank balance. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 4000 | Orig Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | PP | 1200 | Purchase Payment | 01/02/2011 | CANCEL | 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PR | 1200 | Cancelled Cheque | Date specified | CANCEL | 60.00 | 0.00 | T9 |
NOTE: If you are using the VAT Cash Accounting scheme, the transactions are posted using the same tax code as the original transactions.
Refund Credit Notes Use this option when there is an outstanding credit on the account, and rather than allocating this to a future invoice the customer is to be refunded or your money is to be returned to you. Read more >CustomersThis routine posts a sales payment to the customer's account to show an outstanding balance and reduce the bank balance. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 4000 | Original Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | SR | 1200 | Customer Receipt | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SP | 1200 | Refund | Date specified | REFUND | 60.00 | 0.00 | T9 |
Suppliers
This routine posts a purchase receipt to the supplier's account to show an outstanding balance and increase the bank balance. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 4000 | Original Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | PP | 1200 | Purchase Payment | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PR | 1200 | Refund | Date specified | REFUND | 60.00 | 0.00 | T9 |
NOTE: If you are using the VAT Cash Accounting scheme, the transactions are posted using the same tax code as the original transactions.
Payment on Account RefundUse this option when you have paid or received a cheque that is still outstanding on the customer's or supplier's account and is to be returned to the customer or from the supplier. Read more >CustomersThis routine posts a sales payment to correct the balance on the customer's account and to reduce the bank balance. The sales payment is automatically allocated to the sales payment on account. EXAMPLE: Original transaction Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SA | 1200 | Payment on Account | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SP | 1200 | Refund | Date specified | REFUND | 60.00 | 0.00 | T9 |
Suppliers
This routine posts a purchase receipt to correct the balance on the supplier's account and the bank balance. The purchase receipt is automatically allocated to the purchase payment on account. EXAMPLE: Original transaction Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PA | 1200 | Payment on Account | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Transaction posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PR | 1200 | Refund | Date specified | REFUND | 60.00 | 0.00 | T9 |
NOTE: If you are using the VAT Cash Accounting scheme, the transactions are posted using the same tax code as the original transactions.
Write off Customer or Supplier Accounts NOTE: VAT is not accounted for when using the write off wizard, therefore all of the automatic transactions are posted with the non-vatable tax code, T9 by default.
Use this option when an entire account is to be written off. For example, the company has ceased trading and there will be no further activity on the account. This option cannot be used to write off accounts using a foreign currency. Read more >CustomersThis routine allocates together all of the outstanding transactions on the customer's account. EXAMPLE: NOTE: Regardless of which transactions are selected in the wizard, all of the transactions on the customer's account are written off. Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 4000 | Outstd Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | SI | 4000 | Outstd Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | SC | 4000 | Outstd Credit | 01/02/2011 |
| 50.00 | 10.00 | T1 | SA | 1200 | Payment on Account | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Suppliers
This routine allocates together all of the outstanding transactions on the supplier's account and raises either a purchase invoice or a purchase credit to the bad debt write off nominal code to reduce or increase the supplier's account balance to zero, for example: NOTE: Regardless of which transactions are selected in the wizard, all of the transactions on the supplier's account are written off. Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 5000 | Outstd Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | PI | 5000 | Outstd Inv | 01/02/2011 |
| 50.00 | 10.00 | T1 | PC | 5000 | Outstd Credit | 01/02/2011 |
| 50.00 | 10.00 | T1 | PA | 1200 | Payment on Account | 01/02/2011 |
| 60.00 | 0.00 | T9 |
Write off Customer or Supplier TransactionsUse this option to write off outstanding invoice transactions, either individually or in batches. For example, when you are sure that a customer will not pay one or more invoices, or you will not pay your supplier for one or more invoices, perhaps where a dispute has arisen. NOTE: VAT is not accounted for when using the write off wizard, therefore all of the automatic transactions are posted with the non-vatable tax code, T9 by default.
NOTE: This option cannot be used to write off foreign currency transactions. Read more >CustomersFor every sales invoice selected, this routine posts a sales credit to the Bad Debt nominal code and automatically allocates it to the original outstanding sales invoice. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 4000 | Outstd Inv | 01/02/2011 |
| 10.00 | 2.00 | T1 | SI | 4000 | Outstd Inv | 01/02/2011 |
| 5.00 | 1.00 | T1 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 12.00 | 0.00 | T9 | SC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 6.00 | 0.00 | T9 |
Suppliers
For every purchase invoice selected, this routine posts a purchase credit to the Bad Debt nominal code, and automatically allocates it to the original outstanding purchase invoice. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 5000 | Outstd Inv | 01/02/2011 |
| 10.00 | 2.00 | T1 | PI | 5000 | Outstd Inv | 01/02/2011 |
| 5.00 | 1.00 | T1 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 12.00 | 0.00 | T9 | PC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 6.00 | 0.00 | T9 |
Write off Transactions below a valueUse this option to write off invoice amounts up to a specified amount. Enter the value and all outstanding invoices below that value are listed for you to select from. NOTE: VAT is not accounted for when using the write off wizard, therefore all of the automatic transactions are posted with the non-vatable tax code, T9 by default.
NOTE: This option cannot be used to write off foreign currency transactions. Read more >CustomersThis routine displays all outstanding sales invoices below the specified value and then raises a sales credit for each invoice selected from the list. The sales credit is automatically allocated to the sales invoice. EXAMPLE: Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | TEST | 4000 | Outstd Inv | 01/02/2011 | 5.00 | 1.00 | T1 | SI | TEST1 | 4000 | Outstd Inv | 01/02/2011 | 3.00 | 0.60 | T1 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 6.00 | 0.00 | T9 | SC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 3.60 | 0.00 | T9 |
Suppliers
This routine displays all outstanding purchase invoices below the specified value, and then raises a purchase credit for each invoice selected from the list. The purchase credit is automatically allocated to the purchase invoice. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 5000 | Outst Inv | 01/02/2011 |
| 5.00 | 1.00 | T1 | PI | 5000 | Outstd Inv | 01/02/2011 |
| 3.00 | 0.60 | T1 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 6.00 | 0.00 | T9 | PC | 8100 | Bad Debt Write Off | Date specified | BADDBT | 3.60 | 0.00 | T9 |
Write off Small OverpaymentsUse this option to write off overpayments resulting from receipts that are more than the value of the original invoice, or have been entered as payments on account. The maximum value you can specify is £/€99.99. NOTE: VAT is not accounted for when using the write off wizard, therefore all of the automatic transactions are posted with the non-vatable tax code, T9 by default.
NOTE: This option cannot be used to write off foreign currency transactions. Read more >CustomersThis routine displays all sales payments on account below the specified value, and then raises a sales invoice for each payment on account selected from the list. The sales invoice is automatically allocated to the sales payment on account. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SA | 1200 | Payment on Account | 01/02/2011 |
| 10.00 | 0.00 | T9 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
SI | 8100 | Bad Debt Write Off | Date specified | BADDBT | 10.00 | 0.00 | T9 |
Suppliers
This routine displays all purchase payments on account below the specified value, and then raises a purchase invoice for each payment on account selected from the list. The purchase invoice is automatically allocated to the purchase payment on account. EXAMPLE: Original transactions Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PA | 1200 | Payment on Account | 01/02/2011 |
| 10.00 | 0.00 | T9 |
Transactions posted by the wizard Type | N/C | Details | Date | Ref | Net | Tax | T/C |
---|
PI | 8100 | Bad Debt Write Off | Date specified | BADDBT | 10.00 | 0.00 | T9 |
Bad Debt Relief ConditionsBad Debt Relief Conditions for customersHMRC state that you are only eligible to claim back VAT under certain circumstances. EXAMPLE: When writing off sales credits, these rules do not apply. The VAT becomes repayable at the point of write off.
Bad Debt Relief Conditions for suppliersBefore you can write off your purchase invoice to bad debt, you must decide whether or not you need to repay the Input tax claimed when the original purchase invoice was VAT Reconciled. There are different rules depending on when the supply was made to you. For further information about this, please refer to VAT Notice 700/18, available from HMRC or visit their website at http://www.hmrc.gov.uk
Reclaim or repay VAT after a write offAfter writing off customer or supplier transactions or accounts, using the Write Off, Refunds and Returns wizard, you may need to reclaim or repay the VAT element of the transaction. Repay VAT after writing off a supplier account with a positive balanceTo repay the VAT after writing off a positive balance using a non-vatable, T9, tax code, to move the VAT amount from the bad debt write off nominal code to the purchase tax control account and record the repayment in box 4 on the VAT Return, you need to post the following transactions: - A VAT only purchase credit to correct the VAT Return
- A purchase invoice to correct the balance on the supplier account and the Bad Debt Write Off account
Read more >EXAMPLE: In this example an account with a balance of £/€120.00, inc VAT at 20%, was written off on June 30th. The write off qualifies for Bad Debt Relief as of December 31st. Post the VAT only purchase credit- Click Suppliers then click Batch credit.
- Enter the relevant information on the Batch Supplier Credit window, for example:
A/C* | Date* | Credit No | N/C* | Details | Net | T/C* | VAT |
---|
BROWN | Date of Repayment | BadDbt | 8100 | Write Off | 0.00 | T1 | 20.00 | NOTE: You should use the date that the write off qualifies for bad debt relief. As the net amount is zero, this transaction does not affect the bad debt write off nominal code, 8100 by default.
- Click Save then click Close.
You have posted the VAT only credit to record the repayment of VAT in box 4 on the VAT Return. You must now post a purchase invoice to correct the supplier's account and correct the balance on the bad Debt Write Off nominal code. Post the purchase invoice- Click Suppliers then click Batch invoice.
- Enter the relevant information on the Batch Supplier Invoice window to record the bad debt invoice, for example:
A/C* | Date* | Credit No | N/C* | Details | Net | T/C* | VAT |
---|
BROWN | Date of Repayment | BadDbt | 8100 | Write Off | 20.00 | T9 | 0.00 |
- Click Save then click Close.
Repay VAT after writing off a customer account with a negative balanceEXAMPLE: You have written off a sales credit for Brown Ltd. The original credit was for £/€120.00 including VAT at 20% and was posted using the T1 tax code. Brown Ltd has gone out of business and the credit has been written off in the accounts using the Write Off, Refunds and Returns wizard. This process illustrates how to post a journal to include this on your next VAT Return. Read more >
- Click Nominal codes then click Journal Entry.
- Enter a date and reference then enter the required details. For example, the tax code for the line updating the VAT control account should be T1 and the tax code for the line updating the bad debt write off nominal code should be T9.
N/C | Name | Details | T/C | Debit | Credit |
---|
8100 | Bad Debt Write Off | Bad Debt | T9 | 20.00 | 0.00 | 2200 | Sales Tax Control Account | Bad Debt | T1 | 0.00 | 20.00 |
- Click Save then click Close.
You have now posted the journal to repay the VAT. This leaves the effect of the net balance of the write off on the bad debt write off nominal code. The VAT amount is included for repayment in box 1 of the next VAT Return as required by HMRC.
Reclaim VAT after writing off a positive balance on a customer account or a negative balance on a supplier account When you write off a transaction or account using the Write Off, Refunds and Returns wizard you may need to reclaim or repay the VAT element of the transaction. In the following example, an account with a balance of £/€120.00, inc VAT at 20%, was written off on June 30th. The write off qualifies for bad debt relief as of the December 31st. NOTE: If you use the UK VAT Cash Accounting scheme, you only make payments to HMRC for VAT that's already been paid to you. In this situation you haven't received payment and accounted for VAT, therefore there's nothing to reclaim. Read more >
- Click Nominal codes then click Journal Entry.
- Enter a date and reference for the journal then enter the required details. For example, you should use the date the transaction qualifies for bad debt relief. The tax code for the VAT control account should be T1 and the tax code for the bad debt write off nominal code should be T9.
N/C | Name | Details | T/C | Debit | Credit |
---|
2201 | Purchase Tax Control Account | Bad Debt Relief | T1 | 20.00 | 0.00 | 8100 | Bad Debt Write Off | Bad Debt Relief | T9 | 0.00 | 20.00 |
- Click Save then click Close.
You have now posted the journal to reclaim the VAT this appears in box 4 on your next VAT Return, as required by HMRC.
Reverse a write off transactionThere may be instances where you choose to write off a transaction or an account and you need to reverse this write off. - Click Transactions and locate and select the write off transaction then click Edit.
- Delete BADDBT in the Reference box then click Save and click Yes.
- Ensure the write off transaction is still selected then click Delete, click Delete again and click Yes.
|