◆ Excel · track

Financial Reconciliation

Reconcile the supplier's remittance file against our AP ledger and produce a discrepancy list with invoice number, led…

2heights

18tasks

9roles do it

The same job, four heights

do it · improve it · decide · become

AExecute — “help me do it”Reconcile the supplier's remittance file against our AP ledger and produce a discrepancy list…+

Reconcile the supplier's remittance file against our AP ledger and produce a discrepancy list with invoice number, ledger amount, remittance amount, and variance for vendor inquiries.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

BImprove — “do it better”Prepare vendor-ready discrepancies: match remittance lines to ledger using invoice and amount,…+

Prepare vendor-ready discrepancies: match remittance lines to ledger using invoice and amount, flag mismatches and missing invoices, include suggested reasons for each variance, and produce a separate sheet formatted for sending to the supplier.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

8 of them

Reconcile a supplier's detailed remittance file against our AP ledger and produce a discrepancy list for vendor inquiries.

Calculate adjusted balances after identifying errors so the financial statements reflect the correct figures.

Reconcile the monthly sales ledger against bank deposits so finance can close the month with confidence.

Reconcile the monthly invoice from our vendor to the campaign ledger so finance can clear payments without dispute.

Reconcile the small office petty-cash log to bank card statements so reimbursements and balances always agree.

Reconcile the receivables ledger to the general ledger and flag any mismatches for the collections team.

Reconcile two lists of supplier invoices to identify duplicates or missing payments before month end.

Reconcile two lists of expense claims and receipts so no reimbursements are paid twice.

Who does this

9 roles

AuditorBusiness Intelligence AnalystCampaign ManagerExecutive AssistantFinance ManagerOffice ManagerPeople Operations ManagerAccounts Payable ClerkProduction Assistant

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.