In Progress

Google Sheet File for Sales, Shipment, Invoice

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

Skills: Excel, PHP, Data Entry, Microsoft Access, Data Processing

See more: professional cool invoice google docs, google docs work invoice template, invoice tracker google sheets, dj invoice google docs, freshbooks google docs invoice, proforma invoice template google docs, generate invoice from google spreadsheet, google sheet invoice template, google shape file shp editor, online sales service invoice, phpbb3 google sitemap file, import excel file quick books invoice, google banner file format, google banner file size, best sales online invoice software, open google earth file, google analytics track sales across multiple domains, excel vba sheet file, google results file download, clicktag google add file size

About the Employer:
( 9 reviews ) Turkey

Project ID: #26561511

Awarded to:

umairabdillah12

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 f More

$150 USD in 5 days
(18 Reviews)
4.8

47 freelancers are bidding on average $136 for this job

(671 Reviews)
8.7
schoudhary1553

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 kin More

$30 USD in 7 days
(433 Reviews)
8.2
(61 Reviews)
6.6
finecodervw

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 projec More

$200 USD in 7 days
(201 Reviews)
6.6
sharmarahulraman

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 ca More

$250 USD in 8 days
(118 Reviews)
6.5
zu02

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 release More

$250 USD in 7 days
(58 Reviews)
6.2
sadikkhan491

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 su More

$50 USD in 1 day
(3 Reviews)
4.6
corporatessc

Hi There, I have understood your requirement to have a single sheet solution which will have multiple sheets to manage Orders, Order contracts, Invoices, Shipments, Commission, Commission invoices, Commission Invoice More

$200 USD in 5 days
(9 Reviews)
4.3
samanabbad

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.

$140 USD in 7 days
(11 Reviews)
3.9
govindpatra

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 F More

$120 USD in 4 days
(7 Reviews)
3.5
rabiainayat

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. Pric More

$100 USD in 7 days
(3 Reviews)
3.2
tsft

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 More

$250 USD in 14 days
(4 Reviews)
2.9
torikul7644

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 More

$30 USD in 1 day
(4 Reviews)
2.2
mmustansar1

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 More

$100 USD in 5 days
(7 Reviews)
1.8
softxplorers

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 More

$140 USD in 2 days
(1 Review)
1.3
kunder24

I will be happy to work on the project. I have an extensive history of working on Excel in reference to Accounts receivables, payables, ledgers, invoicing, and reportings. Feel free to contact me if you believe I can w More

$166 USD in 5 days
(0 Reviews)
0.0
llenore1996x

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 definitely take care of for you. More

$80 USD in 7 days
(0 Reviews)
0.0
rohitbarapatre00

Hello Sir, I have many data entry projects till date. I have great skills in it. Trust me. I have fast typing speed. You won't regret. Would love to hear from you. Thanks.

$140 USD in 7 days
(0 Reviews)
0.0
kishore1395

TYPING COMMUNICATION SKILLS Good at communication. Leadership qualities. Time management. Confident. Quick learner Social service WILL DO WORK IN TIME

$140 USD in 7 days
(0 Reviews)
0.0
Sarandapetanaj

Hello, I have extensive experience with data entry and creating invoices. I can have this project back to you as soon as possible! Thank you, Saranda Petanaj

$140 USD in 7 days
(0 Reviews)
0.0