Bank-to-GL reconciliation

AI bank-to-GL reconciliation for Canadian CPAs

Upload the bank export and the GL cash account and get matched rows plus two clean lists: unmatched bank items and unmatched GL items. The tedious matching is done before you start.

How it works

1. Step 1

   Upload bank + GL exports

   Attach two files — the bank statement export and the GL cash account export.

2. Step 2

   Matching runs

   Rows are paired by amount, date tolerance, and description similarity.

3. Step 3

   Review the unmatched lists

   Get matched pairs plus separate unmatched-bank and unmatched-GL lists to clear.

What you get

• Matched rows
• Unmatched bank
• Unmatched GL

Frequently asked questions

What formats do the two files need?

Standard CSV or XLSX exports work. The skill asks you to tag which file is the bank side and which is the GL side, then handles the column mapping.

Is the output generated by an LLM?

No. The workpaper numbers are computed by deterministic spreadsheet logic — the same inputs always produce the same outputs. AI is only used to route your request and explain the results, so every figure is traceable to source rows.

What happens to my uploaded file?

Files are processed to build your workpaper and stay attached to your private conversation. They are not used to train models.