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: costing system bata shoe ltd, develop product reviews website, develop student grade system application, 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, project management, reviews, data processing, business plans, excel, report writing, database development, accounting, sap

About the Employer:
( 0 reviews ) Blantyre, Malawi

Project ID: #16333516

25 freelancers are bidding on average £765 for this job


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
(176 Reviews)

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
(276 Reviews)

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
(157 Reviews)

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)

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
(54 Reviews)

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)

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

£555 GBP in 10 days
(66 Reviews)

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
(20 Reviews)

A proposal has not yet been provided

£500 GBP in 1 day
(38 Reviews)

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)

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
(14 Reviews)

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
(27 Reviews)

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
(4 Reviews)
£700 GBP in 8 days
(3 Reviews)

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)

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
(1 Review)

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

£250 GBP in 7 days
(1 Review)

My company is offering online accounting services and remotely accessable accounting softwares. We are currently handling accounts of some of our clients those who are based in US and middle east. Relevant Skills and More

£711 GBP in 15 days
(0 Reviews)

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

£945 GBP in 21 days
(0 Reviews)

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)