Workflow · Reconcile · Opening soon
Supplier invoice price vs PO price
Compare each supplier invoice line to the purchase order line it should match. You can see which lines bill above the PO rate and which agree.
Someone typed
“show every vendor bill line against the po lines, compare billed unit rate to the po rate and flag over-rate, duplicate line, or otherwise Agrees in status”
The agent read it as
show every Vendor Bills against the Purchase Order Lines, compare billed unit rate to the po rate and flag over-rate, duplicate line, or otherwise Agrees in status
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
File
Vendor Bills
CSV export · 24 rows
File
Purchase Order Lines
CSV export · 22 rows
Join
Bring in PO rate
24 of 24 paired
Step
Flag statuses
Step 2
Result
Vendor bill rate flags
24 rows · 2 flagged
Schedule
Runs when you say
Proposed
- FileVendor BillsCSV export · 24 rows
- FilePurchase Order LinesCSV export · 22 rows
- JoinBring in PO rate24 of 24 paired
- StepFlag statusesStep 2
- ResultVendor bill rate flags24 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 24 of 24 rows.
- Download Vendor Bills sample (24 rows)NetSuite: Transactions > Payables > Vendor Bills > Export (line-level search)
- Download Purchase Order Lines sample (22 rows)NetSuite: Transactions > Purchases > Purchase Orders > Export (line-level search)
What you get back
The result of that run, the rows to look at first.
Vendor bill rate flagsSample data24 rows
22 agrees2 over-rate
| Bill number | Bill date | Related PO | Bill vendor | Bill item ID | Bill quantity | Bill rate | Bill amount | PO rate | Status |
|---|---|---|---|---|---|---|---|---|---|
| VB-5015 | 2026-09-25 | PO10025 | Northwind Packaging Co | ITM-1002 | 180 | 2 | 352.80 | 1.8 | Over-rate |
| VB-5023 | 2026-10-29 | PO10030 | Blue Harbor Logistics | ITM-1003 | 600 | 1.8 | 1,056 | 1.7 | Over-rate |
| VB-5020 | 2026-10-26 | PO10030 | Blue Harbor Logistics | ITM-1004 | 50 | 8.6 | 427.50 | 8.6 | Agrees |
| VB-5014 | 2026-09-19 | PO10024 | Evergreen Printworks | ITM-1007 | 1,000 | 0.2 | 190 | 0.2 | Agrees |
| VB-5021 | 2026-10-28 | PO10031 | Summit Office Supply | ITM-1005 | 90 | 6.1 | 544.50 | 6.1 | Agrees |
| VB-5017 | 2026-10-10 | PO10027 | Summit Office Supply | ITM-1005 | 60 | 6.1 | 366 | 6.1 | Agrees |
| VB-5019 | 2026-10-23 | PO10029 | Northwind Packaging Co | ITM-1001 | 400 | 0.4 | 172 | 0.4 | Agrees |
| VB-5019 | 2026-10-23 | PO10029 | Northwind Packaging Co | ITM-1002 | 100 | 1.8 | 180 | 1.8 | Agrees |
| VB-5012 | 2026-09-09 | PO10022 | Blue Harbor Logistics | ITM-1003 | 300 | 1.7 | 522 | 1.7 | Agrees |
| VB-5014 | 2026-09-19 | PO10024 | Evergreen Printworks | ITM-1008 | 150 | 1.6 | 232.50 | 1.6 | Agrees |
| VB-5015 | 2026-09-25 | PO10025 | Northwind Packaging Co | ITM-1001 | 700 | 0.4 | 287 | 0.4 | Agrees |
| VB-5021 | 2026-10-28 | PO10031 | Summit Office Supply | ITM-1006 | 300 | 0.4 | 108 | 0.4 | Agrees |
How do you compare invoice price variance to PO price?
Export your vendor bills and purchase orders from NetSuite, then load the files into the workflow. It matches invoice lines to PO lines, brings in the PO rate, and flags each line as Agrees, Over-rate, or Duplicate line. You can then list the lines billed above the PO price.
How it works
How to use the Vendor bill rate flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Vendor bill rate flags: questions
What export should I use?
Use exported spreadsheet files from the system that holds your supplier invoices and purchase orders. The workflow reads those exported rows and compares the line items it finds.
What happens to rows that do not match?
Rows that do not find a clear match are still shown, but they are flagged so you can review them. They are not dropped from the workflow.
How do I change the matching rules?
You change the rules in words by telling the workflow what fields to compare and what status to assign when values match or differ. For example, you can adjust which columns define the invoice line, the PO line, and the over-rate check.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Duplicate payments checkCheck for duplicate payments in QuickBooks exports by matching vendor payments to bills and flagging duplicate payment cases.See the workflow Built by the agent
- Deposit reconciliationMatch bank statement exports to QuickBooks deposits exports by date and amount, then see which deposits agree and which are missing.See the workflow Built by the agent
- Match an Amex statement to QuickBooksMatch Amex statement lines to QuickBooks card charges by date, payee, and amount. See which lines agree, are missing, or are duplicates.See the workflow Built by the agent
- Match Brex transactions to QuickBooksMatch exported Brex card transactions to QuickBooks expenses by date and amount, then see which rows agree and what needs a check.See the workflow Built by the agent
- Match Expensify reports to XeroCheck approved Expensify expenses against Xero bills, see which match, and list rows that need a look.See the workflow Built by the agent
- Match Ramp transactions to NetSuiteMatch Ramp card transactions to your NetSuite credit card register, then flag agreed, missing, mismatched, and extra lines.See the workflow Built by the agent