Custom Google Spreadsheet for COD Operations -- 2

$10-30 USD

Stengt

Lagt ut

omtrent 2 måneder siden

$10-30 USD

Betalt ved levering

So our company is doing Cash On delivery, and the shipping company gives us a spreadsheet with all the transaction: - name of the person in our team who closed the sale “It’s an individual identifier code XRZET for ex” - Amount of the payment received in Algerian Dinar - Net amount after shipping fees - Return fees (returns if there’s returns) - State where costumer lives - Date of order creation - Date of shipping What I need: A google sheet that allows me to read the data easily. - Checking the total sales / Sale amount / returns of each team member in a specific period of time (Or eventually, daily, weekly, monthly, quarterly) - Checking in couple clicks total sale amount in a specific timeframe (Total amount and total after fees) - Checking in couple clicks total sales by States - Checking in couple clicks total orders in a specific day. - Converting the Algerian dinar into USD with today’s price of Dollar. - Checking in couple clicks the total spent on shipping in a specific timeframe. - New column for AD expenses monthly - New column for Team expenses monthly - Getting the total profit after ADS/TEAM expenses in a specific timeframe. - A Graph showing the Expenses to Profit per Day / Week / Month / Quarter (Something visually easy to read) - Getting easily total sales per product in a specific timeframe. - Anything else that is visual and helps reading the date with ease would be more than welcome - It should be easy to just copy past the new data to get it integrated to the whole I need this for today, please bid only if you can get it all set for today. I’m paying $10 to $20 for this depending on your Google sheet ninja [login to view URL] send me some examples of Google sheets you've made. Attached example of desired end result. PS: I need Google Sheet not MS Excel.

Prosjekt-ID: 38757512

Om prosjektet

30 forslag

Eksternt prosjekt

Aktiv 20 dager siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

30 frilansere byr i gjennomsnitt $32 USD for denne jobben

@merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$50 USD om 7 dager

4,8

(149 omtaler)

5,8

@carlitanjuguna05

Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includesGoogle Sheets, Google Spreadsheets, Excel and Data Processing, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.

$30 USD om 2 dager

5,0

(10 omtaler)

4,9

@monicawriter99

Hello employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Custom Google Spreadsheet for COD Operations -- 2 ". I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in Google Sheets, Data Processing, Google Spreadsheets and Excel. On Freelancer.com, I seek to help individuals, groups, or companies solve their statistical problems in various types of disciplines. My previous experience includes, but is not limited to: Descriptive Statistics, Visual Representation, Regression Analysis, Analysis of Variance, Nonparametric Statistics, etc. Click on my profile, (https://www.freelancer.com/hireme/monicawriter99) to see my profile reviews as well as have an insight into what I will do for you. Thanks.

$100 USD om 3 dager

4,7

(18 omtaler)

4,9

@saim2105

With my comprehensive background in data analysis, document management, and automation, I'm a perfect match for your project. My expertise in creating complex data formulas and reports using Excel is completely transferrable to Google Sheets. I understand the importance of checking your team's total sales, returns, order amounts, as well as tracking expenses effectively for a Cash On Delivery (COD) operation. My approach is not only thorough but also efficient in order to facilitate easy access and comprehension of your spreadsheet data, much like the attached example you provided. My proficiency in Google Sheets goes beyond simple data organization; I excel at creating dynamic formulas that automatically convert Algerian Dinar into USD using today's exchange rate. One of the highlights of my skills is leveraging Google Sheets' collaborative features to enable real-time teamwork which means easier integration for new data without any disruptions. Additionally, my extensive experience with formulas can aid in quickly generating the information you require about total sales per product in a specific timeframe.

$20 USD om 1 dag

4,9

(17 omtaler)

4,5

@aruls1962

It is possible to achieve your targets. I have done many similar projects. But, you have to increase your budget. The project may take a week to deliver. Let us chat to understand your requirements.

$50 USD om 7 dager

4,9

(19 omtaler)

4,2

@hmplakmal1

Hi, With an MBA, expertise in financial statement preparation and analysis, and hands-on experience with Google Sheets, I am the ideal candidate for your project. I understand how crucial it is for you to have a comprehensive Google Sheet that allows you to effortlessly track and analyze your cash on delivery operations. Not only can I ensure a clean, efficient and user-friendly design, but also implement smart formulas and functions that will automate much of the data processing duties for you. My 14 years of professional experience have honed my analytical skills, enabling me to quickly parse through large sets of data for meaningful insights. By utilizing Google Sheets' capabilities alongside my accounting background, I can build reports that offer remarkable clarity on total sales by team member, specific timeframes or states, amount spent on shipping, anything you need and more. It's worth noting that my clients value the high-quality solutions I provide along with my timeliness, communication skills, and commitment to meeting deadlines. As proof of my proficiency with Google Sheets and similar projects similar to yours: "Prasad delivered exceptional work, completing the task on time and with high professionalism." It would be an honor to apply these traits to streamline your COD operations through a powerful but user-friendly Google Sheet. Thank You.

$108 USD om 1 dag

4,6

(8 omtaler)

3,3

@abhay686

Hello! I’m Abhay, experienced in creating dynamic Google Sheets dashboards tailored for easy data analysis. I can develop a comprehensive dashboard to track sales, returns, expenses, and profits with clear visuals and easy data entry. Project Scope: Dashboard Setup: Track sales, returns, and net profit by team member, state, and time period (daily, weekly, monthly, etc.). Automated Calculations: Real-time currency conversion for sales in USD, shipping expenses, and profit calculations. Expense Tracking: New columns for monthly ad and team expenses, with total profit calculations. Visuals: Graphs showing profit vs. expenses (by day, week, month). Easy Data Integration: Simple copy-paste setup for adding new data seamlessly. With my expertise, I’ll ensure your sheet is efficient and easy to read. Looking forward to building this for you today!

$20 USD om 1 dag

5,0

(3 omtaler)

3,1

@ayazakhtar75

Leveraging my 15+ years of expertise in data science, I'm confident that I can construct the Google Spreadsheet you need today. My proficiency in Excel and Google Sheets, especially in areas such as macro automation, KPI tracking, financial modeling, and data analysis and visualization, enables me to design advanced spreadsheets that answer your precise needs for easy data observation. Moreover, my competence in Google Apps Script Automation allows me to ensure seamless integration of the shipping company's spreadsheet with your desired format without the risk of information loss or disruption. Lastly but importantly,I've attached some examples of my previous work for your perusal. From streamlining workflows to providing actionable insights to businesses, I believe the skills and solutions I offer align perfectly with your project needs. Let's transform your COD operations together!

$20 USD om 7 dager

5,0

(10 omtaler)

2,9

@Iffahuzaifa

Hi,Adi M. I am thrilled to submit my application for your Project Custom Google Spreadsheet for COD Operations -- 2 With more than 7 years of experience as an Animator, Graphic Designer, and Video Editor, I am confident in my ability to achieve outstanding results. I am proficient in Data Processing, Excel, Google Sheets, Google Spreadsheets You can check my similar work in my portfolio link: https://www.freelancer.com/u/Iffahuzaifa Collaborating with me offers you: - Unlimited revisions to ensure your complete satisfaction with the final product - 24/7 support to promptly address any concerns you may have - Deliverables in any format you prefer Feel free to join the chat and discuss your requirements in detail. Regards, Iffa H.

$20 USD om 1 dag

0,0

(0 omtaler)

0,0

@Ferdosky

streamline your data from the shipping spreadsheet, I can set up a Google Sheet that includes interactive features for tracking sales, returns, and expenses. The design will allow you to view total sales by team member and state with just a couple of clicks. With experience in Google Sheets, I can also create automatic conversions for Algerian Dinar to USD, generate profit graphs, and ensure easy data integration through a copy-paste functionality. You’ll be able to visualize your profits against expenses seamlessly. I can complete this today to meet your urgent needs. Please share the spreadsheet and any existing data, and I’ll get started immediately. I look forward to your response. Best Regards, Ferdinand

$20 USD om 2 dager

0,0

(0 omtaler)

0,0

@Susi0106

worked as an administrator at a large pharmaceutical company for approximately 12 years and mastered the company's monthly purchasing planning

$20 USD om 7 dager

0,0

(0 omtaler)

0,0

@somiaahmed8

Hi, I read all the requirements, and I have strong skills in Google sheet to provide you what do you need. I could provide you data analysis and preprocessing through many methods in addition to the method you mentioned. Contact me to see some my previous work and work right now.

$20 USD om 7 dager

0,0

(0 omtaler)

0,0

@rioardi12

I can work with this and try to help the company to manage spreadsheet of COD in here i have Appsheet for my workplace I hope you Open for me, Thanks

$20 USD om 7 dager

0,0

(0 omtaler)

0,0

@tariq900

Hello, I can create a user-friendly Google Sheet for easy tracking and analysis of your Cash On Delivery data. This sheet will allow you to instantly view: Total sales, payment amounts, returns, and expenses by team member, date, and location Automatic Dinar-to-USD conversion for accurate financial tracking Shipping and expense tracking for clear cost management Quick updates by copy-pasting new data for seamless integration Clear visual graphs to track profit vs. expenses over any timeframe I can complete this today for $15 and I’d be happy to share examples of similar work. Looking forward to helping you! Best, Tariq Majeed

$15 USD om 5 dager

0,0

(0 omtaler)

0,0

@sewwandik1

With over 3 years of experience in IT and a zeal for coding and web development, I am more than ready to transform your cash on delivery operations. Besides being well-versed in Excel, I also have extensive skills in Google Sheets. Despite working as a freelancer, I combine academic excellence with real-world experience from previous projects in delivering quality and professional results within stipulated deadlines, so completing your project today is absolutely plausible. To give you a customized Google Sheet that precisely aligns with your needs is my core competence. With a glance, you can grasp total sales/returns of each member, total sales by states, total orders in a specific day and pounds or USD equivalent of Algerian Dinar. Furthermore, I can credit simple columns to accommodate monthly AD/TEAM expenses ad total profits just as you wish. But what sets me apart? I don't just deliver data sheets; I deliver visually breathtaking insights that make reading and interpreting complex data so much easier. I will actualize your vision of displaying date on a sleek, interactive graph that illustrates expenses to profit per different time periods – giving effortless aesthetic control over your operations. Team up with me today for quality data management tool that endows you full control

$20 USD om 7 dager

0,0

(0 omtaler)

0,0

@Samkarthi101

Hello, After carefully reading your requirements I understand that you need a custom google sheet tailored to calculate sales, Cod etc I have been working in making custom google sheets for businesses such as yours that delivers precision data to run sales I have been using Appscript to develop custom spreadsheets to a mnc company that boosted their sales and automated their daily tasks such as uploading a Google sheet directly to their gcp for later review, pie charts, creating QR codes inside each cells for the product availability etc. I can confidently say that I would be a perfect candidate to complete your project on time within the 4 days of the start date. Hoping to be the one to help you achieve your goals! Good day, Best regards

$15 USD om 4 dager

0,0

(0 omtaler)

0,0

@FasinAham

Hello! I've carefully reviewed the job description, and I'm confident I can meet your expectations and deliver high-quality work with 100% satisfaction. I'll handle the task with precision and ensure full confidentiality of the document. I'm ready and available to start immediately and am committed to completing the work within your specified timeline. I'm certain I can provide top-quality results in a short time. Thank you, and I look forward to the opportunity.

$10 USD om 5 dager

0,0

(0 omtaler)

0,0

@danielkazazaev

I am available to assist with your project today! I can create exactly what you're looking for, but I recommend partially integrating the graphs into Looker Studio, part of the Google Suite, for enhanced readability and better visualization. To implement your project, I propose using: -A hidden log sheet to store all raw data -A submit sheet to add new, unique data to the log at the press of a button -A CSV backup in Google Drive The remaining elements, such as data validation and dropdown menus, can be implemented directly. However, Looker Studio is more suitable for this type of application, as it would enhance the data presentation. Unfortunately, I cannot share previous project files due to IP constraints from my prior employer, but I have outlined a few relevant projects below: Stock Inconsistency Resolution Dashboard in Google Sheets, which fetched data from the Warehouse Stock Management System to analyze errors reported by employees. This reduced error resolution time significantly and lowered training costs. Trainee Onboarding Dashboard in Looker Studio, which centralized previously inconsistent information on trial period progress. Best regards, Daniel Kazazaev

$10 USD om 1 dag

0,0

(0 omtaler)

0,0

@RuchiraDulaj

I am an ideal candidate for your project due to my strong Google Sheets expertise, including advanced formulas, pivot tables, and visual data presentation. I can set up automated calculations, currency conversions, and clear dashboards to make it easy to track team performance, expenses, and profit trends at a glance. I understand your need for an intuitive, easy-to-update system that allows for quick insights into daily, weekly, and monthly sales data. I can efficiently deliver this solution today, ensuring accuracy and ease of use. Ruchira

$20 USD om 1 dag

0,0

(0 omtaler)

0,0

@Salsabilag20

Semoga saya bisa bekerja dengan baik dan di terima dengan senang hati , syaberharap dengan saya di terima di sni say bisa membantu kluarga say yg sedang kesusahan ?

$20 USD om 7 dager