Write off small purchase values
You may find that you have small values left on your accounts. This may be due to rounding, discrepancies, or you owe a supplier so little that they have written the value off. In such cases, you can use the Write Off Small Amounts option.
Up to 50,000 records can be displayed at once, and you can write off up to 1000 purchase values, on a supplier account. You can write off purchase values, even if the associated transaction is part allocated. If you need to write off more than 1000 values, select the option again and make a further selection of values to write off.
The default transaction value to write off is 200 (base currency), however this amount can be changed.
The appropriate debit or credit note is generated automatically for each write off. The transactions are posted to the supplier account and the Nominal Ledger accounts to update the balances.
When writing off values on a foreign currency supplier account, the exchange rate applied to the original transaction is used to convert the value to base currency.
A report is produced for you to check.
If the write off is an invoice |
If the write off is a credit note |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Note: The central VAT file is not updated.
You must have:
- Calculated the VAT element you can now claim, if you are dealing with a transaction that is part paid.
To write off small purchase values
Open: Purchase Ledger > Adjust Transactions > Write Off Small Amounts.
- Choose to write off entries from a single account or from all accounts.
- If you want to write off entries from a single account, select the supplier account that you want.
-
Accept the default nominal account to be used to write off the VAT element of the entry, or select the relevant nominal account from the drop-down list.
If the system is set up to use cost centre breakdown, only the nominal account reference number needs to be specified. The necessary cost centre and department codes are attached automatically from the account header record.
If the system is not set up to use cost centre breakdown, the full nominal account, including cost centre and department codes must be specified.
ExampleIf your nominal accounts are set up as follows (the first three accounts listed below are set up in default nominal accounts, and the fourth is set up on the supplier account record):
Default bad debt write off
68100
(profit and loss)
Default VAT input
15100
ADM
ADM
(balance sheet)
Creditors control
25100
ADM
ADM
(balance sheet)
Default nominal account
44100
FAC
STD
and you write off a small value transaction for the following values (using a standard VAT rate set to 17.5%):
Net
10.00 VAT
1.75 Gross
11.75 the nominal posting results will be:
If cost centre breakdown is not selected
Bad debt write off
Cr
10.00
68100
FAC
STD
Default VAT input
Cr
15100
ADM
ADM
Creditors control
Dr
11.75
25100
ADM
ADM
If cost centre breakdown is selected
Bad debt write off
Cr
10.00
68100
FAC
STD
Default VAT input
Cr
1.75
15100
FAC
STD
Creditor control
Dr
11.75
25100
FAC
STD
Note: The nominal accounts specified must exist in the Nominal Ledger to prevent postings to the suspense account.
Cost centre breakdown is activated by selecting Accounting System Manager setting Split postings between cost centres for balance sheet accounts on the Operational settings tab.
- Enter the transaction analysis code if required.
-
Accept or amend the maximum value to write off.
Qualifying transactions are displayed for you to select from. If the number of these is too large to be processed efficiently, you are prompted to reduce the maximum value to write off.
- From the generated list, select the transactions that you want to write off, using the check box at the left hand side of the transaction.
- If the entry is part paid and includes VAT, enter the VAT value to be written off in the VAT column.
- Click Write Off to confirm selection of the write offs.