QuickBooks Import Spreadsheet Validation Checklist

Reference checks

• Customer, supplier, product, account, tax-code, and payment-term names match active QuickBooks records.
• Company and currency are correct for the intended import.
• Document numbers and external references are not already in use.

Row checks

• Required headers are present once and spelled consistently.
• Dates are real dates, amounts are numeric, and quantities are positive where required.
• Each document's lines balance to the expected subtotal, tax, and total.
• Blank rows, formulas returning empty strings, and hidden stale values are removed.

Safe import sequence

1. Run a read-only validation.
2. Correct the sheet and revalidate until clean.
3. Post a tiny representative batch.
4. Verify it in QuickBooks, then continue.
5. Retain created record IDs and errors in the sheet.