Closed

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

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.

Skills: Data Processing, Database Programming, Excel, Excel VBA

See more: job costing in quickbooks enterprise, job costing in quickbooks online, job costing in quickbooks pro 2015, job costing quickbooks, construction job costing, construction job costing in quickbooks, quickbooks job costing labor, job cost tracking spreadsheet, develop product, how to develop product, design a marketing plan for a product of your choice include all the different stages of its formation, domain class diagram job costing system, exchange rate product pricing, magento product based exchange rate, develop product catalog

About the Employer:
( 0 reviews ) Blantyre, Malawi

Project ID: #16333516

26 freelancers are bidding on average £755 for this job

P0L

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 in 10 days
(234 Reviews)
6.9
sandroshubladze

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

£750 GBP in 14 days
(157 Reviews)
6.9
avinav606lx

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 in 5 days
(144 Reviews)
6.4
dotsys123

Dear Sir/Madam, Thank you for reading my proposal. I am expert in Admin support, Customer support, eCommerce product listing, Online Marketing and Web Development services . I have following experience of work wh More

£555 GBP in 10 days
(22 Reviews)
6.4
thecloudkernel

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

£5000 GBP in 90 days
(4 Reviews)
6.4
dgled

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

£750 GBP in 10 days
(47 Reviews)
6.1
MohsanEijaz

I am excel and VBA expert, Please review my profile. Mohsan

£555 GBP in 10 days
(64 Reviews)
6.0
fleetways

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

£833 GBP in 21 days
(1 Review)
5.5
workerbee1974

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

£833 GBP in 10 days
(18 Reviews)
5.3
usmanhassan123

A proposal has not yet been provided

£500 GBP in 1 day
(24 Reviews)
5.1
whitehorsetechn

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 More

£750 GBP in 10 days
(11 Reviews)
4.5
insidenetsoft

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

£277 GBP in 9 days
(26 Reviews)
4.3
mmadi

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

£525 GBP in 12 days
(2 Reviews)
2.5
£700 GBP in 8 days
(2 Reviews)
2.7
krishnaagr89

Hi,I have read your requirements and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on on More

£555 GBP in 10 days
(2 Reviews)
0.8
naiilaribzhanov

Hello! I am Realy excited to Start project with you) Good job a perfect quality guarantied!

£250 GBP in 7 days
(1 Review)
0.8
rihamfikry

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

£555 GBP in 10 days
(0 Reviews)
0.0
TigerWI

I can easily get this set up into a CMS for you, so, later on, you can manage job postings yourself! I think the best choice would be WordPress for this, and we can get it done pretty fast. How about it? Hire me? :)

£250 GBP in 5 days
(0 Reviews)
0.0
mzasif

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 More

£444 GBP in 10 days
(0 Reviews)
0.0
king18yat

I can do your task with 1 year support . Waiting for your message to discuss the project scope . .

£388 GBP in 25 days
(0 Reviews)
0.0