Data Import / Export

The Data screen is used to manage your company's data — exporting reports and catalogs, importing data from external files, and backing up the entire database. Open it from the main navigation: More > Data.

The screen is divided into three tabs: Export, Import, and Backup. Tabs are shown based on permissions — if you don't have permission for a particular section, the corresponding tab won't appear.

Export

The Export tab contains a list of available exports. Each export is shown as a card with an icon, a name, and a description. Clicking a card (or a format button) starts the export.

Available exports

Sales — a summary overview of sales for the selected period. Before exporting, you choose a date range in the calendar. Two formats are available:

• PDF — a structured report with a summary, payment methods, categories, top products, a tax breakdown, and a daily overview.
• XLSX — a spreadsheet file with Receipts, Order Items, and Payments sheets.

Product Sales — a detailed report on products sold during the selected period (PDF). It includes top products by quantity and by revenue, category analysis, and an hourly sales overview.

Inventory Status — a current snapshot of stock levels (PDF). It includes a summary, low stock, negative stock, and a complete list of items with purchase and selling prices. It is shown only when the Inventory module is active.

Inventory Movements — a report of stock receipts, issues, and sales for the selected period (PDF). Before exporting, you choose a date range. It is shown only when the Inventory module is active.

Catalog — a complete catalog export. Two variants:

• XLSX — a spreadsheet file with categories, products, modifiers, suppliers, manufacturers, recipes, and tax rates (suitable for editing and re-importing).
• PDF — a readable brochure in Brief mode (price list) or Detailed mode (complete details including variants and modifiers).

Customers — an export of the customer database. Two variants:

• XLSX — a spreadsheet with names, contacts, loyalty points, credit, and total spend.
• PDF — a customer list in Brief mode (name + contact) or Detailed mode (including spending history and loyalty points).

Venue — an export of sections, tables, and floor plan elements. Two variants:

• XLSX — a spreadsheet file with definitions of sections, tables, and floor plan elements.
• PDF — a visual overview of the venue in Brief mode (list) or Detailed mode (with layout and capacities).

Before the PDF export of these three overviews, the system prompts you to choose a mode (Brief / Detailed). Once the file is generated, the system share/save dialog opens, where you can save the file to disk or send it.

Import

The Import tab lets you load data from external XLSX files. The import happens in three steps: file selection, analysis, and confirmation.

Supported imports

Catalog — import of categories, products, modifiers, suppliers, manufacturers, recipes, and tax rates from an XLSX file.

Customers — import of customers from an XLSX file.

Venue — import of sections, tables, and floor plan elements from an XLSX file.

Sales — import of historical receipts, items, and payments from an XLSX file. Before importing, the system asks you to choose a mode: add to existing data, or replace existing data.

Import process

After you select a file, the system automatically analyzes its contents and compares it with the existing data in the database. A confirmation dialog then opens, showing a summary of the planned changes:

Each section shows a number with the count of records. Click the eye icon to preview specific records (the first 5 items).

If the analysis finds errors (invalid values, missing required fields), an Errors section appears with an expandable list of issues. While errors exist, the Import button is disabled — you must fix the errors in the XLSX file and repeat the import.

After you click Import, the data is written to the database. A progress indicator is shown during the import.

Backup

The Backup tab is used to create and restore complete database backups.

Create a backup

Clicking the Backup card creates an encrypted backup file (.kasyro extension) containing the company's complete data. Once created, the system save dialog opens.

We recommend creating backups regularly (e.g., once a week) and storing them in a safe place away from the POS device.

Restore from a backup

Clicking the Restore card opens a dialog for selecting a backup file. The system verifies that the backup belongs to the same company. A confirmation dialog then appears with information about the backup:

• Backup creation date
• Company name
• Number of records

The dialog includes a Sync to server checkbox that determines whether the restored data should be sent to the cloud server after the restore. The dialog also shows a warning that the restore will overwrite the current local data.

After confirmation, synchronization is paused, the data is restored, and then synchronization resumes.

For managers and administrators

Permissions

Access to the individual tabs is controlled by three permissions:

Permissions are assigned to user roles in Settings > Company > Users.

Modules affecting export

Some exports are shown only when certain modules are active:

• Inventory Status and Inventory Movements require the active Inventory module (moduleInventory).

Recommendations

• Backups: Create backups regularly, ideally at the end of each working day or week. Store them away from the POS device (USB drive, cloud).
• Catalog import: Before your first import, export your current catalog so you can see the correct XLSX file format. Use the exported file as a template.
• Sales import: The "replace" mode deletes existing sales data and replaces it with the imported data. Use it with caution — we recommend creating a backup first.
• Restore from a backup: A restore overwrites local data. If you choose to sync to the server, the restored data is sent to the cloud and overwrites the server data as well. Without syncing, it stays local only.