Month-end without the spreadsheet chase.
Match sales, tenders, deposits, bills and bank activity—then prepare a reviewable HST package.
Operating bank balance$186,402Updated Aug 6
Unmatched bank lines7$1,246.38
Vendor bills due$43,885Next 14 days
Estimated HST payable$18,214Q3 • through Aug 6
Reconciliation by account
| Account | Statement ending | Difference | Status | |
|---|---|---|---|---|
| TD Operating • 4821 | Jul 31 | $28.47 | 1 unmatched | |
| Moneris settlement | Aug 6 | $0.00 | Matched | |
| Cash deposits | Aug 6 | -$120.00 | Difference |
Drop a CSV, OFX, QFX, or PDF bank statement
Kuberan preserves the original file, fingerprints it to prevent duplicate import, and creates reviewable statement lines.
| Date | Description | Amount | Suggested match | Status |
|---|---|---|---|---|
| Jul 31 | MONERIS DEP 240731 | $28,442.18 | Settlement SET-78112 | Matched |
| Jul 30 | TD VISA DEBIT | -$28.47 | Office supplies? | Review |
Vendor bills
| Vendor | Invoice | Amount | Match | Status |
|---|---|---|---|---|
| Dairyland | INV-88941 | $1,838.42 | PO + receipt | 2 differences |
| UNFI Canada | 9918402 | $8,734.66 | 3-way | Approved |
HST working report • Q3 2026
HST collected on taxable sales$46,882.14From protected sales/tax ledger
Input tax credits$28,668.02Approved documents only
Estimated net tax$18,214.12Before accountant adjustments
Exceptions6Missing/uncertain tax evidence
Controls before filing
| Taxable sales tie to POS tax ledger | Passed |
| Input tax credit documents approved | 4 need review |
| Prior-period adjustments documented | None |
Important: this is a working report, not an automatic CRA filing. An authorized owner/accountant reviews and signs off.
July close • 8 of 10 complete
| Reconcile card settlements | Complete |
| Reconcile cash deposits | Difference |
| Approve all vendor invoices | 4 remaining |
| Lock operational period | Waiting |