Ledgers

View detailed transaction history and movements

Ledgers

Ledgers provide a complete, detailed record of all financial transactions and money movements in your PayMongo account. Use ledgers for accounting, reconciliation, and audit purposes.

Dashboard Overview

The Ledgers dashboard shows all financial entries with:

ColumnDescription
DateTransaction date and time
ReferenceUnique ledger entry ID
TypeTransaction category
DescriptionDetails of the entry
DebitMoney out
CreditMoney in
BalanceRunning balance

Ledger Entry Types

TypeDescription
PaymentCustomer payment received
FeePayMongo processing fee
PayoutFunds sent to bank account
RefundCustomer refund processed
TransferInternal fund transfer
AdjustmentManual balance adjustment
ChargebackDisputed payment
ReversalTransaction reversal

Understanding Entries

Double-Entry Format

Each transaction creates balanced entries:

TransactionDebitCredit
Payment received-+₱1,000
Processing fee₱35-
Net to wallet-+₱965

Entry Details

Click any entry to view:

  • Original transaction reference
  • Related payments or payouts
  • Fee breakdown
  • Timestamps
  • Notes and metadata

Filtering Entries

Filter ledger entries by:

FilterOptions
Date rangeCustom start and end dates
Entry typePayment, Fee, Payout, etc.
Amount rangeMinimum and maximum amounts
ReferenceSpecific transaction ID

Exporting Ledger Data

Export your ledger for accounting:

  1. Click "Export"
  2. Select the date range
  3. Choose columns to include
  4. Select format (CSV, Excel)
  5. Download the file

Export Fields

  • Ledger entry ID
  • Date and time
  • Transaction type
  • Description
  • Debit amount
  • Credit amount
  • Running balance
  • Related reference IDs

Reconciliation

Use ledgers to reconcile your accounts:

Daily Reconciliation

  1. Export daily ledger
  2. Match with bank statements
  3. Verify all payouts received
  4. Identify discrepancies

Monthly Close

  1. Export monthly ledger
  2. Generate summary reports
  3. Match totals with accounting
  4. Archive for records

Understanding Balance Changes

Credits (Money In)

SourceDescription
Customer paymentsSuccessful transactions
Refund reversalsCancelled refunds
AdjustmentsManual credits
Transfers inFrom other wallets

Debits (Money Out)

SourceDescription
PayoutsBank transfers
RefundsCustomer refunds
FeesProcessing charges
ChargebacksLost disputes
Transfers outTo other wallets

Best Practices

PracticeRecommendation
Regular exportsExport ledger data weekly or monthly
Reconcile oftenMatch with bank statements regularly
Archive recordsKeep exports for audit purposes
Monitor anomaliesReview unusual entries promptly

Feel free to reach out to [email protected] if you have questions about ledgers!