playbooks

home / skills / eddiebe147 / claude-settings / accounts-reconciler

accounts-reconciler skill

/skills/accounts-reconciler

This skill automates account reconciliation by matching transactions across sources, flagging discrepancies, and generating variance reports to save manual

npx playbooks add skill eddiebe147/claude-settings --skill accounts-reconciler

Review the files below or copy the command above to add this skill to your agents.

Files (1)
SKILL.md
1.5 KB
---
name: Accounts Reconciler
slug: accounts-reconciler
description: Automate account reconciliation by matching transactions, identifying discrepancies, and generating variance reports
category: business
complexity: intermediate
version: "1.0.0"
author: "ID8Labs"
triggers:
  - "reconcile accounts"
  - "match transactions"
  - "find discrepancies"
tags:
  - accounting
  - reconciliation
  - finance
---

# Accounts Reconciler

Streamline account reconciliation by automatically matching transactions across multiple sources, identifying discrepancies, and generating variance reports. Eliminates hours of manual spreadsheet work.

## Core Workflows

### Workflow 1: Bank Statement Reconciliation
1. **Import Data** - Load bank statement and internal ledger
2. **Auto-Match** - Match transactions by amount, date, reference
3. **Flag Exceptions** - Identify unmatched items
4. **Document Adjustments** - Record journal entries
5. **Generate Report** - Create reconciliation summary

### Workflow 2: AR/AP Reconciliation
1. **Pull Aging** - Extract receivables/payables by customer/vendor
2. **Match Payments** - Link payments to invoices
3. **Identify Unapplied** - Find payments without matching invoices
4. **Generate Statements** - Create statements for resolution

## Quick Reference

| Action | Command |
|--------|---------|
| Reconcile bank | "Reconcile [account] for [period]" |
| Find mismatches | "Show unmatched transactions" |
| Variance report | "Generate variance report" |

Overview

This skill automates account reconciliation by matching transactions across bank statements, ledgers, and AR/AP systems, identifying discrepancies, and producing variance and exception reports. It reduces manual spreadsheet work and speeds month-end close with repeatable workflows and audit-ready documentation.

How this skill works

The tool imports transaction sets from bank statements, internal ledgers, receivables, and payables. It then auto-matches entries using configurable rules (amount, date tolerance, reference), flags unmatched or partially matched items, and records suggested adjustments or journal entries. Finally, it generates reconciliation summaries, variance reports, and statements to support resolution and audit trails.

When to use it

  • Monthly bank statement reconciliation during close
  • Reconciling AR or AP ledgers to customer/vendor aging
  • Investigating unexplained variances or large mismatches
  • Preparing audit-ready reconciliation documentation
  • Automating repetitive reconciliation tasks to save time

Best practices

  • Standardize import formats and naming conventions for sources
  • Configure matching rules with sensible date and amount tolerances
  • Review flagged exceptions promptly and attach supporting documents
  • Record and approve adjustments through controlled journal entries
  • Schedule regular reconciliation runs to avoid backlog

Example use cases

  • Reconcile a corporate checking account for a monthly period to identify timing differences and bank fees
  • Match customer payments to open invoices to find unapplied cash and short pays
  • Generate a variance report comparing ledger balances to bank balances and highlight material discrepancies
  • Produce vendor statements showing unmatched invoices to speed dispute resolution
  • Automate daily or weekly reconciliation runs for high-volume payment accounts

FAQ

What data sources can it reconcile?

It works with bank statements, internal general ledger exports, AR aging reports, and AP vendor ledgers when provided in standard import formats.

How are matches determined?

Matches use configurable rules based on amount, date tolerance, and reference fields; fuzzy matching can handle minor description differences.