calculate-loan

01 Loan payments

Loan Repayment VAT Code in Sage: How to Record It

Guide 01-15158 · Updated · Step by step

In Sage, loan principal repayments are normally recorded with a no-VAT or outside-the-scope tax code, because repaying borrowed principal is not a purchase of goods or services. The exact code name depends on your Sage product, country configuration and chart of accounts; check the tax treatment of any interest separately rather than applying a VAT code to the whole payment.

Why a loan repayment is usually outside VAT

A loan repayment transfers money back to a lender to settle a liability. It does not, by itself, represent a taxable sale or purchase. For that reason, the principal portion generally should not create input VAT to reclaim or output VAT to report. In Sage, this is commonly represented by a code labelled “No VAT,” “Outside Scope,” “Exempt,” or a similar term, depending on the software edition and setup.

These labels are not interchangeable in every tax system. “Exempt” can have a specific meaning in VAT reporting, while “outside the scope” means a transaction is not treated as a VAT-able supply in the relevant way. Do not choose a code only because its name sounds close. Confirm which code your organisation uses for balance-sheet transactions that do not carry VAT.

How to enter the repayment in Sage

First identify the relevant loan account in your nominal or general ledger. A loan received is usually recorded as a liability; a repayment reduces that liability. The bank payment should be allocated between principal, interest and any separate charge shown by the lender, with each amount posted to the appropriate ledger account.

  1. Open the bank transaction or payment entry for the repayment.
  2. Use the loan liability account for the principal amount and select the configured no-VAT or outside-scope code.
  3. Post interest to the appropriate interest expense account. Apply a VAT code only if the lender’s documentation and your accounting setup establish that VAT is applicable to that specific charge.
  4. Post any separately identified fee to the relevant expense account and verify its tax treatment independently.
  5. Check that the bank total equals the sum of the principal, interest and charges, then reconcile the transaction.

Menu names and entry screens vary between Sage products and versions. The accounting distinction is more important than the button labels: the principal reduces the liability, while interest and fees are separate components.

Example: splitting principal and interest

Suppose a lender collects $500, made up of $430 principal and $70 interest. Record $430 against the loan liability with the applicable no-VAT or outside-scope code, and record $70 as interest expense using the tax treatment confirmed for that interest. The bank account decreases by $500; the loan liability decreases by $430; and interest expense increases by $70.

Do not enter the entire $500 against the loan liability if the lender’s statement identifies interest separately. Doing so would reduce the recorded debt by too much and omit the interest expense. Likewise, do not treat the principal as a VAT-bearing purchase just because a VAT code is required in a particular Sage transaction screen. Use the code configured for non-VAT transactions, or ask your administrator or accountant which code serves that purpose.

Interest, fees and tax-code distinctions

Interest is not principal: it is the cost of borrowing and should normally be tracked separately in the accounts. Its VAT treatment can depend on the transaction and applicable rules, so do not assume that the principal’s code automatically applies to interest, arrangement fees, late charges or other lender costs. Review the lender’s statement or invoice and follow the tax coding confirmed for your organisation.

Also distinguish a VAT code from a nominal account. The nominal account says what the transaction is financially—for example, loan liability or interest expense. The VAT code tells Sage how to treat the transaction for VAT reporting. A correct nominal account does not guarantee a correct VAT code, and a VAT code does not determine whether a payment is principal or interest.

Which Sage code should you choose?

There is no universal Sage code number or label for every loan repayment. Sage editions, regional tax settings and customised company files can use different codes. Look for the code your organisation has configured for transactions that are not subject to VAT, then confirm that it posts and reports as intended.

  • Check the code’s description and tax rate in your company’s Sage tax-code settings.
  • Review a previously approved loan-principal posting or your organisation’s bookkeeping procedure.
  • Ask the person responsible for VAT returns or the accountant who maintains the ledger if the code is unclear.
  • Do not create or edit a tax code without understanding its effect on VAT reports and prior transactions.

If the payment entry forces a code selection, use the organisation’s established non-VAT code rather than selecting a taxable rate to make the screen accept the entry. If none is available, pause and have the Sage setup reviewed.

Common errors and checks

A frequent mistake is treating the direct debit as one undivided expense. This can misstate both the outstanding loan balance and interest expense. Another is selecting “exempt” when the organisation’s reporting process requires an outside-scope or no-VAT code. The words may look similar, but their reporting behaviour can differ in a configured system.

  • Match the bank amount to the lender’s statement, including any separate charges.
  • Reconcile the loan liability to the lender’s outstanding balance periodically.
  • Check that principal has not been posted to an expense account or interest to the liability account.
  • Review the VAT report after posting if the code’s reporting effect is uncertain.
  • Correct coding through your normal adjustment process rather than changing old entries casually.

Keep the lender statement and the calculation or allocation supporting the split with your accounting records. If the lender provides only a combined payment figure, obtain a breakdown before allocating principal and interest where one is needed.

Frequently Asked Questions

What VAT code do I use for a loan repayment in Sage?
Use the Sage code configured for no VAT or outside-scope transactions for the principal repayment, subject to your organisation’s tax setup. There is no single code number that applies to every Sage file.

Is loan principal subject to VAT?
Repayment of borrowed principal is generally not a purchase of goods or services and normally does not carry VAT. Check the specific transaction and local tax treatment if there are unusual features.

Should interest use the same code as principal?
Not automatically. Interest is a separate charge, and its tax treatment should be checked separately using the lender’s documentation and your organisation’s accounting guidance.

Can I use an exempt code for the repayment?
Only if that is the code your Sage setup and accounting procedure specify. “Exempt” and “outside the scope” can mean different things for VAT reporting, so confirm the code’s settings rather than relying on the label alone.

How do I split a loan payment in Sage?
Allocate the principal to the loan liability account, interest to an interest expense account and any separately stated fee to the appropriate account. The parts should add up to the bank payment.

What if Sage has no no-VAT code?
Ask the person who manages the company file or its accountant to review the tax-code setup. Avoid inventing a code or choosing a taxable code simply to complete the entry.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this section

The whole Loan payments section →