How to Record Loans in Xero: Keeping Track of Borrowings

Need to track loans in Xero? Here's how:
Recording loans in Xero ensures accurate financial records and compliance with accounting rules. This guide covers everything from setting up loan accounts to managing repayments and interest.

Key Steps:

• Set up loan accounts: Use codes 900 (bank loans) and 835 (director's loans).
• Record transactions: Separate principal and interest payments.
• Use tools: Bank feeds, manual journals, and dashboard watchlists for real-time tracking.
• Stay compliant: Follow GAAP/IFRS rules for liabilities and interest expenses.

Quick Example:

• Loan received: Debit Bank, Credit Loan Liability.
• Repayment: Split into principal (Loan Liability) and interest (Interest Expense).

Follow these steps to manage loans efficiently in Xero without errors or delays.

How To Deal With Loans In Xero

How do I account for a loan in Xero?

Managing loans in Xero involves careful coding of transactions to keep your financial records accurate.

When reconciling bank transactions:

• Choose the lender under 'Who'
• Assign the payment to the Loan Account
• Add a clear and descriptive reference
• Select 'No VAT'

It's important to separate the loan's principal and interest. For instance, if you make a £1,200 payment, this might include £1,000 for the principal and £200 for interest. Use a specific interest expense account for the latter.

Transaction Component	Xero Code
Principal Amount	900
Interest Payment	Add via Add Account > Bank Loan Interest

How do you account for loans in accounting?

When managing loans, it's essential to record the full amount as a liability, following GAAP or IFRS guidelines. While these principles provide the framework, tools like Xero make handling loans much easier:

Loan Component	Account Type
Short-term Portion	Current Liability (Xero code 835)
Long-term Portion	Non-current Liability (Xero code 900)
Interest Expense	Profit & Loss

Double-Entry Bookkeeping for Loans

• For cash loans: Debit your bank account (to increase assets) and credit the loan liability accounts.
• For asset financing: Debit the fixed asset account and credit the loan liability accounts.

To stay organized, schedule monthly reconciliations in Xero using lender statements. Use the dashboard watchlist to monitor balances and quickly spot any discrepancies.

How are loans recorded?

Xero's double-entry system makes it easy to record loans while maintaining accurate financial records. When you receive a loan, you’ll debit your bank account and credit the loan liability account. To simplify repayments, use bank rules to automatically divide payments into principal and interest.

For instance, if you take out a £25,000 loan, you would debit Cash and credit the Loan Account. Then, set up bank rules to handle repayments based on your lender's terms. These rules can automatically split payments into their principal and interest portions, saving time and reducing the chance of mistakes.

To account for interest, use manual journals to record it monthly. When creating bank rules, make sure to include specific transaction descriptions provided by your lender. This ensures repayments are accurately split according to your loan agreement.

This method sets you up for smooth repayment tracking, which we’ll dive into next.

How do you record a loan in a journal entry?

When recording loan transactions in your journal, it's important to account for both the principal and interest components accurately. This process builds on Xero's liability account structure and aligns with GAAP/IFRS principles.

Here’s how loan journal entries typically look:

• Initial loan receipt: Debit Bank £X / Credit Loan Liability £X
• Interest accrual: Debit Interest Expense £X / Credit Loan Liability £X
• Loan repayment: Debit Loan Liability £X + Debit Interest £X / Credit Bank £X

For monthly interest accruals, record them separately by debiting the Interest Expense account and crediting the Loan Liability account. When the interest is paid, reverse this entry.

When making repayments, split the payment between the principal and interest portions. For example:

Account	Debit	Credit
Loan Liability	£200
Bank Loan Interest	£50
Bank Account		£250

In this case, a £250 payment is divided into £200 for reducing the principal (debit Loan Liability) and £50 for interest expense (debit Interest Expense), with the full amount credited to the bank account.

Accurate journal entries are essential for tracking loan repayments effectively. In the next section, we’ll dive deeper into splitting payments correctly.

Recording Loan Receipts in Xero

How to Record Bank Loan Received in Xero

To record loan receipts in Xero, use Bank Reconciliation to match the bank feed transaction to account 900. For example, if you receive a £30,000 loan from Barclays, here's what to do:

• Who: Enter the lender's name (e.g., Barclays).
• What: Choose the Bank Loan account.
• Why: Provide a clear description, such as "Barclays Loan Advance."
• Tax: Set this to 'No VAT,' as loans are not subject to VAT.

This method ensures the transaction is accurately categorized and avoids errors during reconciliation.

How to Add Bank Loan to Dashboard Watchlist

You can track loan balances more effectively by adding the loan account to your Dashboard Watchlist. This makes it easier to monitor changes at a glance.

For future loan transactions, consider setting up bank rules. For example, create a rule that recognizes descriptions like "Loan Repayment" to automate coding. This saves time and reduces errors during reconciliation.

Documentation Element	Required Information
Interest Calculations	Attach spreadsheets with detailed breakdowns

Always attach relevant loan documents to transactions and use consistent naming for clarity. Proper documentation simplifies audits and tax reporting while ensuring smooth repayment tracking, which we'll cover next.

Keeping Track of Borrowings and Loan Repayments

How to Record Bank Loan Repayments in Xero

Once you've recorded loan receipts, use Xero's reconciliation tools to keep track of repayments. Make sure to categorize repayments accurately:

For split repayments that include fees, here's an example breakdown:

Payment Component	Amount	Account Code
Principal Payment	£1,800	900 (Bank Loan)
Processing Fee	£200	Interest Expense
Total Payment	£2,000	-

How to Check Bank Loan Balance and Record Interest

To stay compliant with GAAP principles, record monthly interest using Xero's +New > Manual Journal feature. Here's how:

• Debit: Interest Expense
• Credit: Loan Account (900)
• Add a description like 'Monthly interest accrual' for clarity.

For loans with variable rates, adjust your bank rules as needed and document effective dates in transaction memos for transparency.

If you're managing more complex loans, third-party tools like iLoanManager can help automate the process of separating principal and interest amounts.

Managing Director's Loan Accounts

How to Set Up a Director's Loan Account in Xero

Start by navigating to Accounts > Chart of Accounts in Xero and creating a new liability account specifically for director loans. Choose "Other Current Liabilities" as the account type and assign it a clear name, such as "Director's Loan Account."

To make tracking easier, enable the 'Show on Dashboard Watchlist' option during setup. This feature allows you to quickly view the loan balance and monitor transactions. It's especially useful for keeping tabs on balances and ensuring compliance.

Setup Component	Required Configuration	Purpose
Account Type	Other Current Liabilities	Ensures proper financial categorization
Tax Settings	Based on jurisdiction	Aligns with local tax regulations
Dashboard Display	Watchlist enabled	Simplifies real-time balance tracking

How to Record Bill Payments Made with Personal Money as a Director's Loan

When directors use personal funds to cover company expenses, it's essential to record these transactions accurately. In Xero, create an expense claim and select "Director's Loan Account" as the payment account. This action increases the company's liability to the director while properly categorizing the expense.

For example, to record a £500 office supply payment:

• Create an expense claim, using the Director's Loan Account as the payment source.
• Categorize the expense under Office Supplies and include a description like "Office supplies paid by director [Date]."

"The most critical aspect of managing director's loan accounts is maintaining clear separation between personal and business transactions. Our data shows that 83% of compliance issues stem from improper transaction categorization", explains Xenon Connect's accounting team in their 2024 guide.

To ensure compliance, always:

• Use the correct expense categories for all transactions.
• Maintain a clear audit trail by utilizing Xero's tracking features.

Setting up and managing these accounts properly lays the groundwork for handling director borrowings, which we'll cover next.

Handling Director Borrowings and Personal Expenses

Charging Interest on a Director's Loan in Xero

Once your Director Loan Account is set up, charging interest requires careful handling to stay compliant. In Xero, you can manage this process either manually or with automated tools.

For manual interest charges, navigate to + New > Manual Journal in Xero. Create a journal entry that debits a "Director Loan Interest Expense" account and credits the "Director Loan Account." Use the "No VAT" tax code to ensure compliance.

If you'd prefer automation, tools like iLoanManager can calculate and apply interest directly in Xero, minimizing the risk of errors.

Method	Process	Best For
Manual Entry	Add custom descriptions	Occasional loans
iLoanManager	Automates calculations	Frequent transactions

Handling Money Transfers In and Out of the Company

When directors repay loans via bank transfers, make sure to reconcile these transactions with clear memos, such as "Director Loan Repayment." Consistently coding these transactions ensures a clean audit trail, aligned with the setup of your loan account.

Managing Overdrawn Director's Loan Accounts

If a Director's Loan Account becomes overdrawn by more than £10,000, it’s crucial to act quickly to avoid tax penalties. If not resolved within nine months after the company’s year-end, you’ll need to record an HMRC S455 tax accrual journal.

Here’s how to address overdrawn balances:

1. Create a journal entry to reclassify the excess as dividends.
2. Record repayments promptly using the Director Loan Account.
3. Regularly monitor balances through Balance Sheet reports filtered by the Director Loan account.

Using Company Money for Personal Expenses

When personal expenses are paid using company funds, always code these transactions to the Director Loan Account. Use the "No VAT" tax code, and include clear descriptions to maintain transparency.

For each transaction, ensure the following:

• Clearly label it as a personal expense.
• Apply the correct tax code (usually "No VAT").
• Keep supporting documents for audit purposes.

Maintaining the separation of personal and business funds is essential for accurate records and compliance.

Conclusion: Mastering Loan Management in Xero

Key Takeaways for Managing Loans Effectively

Using Xero's loan tracking tools consistently helps ensure accurate financial records and compliance. Here’s what to focus on:

Proper loan management in Xero hinges on accurate account coding and organized tracking. In fact, audits reveal that poor tracking can lead to 15-20% of financial reporting errors.

To stay on top of loan management, businesses should:

• Regularly review Xero dashboards (at least weekly)
• Verify interest calculations every month
• Conduct full reconciliations quarterly

Related Blog Posts

• Track Expenses in Xero: A Simple Guide
• Recording Assets in Xero: A Simple Guide
• How to Record Loans in Xero: Managing Debt Effectively
• Tracking Donations in Xero for Non-Profits