Value Proposition: Loan Accounts become problematic at Month-End when managed solely as “Bank Payments”: there is no unified Debt Schedule, no separation between principal, interest, and fees, no schedule addressing draws from facilities, and no reconciliation between the loan balance in GL and the bank statement/bank letter. This template transforms the loan from a PDF file into a closing pathway: Register → Schedules → JE Log → Reconciliations → Closing Pack that is auditable.

In 20 seconds: What will you get?

• Loan & Facility Register: Register of loans and facilities (Term/Limit/Rate/Collateral/Covenants) with a Reference ID for each contract.
• Debt Schedule: Loan principal schedule (Opening → Drawdowns → Repayments → Closing) + Current/Non-current separation.
• Interest Accrual Schedule: Monthly interest accrual evidence linked to the JE and bank statement.
• Fees & EIR Schedule: Processing of arrangement/commitment/commission fees linked to amortization according to company policy.
• Covenants Tracker: Monitoring of Covenants/commitments (DSCR/Leverage… per contract) and evidence of compliance or explanation of deviations.
• Reconciliations: Matching loan and facility balances in GL/TB with schedules and bank statements/bank letters.
• Closing Pack: Month/Year delivery index (Schedules + JE Log + Recs + Sign-off) that is auditable.

The download is linked to the outputs: Debt Schedule + Interest Accrual + Fees (EIR) + Covenants + GL Reconciliation + Closing Pack.

Suitable for

• Treasury / Finance: Needs a unified Debt schedule for facility draws, repayments, and renewals.
• GL / Chief Accountant: Needs JE Templates + Reconciliations for Month-End and Year-End closing.
• Internal/External Audit: Needs Traceability: Contract → Schedule → Entry → GL + Evidence (Bank/Confirmations).

Not Suitable for

• Those looking for “accounts” in the sense of application/social accounts like Beautiful Instagram Accounts or Apple Store Accounts or Random Accounts or Fort Accounts — the product is accounting for loans only.
• Those wanting to build a complete Chart of Accounts or Ledger as a general ledger system — this is a specialized template for managing loans and facilities within closing.

Without the template / With the template (short comparison)

Before Use: 5 Symptoms That Loans Will Cause Differences and Delays in Month-End

• No unified Debt schedule; draws and repayments scattered between bank statements and emails.
• Interest recorded “upon payment” only, leading to discrepancies in accrued/paid interest at month-end.
• Arrangement/renewal/commitment fees recorded as expenses once without amortization/distribution schedule.
• No Current/Non-current separation for loans, causing the impact of maturities to be lost within the statements.
• Covenants not tracked as a record (Tracker), posing a risk of default/reclassification without preparing evidence files.

How do Loan Accounts work in practice?

Step 1: Preparation and Report Gathering

• Gather loan/facility agreements + appendices (Limit/Term/Rate/Fees/Covenants/Collateral) and record them in the Register with a reference number.
• Extract bank statements/facility statement (Drawdowns/Repayments/Interest charged) + any statements from the bank regarding fees.
• Identify relevant GL accounts (Loan liability / Interest expense / Fees deferred / Bank) and prepare TB for reconciliation.

Step 2: Settlements + Matches + JE Log

• Update Debt schedule: Opening + Drawdowns + Repayments + Closing, specifying due dates and preparing Current/Non-current.
• Record Interest accrual for the month (accrued but unpaid) and link it to the bank statement, then prepare the month’s entry within JE Templates and record it in JE Log.
• Update Fees/EIR schedule: Paid/accrued fees + monthly amortization + link to allocation/amortization entries according to company policy.

Step 3: Adjusted TB + Schedules + Closing Pack

• Execute Reconciliations to GL/TB: (Loan balance + interest payable + deferred fees) with explanation of differences (Timing/Bank posting).
• Produce Debt maturity table + Current/Non-current split to support presentation in the statements (or Note support in Year-End).
• Compile Closing Pack: Register + Schedules + JE references + Bank evidence + Covenants tracker + Sign-off before approving Adjusted TB.

Template Components (Clear Inventory)

1. Loan & Facilities Register
   • Practical Purpose: Consolidate data for each loan/facility (Limit/Term/Rate/IBR/Fees/Covenants/Collateral) instead of scattered files.
   • When to Use: When entering a new loan/facility + update upon renewal/amendment.
   • Resulting Evidence: Register Versioned + Reference ID + Archiving links for contracts.
2. Drawdowns & Utilization Tracker
   • Practical Purpose: Track draws from facilities (Revolving/OD) and link them to the date and amount of the draw and its bank source.
   • When to Use: Monthly (and sometimes daily) depending on the frequency of draws.
   • Resulting Evidence: Utilization schedule + link to bank movement/facility statement.
3. Debt Schedule & Amortization
   • Practical Purpose: Loan balance schedule: Opening → Repayments → Closing + due dates + Current/Non-current classification.
   • When to Use: Monthly + upon rescheduling or refinancing.
   • Resulting Evidence: Debt schedule + Maturity table + Snapshot for the month/year.
4. Interest Accrual Schedule
   • Practical Purpose: Evidence of accrued interest at Month-End linked to what the bank actually deducted later (Accrued vs Paid).
   • When to Use: Monthly before closing accounts.
   • Resulting Evidence: Accrual schedule + explanation of timing differences + month’s entry reference.
5. Fees & EIR Schedule
   • Practical Purpose: Document arrangement/renewal/commitment fees and amortize them according to company policy.
   • When to Use: Monthly + when paying new fees or amending terms.
   • Resulting Evidence: Fees rollforward + Monthly amortization + entry reference.
6. Covenants Tracker
   • Practical Purpose: Monitor covenants in contracts and evidence compliance or explain deviations and remedial steps (Waiver/Reset).
   • When to Use: Monthly/quarterly depending on bank terms.
   • Resulting Evidence: Covenant report + Supporting calculations + Attachments (if any).
7. FX Revaluation Sheet (if multiple currencies exist)
   • Practical Purpose: Evaluate loans in foreign currencies and evidence currency differences linked to accounts.
   • When to Use: Monthly, especially during currency fluctuations.
   • Resulting Evidence: FX revaluation schedule + source of the exchange rate used + entry reference.
8. JE Templates + JE Log
   • Practical Purpose: Templates for entries for accrued interest, repayments (Principal/Interest split), fee amortization, and currency differences.
   • When to Use: Monthly + upon repayment/drawdown/amendment.
   • Resulting Evidence: JE template + entry number after posting + JE Log references.
9. Reconciliations to GL/TB
   • Practical Purpose: Evidence that total schedules = GL/TB balances or explanation of differences (Timing/Posting/Bank charges).
   • When to Use: Monthly before Adjusted TB + annually for delivery.
   • Resulting Evidence: Reconciliation schedule + classified differences + closing plan.
10. Closing Pack Index + Sign-off
    • Practical Purpose: Define “what is delivered” to the auditor/oversight: schedules + entries + reconciliations + bank evidence.
    • When to Use: Month-End and Year-End.
    • Resulting Evidence: Pack index + Prepared/Reviewed/Approved + Version.

What should be included in the delivery?

• 01-ReadMe & Runbook: Steps for Month-End operation for loans and facilities + control points.
• 02-Loan Register: Register of loans/facilities + Reference IDs + Links to loan agreements/appendices.
• 03-Drawdowns & Repayments: Drawdown/repayment file + their sources (Bank statements / Facility statements).
• 04-Debt Schedule: Loan principal schedule + Maturity table + Current/Non-current split.
• 05-Interest Accrual: Schedule of accrued interest + link to bank deductions/bank invoices.
• 06-Fees/EIR: Schedule of fees (Upfront/Commitment/Renewal) + monthly amortization + link to entries.
• 07-Covenants Pack: Covenant report + calculations + any letters/approvals (Waiver) if available.
• 08-FX Revaluation: (if applicable) Currency evaluation schedule + FX source + currency difference entries.
• 09-JE Pack: JE templates + JE Log + posting numbers + References for schedules and bank evidence.
• 10-GL/TB Reconciliation: Reconciliation of loans, interest, and fees to TB/GL + explanation of differences.
• 11-Pack Index & Sign-off: Delivery index + Prepared/Reviewed/Approved + month/year version.
• 12-Archiving Map: Folder tree for archiving linking each Contract ID to where evidence is stored.

After Implementation (Two Points Only)

• Operational Result for the Team: Each loan/facility has one schedule updated monthly (balance/interest/fees/draw/repayment) instead of delayed bank aggregation at closing.
• Control/Audit Result: Traceability: Contract → Draw/Repayment → Schedules → JE → GL/TB, with Reconciliations and Closing Pack reducing repeated evidence requests.

FAQ — Questions Before Purchase

Is it suitable for any accounting system or ERP?

Yes. Because inputs can be Exports (TB/GL + Bank statements) and outputs are Schedules + JE templates + Reconciliations.

Does it support Revolving/OD loans and facilities?

Yes, through the Utilization tracker: it records draws and repayments and produces a moving balance with accrued interest linked to the bank statement.

Does it include Current/Non-current split and maturity schedule?

Yes. The Debt schedule produces a Maturity table and Current/Non-current classification to support presentation in the statements or Note support.

Does it handle loan fees (arrangement/commitment/renewal)?

Yes, through the Fees/EIR schedule: it documents fees and shows monthly amortization and links the entry within the JE Log according to company policy.

Does it include tracking of Covenants?

Yes. The Covenant tracker evidences covenant limits and calculations and the source of data (TB/financial metrics) with compliance status.

What is the minimum data required to get started?

Loan/Facility Agreement, payment schedule or loan statement from the bank, interest rate/index, fees, TB/GL for loan, interest, and fee accounts, and bank statement for the period.

Does it support multiple currencies and currency differences?

Yes, when entering the loan currency and the exchange rate used for each period and producing an FX revaluation schedule with currency difference entries.

Is this product related to “account management” or “chart of accounts” or “ledger” as a general system?

No, as a complete scope. You may need a suitable Chart of Accounts to distinguish loans, interest, and fees, but the product itself is specialized in operating loans and facilities and producing closing evidence.

Is it related to Fort accounts or Instagram accounts or Apple Store accounts?

No. These are general search terms unrelated to accounting. The product is dedicated to Loan Accounts within companies only.

Ready to close loans and facilities with schedules and reconciliations instead of GL differences?

Outputs: Debt Schedule + Interest Accrual + Fees/EIR + Covenants + Reconciliations + JE Log + Closing Pack Index.