Please enable JavaScript.
Coggle requires JavaScript to display documents.
Receipting Module – Reports - Coggle Diagram
Receipting Module – Reports
Report 1 – Receipt Transaction Report
Input Parameters
From Date — Date — Mandatory — The start date of the period for which receipt transactions should be retrieved.
To Date — Date — Mandatory — The end date of the period for which receipt transactions should be retrieved.
Status — Dropdown — Optional — Filters receipts based on their status (e.g., Completed, Cancelled, Banked).
Branch — Dropdown — Optional — Filters the report to show receipt transactions related to a specific branch.
Currency — Dropdown — Optional — Filters receipts by currency. If a currency is selected, only that currency is included; if not, include all and convert to base currency.
Debtor — Dropdown — Optional — Filters by selected debtor/customer.
Intermediary — Dropdown — Optional — Filters by intermediary (agent/broker).
Account Handler — Dropdown — Optional — Filters by responsible staff/account handler.
Sundry Transaction Type — Dropdown — Optional — Data retrieved from Miscellaneous Transaction Type Management.
Receipt Type — Dropdown — Optional — Type of the Receipt (Debit Settlement, Miscellaneous, Deposit).
Amount From/To — Number — Optional — Filters receipts with amount ≥ From and ≤ To.
Output Parameters (Data Source → Field — Description)
Receipts.TransactionDate → Date — The transaction date on which the receipt was generated.
Receipts.ReceiptNo → Receipt No. — The system-generated reference number assigned to the receipt.
Receipts.Status → Status — The current status of the receipt.
Receipts.ReceiptType → Receipt Type — Indicates the category (Debit Settlement, Miscellaneous, Deposit).
Debtors.Name → Customer Name — The name of the customer associated with the receipt.
DebitNotes.DNNo (via Allocations.DebitNoteId) → Debit Note No. — The debit note number settled/linked, if applicable.
Users.DisplayName (via Receipts.CreatedBy) → Generated User — The user who created/recorded the receipt.
MiscTransactionTypes.Name → Sundry Transaction Type — Type of the miscellaneous transaction (from Misc. Transaction Type Mgmt).
Receipts.CurrencyCode → Currency — The transaction currency.
Receipts.ExchangeRate → Exchange Rate — Rate used to convert foreign currency to base.
Receipts.Amount → Receipt Amount — Original amount received (transaction currency).
Computed(Receipts.Amount × Receipts.ExchangeRate) → Converted Receipt Amount — Amount converted into base currency.
Computed(SUM(Allocations.AppliedAmount) per ReceiptId) → Paid Amount — Portion of receipt allocated to debit notes.
Computed(Paid Amount × Receipts.ExchangeRate) → Converted Paid Amount — Paid amount in base currency.
Receipts.ExcessAmount OR Computed(Receipts.Amount − Paid Amount) → Excess Collected — Extra amount over billed amount.
Computed(Excess Collected × Receipts.ExchangeRate) → Converted Excess Collected — Excess amount in base currency.
Receipts.CancelledDate → Cancelled Date — Date the receipt was cancelled.
Users.DisplayName (via Receipts.CancelledBy) → Cancelled User — User who cancelled the receipt.
Receipts.CancelReason → Cancelled Reason — Reason for receipt cancellation.
Report 2 – Debtor’s Ageing Report Summary
Input Parameters
From Debtor Code — Number — Optional — Starting debtor code (inclusive).
To Debtor Code — Number — Optional — Ending debtor code (inclusive).
Debtor Group — Dropdown — Optional — Filter by debtor group (Corporate, Retail, Brokers).
Currency Code — Dropdown — Optional — Report currency; filters balances by selected currency.
As at Date — Date — Mandatory — Cut-off date for calculating outstanding amounts and ageing.
Status — Dropdown — Optional — Debtor status (Active, Inactive, Closed).
From Ref. No. — Number — Optional — Starting reference number range for invoices/transactions.
To Ref. No. — Number — Optional — Ending reference number range.
Ageing Periods — Number — Optional — Defines count/duration of ageing buckets (e.g., 0–30, 31–60, 61–90, >90).
Output Parameters (Data Source → Field — Description)
Debtors.Code → Debtor Code — Unique identifier assigned to the debtor.
Debtors.Name → Debtor Name — Name of the debtor/entity to whom payment is due.
Computed(AR.Documents, Receipting.Allocations) → Total — Total outstanding as at date (DocAmount − allocations/adjustments).
Computed(AR.Documents aged by bucket rules) → Ageing Range 1 — Amount in first user-defined range.
Computed(AR.Documents aged by bucket rules) → Ageing Range 2 — Amount in second user-defined range.
Computed(AR.Documents aged by bucket rules) → Ageing Range 3 — Amount in third user-defined range.
Computed(AR.Documents aged by bucket rules) → Ageing Range 4 — Amount in fourth user-defined range.
Computed(AR.Documents aged by bucket rules) → Ageing Range 5 — Amount in fifth user-defined range.
Report 3 – Ageing Analysis Report Detail
Input Parameters
From Debtor Code — Number — Mandatory — Starting debtor code (inclusive).
To Debtor Code — Number — Mandatory — Ending debtor code (inclusive).
Debtor Group — Dropdown — Optional — Filter by debtor group.
Currency Code — Dropdown — Optional — Report currency; filters balances by selected currency.
As at Date — Date — Mandatory — Cut-off date for outstanding/ageing.
Status — Dropdown — Optional — Debtor status (Active, Inactive, Closed).
From Ref. No. — Number — Optional — Starting reference number range.
To Ref. No. — Number — Optional — Ending reference number range.
Ageing Periods — Number — Optional — Defines the number/duration of ageing buckets.
Output Parameters (Data Source → Field — Description)
Debtors.Code → Debtor Code — Unique identifier assigned to the debtor.
Debtors.Name → Debtor Name — Name of the debtor/entity.
DebitNotes.VoucherNo OR GL.Vouchers.Number → Voucher No. — Reference number of the voucher linked to the DN.
Computed(AR.DebitNotes − Receipting.Allocations up to AsAt) → Total — Outstanding amount for the DN as at date.
Computed(DN aged by bucket rules) → Ageing Range 1 — Amount in first range.
Computed(DN aged by bucket rules) → Ageing Range 2 — Amount in second range.
Computed(DN aged by bucket rules) → Ageing Range 3 — Amount in third range.
Computed(DN aged by bucket rules) → Ageing Range 4 — Amount in fourth range.
Computed(DN aged by bucket rules) → Ageing Range 5 — Amount in fifth range.
Report 4 – Cheque Register (Returned & Postdated)
Input Parameters
From Date — Date — Mandatory — Start date of the period for cheque records.
To Date — Date — Mandatory — End date of the period for cheque records.
Bank — Dropdown — Optional — Filter by bank.
Branch — Dropdown — Optional — Filter by branch.
Amount From — Number — Mandatory — Include cheques with amount ≥ this value.
Amount To — Number — Mandatory — Include cheques with amount ≤ this value.
Cashbook — Dropdown (Ledger Account) — Optional — Filter by ledger account.
Output Parameters (Data Source → Field — Description)
Cheques.ChequeNo → Cheque No. — Deposited cheque number.
Cheques.ChequeDate → Cheque Date — Cheque date entered by customer.
Banks.Name → Bank — Issuing/deposit bank name.
Branches.Name → Branch — Issuing/deposit branch name.
Cheques.Status → Status — Returned or Postdated.
Debtors.Name OR Intermediaries.Name → Received From — Party from whom the cheque was received.
Cheques.CurrencyCode → Currency — Currency of the cheque amount.
Cheques.Amount → Amount — Total cheque value received.
Computed(SUM(Allocations.AppliedAmount) for cheque receipt) → Utilized Amount — Amount set off/used.
DebitNotes.DNNo (via Allocations) → Debit Note No. — Linked debit note reference.
Receipts.TransactionDate → Received Date — Date the cheque was received.
Users.DisplayName (via Receipts.CreatedBy) → Received By — User who recorded the cheque.
Receipts.ReceiptNo → Receipt No. — System-generated receipt number for the cheque transaction.
BankDeposits.DepositedDate → Deposited Date — Date the cheque was deposited to bank.
BankDeposits.Amount → Amount (Deposited) — Amount deposited (same or partial).
DepositSlips.SlipNo → Deposit Slip No. — Deposit slip reference number.
BankAccounts.AccountNo → Bank Account No. — Account number into which the cheque was deposited.
Users.DisplayName (via BankDeposits.CreatedBy) → Deposited User — User who recorded the bank deposit.
ChequeReturns.Reason → Reason for Return — Return reason (e.g., insufficient funds).
Report 5 – Deposit Slip Register
Purpose: Unify daily financial records (banking, shared deposits, receipt entries, and deposit slip details) into one consolidated report for reconciliation and audit tracking.