Your P&L (BWA in German) is required for your profitability & financial health insights.
Betriebswirtschaftliche Auswertungen (BWA): it shows whether a company is making a profit or a loss. The BWA provides companies with an overview of their revenue, costs and key financial figures.
What a 12-month P&L should look like:
1. First go to DATEV Unternehmen online.
2. Log in accordingly.
3. Once you have logged in successfully, click on Applications, top right.
4. Click on Reports Business Accounting.
5. Click on Monthly Income Statement.
6. Select Jahresübersicht from the drop down selection.
7. Click on Daten holen.
8. You should now see your P&L for the current fiscal year with a monthly breakdown. Click on the export icon.
9. Select XLS (MS Excel) as a format and click on OK.
Note: We now have to export the BWA for the previous fiscal year. Why? Unless we are currently in January, the last 12 months of financial data exists in the last two fiscal years. For example, if we are in April 2022, the last 12 months are from February 2021 to March 2022. We therefore need to export two fiscal years of financial data in order to examine the last 12 months.
10. Click on WJ wechseln.
11. Choose the previous fiscal year and click on OK.
12. You should now see your P&L for the previous fiscal year with a monthly breakdown.
13. Click on the export icon again, top right.
14. Select the same format again: XLS (MS Excel) and click on OK.
15. Don’t forget to check that the correct information is in your file and then upload the spread sheet to re:cap.
- Via the left menu, click on Data and then Accounting.
- Under Accounting documents, click on Monthly P&L.
- Click on the Add data manually button.
- Upload your file and then follow the instructions to confirm.
