The Balance Verification page provides administrators with a direct financial reconciliation tool. It compares your internal double-entry ledger database states (Expected Internal) against the actual processed cash data retrieved directly from the payment gateway APIs (Actual Gateway).
Getting here
- Log in to the OwnPay admin dashboard
- Under the REPORTS & FINANCE section in the left sidebar, click Balance Verification
Page sections
1. Verification controls
- Currency Dropdown: Select the target currency context to run the reconciliation on
- Run Verification Button: Triggers database queries and external gateway checks
2. Reconciliation results table
- CURRENCY: Audited currency code
- EXPECTED (INTERNAL): Net total calculated from internal double-entry ledger entries
- ACTUAL (GATEWAY): Net total compiled from transaction logs registered across payment gateways
- VARIANCE: The mathematical variance (Expected minus Actual). Ideally, this should show
0.00
- STATUS: Audit state indicator (
Balanced in green, or Discrepancy in red)
Fields and options reference
Step-by-step: running a balance audit
- Navigate to the Balance Verification page
- Open the Currency dropdown and select the currency to verify
- Click the Run Verification button
- Scan the table for the STATUS badge:
- If it shows Balanced with
0.00 variance, your accounting system is aligned
- If it shows Variance Detected, look at the VARIANCE column value
Best practices
- Run balance verifications before making settlements or payout distributions
- Perform audits during low-traffic periods to ensure pending checkout sessions do not cause temporary variance fluctuations
- Do not ignore non-zero variance values, even if they are minor
Always post ledger transactions within a database transaction block. If writing custom plugins or addons that interact with balances, utilize the double-entry repository to preserve balance integrity.
Common mistakes and troubleshooting
Related pages
- Ledger - Inspect individual accounting ledger sheets
- Transactions - Monitor real-time transaction updates
- Audit Log - Check modification actions history
