Account Listing Details Report - kwentra Help Center

See every transaction on any GL account for a date range. Each line shows the running balance and links to its journal voucher. Business Value

Shows every debit and credit on any GL account, for any dates.
Shows the running balance after each transaction, which makes reconciliation easier.
Opens the source journal voucher from a report line.
Filters by account range, JV code and reconciliation status.

Use Cases

Finance checks all AR transactions on the Visa bank account for the month, then reconciles the closing balance.
An accountant opens each JV from the report to find why a balance looks wrong.
An auditor filters by reconciliation status to find not reconciled transactions fast.

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 these filters before you run the report:

Parameter	Description	Options / Example
From Date	First day of the report	e.g. 2026-03-01
To Date	Last day of the report	e.g. 2026-03-30
From Account	First GL account in the range	e.g. 11003001 BANK LE
To Account	Last GL account in the range	e.g. 11003001 EAB BANK LE
JV Code	Show one journal code only	6/1, 6/2, 13, Beverage Store, accrual… (optional)
Level of Detail	How much detail to show	Summarized / Detailed / Detailed with Currency
Reconciled	Show reconciled, not reconciled, or all entries	All / Yes / No
File Type	Format of the exported file	XLS, XLSX, ODS, PDF

Report Output Results are grouped by account. Each account starts with a header. A transaction table follows for each GL period. Account Header Block:

Field	Description	Example
Account	GL account code and name	8200001 / A/R Sample Bank USD
Open Balance	Account balance at the start of the period	1,250,000.00
GL Period	GL period of the transactions below	3-2026

Transaction Columns (Detailed level):

Column	Description	Example
Date	Date the transaction was posted	2026-03-06
Serial	JV serial number. Click it to open the source voucher (see the update below)	JV-20260001
User	User who created the entry	—
Code	Journal voucher code	—
Description	Created by the system: AR account, agent, guest name, reservation ID and posting dates	AR Account: 100 Online Travel Agency – OTA(Guest Name-1000000001)
Debit	Amount debited to the account	6,782.56
Credit	Amount credited to the account	0.00
Balance	Running balance after this transaction	40,370,840.92

Sample Report Data

Date	Serial	Description	Debit	Balance
2026-03-06	JV-20260001	AR Account: 100 OTA Agency A – Agency A(Guest Name-1000000001)Created 1/3/26	5,000.00	1,255,000.00
2026-03-06	JV-20260002	AR Account: 101 OTA Agency B – Agency B(Guest Name-1000000002)Created 2/3/26	8,500.00	1,263,500.00
2026-03-07	JV-20260003	AR Account: 101 OTA Agency B – Agency B(Guest Name-1000000003)Created 3/3/26	3,200.00	1,266,700.00
2026-03-07	JV-20260004	AR Account: 102 OTA Agency C – Agency C(Guest Name-1000000004)Created 3/3/26	12,000.00	1,278,700.00
2026-03-08	JV-20260005	AR Account: 100 OTA Agency A – Agency A(Guest Name-1000000005)Created 4/3/26	7,500.00	1,286,200.00
2026-03-08	JV-20260006	AR Account: 102 OTA Agency C – Agency C(Guest Name-1000000006)Created 4/3/26	4,800.00	1,291,000.00

🔄 Update — 30th of March: Smart File Number Navigation When a JV has a file number, the Serial link now opens the right place. All file numbers now work the same way. Before, number-only file numbers worked differently from the rest. Read more about how to add a Serial Number to a JV Click a Serial link on a JV that has a file number. The system counts the JVs with that file number:

Single JV — Only one JV has this file number (added by hand). The link opens that JV.
Multiple JVs — Several JVs share the file number, for example AR Payments. The link opens the Journal Voucher Listing, filtered by that file number.

Quick reference:

File Number	Linked JVs	What Happens When You Click
INV-2025-001	1 JV	→ Opens that JV directly
10045	1 JV	→ Opens that JV directly
AR-10099	3 JVs	→ Opens JV listing filtered by file number
50012	4 JVs	→ Opens JV listing filtered by file number