Marketplace/i2Business/rapprochement-grand-livre
i2Bi2BusinessSkillsVia form

Ledger reconciliation

Reconciles a third-party account (customer or supplier): compares your subsidiary ledger with the statement the third party sent you, both in PDF. Matches documents by number, checks debit/credit reciprocity, quantifies the difference and lists documents to record in a four-tab Excel workbook.

1 downloads3 files · 2 PDF inputs · 4-tab Excel workbook · Python script · Claude Cowork and Claude Code
Free download via formNo account needed: fill in the form below to receive the download link.

Description

Reconciles a third-party account (customer or supplier): compares your subsidiary ledger with the statement the third party sent you, both in PDF. Matches documents by number, checks debit/credit reciprocity, quantifies the difference and lists documents to record in a four-tab Excel workbook.

This resource is maintained by i2Business consultants and updated whenever the systems it covers change. It works with the other building blocks in the catalog and can be tailored to your context as part of a support engagement.

Download for free

Enter your details to receive the download link.

Content preview

Excerpt: the reciprocity principle the whole check relies on, with the amount identical to the cent on both sides. recoupement-tiers/SKILL.md

Supplier account in your books:
- Invoice: DEBIT at the supplier <-> CREDIT in your books
- Payment, credit note, withholding: CREDIT at the supplier <-> DEBIT in your books
A document's amount must be identical on both sides; only the direction is reversed.
Workbook produced: Summary, To record, Matched items, Credit notes.

Included files

Skill (SKILL.md)1 file
Scripts (Python reconciliation, configuration template)2 files

How to use it

1
Add the skillUnzip the archive and place the recoupement-tiers folder in your skills folder (Claude Code: ~/.claude/skills/), or import it as a skill in Cowork. Python with pdfplumber and openpyxl is required.
2
Provide both PDFsAttach your subsidiary ledger for the third party and the account statement received from them. The skill identifies each document by its content, not its file name.
3
Validate the column configurationThe two PDFs never share the same layout: the skill locates columns by coordinates and prepares a configuration file from the template. Check document prefixes and debit/credit direction.
4
Run and checkThe script produces the Excel workbook. Check that invoice totals match the totals printed on both PDFs, then that recalculating the workbook returns no errors.
5
Interpret the differenceThe difference often comes from invoices not yet recorded, credit notes, payments after the cut-off date or withholding taxes. The skill helps with matching: validation and journal entries remain the accountant's job.
Details
TypeSkills
AccessVia form
Version1.0
Updated31 October 2026
Works withClaudeClaude Code
LicenseCC BY 4.0 - source attribution: i2Business
LanguagesFrench
Size10 KB
Downloads1
Need to adapt it to your processes?

Our consultants tailor this resource to your use cases and train your teams in its day-to-day use.

Talk to a consultant
Industries covered
Services & consulting