Most Powerful Open Source ERP

How to Generate Accounting Reports

In this tutorial, you will learn how to generate accounting reports such as a Journal or a Profit and Loss report
  • Last Update:2023-09-13
  • Version:005
  • Language:en

How to create Accounting Report

This visual guide is part of a collection of documents created by the One Student One ERP (OSOE) project in collaboration with Institut Mines Telecom, Telecom Bretagne, Dresden University of Technology and the South Westfalia University of Applied Sciences. It can be used to teach modern ERP theory and practice to undergraduate students or professionals.

Copyright: You are free to copy, distribute, display, and perform the work under the following conditions: you must attribute the work in the manner specified by the author or licensor; you may not use this work for any commercial purposes including training, consulting, advertising, self-advertising, publishing, etc.; you may not alter, transform, or build upon this work. For any reuse or distribution, you must make clear to others the license terms of this work. Any of these conditions can be waived if you get permission from the copyright holder through a commercial license or an educational license. For more information, contact info@nexedi.com

Agenda

  • Which reports you can generate
  • How to generate a report

In this guide, you will learn which type of report you can generate with ERP5, and how to generate them.

The Reports tab in ERP5 home page

The Reports tab

In order to see the list of reports available to generate, access your ERP5 instance through https://[URL]/erp5/web_site_module/osoe_runner/ and click on the Site Reports tab on the sidebar.

Once clicking on the Site Reports, you can see the Accounting area displaying a list of the reports you are able to generate: Trial Balance, Account Statement, Journal, Third Parties, General Ledger, Aged Balance, Balance Sheet, Profit and Loss, and Invoices Report. In order to create a report, simply click on the title of the report you want to create . In our example, we will create Account Statement.

Example: Account Statement

The Account.Statement Button 1

Account Statement

Here is an example of an Account Statement report Creation. As you can see in the screenshot, please follow the steps to set the following information.

Firstly, the Section Category is the group your company belongs to, you will have only one choice here (if you only have one group in your ERP5 instance); From Date and At Date (end date) are the dates delimiting your report. The At Date is compulsory .

Secondly, you can choose which Simulation State(s) you want to display in your report, and the Journal Type (types of transactions) you need to display.

Thirdly, you have to choose an Account, this is compulsory , and then you can choose one of your Bank Account if you have several ones.

Then, you can choose to display the Detailed Beginning Balance , and to Omit Grouped References . You can also choose the Format of your report. As you will see in this item list, many formats are already supported by ERP5.

Finally, when you are done editing, click the "Account Statement" button. Then you can save or print this Account Statement.

Account Statement example

Account Statement example

Here is an example of the Account Statement report we have just created.

Another example: Profit and Loss

Another example: Profit and Loss

Another example: Profit and Loss

As you can see on the picture, this is an other example of report: Profit and Loss. The parameters requested by ERP5 are different from the Account Statement, as the report itself is different.

Profit and Loss

Profit and Loss

Here is the Profit and Loss Report we have just created.