| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) • Sales (sale_management) |
| Community Apps Dependencies | Show |
| Lines of code | 381 |
| Technical Name |
ask_sale_vs_cash_report |
| License | LGPL-3 |
| Website | https://www.asksol.pk |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) • Sales (sale_management) |
| Community Apps Dependencies | Show |
| Lines of code | 381 |
| Technical Name |
ask_sale_vs_cash_report |
| License | LGPL-3 |
| Website | https://www.asksol.pk |
Compare customer sales vs cash collection with date filters, PDF and Excel export.
Accounting Sale vs Cash Report
Key Highlights
Sales vs Cash Comparison
Compare total sales (invoices) against total cash collected per customer in your selected date range.
Opening Balance
Automatic calculation of receivable balance at the start of the period for accurate recovery analysis.
Recovery Percentage
See cash recovery ratio (Total Cash / Opening Balance) per customer to track collection performance.
PDF & Excel Export
Print professional PDF reports or export to Excel for further analysis and sharing with your team.
Date Range Filter
Define From and To dates to analyze sales and cash collection for any custom period.
Customer Selection
Select specific customers using multi-select to generate targeted sale vs cash reports.
Sale vs Cash Report
Compare sales vs cash collection today!
Print PDF or
export Excel reports instantly.
Module in the App Store
The Accounting Sales vs Cash Report module as it appears in the Odoo Apps store.
Menu Item
Access the report via Accounting → Sales Report → Sale vs Cash Report.
Report Wizard
Select customers, set From and To dates, then choose Print (PDF), Export Excel, or Cancel.
PDF Report
Professional PDF showing Customer, Opening, Total Sale, Total Cash, Recovery %, and Balance with Grand Totals.
Excel Report
Export to Excel (.xls) with Salesperson and Partner Category for further analysis and sharing.
Customer Filtering
Select specific customers using a multi-select field in the wizard to generate targeted Sale vs Cash reports.
Professional PDF Report
Generate a clean A4 PDF showing Opening, Total Sale, Total Cash, Recovery %, and Balance per customer.
Automatic Calculation
Automatically calculates Opening Balance, Total Sale, Total Cash, Recovery %, and Balance from posted accounting entries.
Date Range Analysis
Define From and To dates to analyze sales and cash collection for any period—daily, monthly, or yearly.
Excel Export
Export the report to Excel (.xls) including Salesperson and Partner Category for further analysis.
Grand Total Summary
Displays Grand Totals for Opening, Sale, Cash, Recovery %, and Balance at the bottom of the report.
Clear Tabular Layout
Report displays Customer, Opening, Total Sale, Total Cash, Recovery %, and Balance in a clean, organized table.
Fast SQL-Based Report
Uses optimized SQL queries for fast generation even with large volumes of accounting data.
This module is compatible with
Odoo 18 Community Edition. It
works with standard Odoo modules such as
Accounting and
Contacts.
The Sale vs Cash Report compares total sales (invoices) with total cash collected per customer for a given period. It shows Opening Balance, Total Sale, Total Cash, Recovery %, and Balance to help analyze collection performance.
Yes. You can select specific customers using the multi-select Customer field in the wizard, or leave it empty to include all customers.
The report displays Customer, Opening Balance, Total Sale, Total Cash, Recovery Percentage, and Balance. Excel export also includes Salesperson and Partner Category.
Yes. You can Print (PDF) or Export Excel directly from the wizard. Both options use your selected date range and customer filters.
Version 18.0.1
Initial Release – 2026- Initial module release for Odoo 18 Community Edition.
- Introduces Sale vs Cash Report under Accounting → Sales Report.
- Shows Opening Balance, Total Sale, Total Cash, Recovery %, Balance per customer.
- Print PDF and Export Excel with Salesperson and Partner Category.
- Customer multi-select and date range (From/To) filters.
- Integrated with standard Odoo Accounting module.
Please log in to comment on this module