1. Portfolio Filter & Accounting Period Control Center (2020 β 2030)
Dynamic IFRS 16 recognition engine β Switch between Month-End and Year-End closing.
Accounting Basis:
Showing All
Active Leases:
0
Depreciation:
QAR 0
Finance Interest:
QAR 0
Rentals Paid:
QAR 0
Closing Liability:
QAR 0
Closing Net ROU:
QAR 0
2. Consolidated Portfolio Schedule (Click any row to Drill Down)
Summary line by asset matching sheet PROPERTY WORKING 23 & TRANSPORTATION WORKING 23
| Category | Asset Code / Identifier | Asset / Branch Name | Commence Date | Ending Date | Term (m) | Rent / Period | Monthly Depr | Monthly Interest | Rent Paid | Month-End Liab | Month-End Net ROU | Action |
|---|
Drill-Down Inspector
MONTHLY POSTING
Month ended 31 January 2026
Asset: -
| Cut-off date | 1-Jan-26 |
| Lease commencement date: | 1-Apr-23 |
| Lease ending date: | 31-Mar-28 |
| Lease term: | 60 months |
| Lease rentals | QAR 0 |
| Payment terms | Semi-Annually |
| Initial Direct Cost | 0 |
| Lease incentive | 0 |
| Incremental Borrowing Rate p.a | 6.32% p.a. |
MONTHLY ERP JOURNAL ENTRY
Posting Date: 31/01/2026
Balanced JV Entry
| GL Head / Account Description | Debit (QAR) | Credit (QAR) |
|---|
Month-End Lease Liability:
QAR 0
Month-End ROU Asset:
QAR 0
Monthly Depr (P&L):
QAR 0
Monthly Interest (P&L):
QAR 0
Monthly Amortization Schedule (Month-End Posting Dates & Discounting)
Month-End Posting (Last Day of Month)| Month & Posting Date | Discount Factor | Contract Payment | ROU Opening | Depreciation | ROU Closing | Opening Liab (A) | Payment (B) | Interest (C) | Closing Liab (D) |
|---|
Flexible Period Range Journal Voucher (JV) Posting Module
Select any custom period range (e.g. Jan 2023 to Mar 2023, 01 Oct 2022 to 31 Oct 2023, or single month) to pass aggregated ERP journal entries.
|
β
|
Dynamic Accounting Period
Range Presets:
ERP POSTING VOUCHER SUMMARY
ERP Journal Voucher Posting Summary
Coverage: Dynamic calendar month accounting
12 Months
Balanced JV Entry
Period Opening Liab:
QAR 0
Period Closing Liab:
QAR 0
Total Depreciation:
QAR 0
Total Interest Accrued:
QAR 0
Total Rentals Paid:
QAR 0
Journal Voucher Presentation:
Showing complete annual journal entries and roll-forward balances as per IFRS 16
Annual Journal Entries (Year-Wise Schedule with Last Balancing Head β PIC 1)
IFRS 16 Formal Ledger Postings
| Date | Debit | Credit | Amount (QAR) | Posting Narration / Account Code |
|---|
Full Trial Balance β Lease-Related Accounts (Self-Balancing Ledger Verification β PIC 1)
Cumulative Balance Sheet & Annual P&L Movement (Debits = Credits)| GL Code | Account Description | Debit (QAR) | Credit (QAR) | Posting Period & Narration |
|---|
Lease Contract Data Entry Form (All Fields)
Input new or modified lease parameters to calculate outputs in real time and store into SQLite 3.
β Contract successfully calculated and stored in SQLite 3 database (
ifrs16_database.db)!
β
Real-Time Calculated Outputs (From Input Data)
Right of Use Asset (Day 1):
QAR 0
Total Lease Liability:
QAR 0
Current Liability (< 12m):
QAR 0
Long-Term Liability (> 12m):
QAR 0
Monthly Depreciation:
QAR 0
Annual Depreciation:
QAR 0
End Year 1 Net ROU:
QAR 0
Total 3-Yr Finance Interest:
QAR 0
Live Amortization Schedule (Full Tenure Breakdown)
Generated from input parameters| Month | Posting Date | Opening Liab | Payment | Principal | Interest | Closing Liab | Depreciation | Net Carrying ROU |
|---|---|---|---|---|---|---|---|---|
| Enter lease parameters above and click "Apply & Compute Schedule" to view the full amortization schedule. | ||||||||
Annual Journal Entries with Last Balancing Head (JV Breakdown)
Bank clearance on actual debit dates & derecognition entry at expiry| Date | Debit Account | Credit Account | Amount (QAR) | Narration & Clearance Reference |
|---|---|---|---|---|
| Journal entries will populate here once lease rent and term are calculated. | ||||
Full Trial Balance β Lease-Related Accounts (Self-Balancing Ledger Verification β PIC 1)
Cumulative Balance Sheet & Annual P&L Movement (Debits = Credits)Trial Balance tables will dynamically generate here upon calculation.
Satisfied with this Schedule, Journal Entries, and Trial Balance?
Click below to commit this contract and its complete amortization schedule directly into SQLite 3 (ifrs16_database.db).
SQLite 3 Database Repository & Live Records
Direct view of active lease records stored in ifrs16_database.db.
| Code | Asset / Branch Name | Category | Rent / Period | Term | Initial ROU | Initial Liability | Actions |
|---|---|---|---|---|---|---|---|
| Loading contracts from SQLite 3... | |||||||