Jump to a section
What reconciliation means here
You are comparing the transactions recorded in Cashflow Pilot with the activity and closing balance on a bank statement. Personal statement checks and Business bank reconciliation use different screens; neither should be assumed to lock all past records permanently.
1. Compare the same dates and currency
Use the beginning and ending dates printed on the statement. Confirm you are looking at the correct bank or credit-card account, and compare figures in its native currency.
2. Calculate the expected closing balance
| Example statement | Amount |
|---|---|
| Opening balance | $1,200 |
| Deposits | +$2,000 |
| Withdrawals | −$850 |
| Expected closing balance | $2,350 |
| Cashflow Pilot currently shows | $2,400 |
| Unexplained difference | $50 |
3. Investigate the $50 difference
- Missing activity: Was there a $50 debit, fee or card purchase omitted from the file?
- Sign error: Did the statement import classify a $50 withdrawal as an inflow?
- Duplicate or overlap: Was a deposit included twice when two statement files overlapped?
- Different cutoff: Is the transaction dated outside the statement period, or merely pending at the bank?
- Split/refund: Were split children counted twice or a refund treated as spending?
A transfer between your accounts changes each account's balance but is not additional household spending or business revenue.
4. Correct the source, then recheck
Inspect the relevant transaction or import before changing an opening balance. Correct the actual issue and rerun the statement comparison. Avoid adding an unexplained “balancing” transaction simply to make the number match.
Personal versus Business
In Personal, use statement checks and transaction review. In Business, inspect the bank ledger and Pending versus Posted records before comparing the bank statement. Posting a transaction to the wrong account can leave the ledger incorrect even when the overall debit and credit totals balance.
When to ask for help
If you cannot identify the difference, keep the original statement and a backup. Record the affected account, period and difference without sharing full account numbers. Continue with duplicate troubleshooting or support.
Want the bigger picture? Explore the Personal, Portfolio and Business product tour →