Table Name

Description

Key Information Captured

Sales Invoice

Record of issued invoices to customers

Invoice number, customer details, invoice date, amount billed, outstanding amount

Bank Transaction

Transactions recorded in the bank statement

Transaction date, description, deposit amount, allocated and unallocated

Settlement Advice

Advice document for settlements from payers

Settlement date, settlement amount, against which bill, in which UTR, TDS amount, Disallowance amount

Claim Book

Records claims made for reimbursement or settlement

Claim number, claimant details, claim date, amount claimed

Matcher

Tool or system used for matching payments against invoices

Invoice number, payment details, matching logic, matching status, amount details.

Payment Entry

Entry documenting payments received

Payment date, payer details, payment method, amount details, taxes and disallowance.

Journal Entry

Accounting entry used to record financial transactions

Entry date, account(s) debited and credited, description, amount