bank-reconciliation

Automates the bank reconciliation process by matching transactions from bank feeds with accounting records in QuickBooks or Xero. Identifies unmatched transactions, suggests matches for review, and fl

SKILL.md

GitHub

Bank Reconciliation

Automate bank reconciliation by matching transactions across bank feeds and accounting records.

Integrations: QuickBooks

When to Use

  • Month-end reconciliation needs to be completed
  • Transaction discrepancies need investigation
  • The user mentions "bank reconciliation", "reconcile", or "month-end close"

Steps

Step 1: Import Transactions

Pull bank feed and accounting records for the period.

Step 2: Auto-match Transactions

Match transactions by amount, date, and reference number.

Step 3: Flag Discrepancies

Identify unmatched items and suggest potential matches.

Step 4: Close Reconciliation

Resolve remaining items and finalize the reconciliation.

Output

Deliver:

  • Reconciliation summary with match rate
  • Unmatched transaction lists
  • Recommended actions for discrepancies