arfiti-core-reconciliation

Execute the complete reconciliation: assess current state, run the automated 6-pass matching agent, analyze remaining unmatched items grouped by party, propose manual matches (1:1, 1:N, N:1, N:N, partial), apply confirmed matches, categorize unresolvable items, and show before/after summary with match rate.

Directly match a specific payment to one or more invoices. Search for the payment, list open invoices for the same party, specify applied amounts per invoice, preview the match with status changes, and apply with confirmation. Supports partial matching and rounding write-offs up to $100.

Read-only status dashboard showing AP and AR payment reconciliation breakdown (matched, partial, unmatched), open invoice counts, aging of oldest unmatched items, and recommended next action.

Full Reconciliation

1. 1

   Assess current state — load unmatched payment and open invoice counts for AP and AR

2. 2

   Run automated reconciliation agent (6-pass matching algorithm)

3. 3

   Review agent results — how many matched, what remains unmatched

4. 4

   Group remaining unmatched items by party (vendor/customer)

5. 5

   For each party: load payments + invoices, propose manual matches using 6 strategies

6. 6

   Present match proposals as tables with amounts, logic explanation, and differences

7. 7

   User reviews and confirms matches (one confirmation per party batch)

8. 8

   Apply confirmed matches via submit("reconciliation", "match", {...})

9. 9

   Categorize unresolvable items (missing bills, unknown parties, overpayments)

10. 10

    Show before/after summary with total match rate

Quick Manual Match

1. 1

   Identify the payment (by ID or search)

2. 2

   List open invoices for the same party with amounts due

3. 3

   User specifies which invoice(s) and amounts to apply

4. 4

   Preview the match — show status changes for payment and each invoice

5. 5

   Apply after confirmation

Legal entity exists and has posted transactions

Agent run completed successfully (Mode 1)

All proposed matches are valid — same party, amounts within limits, invoice has amount_due > 0

User has reviewed and confirmed match preview before applying

Post-reconciliation counts match expected changes

Six matching strategies in priority order: exact 1:1, partial, 1:N split, N:1 group, N:N complex, rounding write-off — with decision rules and examples

AR vs AP scope configuration, submit payload format, financial update behavior, and audit trail structure

Common issues: no matches found, tax payments without bills, rounding differences, party mismatches, agent failures, and multi-currency FX handling