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.

Updated 11 min read

Download .xlsxExcel spreadsheet · 12 KB · Free, no sign-upFill it in online

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.

Vendor invoice processing checklist items, pass conditions and the record kept
#CheckPasses whenRecord kept
1LoggedDate received, vendor, invoice number, invoice date and amount entered in the payables logPayables log
2Vendor on fileThe vendor exists in the vendor list with a current Form W-9 showing name, taxpayer identification number and entity typeForm W-9
3Not a duplicateNo earlier entry with the same vendor and invoice number, or the same vendor, amount and dateSearch of the payables log
4Remittance details unchangedBank or remit-to details match the vendor file; any change was confirmed by calling a number already on fileVendor file, call note
5Purchase order matchThe PO number is on the invoice, the PO is open, and quantities and prices agree within tolerancePurchase order
6Receipt matchA receiving record, delivery ticket or signed work order shows the goods arrived or the work was doneReceiving record or work order
7Job and cost codeEach line carries a job number and a cost category: materials, subcontract, rental, tools or overheadCoding on the invoice
8Arithmetic and chargesExtensions and totals are right; freight, fuel and restocking charges appear only where the agreement allows themRecalculation
9Sales or use taxTax charged at the right rate on taxable items, or use tax accrued where the seller charged noneTax note on the invoice
10Credits appliedOpen credit memos and returned cores from the vendor are nettedCredit memo
11Terms and due dateDue date and any early-payment discount computed from the invoice date and termsTerms on the invoice
12ApprovalApproved by the person the dollar threshold namesApproval initials or log
131099 statusThe vendor is marked reportable or not, and payments for services are added to its year-to-date totalVendor file, 1099 tracking column
14Paid and referencedPayment made by the method and date set; check or transfer reference on the invoicePayment record
15FiledInvoice filed with its purchase order, receipt and payment recordPayables 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.

Batch of vendor invoices, November 12, 2026 (sample vendors and amounts)
InvoiceVendorWhat it billsAmount
A: 55102, Nov 9Example Supply Co., Louisville, a corporation200 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 6Example Online Tools, an Ohio seller not collecting Kentucky taxRefrigerant recovery machine for the shop, paid by company card$1,489.00, no tax
C: 2026-118, Nov 10Example Duct Care LLC, single-member LLC, W-9 marked individual or sole proprietorDuct cleaning on job J-6620, PO 4480, net 15$1,350.00
D: 88213, Oct 30Example Equipment Rental Inc.Trencher, one day, plus delivery, on job J-6611$380.00 plus $22.80 Kentucky tax, $402.80
Filled checklist results for the batch (sample entries)
#CheckResultNote
3Not a duplicateFail, DInvoice 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
4Remittance details unchangedPass, A to CNo 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
5Purchase order matchFail, ACopper 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
6Receipt matchPass, A and CA: shop receiving record, November 9. C: work order J-6620 signed by the customer, November 9
7Job and cost codePassA: water heater to job J-6614, materials; copper and fittings to shop stock. B: tools. C: J-6620, subcontract
9Sales or use taxAccrued, BNo 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
11Terms and due datePass, A2/10 net 30 from November 9: $33.11 discount, 2 percent of the $1,655.50 merchandise subtotal, if paid by November 19
12ApprovalPassAll four under the $2,500 threshold for the operations manager
131099 statusPassA 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)
14Paid and referencedPassA: $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

  1. Log every bill on arrival, from mail and email alike, before anyone reads it for content.
  2. Search the log for the vendor and invoice number, then for the vendor, amount and date, and stop any match.
  3. Confirm the vendor's W-9 and remittance details against the vendor file, and call a number already on file about any requested change.
  4. 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.
  5. Code every line to a job or a cost category, and flag parts that will be billed to a customer.
  6. Recalculate the bill, confirm tax at 6 percent on taxable items, and accrue use tax where none was charged.
  7. Net credits, compute the due date and discount, and route for approval by threshold.
  8. 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