Any accounting software, except for the most primitive, can easily calculate the cost of inventory, balance list on a specific counterparty, or gross profit for a given period.
All these data is vital for a company, but on their own they won’t give you the big picture of the company’s financial standing.
The big picture can be seen through integrated reporting forms.
Traditionally, the most important ones, as considered by finance professionals, are the Balance Sheet, P&L — profit and loss statement, and Cash Flow.
By their nature, integrated reporting forms require collecting, organizing and grouping of data from a variety of "simple" reports.
Since most of the widely used accounting systems can’t do that (and the vast majority of those that claim they can — can only do it in promises of their sellers), in 99.9% of Russian (and not only Russian) companies, integrated reporting forms are made using poor old Excel.
As well as hands, eyes, and consequently wasting millions of man years.
And those titanic "pivots’!.. Those, who haven’t seen them, never got the smell of powder.
If Dante lived in our time, then generations of accounting and finance professionals and their oceans of tears and grinding of teeth would provide him with far more convincing material to describe purgatory, then his own dull fantasies did against the background of a complete absence of MS Excel in the 15th century.
The financial unit of dia$par offers a flexible and universal report constructor for complicated reporting
For illustration purposes, let’s design a simplest version of a P&L report:
CRM-system. Firstly it will be of no help, secondly it is gibberish all-in-all.minus Cost of Goods
= Gross Profit
CRM-system. Firstly it will be of no help, secondly it is gibberish all-in-all.minus Expenses
= Net Profit (Loss)
Thus, we’ll need data on sales for the period and accrued expenses. If we have information on the cost of goods, we can calculate gross profit, and then subtract expenses.
Configuring the report includes selecting sources of data and setting up variables in these sources (for financial reports it’s the "amount", for product reports it’s the "quantity" AND/OR "amount") for groups to be calculated.
1. Selecting sources of data:
2. Configuring variables and calculated fields:
3. Voilà! The P&L report is configured, then you can run it with a press of that one single button:
The flexibility and versatility of this mechanism allow designing forms however complex with multilevel grouping.
Cash flow report:
That’s it — and you won’t need? Excel any more.