Wallet transfers booking

Purpose

To ensure wallet transfers between a client’s own accounts are correctly booked in the general ledger with no net financial impact.

Data sources

1. Wallet transactions: Source data containing wallet-to-wallet transfer activity.
2. Configuration files
   • Chart of accounts
   • Allowed ledger accounts
   • Ledger entry logic

Key processing steps

1. Wallet transaction preparation

• Filters out test accounts
• Selects only wallet transfer transactions
• Standardizes date formats and currency codes

2. Transfer aggregation and pivoting

• Aggregates wallet transfers by relevant booking dimensions (e.g. currency)
• Produces a pivoted view used for journal entry creation
• Preserves detailed transaction data for reference

3. Journal entry logic

• Applies predefined ledger logic to wallet transfers
• Determines debit and credit sides based on configuration
• Ensures each transfer results in balanced postings

4. Account mapping

• Maps transactions to the correct client payable accounts
• Uses the chart of accounts and allowed-account rules
• Applies currency-specific account selection where required

Outputs

• Journal entries: Balanced wallet transfer bookings ready for posting.
• Pivot summary: Aggregated view of wallet transfers used for reconciliation.
• Wallet transactions: Original transaction-level data retained for auditability.