What to paste into the tool
Task: Excel workbook with match, rate check and cap test formulas. Create an .xlsx workbook with one sheet for the lines, one for the match and one for the cap test, using working formulas that the reviewer can read. Mark a line UNMATCHED when no PO line fits and ESTIMATED where the match is a guess. State on the output that no goods receipt exists, so receipt-based confirmation is impossible, that this is a two-way match and not payment approval, and mark estimated matches as ESTIMATED. Task: Draft match table of invoice lines to PO lines with rate and cap checks, plus an exception list. List every unmatched line, rate difference and cap breach with the line IDs, the PO values and the invoice values, and keep the receipt statement on the output. State on the output that no goods receipt exists, so receipt-based confirmation is impossible, that this is a two-way match and not payment approval, and mark estimated matches as ESTIMATED.