Guide: Tenzo Data Importer (Google Sheets: POS - Point Of Sale)

How Do Core Concepts Map to Tenzo?

Key: ✅ Supported   🚸 Work in Progress   ❌ Not Supported

Location	✅ Location
Order Type	✅ Order Type
Revenue Center	✅ Revenue Center
Product Item	✅ Product Item
Product Category	✅ Product Category
Product Division	✅ Product Division
Net Amount	✅ Unit Net Sales
Gross Amount	✅ Unit Gross Sales
Tender Type	❌ Not Supported
Employee	✅ Employee Name
Customer	✅
Discount Name	✅ Discount Name
TicketItemDiscounts	✅ Discount Amount
TicketDiscounts	❌ Not Supported — discounts are recorded against items
Guest Count	✅ Guests
Transaction length	✅
Time of Transaction	✅ Time
KDS Bump Time	❌ Not Supported
Ticket Voids	❌ Not Supported
Ticket Item Voids	❌ Not Supported
Table	❌ Not Supported
Service Charge	✅ Service Charge
Tips	❌ Not Supported
Price	❌ Not Supported
Menu Item Visibility	❌ Not Supported
Menu Item Size	❌ Not Supported
Ticket Item Modifiers	❌ Not Supported

Data Ingestion

How Do I Populate the Template?

Use this template.

You can delete the columns that are not relevant for what you are uploading (e.g. revenue center, order type, etc.) and just leave the ones you will be filling.

Formatting:

1. Date Format:
   • Always use: YYYY-MM-DD (e.g., 2024-08-01, 2024-12-30)
   • Include leading zeros: 01, 02, etc.
2. Commas:
   • Avoid commas: in all fields (Location, Date, Numbers)
   • Reason: Commas can disrupt data loading, causing errors and delays.
3. Location Names:
   • Keep consistent: Use the same names for locations across all sheets.
   • Manual mapping: Changes to location names require manual updates.
   • Notify in advance: If you plan to change location names/codes etc., please let us know ahead of time to minimise delays.

Example of Date Format:

How Do I Compare Google Sheets Data to Data in Tenzo?

Access the GoogleSheet and compare the daily total by line making sure to select in Tenzo the right settings (ie. Net Amount in the GoogleSheet will appear in Tenzo with NO filters selected and Gross Amount in the GoogleSheet will appear in Tenzo with “Include tax” filters selected 

Net Amount

Gross Amount

You will then be able to see the same number by selecting one day within Tenzo’s “Sales by Location” view.

Exceptions

None

Other Ways to Send This Data to Tenzo

As well as a Google Sheet, Tenzo can receive data in the Tenzo Data Importer format by Email or as CSV files over SFTP. Talk to your Customer Success Manager if you would like to send your data one of these ways.