NextSteps-Bank — Chequing Reconciliation
Section titled “NextSteps-Bank — Chequing Reconciliation”Generated by reconcile_bank.py — do not hand-edit, re-run the script instead. One section per month, appended as each statement is processed.
2025-06-30
Section titled “2025-06-30”Posted
| Date | Description | Amount | Status |
|---|---|---|---|
| 2025-06-17 | Pre-AuthorizedPaymentNoFee,BMOPAYMENT | $207.07 | already posted (Id 288) |
| 2025-06-30 | PlanFee | $6.00 | already posted (Id 289) |
| 2025-06-30 | DepositContentsfee,CHQ1@$0.20 | $0.20 | already posted (Id 290) |
| 2025-06-25 | MobileChequeDeposit → Invoice 31277 payment, Robinson Rob (SWRLEVPro renewal) | $107.35 | posted manually (hand-edited row — reconcile_bank.py’s BANK_RULES doesn’t recognize this yet, it was a one-off from Talbot’s screenshot classification 2026-07-30): Invoice Id 291 (dated 2025-05-12, the real invoice date) + Payment Id 292 |
| 2025-06-30 | DirectDeposit,AMAZON.CAMSP/DIV → KDP royalty, April 2025 sales period | $0.16 | posted manually (same one-off): Deposit Id 293, no tax |
Issues to Resolve
| Date | Description | Amount | Reason |
|---|---|---|---|
| — | Invoice 31277’s $12.35 HST — invoiced 2025-05-12, inside the already-filed Mar-May 2025 quarter, not this Jun-Aug quarter | $12.35 | Unconfirmed whether this was included in the Mar-May 2025 filing. If it was, no action needed here — it’s already reported, this June entry is just cash collection of the receivable. If it wasn’t (the “sloppy logging” Talbot flagged may extend to source data, not just filed-PDF filenames), it’s a real unreported amount needing an adjustment to a past return, not this quarter’s. |