Writing a macro

From 1C, a report on the movement of commodity and material values at the enterprise for each month is unloaded together with a turnover sheet, which reflects all movements in the warehouse for the reporting month. It is necessary to write a macro deduces the general change in the balances both in rubles and in names and their quantitative change. More details can be discussed via video link. I will send the file types after the agreement.