Monthly Sales Report Generation in Excel
Budget: €8 – €15 EUR
I'm in search of a professional to create monthly sales reports in Excel.
We need to create several tables starting from the attached files starting from input file 1
1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund".
2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached)
3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there are lines that are not present or do not have a value, you must report them in the VAT control output file report (attached).
4- Starting from input file 1 (attached), look for the lines of column D "product details" in column A of the newly created VAT output file and insert the respective value present in column B of the file in column K of the example output file (attached). VAT output.
5- Starting from the output file just created, create a new file such as the VAT corresponding file (attached) in which in column A "DATE" there are the dates present in column A of the "Input 1" file (only 1 line per date). In column B "VAT 4%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 4 in column K of the newly created output file. In column C "VAT 10%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 10 in column K of the newly created output file. In column D "VAT 22%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 22 in column K of the newly created output file.
Ideal Skills:
- Proficiency in Excel
- Experience in report creation
- Data analysis capabilities
- Attention to detail
If you any any other question please contact me.
Thanks,
Regards,
Marco
We need to create several tables starting from the attached files starting from input file 1
1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund".
2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached)
3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there are lines that are not present or do not have a value, you must report them in the VAT control output file report (attached).
4- Starting from input file 1 (attached), look for the lines of column D "product details" in column A of the newly created VAT output file and insert the respective value present in column B of the file in column K of the example output file (attached). VAT output.
5- Starting from the output file just created, create a new file such as the VAT corresponding file (attached) in which in column A "DATE" there are the dates present in column A of the "Input 1" file (only 1 line per date). In column B "VAT 4%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 4 in column K of the newly created output file. In column C "VAT 10%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 10 in column K of the newly created output file. In column D "VAT 22%" the sum of all the values in column J "order total" of the input 1 file which have the same date in column A "DATE" of the "example output" file and the value 22 in column K of the newly created output file.
Ideal Skills:
- Proficiency in Excel
- Experience in report creation
- Data analysis capabilities
- Attention to detail
If you any any other question please contact me.
Thanks,
Regards,
Marco