Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.kwentra.com/llms.txt

Use this file to discover all available pages before exploring further.

The Account Listing Details report shows a full transaction-level ledger for any GL account over a selected date range, with running balances and direct links to the underlying journal vouchers. Business Value
  • Review every debit and credit on any GL account for any date range.
  • Track running balances transaction by transaction for easy reconciliation.
  • Jump directly from a report line to the source journal voucher.
  • Filter by account range, JV code, and reconciliation status to narrow results.
Use Cases
  • Finance reviews all AR transactions on the Visa Bank account for the month to reconcile the closing balance.
  • Accountant investigates an unexpected balance by drilling into individual JV entries from the report.
  • Auditor filters by reconciliation status to identify unreconciled transactions quickly.
How It Works Where to Find It 📍 Where: Reports → Back Office → Account Listing Details (American) Reports → Back Office → Main Account Listing Details (British) Report Parameters Set the following filters before running the report:
ParameterDescriptionOptions / Example
From DateStart of the date range to report one.g. 2026-03-01
To DateEnd of the date range to report one.g. 2026-03-30
From AccountFirst GL account in the rangee.g. 11003001 BANK LE
To AccountLast GL account in the rangee.g. 11003001 EAB BANK LE
JV CodeNarrow results to a specific journal code6/1, 6/2, 13, Beverage Store, accrual… (optional)
Level of DetailHow much detail to showSummarized / Detailed / Detailed with Currency
ReconciledShow only reconciled, unreconciled, or all entriesAll / Yes / No
File TypeFormat of the exported fileXLS, XLSX, ODS, PDF
Report Output Results are grouped by account. Each account section starts with a header block followed by a transaction table per GL period. Account Header Block:
FieldDescriptionExample
AccountGL account code and name8200001 / A/R Sample Bank USD
Open BalanceAccount balance at the start of the period1,250,000.00
GL PeriodGL period covering the transactions below3-2026
Transaction Columns (Detailed level):
ColumnDescriptionExample
DateDate the transaction was posted2026-03-06
SerialJV serial number — clickable link to the source voucher (see update note below for new link behaviour)JV-20260001
UserUser who created the journal entry—
CodeJournal voucher batch/code—
DescriptionAuto-generated text: AR account, agent, guest name, reservation ID, and posting datesAR Account: 100 Online Travel Agency – OTA(Guest Name-1000000001)
DebitAmount debited to the account6,782.56
CreditAmount credited to the account0.00
BalanceRunning balance after this transaction40,370,840.92
Sample Report Data
DateSerialDescriptionDebitCreditBalance
2026-03-06JV-20260001AR Account: 100 OTA Agency A – Agency A(Guest Name-1000000001)Created 1/3/265,000.000.001,255,000.00
2026-03-06JV-20260002AR Account: 101 OTA Agency B – Agency B(Guest Name-1000000002)Created 2/3/268,500.000.001,263,500.00
2026-03-07JV-20260003AR Account: 101 OTA Agency B – Agency B(Guest Name-1000000003)Created 3/3/263,200.000.001,266,700.00
2026-03-07JV-20260004AR Account: 102 OTA Agency C – Agency C(Guest Name-1000000004)Created 3/3/2612,000.000.001,278,700.00
2026-03-08JV-20260005AR Account: 100 OTA Agency A – Agency A(Guest Name-1000000005)Created 4/3/267,500.000.001,286,200.00
2026-03-08JV-20260006AR Account: 102 OTA Agency C – Agency C(Guest Name-1000000006)Created 4/3/264,800.000.001,291,000.00
🔄 Update — 30th of March: Smart File Number Navigation The Serial link in this report now uses smart routing when a file number is present on the JV. Previously, numeric file numbers were treated differently from non-numeric ones. This inconsistency has been removed — all file numbers now follow the same logic. Read more about how to add a Serial Number to a JV When you click a Serial link and the JV has a file number attached, the system checks how many JVs share that file number:
  • Single JV — The file number belongs to exactly one JV (added manually). The link opens that JV directly using its serial/ID in the URL.
  • Multiple JVs — The file number is shared across multiple JVs (e.g. AR Payments). The link opens the Journal Voucher Listing filtered by that file number.
Quick reference:
File NumberLinked JVsWhat Happens When You Click
INV-2025-0011 JV→ Opens that JV directly
100451 JV→ Opens that JV directly
AR-100993 JVs→ Opens JV listing filtered by file number
500124 JVs→ Opens JV listing filtered by file number