Purchase XLS Pro | Export Purchase Orders to Excel | Advanced PO Export
by Odonity https://www.odonity.com$ 175.14
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 777 |
| Technical Name |
odnt_purchase_xls_pro |
| License | See License tab |
| Website | https://www.odonity.com |
| Versions | 16.0 17.0 18.0 19.0 |
Purchase XLS Pro
Export Purchase Orders to Excel | Multi-Sheet | Product Images | Receipt Status | Procurement Analytics
One click transforms your Odoo Purchase Orders into professionally formatted Excel workbooks — complete with receipt tracking, vendor bill reconciliation, and procurement analytics ready to share with management or finance.
Key Features
Workbook Sheet Overview
Sheet 1 — Summary
- Company logo & branding header
- PO number, dates, status
- Vendor name, email, phone
- Vendor reference & address
- Procurement rep & company
- Payment terms, incoterm
- Receipt destination
- Delivery & billing status counts
- Notes / Terms & Conditions
Sheet 2 — Lines
- Product image embedded
- Internal ref & product name
- Full line description
- Ordered, received, billed qty
- Unit price & discount
- Taxes applied per line
- Subtotal, tax amount, total
- Colour-coded receipt status
Sheet 3 — Financial
- Untaxed amount
- Per-tax-group breakdown
- Grand total (bold, prominent)
- Amount billed (vendor bills)
- Unbilled amount (red if > 0)
- Total ordered / received / billed qty
- Payment terms reminder
Sheet 4 — Analytics
- Qty & value per product
- Received & billed qty per line
- Highest value line
- Highest qty line
- Receipt status line counts
- Tax distribution summary
- % of order per line
Receipt Status — At a Glance
Every order line in the Lines sheet is colour-coded to show receipt progress instantly — no formulas or manual work needed.
Fully Received
All ordered quantity has been received in the warehouse.
Partially Received
Some quantity received. Shows exact received vs ordered count.
Nothing Received
No receipt has been recorded yet for this product line.
Perfect For
- Procurement Teams — share professional PO confirmations with vendors or management in Excel format
- Finance & Accounts Payable — vendor bill reconciliation with tax groups and outstanding amounts
- Managers & Directors — procurement analytics with receipt tracking for operational decisions
- Warehouse & Operations — receipt status per line for goods-in tracking and follow-up
Module Screenshots
Export Button on Purchase Order Form
Export Wizard — Configure Sheets & Options
Excel Output — Order Summary Sheet
Excel Output — Order Lines with Product Images & Receipt Status
Excel Output — Financial Summary with Bill Reconciliation
Excel Output — Procurement Analytics Sheet
Multi Export Button In List View
Installation & Usage
Installation
odnt_purchase_xls_pro to your custom addons directory.Usage
- Open any Purchase Order and click the Export XLS smart button
- Or select multiple orders from the list view → Action → Export to Excel
- Choose which sheets to include (Summary, Lines, Financial, Analytics)
- Toggle product image embedding on or off
- Click Export to Excel and download the
.xlsxfile
Support & Customization
Need assistance, custom features, or version upgrades?
- Email: odonity.services@gmail.com
- Website: www.odonity.com
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 777 |
| Technical Name |
odnt_purchase_xls_pro |
| License | See License tab |
| Website | https://www.odonity.com |
Purchase XLS Pro | Export Purchase Orders to Excel | Advanced PO Export
Export Purchase Orders to Professional Multi-Sheet Excel Workbooks in Odoo
This Odoo Purchase extension by Odonity enables your procurement and finance teams to export Purchase Orders into beautifully formatted, multi-sheet Excel workbooks in one click — individually from the order form or in bulk from the list view.
Key Features
- 📊 Multi-sheet Excel workbooks (Summary, Lines, Financial, Analytics)
- 🖼 Product images embedded directly in Excel rows
- 💰 Complete financial summary with per-tax-group breakdown and vendor bill reconciliation
- 📦 Order line details: ordered, received, billed qty, discount, taxes, subtotal
- 🟠 Receipt status per line: Fully Received / Partial / Nothing Received
- 🏢 Company logo embedded in the workbook header
- 🎨 Professional colour-coded formatting with Odonity brand aesthetics
- 🔴 Unbilled amounts highlighted for quick financial review
- ⚡ Bulk export from list view (multi-select supported)
- 🔧 Toggle individual sheets and image export on or off
- 📁 Auto-generated filenames with PO number, vendor, and date
Installation
- Copy the odnt_purchase_xls_pro folder into your Odoo custom addons directory.
- Restart the Odoo server.
- Activate Developer Mode from Settings > General Settings.
- Navigate to Apps and click Update Apps List.
- Search for Purchase XLS Pro and click Install.
Usage
Single Order Export:
- Open any Purchase Order.
- Click the Export XLS smart button (top-right button box area).
- Configure which sheets to include and whether to embed product images.
- Click Export to Excel.
- Download the generated .xlsx file.
Bulk Export:
- Open the Purchase Orders list view.
- Select one or more orders using the checkboxes.
- Click Action → Export to Excel.
- Configure export options and download.
Sheet Overview
- Sheet 1 — Order Summary
- Company logo, PO details, vendor information, procurement representative, payment terms, fiscal position, incoterm, receipt destination, delivery & billing status counts, and notes/terms.
- Sheet 2 — Order Lines
- Product thumbnails (embedded), internal reference, product name, description, category, ordered qty, received qty, billed qty, unit price, discount, applied taxes, subtotal, tax amount, line total, and colour-coded receipt status.
- Sheet 3 — Financial Summary
- Untaxed amount, per-tax-group breakdown, total tax, grand total, amount billed via vendor bills, and amount not yet billed (highlighted when outstanding). Also includes total ordered / received / billed quantity summary.
- Sheet 4 — Procurement Analytics
- Product-level quantity and value breakdown, highest value line, highest qty line, receipt status summary (fully received / partial / not received counts), and tax distribution summary.
Support & Contact
About Odonity
Odonity builds business-ready Odoo applications focused on automation, productivity, and professional presentation. Trusted by businesses worldwide for reliable and scalable Odoo solutions.
Odoo Proprietary License v1.1 - Strict Commercial Use © 2026-Present Odonity. All Rights Reserved. Module Name: Purchase XLS Pro | Export Purchase Orders to Excel | Advanced PO Export (By Odonity) License Owner: Odonity (https://www.odonity.com) Support Email: odonity.services@gmail.com This software is protected by copyright laws and international treaties. It is licensed, not sold. You are granted a **non-transferable, non-sublicensable, and non-exclusive license** to use this software ONLY under the terms below: -------------------------------------------- STRICT TERMS OF USE -------------------------------------------- PERMITTED: - Use the module in one Odoo production instance only (with staging/test allowed only for that instance). - Use for internal company operations. - Request support, upgrades, or customization services from Odonity. PROHIBITED WITHOUT WRITTEN PERMISSION FROM ODONITY: - Modifying, altering, or extending the source code in any way. - Reselling, sublicensing, or redistributing any part of the module. - Sharing the code with third parties, including freelancers or other vendors. - Uploading this module to public or private repositories, websites, or forums. - Creating derivative works or using snippets in other modules. - Using the module as a base to develop similar competing products. WARNING: This software contains **branding, code-level markers, and security tracking** for anti-piracy purposes. Tampering with these or violating this license may result in: - Permanent termination of your usage rights - Legal action under local and international intellectual property laws - Immediate take-down notices for marketplaces and hosting providers -------------------------------------------- LICENSE VERIFICATION & SUPPORT -------------------------------------------- License Keys / Validation (optional): Odonity reserves the right to implement license key checks in future versions. Support is only available to verified license holders. Invoice or proof of purchase must be retained for all license claims. For official support, licensing clarifications, or enterprise usage, please contact: odonity.services@gmail.com | https://www.odonity.com -------------------------------------------- BY INSTALLING THIS MODULE, YOU AGREE TO BE BOUND BY ALL TERMS ABOVE. Unauthorized use, reproduction, or redistribution is strictly prohibited.
Please log in to comment on this module