# Texas Manufacturing Exempt Purchase Log Worksheet

> Source: https://netray.co/tools/texas-manufacturing-exempt-purchase-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log purchases you treat as exempt from Texas sales and use tax, with the certificate given, support on file and the tax avoided.

## Category

compliance-legal

## Region

United States

## Industry

Manufacturing

## Audience

- Accounts payable
- Controller
- Purchasing

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Invoice date

**Key:** date

**Type:** date

#### Vendor

**Key:** vendor

**Type:** text

#### Item purchased

**Key:** item

**Type:** text

#### Use

**Key:** use

**Type:** select

**Options:**

- Directly in manufacturing
- Raw material or component
- Maintenance of exempt equipment
- Office or non-production
- Resale

#### Treated as exempt

**Key:** exempt

**Type:** select

**Options:**

- Yes
- No
- Review

#### Certificate on file

**Key:** cert

**Type:** select

**Options:**

- Yes
- No
- N/A

#### Invoice amount before tax

**Key:** amount

**Type:** number

**Format:** currency

#### Combined tax rate

**Key:** rate

**Type:** number

**Unit:** %

**Help:** Total local rate for the delivery location, up to 8.25 percent in Texas.

#### Tax avoided

**Key:** tax

**Type:** number

**Expr:** amount * rate / 100

**Format:** currency

**Rows:**

**Date:** 2026-08-12

**Vendor:** Hartwell Machine Tool

**Item:** Horizontal CNC mill

**Use:** Directly in manufacturing

**Exempt:** Yes

**Cert:** Yes

**Amount:** 320000

**Rate:** 8.25

**Date:** 2026-08-30

**Vendor:** Gulf Steel Supply

**Item:** A36 steel plate

**Use:** Raw material or component

**Exempt:** Yes

**Cert:** Yes

**Amount:** 41800

**Rate:** 8.25

**Date:** 2026-09-04

**Vendor:** Office Depot

**Item:** Break room supplies

**Use:** Office or non-production

**Exempt:** No

**Cert:** N/A

**Amount:** 1250

**Rate:** 8.25

**Date:** 2026-09-18

**Vendor:** Industrial Cutting Tools

**Item:** Replacement spindle repair parts

**Use:** Maintenance of exempt equipment

**Exempt:** Review

**Cert:** No

**Amount:** 9400

**Rate:** 8.25

**Totals:**

#### Total purchases logged

**Key:** amount

**Agg:** sum

**Format:** currency

#### Total tax avoided (all rows)

**Key:** tax

**Agg:** sum

**Format:** currency

**Notes:** The Tax avoided column multiplies every row, so filter to rows marked Yes when quoting exposure. Texas rules on what qualifies as used directly in manufacturing are detailed and change by ruling. Verify with the Texas Comptroller and your adviser. This is a documentation aid, not tax advice.

## Content

**Intro:** Texas offers sales and use tax exemptions for certain tangible personal property used in manufacturing, but the burden of proof is on the buyer. This log gives accounts payable one place to record each exempt purchase, whether a certificate was given and how much tax would have applied.

**Sections:**

#### How to use the log

**Body:** Add a row for each material, equipment or repair purchase where you did not pay tax. Pick the use category, mark whether you treated it as exempt and whether a certificate was given to the vendor. Enter the combined local rate for the delivery location. Review rows flagged Review or with no certificate before your next audit. Export to Excel and keep the file with your tax records.

**Bullets:**

- Match each row to the invoice and purchase order number in your ERP
- Use the ship-to rate, not the headquarters rate
- Resolve every Review row each month

#### Texas rules in brief

**Body:** The Texas state rate is 6.25 percent and local taxes can bring the combined rate up to 8.25 percent. Property used directly in manufacturing, processing or fabricating tangible personal property for sale can qualify for exemption, and so can certain raw materials that become part of the product. Items such as general office supplies and many facility costs do not qualify. Because the line between directly used and indirectly used is often disputed, treat this log as evidence, not a legal conclusion.

#### Reading the sample

**Body:** The CNC mill and steel plate are marked exempt with a certificate on file. The break room supplies are taxable, so the correct treatment is to pay tax. The spindle repair parts are marked Review with no certificate, which is the row to resolve first: either obtain documentation or accrue use tax. The tax avoided column on that row shows the exposure if the exemption fails.

#### Common mistakes

**Body:** Frequent audit findings include missing certificates, exempting maintenance supplies that do not qualify, using the wrong location rate and not accruing use tax on out-of-state purchases that arrive without tax. Build the log from a monthly AP report filtered on tax code, not from memory at audit time.

**Cta:** A scheduled report on tax code, vendor and GL account can feed this log directly from your ERP. We can build that with your AP and tax teams.

**Faq:**

#### Do I need an exemption certificate for every purchase?

**Answer:** Vendors generally need a properly completed certificate to justify not charging tax. Blanket certificates can cover repeat purchases from the same vendor in many cases, but confirm how long they remain valid.

#### What is use tax?

**Answer:** Use tax is the buyer's tax on taxable items bought without tax being charged, often from out of state vendors. It is due at the same rate as sales tax and is reported on your Texas return.

#### Are repair parts for production machines exempt?

**Answer:** It depends on how they are used and how the rules classify them. Treat them as Review items and get a clear answer before claiming exemption.

#### Does the sheet file my return?

**Answer:** No. It documents purchases to support your return. Filing is done through the Texas Comptroller system or by your preparer.

## Search terms

texas manufacturing exemption log, texas sales tax exempt purchases spreadsheet, texas exemption certificate tracking, texas sales tax audit support worksheet, texas manufacturer use tax review, exempt purchase log excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json