Closed

Need a piece of software to convert Excel file to TXT for uploading to MYOB

This project received 14 bids from talented freelancers with an average bid price of $165 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
14
Project Description

Need a piece of software that will take file called "Synaps 3 [url removed, login to view]" and convert into format like "output may [url removed, login to view]" for me to upload into MYOB. (Sample files are attached)

Software needs to allow"

- Importing xls in format provided
- Smart enough to know that that if the field in "Synaps 3 [url removed, login to view]" call "Amount Paid" is empty or 0 then ignore line.
- Have the ability to allocate product code to the Description in field called "Shipping method" i.e $[url removed, login to view] FRDLE Courier to NON RURAL address = FRDLE and use as a sales line in export file. There should be ability to add multiple variable into the software for this and allocate Stock code against it.

- The Following is how the fields are mapped in the "output" file compared to the Input file

Co./Last Name = Source
First Name = No used

Addr 1 - Line 1 = Shipping address
- Line 2 = Shipping address
- Line 3 = Shipping address
- Line 4 = Shipping address

Invoice No. = Blank as this is generated by MYOB
Date = Sale Date
Customer PO = Reference
Ship Via = This should be be linked to "Freight stock code" i.e FRDLE = Courier Post or FRNZPOST = NZ Post


Delivery Status = P
Item Number = Product Code
Quantity = Qty Sold
Description = Blank as MYOB picks this up
Price = Sales Price
Inc-GST Price = Sale Price
Discount = 0
Total = Sale price X Qty
Inc-GST Total = Sale price X Qty
Job = Blank
Comment = Ship Ref
Journal Memo = Sale;Source i.e Sale;Trademe or Sales;Sella
Salesperson Last Name = Blank
Salesperson First Name = Blank
Shipping Date = Blank
GST Code = NT
GST Amount = 0
Freight Amount = BLANK
Freight GST Code = NT
Freight GST Amount = 0
Sale Status = I
Terms - Payment is Due = 1
- Discount Days = 0
- Balance Due Days = 0
- % Discount = 0
- % Monthly Charge = 0
Referral Source = Blank
Amount Paid = Blank
Payment Method = Blank
Payment Notes = Blank
Name on Card = Blank
Card Number = Blank
Expiry Date = Blank
Authorisation Code = Blank
Cheque Number = Blank
Inclusive = X
Category = Blank
Card ID = Linked to Source, Should have ability to set in software ie: Source = Trade Me = Card ID: TRADE ME, Record ID = 5
Record ID = Linked to Source

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online