How to Use Accounting Fiscal Reports in Odoo 19: Complete Guide
Fiscal categories in Odoo 19 Accounting represent expenses that, in accordance with local tax regulations, cannot be fully deducted when determining taxable income. These expenses are still recorded in the accounting system to reflect the actual costs borne by the company, but they must be tracked separately for accurate tax reporting. Depending on legal restrictions, a portion or the entire cost may be flagged as disallowed. Odoo automatically removes the disallowed amount from deductible expenses when creating tax reports, preventing permitted expenditures from being overstated in tax computations. Fines, penalties, and personal-use charges are common examples. This complete step by step beginner guide walks through everything you need to know about accessing, configuring, and using fiscal reports in Odoo 19 Accounting.
What You'll Learn:
- How to access the Fiscal Category Report in Odoo 19 Accounting
- How to use Date, Comparison, Journal, and Partner filters
- How to configure the amount display scale for better readability
- How to create and manage Fiscal Categories
- How to apply fiscal categories to vendor bills and track disallowed expenses
Understanding Fiscal Categories in Odoo 19
Fiscal categories in Odoo 19 Accounting are a mechanism for tracking expenses that tax authorities consider partially or fully non-deductible. When you post expenses to accounts linked to a fiscal category, Odoo automatically calculates the disallowed portion based on the configured rate and excludes it from deductible expenses in tax reports. This ensures your tax filings reflect only the allowable deductions while your books still show the full economic cost of the expense.
Common examples of expenses that typically fall under fiscal categories include business entertainment (often only 50% deductible), fines and penalties (fully non-deductible), personal-use expenses, and luxury items. The exact rules depend on your local tax jurisdiction, but Odoo's fiscal category system provides the flexibility to configure any rate from 0% to 100% disallowance.
Automatic Tax Adjustment
Odoo automatically removes the disallowed amount from deductible expenses when generating tax reports, preventing overstatement of permitted expenditures in tax computations.
Configurable Disallowance Rate
Each fiscal category defines a Current Rate percentage that determines how much of the posted expense is disallowed, from 0% to 100%, matching your local tax regulations.
Dedicated Fiscal Report
The Fiscal Category Report provides a clear breakdown of base amounts, rates, and fiscal amounts for each category, with PDF and XLSX export for external reporting.
Drill-Down Exploration
Each line in the report offers a 3-dot menu to open the General Ledger or Journal Items, enabling detailed audit trail investigation from the report itself.
How to Access the Fiscal Category Report
The Fiscal Category Report is available inside the Odoo 19 Accounting module. Navigate to the Reporting section to find it under the Taxes & Fiscal Reports group.
Open the Accounting Module
Go to the Accounting application from the Odoo app switcher. This is where all financial reports, journals, and reconciliation tools are located.
Navigate to Reports
Click the Reports menu item on the left sidebar. This opens the reports dashboard where all accounting reports are organized.
Select Fiscal Report
Under the Taxes & Fiscal Reports section, choose Fiscal Report. The report displays all fiscal categories with their base amounts, rates, and calculated fiscal amounts.
Understanding the Fiscal Report Filters
The Fiscal Report in Odoo 19 comes with several powerful filters that allow you to narrow down the data precisely. These filters help you analyze fiscal expenses by time period, journal, partner, and more.
Date Filter
The Date filter is the initial filter available at the top of the report. It allows you to filter the report by Month, Quarter, or Year. You can also choose Custom Dates to specify an exact date range. This flexibility lets you generate fiscal reports for specific periods such as a single month for monthly reporting or a full fiscal year for annual tax filings.
Comparison Filter
The Comparison filter enables side-by-side analysis by comparing the current period's data against previous periods. Available options include Previous Period, Same Period Last Year, and Custom Dates. You can set the period order to either Ascending or Descending depending on how you want the comparison columns arranged. This is particularly useful for identifying trends in disallowed expenses month over month or year over year.
Journal Filter
The Journal filter lists all created journals and the multi-ledgers available inside the company. Selecting a specific journal filters the report to show only entries posted through that journal. This is useful when you want to isolate fiscal expenses from a particular source, such as a Purchase Journal for vendor expenses or a Miscellaneous Journal for adjustments.
Partners Filter
The Partners filter displays all partners in the company. You can also filter based on Tags. Selecting a partner or tag filters the report to show only entries linked to that specific partner. This is helpful when auditing expenses from a particular vendor or customer.
| Filter | Purpose | Options |
|---|---|---|
| Date | Filter by time period | Month, Quarter, Year, Custom Dates |
| Comparison | Compare against previous periods | Previous Period, Same Period Last Year, Custom Dates |
| Journal | Filter by posting journal | All journals, specific journals, multi-ledgers |
| Partners | Filter by partner or tag | Individual partners, Tags |
Additional Options Toggle
The Additional Options section provides several toggles that refine how the report displays data:
Draft Entries
When enabled, all unposted journal entries appear in the report. Useful for reviewing pending entries before posting.
Unreconciled Entries
Shows only entries that have not yet been reconciled. Works alongside the Cash Basis method for complete visibility.
Hide Lines at 0
Removes entries with zero values from the report display for a cleaner, more focused view of only active fiscal lines.
Cash Basis Method
Switches the report to cash basis accounting where revenue and expenses are recognized when cash is received or paid, rather than when transactions occur.
Configuring the Amount Display Scale
The amount display scale filter controls how monetary amounts are visually presented in the report. This is purely a display adjustment and does not affect the underlying accounting data or calculations. It is especially useful when reviewing large fiscal reports with significant transaction quantities.
| Scale | Display Format | Example |
|---|---|---|
| $ | Full value | $1,000 |
| K$ | In thousands | $1.0K |
| M$ | In millions | $1.0M |
How to Create and Manage Fiscal Categories
Fiscal categories define the types of expenses that are subject to tax disallowance. You can create and manage them through the Configuration menu.
Open Fiscal Categories Configuration
Go to Accounting → Configuration → Fiscal Categories. This opens the list of all existing fiscal categories with their codes, names, and related accounts.
Create a New Fiscal Category
Click the New button to add a new fiscal category. Fill in the following fields: Code (a unique identifier), Name (a descriptive term such as "Business Entertainment"), Company (select the company this applies to), and Related Account (the expense account associated with this category).
Set the Current Disallowance Rate
Define the Current Rate as a percentage. This determines how much of the expense posted to the related account is disallowed for tax purposes. For example, 50% for partially deductible entertainment expenses or 100% for fully non-deductible fines.
Apply Fiscal Categories to Transactions
Once configured, the fiscal category applies automatically when you post expenses to the related account. Create a vendor bill or purchase order with the linked expense account, confirm it, and the fiscal category rate governs the tax-disallowed portion.
Working with Fiscal Categories in Vendor Bills
To see fiscal categories in action, create a vendor bill and assign the expense account that is linked to a fiscal category. Navigate to Accounting → Vendors → Bills and click New. Enter the vendor and the bill date, then in the Invoice Lines section, set the Account field to the expense account that matches your fiscal category. Enter the amount and confirm the bill.
Once confirmed, return to Reports → Fiscal Report. The report now displays the fiscal category, base amount, rate, and fiscal amount. The base amount reflects the full expense, while the fiscal amount represents the disallowed portion based on the configured rate.
Important
The account selected in the vendor bill invoice line must match the Related Account configured in the Fiscal Category. If a different expense account is used, the fiscal category will not be applied to that transaction.
Exploring Report Details
Each line in the Fiscal Report provides a 3-dot menu (vertical ellipsis) that offers two drill-down options for detailed investigation:
Selecting General Ledger opens the general ledger view showing the account date, partner, debit amount, credit amount, and running balance for the entries behind that fiscal line. Selecting Journal Items displays all the individual journal items that make up the fiscal category total. This drill-down capability makes it easy to audit specific transactions without navigating away from the report.
Export to PDF
The report can be exported as a PDF file using the export button in the upper-left corner, suitable for sharing with auditors or filing with tax authorities.
Export to XLSX
The report can also be exported as an XLSX spreadsheet for further analysis, data manipulation, or integration with external reporting tools.
Odoo 19's Accounting Fiscal Categories Report offers an organised and transparent view of transactions according to their fiscal classification. It helps businesses ensure better financial analysis, improved compliance, and correct tax reporting. Accountants can use this report to make more informed and effective decisions with confidence.
Frequently Asked Questions
What is the difference between base amount and fiscal amount in the Fiscal Report?
The base amount is the full expense value posted to the account. The fiscal amount is the portion that is disallowed for tax purposes, calculated by applying the Current Rate percentage to the base amount. For example, with a 50% rate on a $1,000 expense, the base is $1,000 and the fiscal amount is $500.
Can I have multiple fiscal categories with different disallowance rates?
Yes, you can create as many fiscal categories as needed, each with its own disallowance rate. Common configurations include 50% for entertainment, 100% for fines and penalties, and 0% for fully deductible expenses. Each category links to a specific expense account.
Does the amount display scale affect the actual accounting data?
No, the amount display scale is purely a visual formatting option. It changes how numbers are presented in the report (full value, thousands, or millions) but does not alter any underlying accounting data or calculations. The fiscal amounts and tax computations remain unchanged.
How do fiscal categories integrate with tax reports in Odoo 19?
When Odoo generates tax reports, it automatically identifies expenses posted to accounts with fiscal categories and removes the disallowed portion from deductible expenses. This ensures tax filings reflect only allowable deductions while the general ledger retains the full expense for accurate financial reporting.
Can I view the individual journal entries behind a fiscal category line?
Yes. Each line in the Fiscal Report has a 3-dot menu with two drill-down options. Select General Ledger to see the account date, partner, debits, credits, and balance. Select Journal Items to view the individual journal entries that make up the fiscal category total.
Need Help with Odoo Accounting Configuration?
Our Odoo accounting experts can help you configure fiscal categories, set up tax-disallowed expense tracking, customize fiscal reports, and ensure your Odoo instance is fully compliant with local tax regulations.
About the author
Founder & Odoo Practice Lead, Braincuber Technologies
Founder of Braincuber. Has scoped and shipped 500+ Odoo implementations for US mid-market and global brands. Takes every founder call personally — no SDR layer between buyers and the people building the system.