Awarded

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

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 @$[url removed, login to view] $60.00

4 x Red Ball 100mm pn. 678 @$[url removed, login to view] $40.00

Into 3 x Blue Ball 150mm [url removed, login to view] to Project A

4 x Red Ball 100mm [url removed, login to view] 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.

Skills: Accounting, Excel, Software Architecture, Software Testing, Web Hosting

See more: online ordering system template company website, small home care companydevelop simple medical software company nurses staff forms havedownloading forms staff click type, accounting system project small company, ordering system different company, drupal easy website build, alibaba website build, handicapping website build service design, joomla commerce website build, full website build, copy exitsing website build site, drag drop website build bracelet, projects database system music company, teacher rating website build, airline reservation system small business, bid website build, common questions freelance website build, small company web page, operating system selected company use 250 computers, website build bid, small reporting excel, sms food ordering software, client management system advertising company, poker website build, project online reservation system transport company, drupal small company

About the Employer:
( 1 review ) Perth, Australia

Project ID: #11745553

14 freelancers are bidding on average $269 for this job

someka

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
(104 Reviews)
6.7
mantislin

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

$215 AUD in 5 days
(77 Reviews)
6.4
rohitpithisaria

Hello I am an excel expert and a web developer but a certified accountant by qualification. I understand the job requirement. I suggest a web based system preferably with all the requirements. Please check this l More

$250 AUD in 15 days
(93 Reviews)
6.2
wsh2

Very nice write-up. Greetings from the USA.. {smile} Highly experienced (25+ years) MsExcel Business System, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange More

$155 AUD in 3 days
(28 Reviews)
6.2
dpune

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

$500 AUD in 15 days
(132 Reviews)
6.2
stevecorsi

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

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

$222 AUD in 10 days
(59 Reviews)
5.6
xielessupport

I can make your project a great success. I'm 31 year old talented PHP and open-source developer. I have 9 years of experience in Server Administration and Web Application Development. I'm expert in web application cust More

$222 AUD in 8 days
(10 Reviews)
4.7
ongili

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

$555 AUD in 10 days
(9 Reviews)
4.3
kaycharles

Dear Sir/Madam, I Am a US licensed CPA with 20+ years of US Business Experience. I am well Versed, Experienced and Qualified to Recommend and set up a Software that would provide you with your inventory and account More

$250 AUD in 3 days
(5 Reviews)
3.7
kvosaravana

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

$150 AUD in 7 days
(19 Reviews)
3.7
$55 AUD in 3 days
(9 Reviews)
3.2
chyconsl

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
(6 Reviews)
4.1
ataasc

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 More

$77 AUD in 3 days
(2 Reviews)
1.4