◆ Excel · report

Accounts Payable

Reconcile Supplier Invoices sheet to the Purchase Schedule: build two tables (Invoices and Purchase Schedule) with Inv…

2heights
2tasks
1roles do it
See the prompt↓More report workflows

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Reconcile Supplier Invoices sheet to the Purchase Schedule: build two tables (Invoices and…+
Reconcile Supplier Invoices sheet to the Purchase Schedule: build two tables (Invoices and Purchase Schedule) with Invoice date, Supplier, PO number, Amount; match on PO and Amount, flag blanks and mismatches with conditional formatting and a column showing Reconciled (Y/N).
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before I send this to Accounting, make the reconciliation hard to misread — add a…+
Before I send this to Accounting, make the reconciliation hard to misread — add a matching-score column that compares PO, supplier name and amount, colour-code unmatched items, show outstanding schedule entries older than 30 days, and include a small printable list of suspected duplicates for follow-up by the accounts payable lead.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Reconcile supplier invoices to the purchase schedule so the accounting team knows what still needs paying.

Who does this

1 roles
Architect

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.