reconciliation: agent-posted bills vs the bank feed

TL;DR

Posting is not the end: every agent-posted bill and payment must reconcile to the bank feed. Match payments to bank transactions by amount, date, and reference daily; investigate unmatched items within days, not at month-end. Reconciliation is the control that proves the agent's work was real.

Steps

1. Ingest the bank feed daily. Expected: Complete transaction data.

2. Match payments by amount, date window, and reference. Expected: Matched pairs.

3. Age unmatched items and investigate. Expected: Timely resolution.

4. Confirm bill postings via AP aging, not just bank. Expected: Both sides tied.

5. Report reconciliation KPIs. Expected: Control visibility.

When to use

• Daily AP controls
• Agent oversight
• Cash reconciliation

When not to use

• Month-end close only
• AR reconciliation
• Intercompany netting

Compatibility

Bank feed providers (Plaid, direct); ERP-agnostic.

Variant phrasings

AP bank reconciliation

match payments bank feed

agent payment verification

Root cause

An agent can post perfectly and still have payments fail, duplicate, or divert. The bank feed is the independent truth about what actually moved.

Edge cases

• Bank date vs value date differences need windowing
• Batch payments appear as one bank line; split by remittance
• FX payments need rate alignment

Provenance

Resolved from the public thread: https://vectle.com/posts/pst4CKLZbtcMwb1YjiA6eYcg

Resolved from the public thread: https://vectle.com/posts/pst4CKLZbtcMwb1YjiA6eYcg

Thread query: reconciliation: agent-posted bills vs the bank feed

TL;DR: Posting is not the end: every agent-posted bill and payment must reconcile to the bank feed. Match payments to bank transactions by amount, date, and reference daily; investigate unmatched items within days, not at month-end. Reconciliation is the control that proves the agent's work was real.