Accounting · Tax Reporting
Sales Register Excel Report
Stop building sales registers by hand in spreadsheets. Export a fully formatted, invoice-wise Excel sales register with dynamic ledger columns, FC/DC currency splits, and CGST/SGST/IGST breakdowns in one click.
1 Wizard
Date-range export
3 References
PO, SO & Shipment
2 Currencies
FC & DC totals
DYNAMIC GL ACCOUNT COLUMNS
MULTI-CURRENCY CONVERSIONS
FROZEN HEADER GRIDS
Trusted Partners
More Than 150+ Brands
A sales register (also called a sales day book, sales ledger, or sales summary report) is the master record accountants use to reconcile every invoice raised in a given period against the general ledger, tax filings, and bank statements. In most ERPs, including standard Odoo, pulling this together still means exporting raw invoice data and rebuilding it manually in Excel, mapping ledger accounts, splitting tax columns, and converting foreign currency invoices by hand.
The Sales Register Excel Report module by Ahex Technologies removes that manual work entirely. It adds a dedicated Invoicing → Reporting → Sales Register Report menu that generates a clean, professionally formatted Excel workbook for any date range, built directly from your posted customer invoices and credit notes.
Instead of a flat export, you get an invoice-wise, tax-split, currency-converted register that's ready to hand to your auditor, your GST consultant, or your CFO, no VLOOKUP gymnastics required.
Dynamic Ledger Mapping
Automatically scans every invoice line, detects active ledger/account codes, and adds them as dynamic columns in the sheet.
Multi-Currency FC/DC Split
Separates Foreign Currency and Domestic Currency totals, applying the invoice's own exchange rate automatically.
GST Tax Breakdown
Dedicated columns for CGST (9%), SGST (9%), IGST (18%), and IGST (0%) assessable values and tax totals.
PO & Shipment References
Pulls Customer PO numbers, Sales Order sequences, and linked Stock Picking (shipment) numbers automatically.
Customer Commercial Data
Includes Party Type, Partner Code, Party Account Code, GSTIN, and customer state for every row.
Auto Summary & Grand Totals
Appends dynamic subtotal and grand-total rows for item amounts, discounts, taxes, and ledger columns.
The exported workbook isn't just raw data dumped into a sheet, it follows real spreadsheet reporting conventions
| Formatting Rule | What It Means For You |
|---|---|
| Pre-formatted numeric columns | Currency values display with correct decimals and localized symbols out of the box. |
| Auto-adjusted column widths | No manual resizing, long account names and descriptions never wrap awkwardly. |
| Frozen header row | Headers stay visible while scrolling through hundreds of invoice rows. |
| Dynamic GL account columns | Only the ledger codes actually used in the selected period appear, no clutter. |
This format is built for the way accountants actually work in Excel, filter, pivot, and reconcile straight from the exported file without any cleanup pass.
This module solves a recurring pain point for any business that invoices customers and has to report on it. Common scenarios include
1 of 7
Accountants and finance teams
Preparing monthly or quarterly sales registers for GST returns, VAT filings, or tax audits.
2 of 7
Exporters and import/export businesses
Needing automatic foreign currency (FC) vs domestic currency (DC) splits with exchange rate conversion.
3 of 7
Companies with multiple GL accounts
Who need dynamic, per-account ledger mapping instead of one flat sales total.
4 of 7
Auditors and audit firms
Reviewing posted invoices and credit notes against ledger entries during statutory or internal audits.
5 of 7
Distribution and manufacturing businesses
That need invoice rows cross-referenced against Sales Order and shipment/stock picking numbers.
6 of 7
India-based Odoo users
Who need CGST, SGST, and IGST split columns to match standard Indian GST sales register formats.
7 of 7
Odoo implementation partners
Looking for a ready-made sales register Excel export instead of building one from scratch for every client.
Think of it as your monthly sales register on autopilot: every posted invoice and credit note, fully tax-split, currency-converted, and reconciled into one downloadable Excel file.
Step-by-Step
Set up partner configuration
On each contact card, specify the Partner Code and Party Type (Customer, Vendor, Other) used in the report.
Fill in invoice reference fields
Add the Customer PO Number, choose Invoice Type (Local vs Export), and set the foreign currency exchange multiplier if invoicing in USD or another currency.
Open the Sales Register Report wizard
Navigate to Invoicing → Reporting → Sales Register Report. Choose your date range parameters.
Click Export Excel
The system scans all posted invoices and credit notes in the selected period and builds the workbook.
Download and audit
A formatted spreadsheet is generated, attached, and downloaded automatically, ready for tax filing, audit, or management review.
The exported Sales Register Excel worksheet generates a complete set of commercial and accounting columns
| Column Group | Fields Included |
|---|---|
| Header Metadata | Invoice Custom Type, Transaction Category, Invoice Number, Invoice Date, Status |
| Commercial References | Customer PO Number, Sales Order Number, Sales Shipment Number |
| Customer Metadata | Party Type, Party Code, Party Description, Party Account Code & Description, Party GSTIN, Party State |
| Currencies & Multipliers | Billing Currency, Exchange Rate |
| Financial Values (FC & DC) | Total Item Amount, Total Discount Amount, Total Tax Amount, Taxable Amount, Total Invoice Amount |
| Dynamic GL Accounts | Auto-added columns for each general ledger account code found on active invoice lines |
| GST Split Mapping | CGST 9% (Assessable Value & Tax), SGST 9% (Assessable Value & Tax), IGST 18% (Assessable Value & Tax), IGST 0% (Assessable Value & Tax) |
The module separates every monetary figure into Foreign Currency (FC) and Domestic Currency (DC) values
Domestic Value (DC)
=
Foreign Currency Value
x
Invoice Exchange Rate
For non-INR invoices, the domestic value is automatically multiplied by the customer exchange rate entered on that specific invoice, not a generic daily rate - so each row reconciles exactly against what was actually billed.
Only posted customer invoices and outbound refund credit notes are included. Draft and unposted documents are excluded by design, so the register always matches your audited general ledger.
Compatibility
- Odoo.sh
- On-Premise
- Community Edition
- Enterprise Edition
Module Dependencies
- No third-party libraries
- No external APIs
- no additional SaaS subscriptions
Installation
- Copy the module folder to your custom addons directory
- enable Developer Mode, update the apps list, search for "Sales Register Excel Report", and install
- Once installed, configure Partner Codes on your contacts and the report is immediately available under Invoicing → Reporting.
Building a custom sales register export in Odoo from scratch means writing logic to scan invoice lines for active ledger accounts, handling foreign-to-domestic currency conversion per invoice, building GST tax-split columns, tracing invoices back through sales orders to stock pickings, and formatting a clean, frozen-header Excel workbook. For an experienced Odoo developer, that's realistically several days of work, and ongoing maintenance every time tax rules or account structures change.
At $13.44 for a tested, ready-to-install module, the cost of building this yourself is replaced almost instantly, especially for any business that runs this export monthly for tax or audit purposes.
The module is maintained by Ahex Technologies, an Odoo Apps publisher with a track record of clean, well-scoped modules across accounting, sales, and inventory reporting.
Ready to Automate Your Sales Register?
Get the Sales Register Excel Report module for Odoo and turn every monthly close, GST filing, or audit prep into a one-click Excel export.
Case Study
Towanto: Multi-Vendor Agriculture E-Commerce Platform
Towanto
Towanto is an agricultural products provider that partnered with AHEX Technologies to build a scalable Odoo-powered marketplace connecting multiple sellers with customers through web and mobile commerce.
- Multi-Vendor Marketplace
- Web & Mobile Commerce
- Seller Management Portal
- Integrated Payments & Notifications
Sodahub: Multi-Company Odoo ERP Transformation
Sodahub Industrial
Sodahub Industrial is a diversified beverage manufacturing company operating across flavour production, PET bottle manufacturing, and packaged drinking water. AHEX Technologies migrated its operations from TCS iON ERP to a unified Odoo platform.
- Multi-Company ERP Implementation
- Manufacturing & Supply Chain Management
- TCS iON to Odoo Migration
- Real-Time Dashboards & Reporting
Isler India: End-to-End Kitchen Appliance Manufacturing
Isler
Isler India is a design-driven kitchen appliance manufacturer producing chimneys, built-in hobs, cooktops, OTGs, microwaves, and dishwashers. AHEX Technologies implemented Odoo ERP to connect sales, manufacturing, inventory, procurement, finance, and HR.
- Automated Production Planning
- Real-Time Inventory Management
- Centralized CRM & Sales
- Integrated HR & Accounting
Vastu Company Ltd.: Smarter Construction Operations with Odoo
Vastu Company Ltd.
Vastu Company Ltd. provides mining, drilling, blasting, and light gauge steel construction solutions. Ahex Technologies implemented Odoo ERP to connect project management, field service, workforce, finance, procurement, and inventory operations.
- Project Cost & Profitability Tracking
- Automated Workforce & Payroll
- Integrated Accounting & Billing
- Real-Time Dashboards & Reporting
What Our Clients Say About Us
Explore Our Blogs on Odoo Integration
Related to Implementation
The system parses all invoices within the user-defined start and end dates, detects every unique account code on active invoice lines, and adds them as dynamic columns to the Excel layout with running subtotals.
Yes. It separates values into Foreign Currency (FC) and Domestic Currency (DC). For non-INR transactions, the domestic value is automatically multiplied by the customer exchange rate entered on the invoice.
The module traces active invoice lines back to their related Sales Orders, then queries all linked stock pickings in “Done” status, mapping their sequence names into the spreadsheet row.
No. The module queries only posted customer invoices and outbound refund credit notes, ensuring the financial data always matches your audited general ledger.
Yes. The module supports both Odoo Community and Enterprise editions running version 18, since it depends only on core Sales, Inventory, and Invoicing modules available in both.
Yes. The dedicated CGST, SGST, and IGST assessable value and tax columns are built to match the structure accountants typically need for Indian GST return reconciliation.
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more âžž
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more âžž
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more âžž
Looking for a Solution? Let's Talk
- sales@ahex.co.in
- (India) +91 - 8885564224
- (USA) +1 - 6503197394
DEVELOPERS
YEARS IN OPERATION
GLOBAL CLIENTS
