Template
Vendor Invoice Processing Checklist:Duplicate and Vendor File Checks, Three-Way Match, Job Coding, Kentucky Use Tax, Terms, Bank-Detail Changes and 1099 Status, with a Filled Louisville Batch
Vendor invoice processing checklist for a service company: three-way match, job coding, Kentucky use tax, terms and 2026 1099 status, filled for Louisville.
A vendor invoice processing checklist lists the accounts-payable checks a supplier's bill passes before payment: the vendor is on file, the bill is not a duplicate, it matches the purchase order and the receipt, it carries a job code, its tax and terms are right, and the vendor's 1099 status is known. The filled batch is from Louisville, Kentucky.
This checklist belongs to the free field service templates of FieldRanger, which builds field service software inside HubSpot. The table lists the checks, and the page offers them as a free .xlsx download with no sign-up. It covers bills a service company receives from supply houses, online sellers, rental yards and subcontractors. Bills the company sends to its own customers go through the invoice checklist instead.
Vendor invoices and customer invoices in a service company
The two checklists face opposite directions and meet on the job. A customer invoice, laid out on the invoice template, bills parts at the quantity a technician used. A vendor invoice bills the company for those parts at the quantity the supplier shipped. When a water heater appears on a customer's bill, a supplier invoice in the payables file should show what it cost, and both should carry the same job number.
The matching logic is the buyer's side of a transaction the seller sees differently. The guide to invoice vs purchase order sets out the three-way match from the point of view of a contractor billing a client that issues purchase orders. This checklist is the same control run by the contractor on its own suppliers.
Vendor invoice processing checklist items
Each check names the condition that passes it and the record kept. Checks 1 to 4 decide whether the bill is real and new, 5 to 9 whether it is right, and 10 to 15 whether, when and how it is paid and reported.
| # | Check | Passes when | Record kept |
|---|---|---|---|
| 1 | Logged | Date received, vendor, invoice number, invoice date and amount entered in the payables log | Payables log |
| 2 | Vendor on file | The vendor exists in the vendor list with a current Form W-9 showing name, taxpayer identification number and entity type | Form W-9 |
| 3 | Not a duplicate | No earlier entry with the same vendor and invoice number, or the same vendor, amount and date | Search of the payables log |
| 4 | Remittance details unchanged | Bank or remit-to details match the vendor file; any change was confirmed by calling a number already on file | Vendor file, call note |
| 5 | Purchase order match | The PO number is on the invoice, the PO is open, and quantities and prices agree within tolerance | Purchase order |
| 6 | Receipt match | A receiving record, delivery ticket or signed work order shows the goods arrived or the work was done | Receiving record or work order |
| 7 | Job and cost code | Each line carries a job number and a cost category: materials, subcontract, rental, tools or overhead | Coding on the invoice |
| 8 | Arithmetic and charges | Extensions and totals are right; freight, fuel and restocking charges appear only where the agreement allows them | Recalculation |
| 9 | Sales or use tax | Tax charged at the right rate on taxable items, or use tax accrued where the seller charged none | Tax note on the invoice |
| 10 | Credits applied | Open credit memos and returned cores from the vendor are netted | Credit memo |
| 11 | Terms and due date | Due date and any early-payment discount computed from the invoice date and terms | Terms on the invoice |
| 12 | Approval | Approved by the person the dollar threshold names | Approval initials or log |
| 13 | 1099 status | The vendor is marked reportable or not, and payments for services are added to its year-to-date total | Vendor file, 1099 tracking column |
| 14 | Paid and referenced | Payment made by the method and date set; check or transfer reference on the invoice | Payment record |
| 15 | Filed | Invoice filed with its purchase order, receipt and payment record | Payables file |
Three-way match, tolerance and the receipt for services
A three-way match pairs the purchase order, the receipt and the invoice before payment. The order states what the company agreed to buy, the receipt states what arrived, and the invoice states what the vendor says it shipped. A bill that matches neither is not paid until one of the three changes.
Two features of a service company change the receipt. Parts delivered to the shop have a receiving record, but parts delivered to a job site have a delivery ticket signed by a technician, and that ticket is the receipt. Subcontracted work has no delivery at all. The signed work order or the customer's sign-off is the receipt, and a subcontractor's bill matches its order against the closed job.
The tolerance is a policy, written once. The sample company's rule holds any line that differs from its purchase order by more than the lesser of 5 percent or $100. A tolerance that is not written down becomes whatever the clerk decides on the day the bill arrives.
Kentucky sales and use tax on supplier invoices
Check 9 has two outcomes in Kentucky, and both come from one rate. The Department of Revenue states that "Kentucky Sales and Use Tax is imposed at the rate of 6 percent of gross receipts or purchase price." It adds that "There are no local sales and use taxes in Kentucky" (Kentucky Department of Revenue, Sales and Use Tax, checked November 13, 2026). The same page describes use tax as a back stop for sales tax. It falls on tangible personal property bought for storage, use or consumption in Kentucky, generally property bought outside the state and used inside it.
A Kentucky supplier's invoice therefore shows 6 percent on taxable items, and check 9 confirms the base and the rate. An out-of-state seller's invoice with no Kentucky tax on a taxable item does not end the matter. The company accrues 6 percent use tax on the purchase price and reports it on its own return. The tax note on the invoice records which of the two happened.
Payment terms and the early-payment discount
Check 11 turns the terms into a date and a number. Terms of "2/10 net 30" allow 2 percent off for payment within 10 days, with the full amount due at 30. Skipping the discount means paying 2 percent to hold $98 for 20 more days: 2 ÷ 98 × 365 ÷ 20, or 37.2 percent a year. The calculation tells the owner which discounts to take when cash allows, and the due date tells the clerk which bills to pay first when it does not.
Form 1099 status for service vendors in 2026
Check 13 starts at the W-9 and ends in January. The IRS states that a business files Form 1099-NEC for services performed by someone who is not its employee, including parts and materials. "For payments made in 2026, the reporting threshold is $2,000"; payments made before 2026 used $600 (IRS, Am I required to file a Form 1099 or other information return, updated July 10, 2026). No return is required if "the payment was made to another business that is incorporated, and the payment is not for medical or legal services".
The instructions for 2026 filings set the remaining rules (IRS, Instructions for Forms 1099-MISC and 1099-NEC, read November 13, 2026). Form 1099-NEC is due "on or before January 31". Payments for "merchandise, telegrams, telephone, freight, storage, and similar items" are exceptions. Card payments reported by the payment settlement entity on Form 1099-K "are not subject to reporting on Form 1099-MISC or Form 1099-NEC". Parts count with the service only "if supplying the parts or materials was incidental to providing the service".
A vendor that will not supply a taxpayer identification number moves check 2 from paperwork to withholding. The IRS describes backup withholding "at the current rate of 24 percent" for payees who fail to provide a correct number (IRS, Backup withholding, updated October 10, 2026). The W-9 is collected before the first payment, not in January.
Filled vendor invoice processing checklist: Louisville service company batch
The company does residential plumbing and HVAC service in Louisville. The batch is four bills processed on Thursday, November 12, 2026. The company, vendors, prices and policies are samples; the tax rate and the 1099 rules come from the sources above.
| Invoice | Vendor | What it bills | Amount |
|---|---|---|---|
| A: 55102, Nov 9 | Example Supply Co., Louisville, a corporation | 200 ft of 3/4-inch Type L copper, a fittings lot and a 40-gallon water heater on PO 4471 | $1,707.50 plus $102.45 Kentucky tax, $1,809.95 |
| B: 7731, Nov 6 | Example Online Tools, an Ohio seller not collecting Kentucky tax | Refrigerant recovery machine for the shop, paid by company card | $1,489.00, no tax |
| C: 2026-118, Nov 10 | Example Duct Care LLC, single-member LLC, W-9 marked individual or sole proprietor | Duct cleaning on job J-6620, PO 4480, net 15 | $1,350.00 |
| D: 88213, Oct 30 | Example Equipment Rental Inc. | Trencher, one day, plus delivery, on job J-6611 | $380.00 plus $22.80 Kentucky tax, $402.80 |
| # | Check | Result | Note |
|---|---|---|---|
| 3 | Not a duplicate | Fail, D | Invoice 88213 was paid by transfer on November 5 from the emailed copy; the mailed copy arrived November 9. Marked duplicate and filed with the payment |
| 4 | Remittance details unchanged | Pass, A to C | No changes; an email from "Example Supply" on November 10 asking to update bank details was not acted on, and the supplier's office confirmed by telephone that it had sent no such request |
| 5 | Purchase order match | Fail, A | Copper billed at $4.36 a foot against $4.10 on PO 4471: $52.00 over on an $820.00 line, beyond the $41.00 tolerance. Line held; the supplier issued a $52.00 credit to the PO price |
| 6 | Receipt match | Pass, A and C | A: shop receiving record, November 9. C: work order J-6620 signed by the customer, November 9 |
| 7 | Job and cost code | Pass | A: water heater to job J-6614, materials; copper and fittings to shop stock. B: tools. C: J-6620, subcontract |
| 9 | Sales or use tax | Accrued, B | No Kentucky tax on a taxable purchase for use in Kentucky: use tax of $89.34, 6 percent of $1,489.00, accrued for the company's return |
| 11 | Terms and due date | Pass, A | 2/10 net 30 from November 9: $33.11 discount, 2 percent of the $1,655.50 merchandise subtotal, if paid by November 19 |
| 12 | Approval | Pass | All four under the $2,500 threshold for the operations manager |
| 13 | 1099 status | Pass | A and D: incorporated, not reportable. B: card payment, outside Form 1099-NEC. C: reportable; $1,200.00 paid earlier in 2026 plus $1,350.00 is $2,550.00, over $2,000, so a 2026 Form 1099-NEC goes out by February 1, 2027 (January 31 is a Sunday) |
| 14 | Paid and referenced | Pass | A: $1,721.72 by transfer on November 18 after credit and discount. C: due November 25 |
Checks not shown passed for every bill. Three of the four bills changed: one was not paid at all, one was paid $52.00 lower and $33.11 earlier, and one added $89.34 to the company's own tax return.
The duct cleaner shows why the 1099 column keeps a running total. Neither of its two bills reached $2,000 alone, and the total crossed the threshold on the second. A company that checks 1099 status only per invoice, or only in January, finds the obligation late.
Batch procedure from mailbox to filed payment
- Log every bill on arrival, from mail and email alike, before anyone reads it for content.
- Search the log for the vendor and invoice number, then for the vendor, amount and date, and stop any match.
- Confirm the vendor's W-9 and remittance details against the vendor file, and call a number already on file about any requested change.
- Pair each bill with its purchase order and its receipt, or with the signed work order for subcontracted work, and hold lines outside the written tolerance.
- Code every line to a job or a cost category, and flag parts that will be billed to a customer.
- Recalculate the bill, confirm tax at 6 percent on taxable items, and accrue use tax where none was charged.
- Net credits, compute the due date and discount, and route for approval by threshold.
- Before releasing payment, check that every bill in the batch has a pass or a note on all fifteen checks, and that each reportable vendor's year-to-date total includes this payment.
Vendor bills and FieldRanger's job records
A payables clerk matches a supplier's parts to a job with a phone call when the job record does not say which job used them.
In FieldRanger, technicians check parts and materials out of a specific warehouse or their own truck, each its own stock location, and materials used on each job are logged for job costing. The water heater on invoice A is tied to job J-6614 by the technician's own record. Revenue reports show job revenue and margin by customer or service type, and any report downloads as CSV or Excel. The customer's invoice is generated from the completed work order, and invoices and payments sync with QuickBooks. The contractor invoicing software page describes that invoice.
The payables checks in this list run in the accounting system, and FieldRanger's QuickBooks sync carries the customer invoices and payments they are reconciled against.
Fill it in here, or download the spreadsheet
The form below is the same template: totals calculate as you type, with the spreadsheet's own formulas, and your entries stay in this browser. Download it filled in, print it or save it as a PDF, or take the blank file.
Frequently asked questions
What are the steps in processing a vendor invoice?
Log it, confirm the vendor is on file with a current W-9, check for duplicates, confirm remittance details have not changed, match it to the purchase order and the receipt, code it to a job, check the arithmetic and tax, apply credits, compute the due date and any discount, approve it, record the vendor's 1099 status, pay it and file it with its supporting documents.
What is a three-way match in accounts payable?
Pairing the purchase order, the receiving record and the vendor's invoice before payment, and paying only when quantities and prices agree within a written tolerance. For subcontracted services, the signed work order stands in for the receiving record.
What is the 1099-NEC threshold for 2026?
The IRS sets the Form 1099-NEC reporting threshold at $2,000 for payments made in 2026; payments made before 2026 used $600. Payments to incorporated businesses are exempt except for medical and legal services, and card payments are reported on Form 1099-K instead.
Does a Kentucky business owe use tax when an online seller charges no sales tax?
Kentucky imposes use tax at 6 percent on tangible personal property bought for storage, use or consumption in the state when sales tax was not paid. The business accrues it on the purchase price and reports it on its own return.
Is there a free vendor invoice processing checklist PDF or Excel file?
The download is a free .xlsx with no sign-up: a Template sheet with every check and a result column, and a Sample sheet with the filled Louisville batch. Excel or Google Sheets saves it as a PDF.
Invoice 88213 and the second copy in the mail
The batch's largest saving was the bill that was not paid: $402.80 for a trencher already settled on November 5, caught by check 3 when the mailed copy arrived. The copper credit, the discount and the use tax accrual followed from checks 5, 11 and 9, and the duct cleaner joins the January 1099-NEC list. Jobs J-6614 and J-6620 bill their customers on the forms in the free field service templates. FieldRanger keeps the parts and hours behind those bills; pricing lists its plans, and a 14-day Start free trial begins without card details.
FieldRanger runs field service inside HubSpot
Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.
Book a demo