Unless otherwise indicated herein, the approaches described in this section are not prior art to the claims in this application and are not admitted to be prior art by inclusion in this section.
Embodiments relate to financial reporting, and in particular to such reporting systems and methods integrating market segment data (e.g., profitability data).
Business enterprises increasingly rely upon complex business software for a variety of purposes, including financial reporting. Commonly, profitability information is stored in a database comprising entities (such as structured data objects) that are different from those of a separate database that tracks accounting information of the enterprise.
Different databases have historically been used for profitability and general accounting information for a variety of reasons. One is that the profitability data may provide additional market segment information, while the general accounting information is relied upon for different purposes (such as legal purposes).
Such storage of profitability and accounting data in separate databases, may give rise to a number of challenges. One is reconciliation of data persistence between the two databases. This can require a substantial effort with ongoing system configuration activities.
Lack of transparency is another issue that may arise from separate storage of profitability and accounting information. In particular, an inability to easily link profitability data with financial documents can hinder the recognition of important case-and-effect relationships by a user.
Reporting is still another aspect that may be affected by separate storage of profitability and accounting information. For example, profitability data may be posted in the profitability database as a batch job during the end-of-period activities (e.g., settlement). As a result, only backwards reporting (i.e., profitability-to-financials) may be possible. The latest available profitability reporting may thus not be current, instead reflecting only data of a previous time period.
In addition, the market segments/characteristics provided for the profitability database, may only available for revenues and costs to provide multi-level contribution margin reporting. Balance accounts are not included.
Financial reporting methods and systems according to embodiments, integrate profitability and accounting data. A universal journal entry allows user definition of relevant characteristics for a market segment. The entry appends the structure of a financial document to provide linkage to market segment characteristics. When creating the financial document including profit and loss (P&L) and balance account line items, a market segment is defined with determined characteristics stored in the line item on the basis of business process dependent rules. For example in posting information on a sales order item, sales order data may be read, and customer, product, and/or other sales order information input. Additional data can be derived on the basis of the determined master data, depending upon user needs. Embodiments allow enriched reporting (e.g., flexible market segment reporting) at the line item level, affording a user with intuitive access to defined characteristics (e.g., drill-down into details of P&L and balance account information).
An embodiment of a computer-implemented method comprises an engine receiving accounting data, and the engine receiving market segment information defined with a plurality of characteristics. The engine integrates the plurality of characteristics with the accounting data according to a ruleset to generate a universal journal entry as a database table comprising a line item broken down into the plurality of characteristics. The engine displays a report including the line item and the at least one of the plurality of characteristics.
A non-transitory computer readable storage medium embodies a computer program for performing a method comprising an engine receiving accounting data and market segment information defined with a plurality of characteristics. The engine integrates the plurality of characteristics with the accounting data according to a ruleset to generate a universal journal entry as a database table comprising a line item broken down into the plurality of characteristics based upon business process dependent rules of the ruleset. The engine displays a report including the line item and at least one of the plurality of characteristics.
An embodiment of a computer system comprises one or more processors and a software program executable on said computer system. The software program is configured to cause an engine to receive accounting data and receive market segment information including a plurality of characteristics. The software program is configured to cause the engine to integrate the profitability data with the accounting data according to a ruleset to generate a universal journal entry as a database table comprising a line item broken down into the plurality of characteristics based upon business process dependent rules of the ruleset, wherein the line item comprises income or expense. The software program is configured to cause the engine to display a report including the line item and at least one of the characteristics.
In some embodiments the plurality of characteristics are stored in the line item according to business process dependent rules of the ruleset.
In particular embodiments the line item comprises aggregated profit.
In various embodiments wherein the line item comprises income.
In certain embodiments the line item comprises expenses.
According to some embodiments the accounting data comprises an existing database table, and the database table includes an extension to the existing database table.
In particular embodiments the report comprises a plot having an axis reflecting the at least one of the plurality of characteristics.
In various embodiments the at least one of the plurality of characteristics comprises a product line, geographic region, or customer.
In some embodiments the at least one of the plurality of characteristics comprises a cost accounting object type.
The following detailed description and accompanying drawings provide a better understanding of the nature and advantages of embodiments.
Described herein are systems and methods providing financial reporting that integrates profitability data and accounting data. In the following description, for purposes of explanation, numerous examples and specific details are set forth in order to provide a thorough understanding of the present invention. It will be evident, however, to one skilled in the art that embodiments of the present invention as defined by the claims may include some or all of the features in these examples alone or in combination with other features described below, and may further include modifications and equivalents of the features and concepts described herein.
Embodiments provide financial reporting methods and systems that integrate profitability and accounting data. A new universal journal entry allows a user to define relevant characteristics of a market segment. The new universal journal entry allows appending those fields to the financial document structure, thereby providing by a new engine linkage between the market segment characteristics and the financial document. Specifically, for profit and loss (P&L) and defined balance account line items, at the time of posting and document creation a market segment is defined, and the determined characteristics are stored in the financial document line item. This additional characteristics information may be defined on the basis of business process dependent rules maintained by the user.
For example in posting information on a sales order item, data of the sales order may be read, and customer, product, and/or other sales order information input. Additional data can then be derived on the basis of the determined master data, depending upon user needs. Thus in posting on a customer project, the leading sales order item can be determined and additional data derived as appropriate.
Components of the universal journal entry according to embodiments may allow enriched reporting. Examples can include but are not limited to, posting costs—as new Management Accounting type of Accounting document line items—utilized in calculations, e.g., freights, provision, customer deductions by interpreting pricing conditions, and/or further customer specific customizing.
Embodiments thus provide flexible market segment reporting on the level of a line item. This provides intuitive access to defined characteristics, allowing the user to drill down for details regarding characteristics of P&L and balance account information.
The engine is in communication with a ruleset 108. Based upon rules in the ruleset, the engine processes the incoming general accounting data 104 and market segment data 106 in order to create in an underlying database 110, a complex data structure 112 (e.g., data object) comprising universal journal entries 114 that integrate both general accounting and profitability information.
In particular the line items 116 of the universal journal entries include the functional area 118. Data in this functional area reflects information typically available from general accounting sources, for example income and expenses. Such general accounting information may reflect some profit measure, but this is typically crude (e.g., gross profit on sales) and not well-suited for detailed reporting purposes. Providing a hierarchy on functional area during design time, allows an aggregated reporting with gross margin sums.
Here, however, the line items further include more specialized information typical of profitability data. For example, line items of the universal journal entries may include characteristics 120 reflecting specific market information (e.g., breaking down financial data according to different market segments A, B, C).
These characteristics may be referenced by the engine in providing enriched financial reporting to a user 122 via user interface 124. For example, they permit ready user access not merely to gross income, expense, and profit information, but also drill-down into details according to market segment.
Financial report 130, however, further comprises profitability data 134. This profitability data includes specific characteristics according to market segment, e.g., for the expense Account Travel the profitability characteristic product group with value “Consumer Products”, and other product segments.
Reports generated according to embodiments may thus accommodate the analysis of financial information with a flexibility and detail not typically available to conventional approaches. For example, the report of
Accordingly, this report allows costs to be allocated to a market segment, with travel costs posted to CO-Objects from which the market segment is derived. Thus
In a second step 154 the engine receives market segment information. In a third step 156 the engine processes the accounting data and the market segment information data to create a universal journal entry integrating the accounting data and the market segment information to allow profitability reporting out of P&L reporting.
In a fourth step 158 the engine generates a report from the universal journal entry. In a fifth step 160, the engine displays the report to a user.
Further details regarding systems and methods of financial reporting integrating profitability and accounting data, are provided below in connection with the following specific example.
An example of a financial reporting methods and systems according to an embodiment, is now presented in connection with financial reporting of project based services. In particular,
A key to the seven transactions is given in the following table.
/h
Financial information 208 corresponds to a particular Product P100 and Customer 4711. Transaction (6) represents COGS, while transaction (7) represents periodic costs.
Processing of financial information for reporting according to embodiments, thus allows for new reporting qualities by profitability. This is illustrated in the display interface of
Embodiments allow reporting of financial information in an insightful manner to a user. One example of such a visualization of financial data is profitability on a time line (e.g., X-axis) with market segment as filter value or for comparison. Another example of such a visualization of financial data is profitability on a time line (e.g., X-axis) taken over a specific period to analyze line particular line items.
The structure of a Universal Journal Entry (UJE) according to some exemplary embodiments, is now described. In particular, a UJE line item (table=ACDOCA) combines FIN applications and may include one or more of the following:
For example, this embodiment offers unified JE extensibility including CO-PA. In the ACDOCA table, the APPEND APP . . . COPA may include a package KEG0 (like CE4xxxx). Identical field names may be used, with a suffix in the table avoiding collisions.
Also, FIORI is a particular user interface that is offered by SAP SE of Walldorf, Germany. The particular embodiment of
The CE4CUST table is a CO-PA table including characteristics encoded by object numbers (PAOBJNR). This may be generated in package KEG0.
Coding block customer fields and other extensions go into separate INCL_EEW_ACDOCA.
CO-PA fields can be addressed identically in the runtime structure and in the table:
The use of separate extension “includes”, allows separate treatment for FIORI extensibility. Coding block fields only may be visible on the planned coding block reuse UI component. CO-PA fields are visible in a separate section of the document display only.
Here the INCL_EEW_ACDOCA extension includes for coding block customer fields and market segment characteristics not included in a standard. INCLUDE Cl . . . COPA is a customer package. The fields start with Z/Y. There is no separation from Cl_COBL fields for FIORI extensibility.
CE4CUST is a CO-PA/Market segment table including characteristics encoded by object numbers (PAOBJNR). It is generated in package KEG0.
The runtime process commences with receipt of a prima nota such as an invoice. Accounting data is created/received from various sources. A market segment derivation engine is driven by the new business process, referencing the previous definition of market segments and their values during design time. Market segments are next derived, and the USE created with reference to the (enhanced) UJE structure previously established at design time. Finally, a report is generated and displayed.
In summary, embodiments may provide enriched market segment information within a financial document. For example, an embodiment may provide customer specific fields in a single financial document structure. This avoids having separate storage or separate documents for purposes of cost management and profitability reporting.
Embodiments may allow a user to provide rules defining market segments in a flexible manner. For example, a user may create a report region rule to derive a region from customer master data.
Utilizing system setup, embodiments may generate these fields as appended to the financial document structure/universal journal entry, and store the link between the defined market segment characteristics and the field in the financial document structure.
Embodiments enrich relevant financials document line items with the defined market segment information during document posting. This is provided for P&L and selected balance line items.
Embodiments may employ a business process dependent rules engine to provide enriched data. The rules engine allows control over those market segments provided and updated. Additional characteristics information may be derived on the basis of the business process dependent rules. These rules can be activated and maintained by the customer.
Examples of scenarios utilizing enriched reporting can include but are not limited to the following. For posting a sales order item, the data of the sales order is read to obtain customer, product, and other sales order information. On the basis of the determined master data, further additional data can be derived depending on information furnished by the user.
Another example relates to posting on a customer project. There, embodiments can determine the leading sales order item, and start a derivation chain as described above.
Regarding deferred and accrued costs and revenues, embodiments can provide in balance line items, characteristics such customer and project.
In some processes a user can directly define market segment information. In such cases, there may be no additional derivation chain. Also, in some logistics processes it may not make sense to employ derivation in order to obtain sensed data, e.g., there may be no need to derive market segments for material price differences of raw materials.
Embodiments may provide additional P&L line items for calculatory costs. Thus, additional line items may be provided for the cost component split at the point of time of delivery posting. This information is obtained by reading cost estimation.
Some embodiments may provide additional line items reflecting the different production variances categories (e.g. scrap, price difference, quantity differences) at the point of time of production order settlement.
Embodiments may post calculatory costs on base of customer sales order and billing information, like freights or provision and customer deductions by interpreting the pricing conditions and further customer specific customization. Additional line items may be posted to provide the information.
Methods and systems of financial reporting according to embodiments may allow for flexible characteristic realignment. In particular, a market segment characteristic may be derived at a point in time of financial document posting to afford insights in near-real time.
Embodiments provide a realignment tool to derive market segments for already posted documents (e.g., for data migrated from other ERP versions). Where a new market segment is defined, existing structures and/or master data may be changed and some new characteristics derived.
Financial reporting embodiments may be compatible with existing data warehouses. Thus, legacy posted information (e.g. lacking the journal entry) may be processed according to the rule engine, in order to obtain enriched insight for that past data.
Embodiments as described herein may provide one or more benefits to a user. One potential benefit is the lack of need for complex and difficult reconciliation efforts. That is, the cost Management and profitability application receives the data out of an income statement—a single source of truth.
Financial reporting systems and methods according to embodiments may also offer the advantage of simplification. That is, data transfer and translation between different financials application is no longer necessary—e.g., there is no settlement.
Also, the same language may be used for different types of financial data. Because the same entities are used for accounting and profitability reporting, there is no need to account for different aggregation, posted periods, and values in different applications.
Financial documents enriched according to embodiments may offer valuable new insights to a user. Some embodiments provide gross margin on market segment out of profit and loss data (income statement).
Certain embodiments may allow a user to drill down on expense in GL Accounts on market segments—e.g., travel per region. An example display afforded by such analysis is shown in the
Embodiments can show open items on a project or region level. A project manager can thus be afforded a holistic view of work in process, accrued revenues, open items—not limited to current P&L.
Moreover, embodiments provide additional characteristics at the time of creation of the financial document. This allows reporting of profitability in near real time, not restricted to conventional backwards-looking profitability.
Embodiments may provide higher quality financial data, affording better transparency and easing compliance burdens. Here, profitability is not just another Key Performance Indicator (KPI) whose internal make-up is not readily apparent to an ordinary user. Instead, a user can drill down into the financial document to identify components and significant relationships therebetween.
Embodiments may further offer simplified extensibility from user-specific fields. Only one table need be enhanced, with one resulting accounting document useful across a variety of different financial applications.
A user can define characteristics relevant to a particular business. That characteristic may then automatically be published in relevant financial document line items. Thus in an example, a user comprising a professional service company may seek revenue and Cost of Goods Sold (COGS) on an employee level. The user may define regions like Asia Pacific Japan (APJ) or Europe, Middle East, and Africa (EMEA), which are aggregations of individual countries.
Additional general ledger (GL) line items useful for purposes of providing multi-level gross margin, may be posted in a Cost Management Appendix ledger. Examples may include but are not limited to the following.
Embodiments may allow a user to decide in which ledger to post, permitting separation of legal and management accounting.
An example computer system 510 is illustrated in
Computer system 510 may be coupled via bus 505 to a display 512, such as a cathode ray tube (CRT) or liquid crystal display (LCD), for displaying information to a computer user. An input device 511 such as a keyboard and/or mouse is coupled to bus 505 for communicating information and command selections from the user to processor 501. The combination of these components allows the user to communicate with the system. In some systems, bus 505 may be divided into multiple specialized buses.
Computer system 510 also includes a network interface 504 coupled with bus 505. Network interface 504 may provide two-way data communication between computer system 510 and the local network 520. The network interface 504 may be a digital subscriber line (DSL) or a modem to provide data communication connection over a telephone line, for example. Another example of the network interface is a local area network (LAN) card to provide a data communication connection to a compatible LAN. Wireless links are another example. In any such implementation, network interface 504 sends and receives electrical, electromagnetic, or optical signals that carry digital data streams representing various types of information.
Computer system 510 can send and receive information, including messages or other interface actions, through the network interface 504 across a local network 520, an Intranet, or the Internet 530. For a local network, computer system 510 may communicate with a plurality of other computer machines, such as server 515. Accordingly, computer system 510 and server computer systems represented by server 515 may form a cloud computing network, which may be programmed with processes described herein. In the Internet example, software components or services may reside on multiple different computer systems 510 or servers 531-435 across the network. The processes described above may be implemented on one or more servers, for example. A server 531 may transmit actions or messages from one component, through Internet 530, local network 520, and network interface 504 to a component on computer system 510. The software components and processes described above may be implemented on any computer system and send and/or receive information across a network, for example.
The above description illustrates various embodiments along with examples of how aspects may be implemented. The above examples and embodiments should not be deemed to be the only embodiments, and are presented to illustrate the flexibility and potential benefits as defined by the following claims. Based on the above disclosure and the following claims, other arrangements, embodiments, implementations and equivalents will be evident to those skilled in the art and may be employed without departing from the spirit and scope of the invention as defined by the claims.
The instant nonprovisional patent application claims priority to U.S. Provisional Patent Application No. 62/139,909, filed Mar. 30, 2015 and incorporated by reference in its entirety herein for all purposes.
Number | Date | Country | |
---|---|---|---|
62139909 | Mar 2015 | US |