Management accounting, data analysis 1C, Excel

How am I working?My main attribute is that I enter into the essence and understand in all aspects of the assigned task, I study the interconnection.I am based on my rich experience, knowledge, practice.The customer addressed me with a problem - it is necessary to form a standard VAT report, but the data for him in the 1C-Accounting base is almost no (VAT articles showed almost nothing, it was necessary to discharg the turnover as much as possible, based on the pipes and documents, from which it was possible to extract some analytical information).I am very well mastered in the "Universal Report" tool.And I also understand how the balance is formed, what movements affect.This knowledge allowed me to set the report in such a way that, as a result of the download from 1C to Excel, the client was able to maximize the cash flow.The next step is P&L (Rapport of Profits and Losses).The similarly built universal report did not give 100% result, as it was necessary to apply several different settings to combine all into one report, as well as to check it for errors (as a rule, this is often the case because there are untypical operations).The cake on the cake is a balance.I am a master in this matter, as I can form a model from the usual turnover and saldo knowledge: the balance - related to the profit and loss report and the VAT report.These are three whales for managerial decisions.I in Excel built such a link from a multitude of formulas and processing so that every time I simply loaded the turn-sald trace for a new period, and the balance was already ready, after the injection into the required fields.It took a lot of time, as the period was not closed, and the setting was at the beginning of the period when there was little business operations.At the end of the period there were many accounting errors, it was necessary to take this into account in the balance settings so that the main rule was followed: Assets are always equal to Passives.#Government_Account #Finances