SG Bank Reconciliation Kit
Month-end bank reconciliation without the hours of ticking. The skill matches your bank statement export against the ledger, puts every unmatched line into an exception queue with its likely cause, and prepares the reconciliation statement. It never posts or edits an entry: you decide.
Hours spent ticking bank lines against the ledger, and month-end held up by a difference nobody can find.
A bank statement export (CSV or Excel) and the ledger export for the same account and period, e.g. Xero Account Transactions.
Proposed matches with the reason for each. Exception queue: bank fees, interest, timing items, duplicates, wrong amounts. Bank reconciliation statement that ties to the cent.
Never posts or edits an entry. Ties go to the exception queue instead of being guessed, and you approve every adjustment.
S$49.50 one-off (11.11 price until 11 Nov, then S$99). SGD, no GST.
Case study: the problem it fixes
Illustrative scenario, not a client story
It is working day 3 and the bank account is out by a small amount. Someone scrolls through two exports side by side, ticking lines, and finally finds a bank charge nobody recorded and a cheque that has not cleared.
Why it costs money, not free
The matching rules, the exception queue and a statement that must tie to the cent are what close the month on time. It also never posts anything, so nothing changes in your books without your approval. Every kit is written and tested by a Chartered Accountant (Singapore), kept to current Singapore rules, and comes with the artifact, templates and setup sheet, not just a prompt.
How it works
- Maps your bank and ledger files
- Proposes matches by amount, date and reference
- Puts every unmatched line in an exception queue with a likely cause
- Prepares the reconciliation statement and the adjustments for approval
- Skill instructions (SKILL.md) with the matching rules and checks
- Python matcher that writes matched.csv and exceptions.csv
- Sample bank and ledger files
- Company setup sheet for accounts, matching window and approvers
- Interactive artifact: Bank reconciliation statement (opens in your browser or in Claude)
- Proposed matches with the reason for each
- Exception queue: bank fees, interest, timing items, duplicates, wrong amounts
- Bank reconciliation statement that ties to the cent
- List of adjustments for your approval
Try this first:
Here are October's DBS statement and the Xero bank account transactions. Reconcile them.
- Download the ZIP from your order email or your account.
- Open the setup sheet and fill in your company details (about 10 minutes).
- Claude: open Customize, then Skills, upload the skill folder as a zip and switch it on.
- ChatGPT or Copilot: paste SKILL.md into a Project, Custom GPT or agent and attach the other files as knowledge.
- Run the test prompt on the "What you get" tab.
Licence. One company, unlimited internal use. You may edit the files for your own company. You may not resell, share publicly or redistribute them.
Refunds. Skills are delivered instantly, so purchases are final once the download is opened. If a kit does not work as described, email us within 14 days and we will fix it or refund you.
Upgrades. A one-off kit purchase and the one-off customisation service cover the version delivered on the day. Later skill upgrades (updated SKILL.md, references and templates) are included only with the Finance Skills Plan or HR Skills Plan while the plan is active.
Plans. The Finance Skills Plan is S$99 a month and the HR Skills Plan S$59 a month, billed by card until you cancel. Cancel any time in your account; access continues to the end of the paid month. Downloads made during the plan stay usable under the same one company licence. Customisation is not included in a plan.
Customisation. Delivered within 7 days of receiving all the documents we ask for. First revision free; further revisions S$120 each. Customisation fees are refundable in full until work starts.
Not professional advice. Skills are general reference tools for Singapore businesses. Review every output before use and take legal or tax advice for contested or high value matters.
Two ways to start
Buy this skill
S$49.50 one-off (11.11 price until 11 Nov, then S$99). SGD, no GST. Instant download after payment.
Get a free costed proposal
Need it built around your own systems instead? Get a written proposal with a fixed price within 3 working days, then a 30-minute call.
Request a free proposal