CMMaliniJoshi
New Member
Dear All
I have got sample balance sheet data in CSV files for two separate dates. Based on these CSVs I have to provide comparative data of increase / decrease in selected parameters of the balance sheet. The sample data is as per CSV files attached. I need output as per excel file attached with the name Comparative.xlsx Sheet named "Output". I shall be getting CSV file for each date separately. I shall keep adding new CSV file in the dedicated folder for the purpose. However, I shall have to present comparative data of any two dates only on any given point of time.
I could manage to achieve data for all the parameters. But one more parameter is required in my output i.e. Working Capital. I cannot figure out how to achieve the same in output. Now, Working Capital is to be derived as under:
Total of Balance Sheet - (Minus) Branch Adjustment.
Now, branch adjustments can appear on both side of Balance Sheets (Assets / Liability) and I have to nullify the effect of Branch Adjustment i.e. Branch Adjustment on one side of Balance Sheet will be deducted from total of Balance Sheet and Branch Adjustment on Second Side will be added to total of Balance Sheet.
Finally, I have to show Working Capital of each month as a separate parameter in the output alongwith increase / decrease in two dates.
I have achieved output of the rest of the parameters as per Excel Attached named "Comparative.xlsx" which is also having Queries prepared by me. But I am yet to work out working capital. I request you all provide a solution to workout Working Capital as desired in output. Besides, if anyone can give better idea on how to present other parameters alongwith Working Capital, I shall be thankful.
Regards
I have got sample balance sheet data in CSV files for two separate dates. Based on these CSVs I have to provide comparative data of increase / decrease in selected parameters of the balance sheet. The sample data is as per CSV files attached. I need output as per excel file attached with the name Comparative.xlsx Sheet named "Output". I shall be getting CSV file for each date separately. I shall keep adding new CSV file in the dedicated folder for the purpose. However, I shall have to present comparative data of any two dates only on any given point of time.
I could manage to achieve data for all the parameters. But one more parameter is required in my output i.e. Working Capital. I cannot figure out how to achieve the same in output. Now, Working Capital is to be derived as under:
Total of Balance Sheet - (Minus) Branch Adjustment.
Now, branch adjustments can appear on both side of Balance Sheets (Assets / Liability) and I have to nullify the effect of Branch Adjustment i.e. Branch Adjustment on one side of Balance Sheet will be deducted from total of Balance Sheet and Branch Adjustment on Second Side will be added to total of Balance Sheet.
Finally, I have to show Working Capital of each month as a separate parameter in the output alongwith increase / decrease in two dates.
I have achieved output of the rest of the parameters as per Excel Attached named "Comparative.xlsx" which is also having Queries prepared by me. But I am yet to work out working capital. I request you all provide a solution to workout Working Capital as desired in output. Besides, if anyone can give better idea on how to present other parameters alongwith Working Capital, I shall be thankful.
Regards