User Roles AdminStaff contributor ✗External contributor ✗Pulse user 

The Summary of Variable Interest Bank Loans reconciliation takes every loan entered on the Variable Interest Bank Loans reconciliation and displays their combined opening balance, movements, closing balance, maturity analysis and instalment split in one place. It takes no data entry of its own: everything on it is read directly from the Variable Interest Bank Loans reconciliation.

Table of contents 

When should I use this template?

Add this alongside the Variable Interest Bank Loans reconciliation wherever that reconciliation is used, so that you have a single combined position across every loan recorded there without adding each one up individually.

It is designed to sit alongside that reconciliation: the reconciliation does the loan-by-loan data entry and reconciliation, and this template presents the combined total.

Before you start

Complete the Variable Interest Bank Loans reconciliation first. This summary has nothing to display until at least one loan has been entered there.

Background

This template performs no calculations of its own. It is a presentation layer over figures already calculated on the Variable Interest Bank Loans reconciliation, so no separate accounting judgement is needed here beyond what has already been applied on that reconciliation.

Steps

  1. Review the combined movement. Opening balance, Loans issued, (Repayments), Interest and Closing balance are shown as the sum across every loan on the Variable Interest Bank Loans reconciliation, with an unreconciled indicator if the combined closing balance does not agree with the combined ledger value of the loan accounts feeding that reconciliation.
  2. Review the maturity analysis. Due < 1 year, Due 2-5 years and Due > 5 years show the combined split across every loan.
  3. Review the instalment split. By instalments and Not by instalments show the combined totals across every loan.

What flows through to the rest of the accounts/workflow?

This is a presentational summary only, so it does not feed any other template itself. The bank loan note and the current/non-current split on the balance sheet are supported by the Variable Interest Bank Loans reconciliation underneath it.

What rolls forward next year?

Nothing. There is no data entry on this template, so nothing rolls forward here. Every figure is recalculated live from the Variable Interest Bank Loans reconciliation each time the summary is opened.

Where the data comes from

Entirely from the Variable Interest Bank Loans reconciliation. Every figure shown here is a direct read of that reconciliation's calculated totals across every loan entered there. This template performs no independent calculations, so if a total here looks wrong, check the loan details on that reconciliation instead.

Frequently asked questions

Why is this summary blank?

No loans have been entered yet on the Variable Interest Bank Loans reconciliation.

Why does this template show its own unreconciled warning when the reconciliation beneath it already reconciles?

This summary checks the combined total across every loan against the combined ledger balance, which can occasionally catch a mismatch even where each individual loan appears to reconcile on its own.

Can I edit figures directly on this summary?

No, everything shown here is read-only. Edit the loan details on the Variable Interest Bank Loans reconciliation instead.