Tax & bank
Tax and reconciliation tools under Reports → category Tax & Bank.
Before you start
- Pro / Enterprise Reports access
- Sales tax configured in Settings → Taxes Setup
- For bank matching: add a bank account in Settings → Payments Setup first
Open Tax & Bank
- Reports → Report Category → Tax & Bank.
- Choose Sales Tax Summary or Match Bank to Payments.
Sales Tax Summary
Sales tax collected vs tax paid on purchases.
Steps
- Select Sales Tax Summary.
- Screen title looks like VAT Return ({start} to {end}).
- Set Period Start and Period End.
- Click Compute VAT Return.
- Read cards: Taxable Sales, Output VAT, Taxable Purchases, Input VAT, Net VAT Payable.
- Optional: Export VAT CSV (dialog Save VAT Return As).
- Use Refresh after changing periods.
Match Bank to Payments
Connect your bank lines to recorded payments.
Screen title: Bank Reconciliation.
Steps
- Select Match Bank to Payments.
- Choose Bank Account (account number).
- Click Refresh to load unreconciled lists:
- Unreconciled Payments (Label, Date, Amount)
- Unreconciled Statement Lines (Description, Date, Amount)
Import statement lines
Option A — Import Statement modal
- Click Import Statement.
- Fill Statement Date, Line Date, Opening Balance, Closing Balance, Line Description, Line Amount, Reference.
- Click Import (or Cancel).
Option B — CSV
- Use Import CSV or the paste area Paste bank CSV (Date,Description,Amount,Reference).
- Paste/import your bank file contents.
Match payments
- Click Suggest Matches to fill the suggestion grid (Score, Reason, Payment, Statement).
- Review suggestions → Accept Suggestions, or select rows and Match Selected.
- Refresh to confirm lists shrink.
What success looks like
- VAT return cards fill for the chosen period
- CSV export downloads
- Bank lines match payments and leave fewer unreconciled items
If something goes wrong
| Problem | What to try |
|---|---|
| No bank accounts | Settings → Payments Setup — add bank account |
| Suggest Matches empty | Import statement lines first; check dates/amounts |
| VAT all zero | No taxed sales/purchases in the period — widen dates |