Find Jobs
Hire Freelancers

Need purchasing & ordering software RECOMMENDATIONS or Excel System - Small company

$30-250 AUD

Awarded
Posted over 7 years ago

$30-250 AUD

Paid on delivery
Brief: Source and recommend a simple and relatively low cost purchasing and ordering system / software for a small business according to the specification below. Alternatively outline a plan or proposal for a excel system that also meets all of the requirements below. Outline: We currently have a relatively outdated purchasing / ordering system that is based around simple excel. The system is very time consuming, laboursome and has limited search functionality. We want to scan all paper copies of our invoices but store them digitally, and have the ability to search for these in the future, easily. Please read the below information for a more detailed list of our setup and the requirements for a new piece of software. We have: • (Paper) Order Book with sequential numbers • We place orders and receive inwards goods on one or multiple (paper) Packing Lists or shipping dockets • This is followed up by a single (paper) Supplier Tax Invoice We produce: 1. 1 x Excel spread sheet ‘Order Books’ and enter only the supplier, some brief key search words ‘Order Books’ achieves a simple searchable index for the books. Order Number=Supplier=Key Product (word) 2. 1 x Excel spread sheet ‘Monthly Material Postings’. This assigns portions of the supplier invoice gross amount to individual ‘Projects’ or ‘Expense categories’ Eg. An invoice from XYZ Timber company may have a gross value of $100.00 In this spreadsheet we might attribute: $20.00 to our project A $20.00 to project B $50.00 to project C $10.00 to workshop maintenance From ‘Monthly Material Postings’ we can extract monthly costs for current and past projects, expense categories etc 3. 1 x Excel spread sheet ‘Projects’. This assigns selected individual products from order books or actual suppliers invoices to our different projects. Eg. Supplier Invoice from ‘Smith Ball Co’ for 6 x Blue Ball 150mm pn. 235 @$10.00ea $60.00 4 x Red Ball 100mm pn. 678 @$10.00ea $40.00 Into 3 x Blue Ball 150mm pn.235 to Project A 4 x Red Ball 100mm pn.678 to Project B From ‘Projects’ we can reference important components for future reference. After the purchasing department extracts the relevant data for the above spreadsheets from the Packing Lists and Supplier Invoices they are sent to the Admin department for processing and payment. At this point they are not readily accessible for future reference. Note also at this stage we have not recorded individual cost prices for products for easy future reference anywhere. We wish to achieve: All of the above spreadsheet information and additionally (and importantly) have the • Scanned copy of paper order with Order Number • Scanned copy of Packing List(s) • Scanned copy of Supplier Invoice • Reduce amount of input required and paperwork pile • Increase search efficiency and usability • Easy intuitive process Attached together with searchable key Items Note: With a basic operational, searchable system more than likely ‘Order Books’ will become obsolete.
Project ID: 11745553

About the project

12 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $280 AUD for this job
User Avatar
Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Kimi
$215 AUD in 5 days
5.0 (243 reviews)
7.6
7.6
User Avatar
Hi there. Just read your job description and being one of the highest rated Excel & VBA expert in this platform, I can work on your purchase order system. I am mostly online. Lets discuss more on chat.
$631 AUD in 6 days
5.0 (142 reviews)
7.2
7.2
User Avatar
Hi, I have more than 14 years of Visual foxpro exp and I am expert in this kind of work. I can build this software using visual foxpro. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 AUD in 15 days
4.9 (157 reviews)
6.4
6.4
User Avatar
lets do this ? lets do this ? lets do this ? lets do this ? lets do this ? lets do this ? lets do this ? lets do this ? lets do this ?
$400 AUD in 7 days
5.0 (14 reviews)
5.7
5.7
User Avatar
Dear Employer, I am working as a freelance programmer on different websites including rent a coder & freelancer dot come from over 6 years. With over 6 years of total experience in Clasical to .net technologies experience. I have got the skills in following technologies VB.Net C# Visual Basic 6.0 MS Sql Server Crystal Reports My Sql PHP Asp.Net CSS HTML Lotus NoSql MS Access IoS Android Data Entry Team Twitter Api instagram Api I have developed many web application and desktop applications includes following projects; ERP system for restaurants and Shops Point of Sale and inventory Control British Petroleum Toolkit HR and Attendance System using Biometric Machines Unit Converter for BP Pharmacy pPOS Real Estate Management System British Petroleum Toolkit Maintenance Plot Management System(PMS) Financial System File Tracking System Thumb Identification with PMS Visitor Tracking System using Bar Code Cards Hospital Patient Management System Human Resource information System Auto Responder SMS Security Management System Image and Video Screen Capturing Application used for capturing video and images DHA Balloting Software Teleman Billing Software Electricity Billing System Attendance System using RFID Device APS School Management System Complaint Management System Concession Management System Saudi Electricy Company Bar code Card I have read the requirements and capable of doing this,. looking forward for your kind response Thank you Regard
$222 AUD in 10 days
4.9 (60 reviews)
5.6
5.6
User Avatar
Hi, I can use your current excel sheet and your requirements as mentioned to develop a software for you within 7 days, please inbox me for more details. Thank you, Kindly refer to my portfolio and previous projects for what I have done
$555 AUD in 10 days
5.0 (11 reviews)
4.5
4.5
User Avatar
Respected Sir, I am interested in your project. I have excellent Microsoft Excel skills along with expertise in VBA programming, which will be a valuable for your business needs. Please consider my Bid amount and discuss with me your detailed business needs. Thank you Yours faithfully, Saravana Prakash
$150 AUD in 7 days
5.0 (31 reviews)
4.5
4.5
User Avatar
Hi, I have read and understood the project description and possess the skills required to meet your needs. Please give me a chance and reply. Thanks.
$88 AUD in 3 days
3.9 (12 reviews)
4.6
4.6
User Avatar
Hi, I am a quickbooks pro advisor and a certified accounting technician with 5 years of experience of bookkeeping and accounting. I can give you complete accounting support as per your requirement. Lets have a chat and discuss in detail the project and get started. Looking forward for your reply Thanks Khalid Salman
$77 AUD in 3 days
5.0 (3 reviews)
1.4
1.4

About the client

Flag of AUSTRALIA
Perth, Australia
5.0
1
Payment method verified
Member since Jul 15, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.