EBM reporting (detailed)

Modified on Thu, 14 Dec, 2023 at 11:48 AM

1. General

EBM stands for "Electronic Business Management".


The purpose of EBM reporting is the reporting of key figures from your company. This can be everything from chart of accounts and info about items in stock, to detailed info about time spent in the workshop on a specific type of vehicle. This is exported to a file which can be loaded into other systems for further processing.


2. Create a report setup

Navigate to "Import/export" from the main menu, and select the "EBM reporting" tab. To create a new report setup, go to the "EBM Report setup" tab and add a new by clicking the add button (+).

Image 2.1


ColumnDescription
DescriptionThe name or description of the report setup.
DelimiterThe delimiter used in the generated file.
FilenameThe filename of the file (including file-extension).
No incoming balancesUsed not to include incoming balances in the auto-generated chart of accounts when using "Year-to-Date". 
Sort by report groupWith this enabled the sort order in the report will be by report group first, then by code. The same sort order is used in the codes grid (UI).

Table 2.1


Here is the report setup of the example we will be following in this article, named "Manual detailed".

Image 2.2


Click the expand arrow at the far left side of the grid to display a grid for specification of report columns which determines the layout of our exported file.

Image 2.3


ColumnDescription
Column order Which order the column will occur in the printed file.
Column type

What type of information to print in this column, possible types:

Report codeThe code as added in the "EBM Code setup" tab.
Report code descriptionThe code description as added in the "EBM Code setup" tab.
Value YTDThe value generated by the code setup (more on that later) as YTD (Year-to-date) value.
GL periodThe period the report has been requested for.
Fixed valueA fixed value that can be specified in the "Fixed value" column to the right.
Value periodThe value generated by the code setup (more on that later), for the period the report was requested for.

Fixed valueUsed as value if column type is "Fixed value".

Table 2.2


As seen in the picture above I've specified 3 columns, so here's an example of what our file might look like in the end if I have a report code "CODE1" with description "Report code 1" and a generated amount/quantity of 250:


CODE1;Report code 1;250


3. Create codes

In most cases codes will be specified by the party requesting the information (such as a vehicle importer) with a specification of what kind of value each code should report. 


Adding of codes is done from the "EBM Code setup" tab. Add a new code by clicking the add button (+). 

Image 3.1


ColumnDescription
Report groupDetermines the kind of information the code will report, by controlling the available code types and filter types.
Report groupSource of valueAvailable code typesAvailable filter types
FinanceGeneral ledger, typically used for reporting a trial balance (list of accounts with balance).AmountDimension, GL account
SalesGeneral ledger, typically used to report vehicle sales numbers with separate codes for make/model (Dimension) and used/new (Entity state). Amount, QuantityDimension, GL account, Entity state, Order type


Entity purchase price, Entity cost
Dimension, GL account, Entity state
StockEntities in stock, typically used to list numbers of vehicles in stock, with separate codes for how long they have been in stock for (Age), make/model (Dimension), used/new (Entity state), or other.Amount, QuantityDimension, Age, Customer, Entity state
PartsInvoices, typically used to report part sales/cost, with separate codes for internal/external sale (Accounting rule), item category (Item group), or other.Amount, Cost, QuantityAccounting rule, Item group, Posting type, Order type, Supplier, Item group EBM code
ServiceInvoices, typically used to report workshop related sales, cost, or time tracking. Often separated by internal/external (Accounting rule). Amount, Cost, QuantityDimension, Accounting rule, Item group, Posting type


Quantity
Dimension, Accounting rule, Item group, Posting type, Order type


Hours
Resource group


Productive hoursResource group, Accounting rule, Dimension, Posting type


Fixed valueFixed value
Table 3.1.1
CodeA (preferably) unique identifier for this particular code. Codes that have the same identifier and are not an autogen. code will have it's values aggregated into one (one row in the file).
DescriptionA short description of what the code will report.
Autogen. typeFor specifying automatic generation of values, more on that here (TODO: Create separate article).
Code typeThe kind of value the code will report. Availability depends on Report group as shown in Table 3.1.1.
QuantityE.g. quantity in stock, number of invoices, quantity of items sold.
AmountE.g. account balance, total sales.
CostE.g. total cost on sales, total cost of entities in stock.
HoursE.g. hours clocked in workshop.
Productive hoursE.g. hours clocked in workshop that are invoiced.
FixedE.g. hourly labor rate.
Table 3.1.2
Reverse signUsed to reverse the sign of the values generated for the code. 
Node in Makes and models hieararchyUsed only for Autogen. type "Makes and models". More on that here (TODO: Create separate article or use the same on as for Autogen.type).
Detail levelsUsed only for Autogen. type "Makes and models". More on that here (TODO: Create separate article or use the same on as for Autogen.type).
Split by model typeUsed only for Autogen. type "Makes and models". More on that here (TODO: Create separate article or use the same on as for Autogen.type).
FiltersAn accumulated string of the filters specified for this code, as can be set up in the filters grid for each code.

Table 3.1


4. Adding filters to codes

Click the expand arrow at the far left side of the code grid to display a grid for specification of filters. The layout (what columns are displayed) of this grid will depend on the selected Report group shown in Table 3.1.1. 

Image 4.1


The filters determine what your generated value will be, but it's not always easy to know which combinations of Report group, Code type, and Filter types to use. Read more about all the possible combinations and what they result in here.


Some notes about filters:

Filter typeNote
GL accountIf you find yourself creating a lot of codes with this filter alone, consider looking into autogenerated codes (TODO: Article...)
DimensionIn the context of being linked to entities we typically use dimensions for make and model to be able to group codes according to this. For report groups that don't necessarily access the general ledger when generating values, and we are interested in connection to entities (vehicles), we are looking for the dimension of the model of the entity. This can be set up in "Makes and models".
Item groupThis has the additional property "Only primary groups" which allows you to only include items which have the specified item groups as primary group.
Resource groupOften used to distinguish the resources working in the workshop and/or bodyshop.
CustomerPrimarily internal customers.
Entity stateTypically used to allow separate codes for new and used entities (vehicles).
AgeIs always specified in days.
Accounting rule
Typically used to allow separate codes for internal and external sale.
Posting ruleTypically used to allow separate codes for warranty.
Order typeTypically used to allow separate codes for workshop, entity sale, and part sales.
FixedBeneficial for values that are needed in the receiving system, such as a fixed workshop labor rate.
SupplierTypically used to only get information about parts from a specific supplier.
Item group EBM codeIs specified on the Item group, and can be used for advanced filtering of item groups on Parts code.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article