VendorOne canonical name per vendor. Feeds both duplicate rules.
Invoice numberExact-match key for the duplicate check at entry.
AmountFuzzy-match key. Checked against PO and rate sheet at entry.
POLinks the invoice to what was actually ordered.
Arrival dateSet the day the invoice arrives. Proves same-day logging.
Due dateDrives the aging alert once it passes.
Discount windowDrives the 3-business-day closing alert.
StatusExactly one of the eight below, at all times.
OwnerOffice manager or bookkeeper. Named on every row.
Dispute fieldWhat is contested, with whom, and the last contact.
Credit/claim logEvery credit and shortage claim, each with an expiry date.
LoggedArrived and captured same day. Draft awaiting approval.
EnteredDraft approved. Posted to the tracker and fed to the ledger.
Flagged duplicateMatched an existing invoice. Human decision pending.
DisputedAmount, rate, or delivery contested with the vendor.
Awaiting creditCredit or claim promised. Expiry date on the clock.
ScheduledPayment date set, inside any discount window.
PaidPayment issued and recorded in the ledger.
ClosedReconciled at month-end. No open action.