ZenotiHelp

Import and export gift card balances

ZTZenoti Docs Team Updated September 5, 2026 2 min readGuide

You can bulk import gift card balance data from a spreadsheet or export current balances for reporting and analysis. These operations are useful when migrating gift card data from another system, making bulk balance adjustments, or generating external reports for accounting.

Before you begin

Permission: ImportGiftCard_Balances under ImportExport in the Administrator section -- Allows importing gift card balance data.

Permission: ExportGiftCard_Balances under ImportExport in the Administrator section -- Allows exporting gift card balance data.

  • Your organization must have the gift cards feature enabled.

Note: The gift card balance import and export feature is accessed through a dedicated page in your Zenoti admin panel. Contact your Zenoti account team for the current navigation path — the in-product location varies by tenant configuration.

Steps

Import gift card balances

Use the import feature to bulk-load gift card balance data for multiple cards at once.

  1. Open the gift card balance import page (see note above for navigation).
  2. Click Download Template to get the import template spreadsheet.
  3. Open the template and populate it with the required data:
  • Gift card code -- The unique code for each gift card.
  • Balance -- The monetary balance to assign to the card.
  • Additional fields as specified in the template (such as expiry date, center, and guest identifier).
  1. Save the completed spreadsheet.
  2. On the import page, click Upload and select the completed file.
  3. The system validates each row in the file. Validation checks include:
  • Gift card codes must exist in the system or follow the expected format.
  • Balance amounts must be valid numeric values.
  • Required fields must not be empty.
  1. If there are validation errors, the system displays them in a summary. Correct the errors in the spreadsheet and re-upload.
  2. Once validation passes, confirm the import. The system processes the records and updates the gift card balances.

Import file format

Use the template provided by the system to ensure the correct file format. The template includes column headers and formatting requirements.

  • Do not modify column headers or add extra columns.
  • Enter balance amounts as numeric values without currency symbols.
  • Ensure that gift card codes match existing cards in the system.
  • Save the file in the format specified by the template (typically.xlsx or.csv).

Export gift card balances

Use the export feature to download current gift card balance data for external analysis, reconciliation, or record-keeping.

  1. Open the gift card balance import/export page (see note in Before you begin for navigation).
  2. Click Export.
  3. Configure the export filters (such as center, date range, or card status) if available.
  4. The system generates a file containing the current balance data for the matching gift cards.
  5. Download the exported file.

The exported file includes details such as gift card code, current balance, original value, sale date, expiry date, status, and associated center.

Tips

  • Validate your import data carefully before uploading. Incorrect gift card codes result in failed rows.
  • Use the import template exactly as provided -- do not rename columns, reorder them, or add extra columns.
  • After importing, review the updated balances by running a gift card report to verify correctness.
  • Import and export permissions are separate. A user can have permission to export balances for reporting without having permission to import and modify them.
  • For large imports, process the file in batches to make it easier to identify and correct any errors.
Was this article helpful?
Your feedback helps us improve our documentation.