ZenotiHelp

Audit Import — Export and Import the Audit Template

ZTZenoti Docs Team Updated November 10, 2026 4 min readGuide

Audience: Center admin, inventory manager


On this page


When you export an audit template and then import completed audit data, the column structure of those files reflects your organization's configured stock quantity model. The templates for import and export carry an on-hand quantity column as the standard. The audit import page reads your organization's configured stock quantity model and passes it to both the export template generator and the import validator, so the file you download always matches what the import expects.

Important: Export a fresh template before each audit cycle. A template downloaded before your organization's stock quantity model was last updated will not match the current import validator and will be rejected.

Before you begin

  • Your organization must have inventory enabled.
  • You must have the InvList permission under Inventory Manager to access the audit import page.
  • At least one open, unreconciled audit must exist before you can import audit data against it.

How the audit template is structured

The audit template column structure is determined at the moment you select Export on the audit import page. The system reads your organization's configured stock quantity model at that point and builds the file accordingly.

The templates for import and export carry an on-hand quantity column, which is the standard column for recording audited quantities. The import validator applies the same model when you upload a completed file. If the uploaded file's column structure does not match your organization's current configuration, the validator rejects the file and displays an error.

Note: If your organization's stock quantity model changed after you exported a template, the old template will fail validation. Download a fresh template after any configuration change is complete.

Steps

Export the audit template

  1. Navigate to Inventory > Audit.

  2. Open an existing audit or create a new one.

  3. Select Import to open the audit import page.

  4. Select Export to download the template file.

    The system reads your organization's configured stock quantity model and generates the file with the appropriate column structure. The templates for import and export carry an on-hand quantity column, labeled On Hand Quantity, for recording audited quantities.

  5. Open the downloaded file and enter audited quantities in the appropriate column for each product.

  6. Save the file without changing column headers, column order, or file format.

Validate and import the audit file

  1. Return to the audit import page.

  2. Select the completed template file.

  3. Select Validate.

    The import validator reads your organization's configured stock quantity model and checks that the file's column structure matches. The validation summary shows Total:, Valid:, and Failed: row counts, along with any Errors or Warnings.

  4. Review any errors listed in the Errors section. Correct the file if rows are flagged, then repeat the validation step.

  5. When the validation summary shows no errors, select Continue to import the data.

  6. Confirm the import when prompted. The audited quantities are applied to the open audit.

Note: You cannot make changes to an audit once it has been submitted. Select Save Changes if you want to save progress and return to the audit later before submitting.

Submit the audit

  1. After importing, review the audit summary:

    • No. of Audited Products
    • No. of Products Not Audited
    • Total No. of Products
    • Total Products Being Submitted
  2. Add any Comments if required.

  3. Select Submit Audit to submit the audit for reconciliation.

    Important: Once submitted, the audit is locked and sent to the owner for reconciliation. You cannot make further changes.

Worked example

You navigate to the audit for your center, select Export, and receive a file with an On Hand Quantity column. You enter quantities — for example, 16 units for a moisturizer — save the file, and upload it. The validator confirms the column structure matches your organization's configured stock quantity model and shows 48 valid rows and 0 failures. You select Continue, then Submit Audit.

If you attempt to upload a template exported before a recent configuration change, the validator rejects the file because the column structure no longer matches the current model. Export a fresh template and re-enter your quantities.

Tips

  • Always export a fresh template immediately before conducting each audit cycle. Templates downloaded weeks earlier may no longer match your organization's configuration, especially after a model change.
  • If you need to audit only a subset of products, check whether your organization has the Enable partial audit of products setting active. When enabled, you can include only the products you audited and leave the rest unsubmitted.
  • Keep the exported template file in its original format. Saving as a different file type or adding extra columns causes the validator to reject the file.
  • After validation, review the Warnings section even when no errors exist. Warnings may indicate products with zero quantities or products that were not found in the current audit.

Troubleshooting

Symptom Likely cause Resolution
Validation fails with a column mismatch error The template was exported before your organization's stock quantity model was last updated, or the file was edited manually Export a new template from the audit import page, re-enter your quantities, and re-upload
All rows show as Failed after validation The file was saved in a format other than the expected Excel format, or column headers were altered Export a fresh template, enter quantities without changing headers or format, and upload again
Import succeeds but audited quantities are not reflected in the audit summary The import was completed against the wrong audit, or the audit was already submitted Verify you imported against the correct open audit; submitted audits cannot be modified
The Export button produces a file that does not match your expectations Your organization's stock quantity model may have changed since you last exported a template Confirm the current configuration with your organization administrator and export a fresh template
Was this article helpful?
Your feedback helps us improve our documentation.