Accountable gives you a real-time view of all your accounting data, including a complete income statement (P&L file) in Excel format. This lets you step back from the day-to-day, review past quarters, and plan ahead in a format that is easy to work with.
This article covers how to access your P&L file, how the Excel document is structured, and how each figure is calculated.
1. How do you access your P&L file in Excel format?
From the web
Go to the Data export screen.
Select P&L.
Choose the period you want.
Click Generate Export.
Click Download file.
From the app on your mobile
Open the main menu.
Click on Data export.
Select P&L.
Click on Choose period.
Click on Export data.
You will receive the file in your mailbox.
2. How is the Excel document structured?
Each fiscal year is presented on a separate tab:
Column B shows the list of P&L categories:
Columns C to H show the total for the year:
Columns J to Y show the total for each quarter:
3. How is the P&L calculated in Excel?
3.1 Turnover
Turnover is made up of your sales excluding VAT recorded during the fiscal year:
Sale of goods
Sale of services
3.2 Operating costs
Your costs are split by category. These are the same categories as in Accountable, and show the amounts as entered in the app.
For an expense to be correctly recorded, it must meet the following conditions:
Have an invoice date
Have an associated category
Be attributed to the corresponding VAT quarter
Have a document attached (marked by the icon below on the web version)
Column C "Total amount, including private" shows the total amount for the category, including amounts that are not deductible as business expenses.
Column D "Professional amount excluding recoverable VAT" shows the same amount as column C, expressed without VAT.
Column E "DNA in %" indicates the percentage of Non-Admissible Expenses, meaning what is not considered deductible for this category.
Column F "DNA in value" indicates the non-deductible professional amount (= D x E).
Column G "Total deductible" indicates the deductible business amount (= D - F).
3.3 Operating margin
The operating margin is the difference between your total turnover excluding VAT and the sum of your deductible expenses excluding VAT.
Social security contributions and any capital gains or losses recorded during the year are then included. Finally, depreciation and financial expenses are factored in to arrive at the profit before taxes.
The profit before taxes is therefore:
+ Total turnover excluding VAT
- Deductible expenses without VAT
- Social security contributions
+ Capital gains
- Loss of value
- Amortization
- Financial expenses
= Profit before taxes
3.4 Net income after taxes
Based on your situation and the amount of your profit before taxes, Accountable estimates the amount of your taxes.
Income from copyright is then added.
The profit after tax and copyright gives you the NET amount left in your pocket at the end of the fiscal year.
Key takeaways
You can export your P&L file in Excel format from both the Accountable web app and the mobile app.
Each fiscal year appears on a separate tab, with columns covering annual totals (C to H) and quarterly totals (J to Y).
Turnover includes all sales excluding VAT recorded during the year; operating costs use the same categories as in Accountable.
The operating margin and profit before taxes account for deductible expenses, social contributions, depreciation, and financial expenses.
Net income after taxes shows the final amount remaining after estimated taxes and copyright income are applied.
Need help? Chat with us or email support@accountable.eu, we're happy to help.