Find Jobs
Hire Freelancers

Develop a Job Costing System(Including: Profitability & Invoice Matching)

£250-750 GBP

Zamknięte
Opublikowano około 6 lat temu

£250-750 GBP

Płatne przy odbiorze
We are a freight and logistics organisation based in Malawi, Africa. We arrange logistics and shipment of cargo to and from rest of the World and Malawi. Malawi is a landlocked country with no direct access to sea coast. The cargo is usually packed into shipping containers and various means of transportation is used including/combination, air, sea, road and rail. Various services are provided by numerous service providers. All the service providers have to be paid on time and per the budgeted cost when quoting the shipment. If over budget then a query to be raised and only a Manager can then allow for invoice to proceed in excess of budget, or Manager to amend the budget. We need to also ensure that service providers do not duplicate service invoice, and our own accounts department do not duplicate any payments as well. In addition we are in Malawi (Local Curreny: Malawi Kwacha [mk]) but majority of our transactions are US Dollar (USD) based. Therefore almost all transaction will have USD and MK equivalent. We need to ensure that the rate of exchange being used is also correct. None of the costs to be paid unless they are first invoice matched to the budget, then approved by Manager and to check that relevant revenue invoice pertaining to particular costs has been invoiced out. At present we are using excell as per attached but it is very cumbersome and difficult to keep track. You will note the different months schedules. There is a schedule for actual and another for budget for each month. At the end of each month whatever figures that have not been receiver are then accrued, be it income or expense. This helps us secure profit and loss for monthly basis. We can also obtain by client. Each service is sold as a product. I have colour coded each revenue and corresponding expense in same colour so that u may differentiate more easily. In addition one of the columns is highlighted in black to separate income from expense. We would like this process to be automated as well as give us period reports based on date of arrival of shipment. Monthly Profit and Loss and Porift and Loss by client. Profit and Loss by Service Product.
Identyfikator projektu: 16333516

Informację o projekcie

23 ofert
Zdalny projekt
Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
23 freelancerzy składają oferty o średniej wysokości £796 GBP dla tej pracy
Awatar Użytkownika
Hello I am Excel Expert and VBA Developer with appropriate experience for your project I have been working as an financial auditor for a while and can sort things out for you including reporting If you are interested, contact me please Thanks & Regards
£750 GBP w 14 dni
4,9 (154 opinii)
8,2
8,2
Awatar Użytkownika
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£500 GBP w 10 dni
5,0 (498 opinii)
8,0
8,0
Awatar Użytkownika
Hi, I have experience in transportation, shipping, and cargo by containers. I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting and Financial Report Tools. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.
£750 GBP w 10 dni
4,9 (97 opinii)
7,5
7,5
Awatar Użytkownika
I am excel and VBA expert, Please review my profile. Mohsan
£555 GBP w 10 dni
5,0 (97 opinii)
6,8
6,8
Awatar Użytkownika
It sounds big project, am I correct? We are Israel based IT solutions and services company, that combines core technical expertise with a global business perspective. The company's key offerings include product development, migration, porting, re-engineering and e-commerce solutions. Over the past 10 years we have assisted many clients worldwide in solving problems ranging from simple needs to extensive corporate requirements. We have references from USA, UK, Brazil, Germany, France, Australia, Canada, Denmark, Norway and other countries. We give 2 months warranty after completion for bugs fixing.
£5 000 GBP w 90 dni
5,0 (4 opinii)
6,4
6,4
Awatar Użytkownika
Hi there, I am an expert in Excel VBA and I can do with the required quality. Ping me to discuss more. Thanks Aman Jha
£722 GBP w 5 dni
4,9 (171 opinii)
6,5
6,5
Awatar Użytkownika
A proposal has not yet been provided
£500 GBP w 1 dzień
4,8 (91 opinii)
6,5
6,5
Awatar Użytkownika
I am a Microsoft Access Database Developer. I think a great solution to you needs would be a Custom Database. If you have Microsoft Professional you have Microsoft Access. Please see my profile for screenshots of my work. I can use the data in the spreadsheets to build the database. It will have a clean Dashboard to easily navigate through the system.
£833 GBP w 10 dni
4,8 (28 opinii)
6,4
6,4
Awatar Użytkownika
Sorry for exceeding max budget, thank you for looking at my bid. Kindly advise whether you want to continue using a XLSX based application, or maybe a web or desktop application to track and report costing. I would request your response to discuss. About Us: 100+ successful projects through Freelancer, Kindly visit our profile on Freelancer https://freelancer.com/u/fleetways.html - to review our past work, feedback. Looking forward to your response. Thank you.
£833 GBP w 21 dni
5,0 (1 opinia)
5,5
5,5
Awatar Użytkownika
Greeting, I have understood your Develop a Job Costing System(Including: Profitability & Invoice Matching) task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Database Programming, Excel, Excel VBA
£750 GBP w 10 dni
4,8 (14 opinii)
5,3
5,3
Awatar Użytkownika
Hello, First of all we could create some windows forms with dropdown lists that will improve the user experience and make it more easy to add, edit or remove your records. I really suggest to create only one database sheet in order to manage the data easily. Automated report generation can be made using the business rules defined together. In order to prepare the data that will be sent to the Manager for approval we can automate some report generation that will put the result directly in the email body and you just click Send button. The manager will see the data directly without opening any files. My last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that sends emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius
£277 GBP w 9 dni
5,0 (28 opinii)
4,4
4,4
Awatar Użytkownika
Hi junaidseedat, I have good working experience with the required skills & I assure you that I can complete your project "Develop a Job Costing System(Including: Profitability & Invoice Matching)" within the required timeframe.I am keen to work with you. I meet all your requirements. Aso I do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. Relevant Skills and Experience I have 10+ years of experience in Data Processing, Database Programming, Excel, Excel VBA I can do this within your budget too £250 - £750 GBP I hope you would choose me for this job, looking at my expertise, and my assurance to get the job within budget and on time. With Best Regards, Mmadi
£525 GBP w 12 dni
5,0 (2 opinii)
3,7
3,7
Awatar Użytkownika
Hello! I am Realy excited to Start project with you) Good job a perfect quality guarantied!
£250 GBP w 7 dni
5,0 (1 opinia)
0,8
0,8
Awatar Użytkownika
I have gone through your project requirement, we can use the peachtree accounting software for it, i am working in Pakistan as Import & Export Company so that it will be helpful both of us to understand the business. I need the proper data which will be helpful for me to post the data into Software and send you monthly profit & Loss Account and balance sheet. All the shipping charges will be included in the expense of the Company and the service charges will be taken as the Income. If you have other branches than we can also use the jobs for branches profitability. I need your last year balance sheet for creating the codes for the peachtree and send you the file for further processing, i also need your customer details and vendor details for creating customer and vendor list in software. Regards, Muhammad Zeeshan Asif
£444 GBP w 10 dni
0,0 (0 opinii)
2,5
2,5
Awatar Użytkownika
experience at Oracle Technologies .Strong implementation capabilities in various business sectors: Oracle E-Business Suite, ERP Systems ,Oracle Apex Government DB Management Systems , Construction Real Estate DB Systems . and also have basic knowledge in Oracle Cloud Development .
£555 GBP w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I understand that doing things on Excel is definitely cumbersome, and it is more efficient to have a real system. I am proposing that the system be a database-driven, Web-based system. You said that you wanted it to be automated. Who will be the users of this system?
£945 GBP w 21 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I can do your task with 1 year support . Waiting for your message to discuss the project scope . .
£388 GBP w 25 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga MALAWI
Blantyre, Malawi
0,0
0
Zweryfikowana metoda płatności
Członek od gru 5, 2015

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.