How to Reconcile Payments with Bank Statements

Overview
Match recorded payments against your bank statement to ensure your books balance.

Steps

1. Export payments via Finance > Payments > Export.

2. Download your bank statement CSV.

3. In Excel or your accounting tool, match on Date, Amount, and Transaction ID.

4. Mark reconciled items; investigate mismatches.

5. For missing payments, add new records via Add Payment or Add Bulk Payment.

Tips

• Use conditional formatting in Excel to highlight unmatched rows.

• Keep transaction IDs consistent between bank and system.

Troubleshooting & FAQs

• Q: Amounts differ by minor rounding.

  • A: Check your currency decimal settings under Add New Currency and adjust decimals.

• Q: Bank shows fee deduction.

  • A: Record a separate expense for bank fees under Finance > Expenses.