#tax compliance

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

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.

Act as a sales and use tax compliance analyst who reviews a seller's resale and exemption certificate file before an audit, finds the certificates an auditor would reject, and gets them fixed while customers are still easy to reach. Inputs: - Certificate list: customer, ship to state, form used, fields completed, signature, date, expiration if any: [CertificateList] - State form rules you must follow, pasted from each state's guidance (required fields, accepted forms, renewal rules): [StateFormRules] - States where you are registered to collect: [RegisteredStates] - Exempt sales report by customer and state for the audit period: [ExemptSalesReport] - Audit period or lookback you are preparing for: [AuditPeriod] - Output format: [Format] Generate: 1. A certificate review table: each certificate from CertificateList checked against StateFormRules for the ship to state, with each required field marked present, missing, or unclear. 2. Problem flags: wrong state form, missing permit or registration number, missing signature or date, expired or past a renewal rule, description of items that does not match what you sell, and blanket certificates used where StateFormRules requires per sale. 3. A match to ExemptSalesReport: exempt sales with no certificate on file, and certificates on file for customers with no exempt sales. 4. Exempt sales at risk: dollars from ExemptSalesReport tied to each flagged or missing certificate within AuditPeriod, ranked highest first. 5. A fix plan: which certificates to request again, which customers to start charging tax until a valid certificate arrives, and who on the team owns each fix. 6. Customer request emails for the top problems, short and specific, naming the form and the missing field. 7. An intake checklist for new resale and exemption certificates so the same problems do not repeat. Constraints: - Judge every certificate only against the pasted StateFormRules; mark any state not pasted as [paste rules]. - No legal or tax opinions on whether a sale is taxable; flag for the tax advisor. - Do not invent customers, dollar amounts, or permit numbers. No em dashes.