Save this Search

All JobsMYOBIT & Programming

 (1 result  
Sort by:
  • Posted Date
IT & Programming
Fixed Price: Less than $500   |  Posted: Aug 17, 2015  |  Ends: 14h, 44m  |   51 Proposals
I have a number of files which have been extracted from an accounting system MYOB. They are in excel format but could be produced in text file format. The files need to be rearranged into a specific mapping of fields in order for them to be imported into a new accounting system - Xero. A mapping will be provided of the old fields to the new fields. The customer list is probably the biggest file and is 16000 lines in excel due to the way the export from MYOB is formatted. There are around 390 customer records. There are around 49 fields in the customer file, but only 5-10 will be required for the CSV file which is to be imported. In addition to the customer file there will also be conversions required for a suppliers file, sales invoice file and purchase invoice file. A sample of the excel customer file to be converted is attached along with a mapping showing the layout of the CSV file to be created - see yellow highlighted fields.
Category: Data Analysis       
Skills: Accounting, MYOB Administration, Excel VBA       

Sign in to view client's details.
| J****rgh
|    United Kingdom
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job