Google Sheets Report for Vouchers Sold
$250-750 USD
Paid on delivery
We sell vouchers/coupons to different website for our premium subscription service. There is a report in CSV format which provides details of all the issued vouchers to date, plus the source site, price, and whether it has been redeemed or not.
I need to create a Google Sheet to report on the sales of each site broken down by month (for the redeemed vouchers), and the prices need to be converted to a different number as well.
1) The report should have the voucher sales for each month broken down by the site (source)
2) The report should provide the total balance due for each site for the vouchers they have sold
3) I should be able to input the payment received from each one along with the payment date (and their balance due should update accordingly)
4) It should include a couple of visual reports (pie chart, bar chart etc) to track and trend which sites are performing better over time in terms of sales, and also to track which products are selling more, trend over time.
5) The sheet should be easy to read, clean color codes, borders, neat and organized.
Ideally it should be easy for me to run this report moving forward once we have a template in place, each month I would be able to just import the same updated CSV file except it will include the new data as well and the Google Sheet will do all the calculations.
I have attached the CSV file for reference. Starting month is March 2021.
Currently there these are the sites (source), but more will be added later so should be flexible:
[login to view URL]
[login to view URL]
giftino
license-market
GiftCardGo
[login to view URL]
Comp
Project ID: #31006365
About the project
Awarded to:
Sir, I understand your requirements, I have over 7 years of experience in Excel. I am Excel/Google sheet Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am More
7 freelancers are bidding on average $339 for this job
Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I'll give you Unlimited revision. I am ready to start work right now and can assure best service from my en More
Hi I read your project carefully and ready for on its. Hope to hire from you in your project. disscussed in more detail.
In my work life I have gathered more than 15 years experience in Excel. I have also worked with Google Sheets in my current company which I have been with over 8 years. My work is precise, constructive and neat. I only More