Cash Flow Reports
Complete ledger of all money movements in your Doitpay account for accounting, reconciliation, and financial tracking.
The Cash Flow report provides a complete ledger of all money movements in your Doitpay account. Every credit and debit is recorded here, making it essential for accounting, reconciliation, and financial tracking.
Why Use Cash Flow Reports
- Complete audit trail: Every fund movement is logged
- Balance verification: Track your Disbursement and Payment balances
- Reconciliation: Match internal records with Doitpay data
- Accounting: Export data for bookkeeping
Accessing Cash Flow Reports
Navigate to REPORTS > Cash Flow from the sidebar.
Balance Summary Cards
At the top of the page, two cards show your current balances:
Disbursement
The Disbursement balance represents the total funds available for outgoing transfers. This is the money you can use to send payments to third parties, such as vendor payouts, refunds to customers, or salary transfers. When you initiate a disbursement (cash out), the amount is deducted from this balance. To top up your disbursement balance, use INVOICES > Deposit VA.
Payment
The Payment balance represents the total funds collected from incoming customer payments. This includes money received through all payment channels — Virtual Account, QRIS, E-Wallet, Credit Card, and others. As customers complete payments, the amounts are credited to this balance. These funds are eventually settled to your bank account through the settlement process.
Note
Both cards display the last update timestamp so you can verify how current the balance is. If the timestamp seems outdated, refresh the page to get the latest data.
Selecting a Date
Use the date selector to view cash flow for a specific date. Click the date button (e.g., "28 Feb 2026") to change the date.
Understanding the Table
| Column | What it shows |
|---|---|
| Transaction ID | Unique identifier for the transaction |
| Ledger Date | Date and time the transaction was recorded |
| Sub Type | Specific type (Payment, Fee, Settlement, Deposit, etc.) |
| Type | Credit (green up arrow - money in) or Debit (red down arrow - money out) |
| Method | Payment channel (QRIS, Virtual Account, E-Wallet, etc.) |
| Reference ID | Reference for cross-checking |
Tip
Each transaction may generate multiple ledger entries. For example, a QRIS payment creates both a "Payment" entry (credit) and a "Fee" entry (debit) with the same Transaction ID and Reference ID.
Transaction Types
Credit (Money In) - Green Up Arrow
| Sub Type | Description |
|---|---|
| Payment | Customer payment received |
| Deposit | Pre-fund deposit credited |
| Refund | Refund returned to your balance |
| Adjustment | Manual credit adjustment |
Debit (Money Out) - Red Down Arrow
| Sub Type | Description |
|---|---|
| Settlement | Funds settled to your bank |
| Disbursement | Outgoing fund transfer |
| Fee | Transaction or service fees |
| Refund | Refund issued to customer |
| Adjustment | Manual debit adjustment |
How to Use Cash Flow for Reconciliation
- Select the date you want to reconcile
- Review the Disbursement and Payment balance cards at the top
- Verify each transaction matches your records
- Cross-reference the Reference ID with the corresponding report page (e.g., QRIS Payment, Virtual Account)
Tip
Export to CSV and use a spreadsheet for detailed reconciliation.
Page Navigation
Use the controls at the bottom of the table:
- Page Size: Choose how many records to show (e.g., 50)
- Page navigation: Move between pages using the arrow buttons
- Go to page: Jump directly to a specific page number
Exporting Data
Click the CSV button to download cash flow data. The export includes all columns for detailed analysis.
Common Questions
Q: Why does my balance not match what I expect?
Check for:
- Pending transactions that have not completed
- Fees that have been deducted
- Settlements that have been processed
- Disbursements that have gone out
Q: What do the green and red arrows mean?
Green up arrows indicate credits (money coming in), and red down arrows indicate debits (money going out).
Q: How far back can I view cash flow?
You can select any date for which records exist. For very old records, contact support.
Q: Can I see real-time cash flow?
The cash flow updates as transactions are processed. Select today's date and refresh to see recent activity.
Best Practices
- Check daily: Review cash flow at the end of each business day
- Export regularly: Download records monthly for your accounting
- Match transaction pairs: Payment and Fee entries share the same Transaction ID
- Investigate discrepancies: Report any unexpected entries to support