Xero Entity Loan Balance: Where to Find It

In Xero, an entity loan balance is usually found in the account transactions and reports for the loan’s ledger account; the quickest starting point is Accounting → Reports → Account Transactions, filtered to that account and the relevant date. If you mean a loan between related entities, first confirm which Xero organisation and which loan account you need: Xero does not provide one universal “entity loan balance” figure across organisations.

What “entity loan balance” can mean

The phrase may refer to different amounts, so identify the question before looking for a number:

• Loan liability: the amount the entity owes a lender, recorded as a liability account.
• Loan receivable: money the entity has lent and expects to recover, recorded as an asset.
• Related-party or intercompany loan: an amount due between connected entities, each of which may record a corresponding balance.
• Current amount owed: the balance at a chosen date, which may differ from the original principal because of repayments, interest, fees, or adjustments.

These balances are accounting records, not necessarily a lender’s payoff quote. A ledger balance may not include interest accrued but not posted, settlement fees, or transactions awaiting reconciliation.

Find the balance in Xero

Menu labels and report availability can vary by Xero plan, permissions, and interface updates. In the standard workflow, use the account’s activity or the balance sheet to check the amount:

1. Open the correct Xero organisation. For a group with multiple entities, do not assume the organisation currently open is the borrower or lender you need.
2. Go to Accounting → Reports and open Account Transactions. If the report is not shown, check the reporting menu available in your organisation.
3. Set the date range or “as at” date relevant to the question, and filter for the loan account. Use the account name or code from the chart of accounts.
4. Review the opening balance, posted transactions, and closing balance. Check whether the report includes draft or unreconciled items, if those options are available.
5. For a summary, open the Balance Sheet report for the same date. Locate the loan under liabilities if the entity owes the money, or under assets if it is owed money.

To investigate a figure, click through from the account balance or report line to the underlying entries where Xero permits. Confirm that repayments and interest have been posted to the correct accounts and dates.

Check the chart of accounts and report date

Xero can only show a meaningful loan balance if the transactions are coded to the right ledger account. Look under the chart of accounts for a loan account with an appropriate type, such as a liability for borrowing or an asset for lending. Account names are organisation-specific; a name containing “loan” is helpful, but not conclusive. Check the account type and the bookkeeping setup before relying on it.

The date matters as much as the account. A balance sheet is a snapshot as at a date, while an account transaction report shows movements over a period. If you need the balance at 30 June, use that date rather than today’s date. A report for a date after a payment was entered will normally include it; a report for a date before that payment will not.

For example, suppose a business borrowed $20,000, repaid $2,000 of principal, and recorded $300 of interest in a separate expense account. The loan liability may be $18,000, not $18,300, if the interest was paid or otherwise recorded separately. The lender’s statement and the accounting entries determine the actual ledger result.

Related-entity loans and matching balances

For an intercompany loan, look in each organisation separately. The lending entity generally records an asset (amount due from the borrower); the borrowing entity generally records a liability (amount due to the lender). Those two ledger balances should be compared at the same date and for the same underlying transactions.

They may not match automatically. Differences can arise from a payment entered in one organisation but not the other, different transaction dates, foreign-currency conversion, interest recorded by only one entity, or incorrect account coding. In a consolidated reporting setup, eliminations or consolidation adjustments may also affect group-level reporting. A group report should not be treated as a substitute for checking each entity’s own ledger.

When reconciling, compare the principal, repayments, interest, and any foreign-exchange entries separately. Keep a record of the agreement or supporting schedule used by the organisation’s bookkeeper, and investigate differences rather than changing a balance just to make the two sides agree.

Why the Xero balance may differ from the lender

A Xero balance is calculated from transactions recorded in the organisation’s books. A lender’s online balance or payoff statement can use a different date and may include items not yet entered in Xero. Common causes include:

• A payment is still pending, unreconciled, or posted after the report date.
• Interest has accrued but has not been recorded, or was coded to a separate account.
• A repayment contains both principal and interest, but the full amount was coded as principal—or vice versa.
• Opening balances, fees, or corrections were entered incorrectly or duplicated.
• The lender reports a settlement amount that includes charges beyond the ledger’s principal balance.

Use the lender’s statement to verify the external loan information, then consult the organisation’s bookkeeping process to determine what needs recording. Do not assume that editing a ledger balance directly is the right correction; the underlying transaction and accounting treatment may need review.

Frequently Asked Questions

Where is the loan balance on a Xero balance sheet?
Open the Balance Sheet for the relevant date. A loan the organisation owes usually appears among liabilities; a loan it has made usually appears among assets. The exact section and account name depend on the chart of accounts.

Can I see the loan balance for a past date?
Yes, if the underlying transactions and dates are recorded, run the Balance Sheet or account transaction report for the date you need. Check that later-entered transactions have been assigned accurate dates.

Why is my Xero balance different from the loan statement?
Compare the report date and account entries with the statement. Timing, unrecorded interest, payment coding, fees, and foreign-currency adjustments can all explain a difference.

How do I find an intercompany loan balance?
Check the relevant asset or liability account in each Xero organisation separately, using the same date. Reconcile the lender’s receivable against the borrower’s payable and investigate unmatched transactions.

Does the Xero balance show the amount needed to pay off a loan?
Not necessarily. Xero shows the bookkeeping balance based on posted entries; request a dated payoff or settlement figure from the lender if you need the amount to close the loan.

What to verify before relying on the figure

Confirm the organisation, account, report date, and whether you are checking a liability or receivable. Then trace material movements and compare them with the relevant loan statement or intercompany schedule. If a balance remains unexplained, ask the person responsible for the organisation’s bookkeeping or accounting records to review the entries. This process distinguishes the balance stored in Xero from the amount another entity or lender says is due.

Related

• VA Loan Interest Rates: What Shapes Your Payment?
• UD Loan Balance Calculator and Explanation
• Balance Equation: Cost and Monthly Payment Calculator