📦 Full Data Export

Download everything in one Excel workbook — Products, Customers, Suppliers, Invoices, Employees across 6 sheets

Products

Customers

Sales

Export All (.xlsx)

Products / Items

Item catalogue with prices, categories, stock settings

{{ $stats['items'] }} items

Export

Import

Customers

Customer master data — names, contacts, credit terms

{{ $stats['customers'] }} customers

Export

Export XLSX CSV

Import

Suppliers

Supplier master data — names, contacts, payment terms

{{ $stats['suppliers'] }} suppliers

Export

Export XLSX CSV

Import

Sales Invoices

Invoice headers — for detailed line items, use the detailed export

{{ $stats['sales'] }} invoices

Export

Import

Customers must exist first. Use customer name or code from your file.

Purchase Invoices

Purchase bills and supplier invoices

{{ $stats['purchases'] }} invoices

Export

Import

Stock / Inventory

Export stock ledger or import opening stock balances

Export Stock Ledger

Import Opening Stock

Items must exist first. One row per item — qty and optional rate.

Employees

HR — employee list with departments, designations, bank details

{{ $stats['employees'] }} employees

Export

Export Employees XLSX

Import

Employee import coming soon.
Use HR module to add employees individually.

Import Rules & Tips

✅ Do this

Download the template first — it has the correct column order
Keep column headers exactly as in the template
Import Customers/Suppliers before importing their invoices
Import Items before importing opening stock
Leave Code blank — it will be auto-generated
Dates must be in DD Mon YYYY or YYYY-MM-DD format

❌ Avoid this

Don't add extra columns — they'll be ignored or cause errors
Don't leave required Name fields blank
Don't use commas in numeric fields (use 1000 not 1,000)
Don't import duplicate invoice numbers — they'll be skipped
Don't exceed 10MB file size — split into batches if needed