---
name: accounts-payable-aging-review
description: Build an as-of-date vendor payable view from approved invoices and payments, flag duplicates and disputes, and leave payment approval to a human.
license: CC-BY-4.0
---

# Accounts Payable Aging Review

Build an as-of-date vendor payable view from approved invoices and payments, flag duplicates and disputes, and leave payment approval to a human.

This free skill is a research and planning workflow. It grants no access to private records and no authority to send, spend, publish, hire or change accounts. Use only approved inputs and keep private data private.

## Inputs

Approved AP invoice export with vendor ID, invoice number, invoice date, due date, currency and open balance; posted payments/credits; reporting as-of date and company aging buckets.

## Workflow

1. Reconcile the invoice population to the AP ledger total and mark missing dates, negative balances, duplicate vendor-and-invoice keys and mixed currencies for review.
2. Compute days past due as max(0, as-of date minus due date). Keep not-yet-due separate from 1-30, 31-60, 61-90 and 90+ day buckets, unless the company defines different buckets.
3. Net posted credits only when they demonstrably apply to the invoice. Group balances by vendor and bucket; flag disputed invoices and any date or amount inconsistency.
4. Prepare an exceptions queue and a review-ready summary. Do not send vendor messages, schedule payments, change bank details or mark a bill paid.

## Output contract

`vendor ID | invoice ID | due date | currency | open balance | days past due | bucket | dispute/credit evidence | action owner`

## Worked fictional example

Fictional ledger as of Sep 30: invoice A due Sep 20 with an unpaid $400 balance is 10 days past due and belongs in 1-30; invoice B due Oct 5 is not yet due. If both share a vendor but currencies differ, report separate totals.

## Verification and boundaries

Recompute aged total against the AP subledger by currency and reconcile invoice counts. Confirm payment and credit posting status in the accounting source before labeling an item open. A bucket is not authorization to pay.

Method source: https://www.intacct.com/ia/docs/en_US/help_action/Accounts_Payable/AP_reports/vendor-aging-report.htm