Suoritettu

Google Sheets Report for Vouchers Sold

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

Taidot: Excel, Google Sheets

Näytä lisää: google adwords report api xslt, google adwords report script, google adwords expired vouchers, download google analytics report php, design a logo we sell software (as a online service) for doctors, design a logo we sell software as a online service for doctors, google sheets report builder, google sheets report writer, google sheets report templates, adwords report to google sheets, expense report template google sheets, google sheets analytics skip report, export salesforce report to google sheets, social media report template google sheets, google sheets social media report, sell google sheets templates, asana google sheets report, google sheets report generator, amazon fba 2019 sales report dashboard template for google sheets, google sheets expense report template

Tietoa työnantajasta:
( 1 arvostelu ) Arlington, United States

Projektin tunnus: #31006365

Myönnetty käyttäjälle:

AccountantArman

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 Lisää

$250 USD 2 päivässä
(85 Arvostelua)
5.4

7 freelanceria on tarjonnut keskimäärin $339 tähän työhön

(121 arvostelua)
6.0
Chandravarun619

Hi, Good day. I am an expert in MS office and the same applies for G Sheets. [login to view URL] I would like to go through this sample Lisää

$250 USD 1 päivässä
(13 arvostelua)
4.2
ismail80196

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 Lisää

$250 USD 1 päivässä
(3 arvostelua)
1.8
laylamum2

I possess all the skills and experience that you're looking for, I've read your all requirement of your project. I can do this work with high quality and within the shortest time, you will be satisfied with the result Lisää

$500 USD 7 päivässä
(0 arvostelua)
0.0
MIKDWS

Hi I read your project carefully and ready for on its. Hope to hire from you in your project. disscussed in more detail.

$250 USD 2 päivässä
(0 arvostelua)
0.0
marsberry20

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 Lisää

$550 USD 5 päivässä
(0 arvostelua)
0.0