InnovativeExport
Advanced sales export module — complete financial reports in Excel and HTML with one click. Created for merchants, accountants and managers working with Point of Sale.
ℹ️ What is InnovativeExport?
InnovativeExport is a module for Odoo 19, created specifically for merchants, accountants and managers working with Point of Sale. It allows generating detailed financial reports for any period — with a full breakdown by VAT rates, payment method, operator, product, category and supplier.
Reports are generated in Excel (.xlsx) with color-coded tabs and cells, and in HTML with a modern, light design — ready to print or email.
✅ The module works entirely within Odoo — it does not require external access or subscription. All data remains on your server.
⚡ Main Features
Period from—to
Filter data by any period — day, week, month, or year.
Cash vs Terminal
Automatic separation of sales by payment method - cash and bank card.
VAT breakdown
All available VAT rates (0%, 9%, 20%...) — automatically detected from the data.
Sales by product
Detailed list with barcode, category, quantity and amounts with/without VAT.
Sales by category
Grouped sales with a share in percentage of total turnover.
Sales by supplier
Which suppliers generate the most turnover — broken down by product.
Search by barcode
Find a specific product by barcode or name within the period.
By operator and cash register
Which operator sold how much — broken down by POS terminal.
Excel + HTML
Two export formats — table with colored tabs or printable web page.
📗 Excel — Sheets and Colors
The generated Excel file contains up to 9 color-coded sheets:
| Icon | Sheet Name | Contents | Color |
|---|---|---|---|
| 📋 | Summary | Summary — general, cash, terminal | Lavender |
| 🛒 | Sales by Product | Each product with barcode, quantity, VAT | Blue |
| 📂 | Sales by Category | Categories with % share | Cream |
| 💵 | Cash Sales | Cash sales at VAT rates | Cream |
| 💳 | Terminal Sales | Card/terminal at VAT rates | Pink |
| 📊 | Sales Overview | All sales at VAT rates | Lavender |
| 🧾 | VAT Only | VAT only - cash and card separately | Turquoise |
| 🏭 | Sales by Supplier | Suppliers → products → amounts | Pink |
| 🔍 | By Product-Barcode | Line by line — date, barcode, VAT | Turquoise |
| 👤 | By Operator | Operator → cashier → orders | Lavender |
⚙️ System Requirements
| Component | Version / Requirement | Status |
|---|---|---|
| Odoo | 19.0 | Required |
| Python library | openpyxl ≥ 3.0 | Required for Excel |
| Odoo module | point_of_sale | Required |
| Odoo module | sales_management | Required |
| Odoo module | account | Required |
| Browser | Chrome, Firefox, Edge (latest) | Recommended |
🚀 Installation — Step by Step
Install openpyxl
Find the Odoo virtual environment and install the library:
# Find the virtual environment
find /opt /home -name "activate" 2>/dev/null | grep -i odoo
# Install openpyxl (replace path with yours)
/opt/odoo19/odoo19/odoo-venv/bin/pip install openpyxl
# Verify installation
/opt/odoo19/odoo19/odoo-venv/bin/python -c "import openpyxl; print(openpyxl.__version__)"
Copy the module
Unzip innovative_export.zip and copy the folder to the Odoo addons directory:
# Unzip
unzip innovative_export.zip -d /opt/odoo19/odoo19/addons/
# Set correct owner (replace odoo19 with your user)
chown -R odoo19:odoo19 /opt/odoo19/odoo19/addons/innovative_export
# Set file permissions
find /opt/odoo19/odoo19/addons/innovative_export -type d -exec chmod 755 {} \;
find /opt/odoo19/odoo19/addons/innovative_export -type f -exec chmod 644 {} \;
Restart Odoo
systemctl restart odoo19
# Check status
systemctl status odoo19
Activate the module
In Odoo, go to: Settings → Apps → Update App List, then search for "InnovativeExport" and click Install.
💡 If the module is not visible, activate Developer Mode (Settings → scroll to bottom → Activate developer mode), then Update App List again.
Find the menu
After installation, a new menu "InnovativeExport" will appear in the main navigation. Click on it → Export Reports → Generate Report.
⚠️ If the menu is not immediately visible, press Ctrl + Shift + R to force a page refresh.
📖 How to Work with the Module
Select period
Set Date From and Date To. The module will search for all completed POS orders in this period.
Select report type
You can generate all reports at once or only a specific type — products, categories, financial, VAT, suppliers, barcode, or operators.
Apply filters (optional)
Narrow down results by product, POS category, product category, supplier, POS cash register, or barcode/name.
Choose a format and generate
Select Excel, HTML, or both formats, then click "📊 Generate Report".
Download the files
Click "⬇️ Download Excel" or "🌐 Download HTML" to save the report.
🧾 VAT Breakdown
The module automatically detects all VAT rates from the data — no manual configuration is required. For each rate, the following are displayed: base excluding VAT, VAT amount, and VAT amount — separately for cash and card.
(hotels, books)
📸 Screenshots
Click any image to view in full size
