# Delivery QA Checklist

Use this before sending any paid delivery. The goal is to catch small mistakes before the client sees them.

## File Checks

- [ ] Original client file is saved separately and not overwritten.
- [ ] Cleaned file has a clear name, such as `{client}-cleaned.csv`.
- [ ] Delivery report has a clear name, such as `{client}-cleaning-report.txt`.
- [ ] File opens in a spreadsheet app or text editor.
- [ ] CSV columns are not shifted or broken.
- [ ] Special characters display correctly.

## Spreadsheet Cleanup Checks

- [ ] Headers are present.
- [ ] Headers are normalized only if that was included in scope.
- [ ] Cell whitespace is trimmed.
- [ ] Fully blank rows are removed if that was included in scope.
- [ ] Exact duplicate rows are removed if that was included in scope.
- [ ] Custom duplicate rules were applied only if quoted.
- [ ] Blank cells are counted or flagged.
- [ ] Row count in the report matches the cleaned file.
- [ ] Duplicate count in the report matches the cleanup result.
- [ ] Any remaining blank cells are mentioned in the delivery note.

## Scope Checks

- [ ] Work matches the quote.
- [ ] No unquoted manual enrichment was added.
- [ ] No new duplicate logic was invented without client approval.
- [ ] No private account, password, wallet, seed phrase, or restricted data access was requested.
- [ ] No guaranteed sales, replies, rankings, or revenue claim appears in the delivery.

## Privacy Checks

- [ ] Client files are not used as portfolio samples.
- [ ] Demo/sample files are clearly fictional.
- [ ] Sensitive data is not pasted into public pages, screenshots, or examples.
- [ ] Client file names are not exposed in public materials without permission.

## Delivery Package

Send:

- [ ] Cleaned CSV or agreed output file
- [ ] Delivery report when included
- [ ] Client-facing summary from `client-delivery-report-template.md`
- [ ] Short delivery note
- [ ] Reminder to review blank or risky fields before import/outreach
- [ ] Minor-fix window if included in the quote

## Delivery Note

Hi {client_name},

The cleaned spreadsheet is ready.

I completed the agreed cleanup, included the cleaned file, and added the delivery report. Please review any rows with blank values before import or outreach.

If the quote included a minor fix round, send any small correction within 3 days.

For a fuller handoff, copy the client-facing section from `client-delivery-report-template.md` and paste in the key numbers from `csv-cleaner.html`.

## Final Question

Before sending, ask:

> Would I be comfortable if this delivery was reviewed publicly by the client?

If the answer is no, fix the delivery before sending.