How to create Reports with Cost Centres

From your accounting reports, you are able to filter the journal entries with cost centre information and then print them or send them further as an e-mail, fax etc. In addition, even the journal from the ledger can be exported with cost centre information to Microsoft® Excel® for further analysis.

How to print reports with cost centre information

All cost centres can be found under the Advanced Filter for the relevant accounting reports (e.g. the Transaction List or the two Audit Trails).
Read more about filters here.

  1. Go to View - Accounting - Reports.

  2. Select Accounting from the left-hand menu.

  3. Double-click the relevant report.

  4. Select the Advanced tab and then click New.

  5. From the Advanced criteria wizard select Extended and then choose the related cost centre group.

  6. Click Next.

  7. Under the Default tab, enter the relevant information for Operator, Conditions and Value.

  8. Click OK.

  9. If necessary, you are able to add further filter criteria.

  10. To complete this process click OK.

The report is now displayed on your screen according to the chosen filter. To print the report, simply click on the print icon.

Tip! If you don't want to print the report, but would rather create a PDF or Excel file, choose this option directly after step 2 in Send to. Then proceed to step 3.
Read more about this here

How to export the ledger journal including cost centre rows to Microsoft Excel

You are able to export the ledger journal, including cost centre rows to Excel, where you are then able to continue with further analyses.

  1. Go to View - Accounting - Financials.

  2. Click Settings.

  3. Tick the cost centre information that you wish to add to the export as additional columns.

  4. Click OK.

  5. The columns will now be displayed within the journal table.

  6. Right-click the table and choose Export to Microsoft Excel from the pop-up menu.

A Microsoft Excel sheet will now open, containing all table information including the cost centre columns. If necessary, you are now able to proceed with your analysis.

Read more about:

Journal Registration with user-defined cost centres

Accounting Settings: Cost Centres

Self-defined Cost Centres

Additional Products

Access to Additional Products and Enterprise Extensions

The Report module