How to Use the Resale and Exemption Certificate File Reviewer Prompt to Fix Gaps Before an Audit
Audit your resale and exemption certificate file before a sales tax audit does: each certificate checked against the state form rules you paste, missing fields and signatures flagged, expired or wrong state certificates found, exempt sales ranked by dollars at risk, and polite customer emails asking for corrected certificates.
When a sales tax auditor reviews exempt sales, the first thing they ask for is the certificate behind each one. A certificate on the wrong state form, missing a permit number, or past its renewal date can turn an exempt sale into a taxable one the seller owes. These problems are easy to fix while customers are still active and easy to reach, and much harder after an audit notice arrives. The Resale and Exemption Certificate File Reviewer: Missing Field Checks by State Form, Expired and Wrong State Certificates, Exempt Sales at Risk, and Customer Request Emails prompt reviews your certificate file against the rules you paste and tells you exactly what to request and from whom.
What the prompt produces
- A certificate review table with every required field marked present, missing, or unclear for the ship to state.
- Problem flags for wrong state forms, missing permit numbers, missing signatures or dates, expired certificates, item descriptions that do not match what you sell, and blanket certificates where a state requires per sale forms.
- A match to your exempt sales report that finds exempt sales with no certificate and certificates with no sales.
- Exempt sales at risk, ranked by dollars within the audit period.
- A fix plan with owners: what to request, and which customers to start charging tax until a valid certificate arrives.
- Customer request emails that name the form and the missing field.
- An intake checklist so new certificates pass review the first time.
How to fill the inputs
CertificateList lists each certificate with the customer, ship to state, form used, fields completed, signature, and date. A spreadsheet export works well.
StateFormRules is the most important input. Paste the required fields, accepted forms, and renewal rules from each state's guidance. The prompt judges certificates only against this text and marks any state you did not paste.
RegisteredStates lists where you collect tax.
ExemptSalesReport gives exempt sales by customer and state for the period. This is how the prompt ranks problems by dollars.
AuditPeriod sets the window you are preparing for.
Reading the example output
The example is a coffee roaster selling wholesale in Texas, California, and Florida. Two certificates pass the pasted rules. A California customer sent a Texas form with no permit number, which is the biggest problem by dollars. A Texas grocer's form has no date and describes the items as "all merchandise," which does not match roasted coffee. A Florida bakery's annual certificate is from 2024 but the sales are from 2025 and 2026. One Texas customer has exempt sales and no certificate at all.
The at risk ranking puts the California customer first and totals the exposure across the four problems. The fix plan assigns each request to an owner and says to charge tax on new orders for the customer with no certificate until one arrives. It also flags a question for the tax advisor about whether new certificates can support past sales, rather than answering it.
The emails are short and specific. Each one names the form, the missing piece, and a date, which makes it easy for the customer's accounts payable team to respond.
Tips for better results
- Review the file every quarter instead of once a year.
- Calendar renewal dates for annual certificates.
- Store the certificate with the customer record so sales and billing can see it.
- Keep the pasted state rules in a shared document and update them when guidance changes.
Mistakes to avoid
- Do not accept a certificate just because it is signed. Check every required field.
- Do not treat the output as a tax opinion. Questions about taxability go to your advisor.
- Do not invent permit numbers or dollar amounts to complete the table.
Who it is for
Finance and accounts receivable teams at wholesalers and distributors, bookkeepers managing several clients, and small manufacturers selling to resellers.
A practical routine
Export the certificate list and exempt sales report at quarter end, run the prompt, send the emails that week, and rerun it a month later to confirm the fixes came in.
Related PromptDig links
Review your file with the Resale and Exemption Certificate File Reviewer: Missing Field Checks by State Form, Expired and Wrong State Certificates, Exempt Sales at Risk, and Customer Request Emails prompt. For more finance and operations prompts, Browse more prompts. If you have a compliance checklist that saves your team time, Share a prompt.