Search results

Hi all, Background: After implementation of GST in India, Buyers of Goods / Services have got a serious issue in form of Reconciliation of GST Input. Every month we (Buyers) have to download GSTR-2A files in JSON format and convert into Excel. GSTR-2A is nothing but GSTR-1 of Suppliers who...

I have attached two excel files 1) FormatAAR 2)FormatAAR - New 1st file is the report (Account Analysis Report) we generate from Oracle ERP and it contains a sheet namely"FNDWRR". 2nd file is the formatted form of 1st file which we do manually every time we generate from Oracle ERP as per the...

The attached file is having live data of BG Commission. BG Commission rate, BG amount is given. If the status of BG is "Issue" then BG Commission to be calculated for those number of days i.e. from BG date to till date of Extension (AD column in attached file). If the status of BG...

The detail requirement is mentioned in the uploaded file. In gist, in a range of ageing columns of a vendor, any positive figure shall be adjusted with the negative figures depending on criteria. Output is required in another sheet in same format as in source data. At present I have been...

Hi all, Now the question is I have Project codes in Column A. There are blank cells between project codes. How to fill those blank cells... To understand better please refer attached excel file. Thanks in advance Surya

Hi all, This is Surya, from Hyderabad, India. This is my first day in the forum. I have been working in Finance of a construction company. Normally I receive data from all site accountants who are spread all over India in different formats and my job is to consolidate the data in a standardized...

There is some data in the range A1:A100.Now I want to delete the data in those cells against which there will be data in range B1:B100 and C1:C100 To be specific about my requirement,I got a worksheet which contains data in A2,B2,C2, A10,B10,C10 and so on.Now I want the data in column A...