P&L and Balance Sheet – Detailed Reports
Automated financial reports developed in response to the issue of manual data generation following the implementation of a new system.
Objective:
To automate quarterly P&L and balance sheet reports that, after system go-live, were generated manually and required several days of work.
Scope:
➤ Rebuilding the report by designing a data model and presentation layer in BI Publisher
➤ Adding a column to indicate whether a company belongs to a capital group
Challenges:
➤ Joining accounts with exceptions (e.g., 700 + 701 without 7010101)
➤ Creating three reports with identical layout: comparative, calculation-based, and balance — each based on different data
➤ Recreating the visual appearance of the previous system’s report due to audit requirements
➤ One report variant required classification by cost center (account 5), which didn’t exist in the system — solved by locating and using several low-level Oracle tables not accessible in standard reporting
Outcome:
➤ Reduced report preparation time from 3–5 days to a few minutes
➤ Eliminated errors from manual processing
➤ Report became a standard across all group companies
Technologies:
Oracle BI Publisher, SQL, general ledger, internal Oracle tables
Year:
2022