# GL Reconciliation Assistant

**Folder:** Accounting / Accounting Manager / General Ledger Reconciliation Assistant
**Author:** MarcL

## What does it do?

Reconciling GL accounts at close is mostly manual tie-out: exporting the trial balance, pulling bank statements and subledger detail, and matching thousands of lines by hand to find the handful that don't agree.

This agent ingests the GL export plus the matching source data (bank statement, AP/AR subledger, fixed-asset register), runs a fuzzy match on date + amount + reference, and hands you back only the unmatched and partially-matched items — the exceptions that actually need a human. For each difference it proposes a clearing journal entry and builds a standardized reconciliation workpaper you can attach to the close binder. It remembers recurring reconciling items (e.g. timing differences, in-transit deposits) so they're pre-explained next month.

## Benefits

- Cuts a multi-hour manual tie-out down to reviewing an exceptions list.
- Fewer missed reconciling items and cleaner close binders.
- Proposed journal entries are ready to review, not write from scratch.
- Standardized workpapers make the next audit far easier.
- Rolling memory of recurring items means month two is faster than month one.

## Recommended setup

• MCP — Google Sheets (read GL/bank exports, write workpapers), Google Drive (pull PDF bank statements), and your ERP/GL MCP (QuickBooks, NetSuite, or Xero via a community/custom REST MCP) to pull trial balance and subledger detail directly.
• Skill — add a "reconciliation workpaper" skill that bundles your firm's tie-out template plus a PDF-statement parser, so every reconciliation comes out in the same audit-ready format.

## Installation

1. Download this file.
2. Drop it into your `.claude/agents/` folder (project or user-level).
3. Restart Claude Code — the agent becomes available as `gl-reconciliation-assistant`.

## How to use it

Invoke it at close with your GL detail and the source data for the account you're reconciling ("reconcile the operating cash account for May"). It returns matched/unmatched buckets, proposed clearing entries, and a finished workpaper.

## System prompt

You are the GL Reconciliation Assistant for an Accounting Manager. Your job is to reconcile general ledger accounts at month-end by matching GL activity against source data (bank statements, subledgers, registers).

Method:
1. Ingest the GL detail and the source data set.
2. Match on amount + date + reference, allowing small timing/rounding tolerances.
3. Output three buckets: matched, unmatched-in-GL, unmatched-in-source.
4. For each reconciling difference, propose a clearing journal entry (account, debit/credit, memo) and classify it (timing, error, missing entry, unknown).
5. Produce a reconciliation workpaper: account, period, GL balance, source balance, reconciling items, adjusted balance, and a tie-out status.
6. Flag recurring reconciling items and pre-explain them in future periods.

Be precise with numbers, never silently net differences, and always show your matching logic. Surface anything you cannot explain rather than forcing a tie-out.