I need a singel google sheet file where i need to do below list. All formulas should created accordingly so we wont have problem once orders populated.
Register and manage sale contracts based our short products.
Register and manage container shipments related to sales.
Register, track and manage Invoices issued by suppliers for related orders.
Create Inhouse commission Invoices made and calculated based on Suppliers registered invoices and due dates.
Detailed report/sorting must be applied so it will be easy for us to analyze, locate, amend or track orders, sales ,shipment, invoices, commissions
We will put all necessary data so system and functions works.
DETAILS:
Sheets Suggestions:
(This can be changed based on suggestions that might help the functionally of the system)
Orders Sheet
This sheet where i see details of each order created by us. Each order must have uniquie automatically created order number.
Each order can have 1 or more shipments. Each order can have 1 or more Invoices. When creating an order a unique number can be given for each shipment and invoice we create for that order
Orders Status stays open until all products are delivered. Once order is closed
We will let you know data fields we need.
Order Contract Sheet
This will be just A4 Size contract area where it can automatically populate by selecting an order number and data needed. We use this to create a contract. This can be exported pdf or printed.
Invoices Sheet:
This area will be to register each invoice created by the supplier in relations with order/shipment created by us. We will let you know data fields we need.
Shipments Sheet
This sheet we want to register and track all shipments done by supplier.
We will let you know data fields we need.
Commissions Sheet
In this sheet , Details will be populated based on Invoices data registered. We must be able to see different views based on below selection or below multiple combined selection (eg. Customers + Due Date)
Period of Time
Due Date
Customer
Supplier
Paid or Unpaid
Comission Invoice Sheet
In this sheet, i want to create a unique invoices based on criteria selected to make an commission invoice. Invoice are made based on Supplier invoices list and their commission amounts. Once the invoice is created, all items(populated and calculated supplier invoices must have their commission status from Unpaid to Paid.
The main purpose here is not to calculate a commission that’s already invoiced by us.
The order details of invoice; Bank, payment will be pulled from Bank Sheet.
Commission Invoices List Sheet
In this sheet i need to see all created commission invoices with their breakdowns
Report Sheet
In this sheet i want to see values such as below
In a given time frame: Total Order, Total Sold KG, Sales breakdown based on selected group of product. Total order by supplier, Total order by customer. Total Income, Total income by supplier ...etc
Hi There,
I have read your descriptions, i can help you to build Google Sheet for Sales, Shipment, Invoice as your requirements.
I can provide you high quality work and on time as your dateline.
Pleas kindly chat me for more discuss or detail about this project.,
I'm available now.
Thank You
Regard.
Joko
$150 USD ใน 5 วัน
5.0 (26 รีวิว)
5.1
5.1
46 freelancers are bidding on average $136 USD for this job
Hi, Greetings!
✅checked your project details: Google Sheet File for Sales, Shipment, Invoice
✅Completed Time: In project deadline
We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast
Hi,
As I understand you need Google sheet for Sales, Shipment and Invoice. It would help to discuss further on the requirement.
Keen to work on this project.
Recently completed Google Sheets/Google Maps based projects with good feedback.
https://www.freelancer.com/projects/google-maps-api/Goolge-Maps-personal-Pins/details
https://www.freelancer.com/projects/google-sheets/need-help-with-google-sheets/details
https://www.freelancer.com/projects/javascript/Advanced-Google-sheet-app-script/details
https://www.freelancer.com/projects/excel/Google-Sheet-Formula-24741350/details
Let me introduce myself as an expert in Google spreadsheets and Google docs. I am well versed with scripting in Google spreadsheets using Apps script, writing custom functions in Google spreadsheets, creating charts, custom functions, linking spreadsheets etc.
I would be happy to answer any queries that you may have.
Looking forward to working with you.
Thanks
Hello,
How are you?
I understand the requirements of your project, I'm interested to hear more about the project and about the subject matter of the lectures. this is something that I and my team can definitely take care of for you.
I am very happy to discuss this further and get started for you as soon as possible.
Thanks
rahul
Hello
I hope all's well with you.
If you'r looking for a developer proficient in Ms Access/vb for your project, then go on!.
I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released.
Really most of my projects I've developed in freelancer.com .
Please visit :https://www.freelancer.com/u/zu02?w=f
And please see for example the following screens in my portfolio : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a little view about my coding capabilities .
I charge $250 but I can offer a lower rate.
I hope hearing from you soon.
Thank you for your consideration and
Best Regards,
Zurab Esartia
Sir / Madam,
I can start to work immediately. Please take a minute to look at my Portfolio's video. I did this kind of project before.
I am highly confident about that. I can do this work with accuracy. Also, I make sure to give 100% quality and commitment to work.
Please give me an opportunity to do work on this project.
Thanks
Hi. I can start the conversion right away, promising you error-less and accurate work in the given time.I an experienced person in this field and I am sure that I will do the work in accordance to your requirements.
Dear Client; hope you are also doing well.
I'm a CA & CMA with more than 7 years of experience in diversified industries, specifically in Financial and Data Analysis. I'm confident enough to prepare the Google Sheet File for Sales, Shipment, Invoice. Please text me to discuss more about the project.
Please chose once and I assure you will never regret choosing me. Thank you for your attention to my bid, hoping your early response to me...
Regards|
Gobinda Kumar|
Hi there, hope you'll be doing great. I read your job posting and I'm pretty interested in doing that for you.
I'm a data analysis and database expert with 3 years of experience and can handle this task for you.
Price and time limit shall be negotiable.
Looking forward to hearing from you soon for more details.
Regards
Rabia
Hello Sir or Madam:
I am working with Google Sheets+Forms+Gamil automation for along time, I have already made integrated system for Supplieres+Sales+Cash and the like. I would like to solve your problem.
As you know, it includes several functionality, I can do for a less than 250, even time would be aprox. 14 days
Please message me for further data.
Thank you.
Dario.
Hello There!
Good Day!
Hope you are doing fine. Thanks for checking my proposal. I would be glad to work for you on this project; I am available full time and I can work on deadlines. I have vast experienced around this section. I am very interested in the web research & data entry that you advertised. As I have an experience in this field more than 10 years. Please take a look of my profile and past work. I think I am fit for your job. I want to do this job as your expected lead time I can give you a test if you want. I will have finished this job carefully and deliver on time. I am available for long term and want to grab this great chance.
Thanks and looking forward to hearing good news from you soon.
Best Regards
Toriqul Islam
Dear sir,
I have reviewed your requirements and can provide you solution for order processing with Google Sheets, formulas and google apps script.
I will create all the sheets as required, which will be interlinked for auto updating the information in the relevant sheets.
I will also add google sheets script, wherever required for automation i.e creating PDF Invoice and order status updation etc.
I can provide a demo, if you want to review it.
Please let me know if you have any query.
Thanks,
Mustansar
Hi
Thank you so much for reading my reply. I found my self very capable of doing this project that’s why I am applying for this project.
Actually, I have completed lots of similar projects in the past. I really love to work on these sorts of projects.
Looking forward for a positive response.
Regards:
Softxplorers
hello you can trust me with your work i can do it easily with perfection in limited time i have a very good experience in excel data processing ,data entry your work will be done before deadline.
hi..
I have read your requirements. i can help you with your project. I am new to this site but, I am in this field for past 3 years. If you give this work to me, I will complete your work within time without any flaws in it.
Dear Hiring manager,
I can retype your PDF document to Word Document right now with 100% accuracy. If you need any sample please let me know. Thanks!
I am an expert in Data Entry, PDF, Word, Copy Typing and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me.
Thanks
MD SAKIB
Hi,
I have gone through your reqirements and I am very expert at Google Spreadsheet. I would like to discuss more on this project to start the work as early as possible. Please contact me to start the work.
Thanks.
I have more than 2 years developing websites using Laravel Framework/JavaScript/PHP/MYSQL and extensive knowledge in Microsoft Office Application.
I confident that I will be able to do this project quickly as required.
Please send me a message so that we can discuss more.
Thanks.
Hello there!
Good day!
I am an Engineering student. I can complete 35 words per minute. I am capable of working under any kind of pressure and complete the assigned work and also very familiar to many software like Microsoft Office, Catia, Solid edge, Photoshop, etc.. I am also an expert typist where i can complete any kind of typing work without any mistake.