Завершено

Excel data import and export into Xero

Our supplier (Ingram Micro) currently provide us an option to manually download all our sales (with multiple clients) from their web portal in an excel format to view our total monthly sales.

We are looking for an efficient way (custom tool, macros, form, VB etc) to be able

1. Download the data (Ingram Excel data will have far too many data, ie 30-40 row/fields) each month

2. We only need 4 fields to invoice our clients (Customer Name, Quantity, Product and Unit Price etc)

3. Need to be able to select different Customer for invoicing

4. Paste/import data into Xero excel format for invoicing

We are looking for something easy to use with minimal steps. Let me know what other information you would need.

I've added sample excel documents for you to review, please have a look

Regards

Sez

Квалификация: Excel, Visual Basic, Visual Basic для приложений

Показать больше php data import export, excel data import template, net data import export, magento commerce data import export, data import export philippimes, visual basic excel macro import export, visual basic excel macro import export 2007, 2005 program data import export, excel data import virtuemart, data import export vbnet, excel data import microsoft dynamics, excel qtpro import export produkte, excel vba import export, excel data import access crosstab queries, excel data import virtumart, magento data import export extension, vbscript data import export, magento excel data import

О работодателе:
( 0 отзыв(-а, -ов) ) Sydney, Australia

ID проекта: #22683400

Поручен:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

$200 AUD за 3 дней(-я)
(128 отзывов(-а))
6.0

32 фрилансеров(-а) в среднем готовы выполнить эту работу за $175

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Больше

$220 AUD за 3 дней(-я)
(327 отзывов(-а))
7.9
sohandas

ok understood, i can make a python script for this, can you please message me so that i can demonstrate the proof of concept? thanks.

$250 AUD за 3 дней(-я)
(238 отзывов(-а))
7.1
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to working with you. Thanks & Regards Khushi India

$250 AUD за 5 дней(-я)
(250 отзывов(-а))
7.0
RRconsultant

Greetings! I am a Chartered accountant with Silver Champion level certification from Xero. I am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC

$250 AUD за 12 дней(-я)
(62 отзывов(-а))
6.6
dvcontact

Hi, Would you like to see a quick demo of your project on developing a tool that can import/download sales information from a certain web portal into Xero Excel format completed before you award the project? You can co Больше

$150 AUD за 5 дней(-я)
(52 отзывов(-а))
6.4
mateenbhatti94

Dear sir I will build the excel document that will do all these 4 steps that will help your work. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me Больше

$150 AUD за 1 день
(75 отзывов(-а))
6.2
zu02

Hi I need format of downloaded Excel file(s) , then format of output Excel file. And better if you can prepare a little sample of income and outcome files with explanation of how calculates outcome file fields . Ho Больше

$250 AUD за 7 дней(-я)
(33 отзывов(-а))
5.8
Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am interested in this project , can begin now waiting your answer on chat Regards ⭐⭐⭐⭐⭐

$140 AUD за 2 дней(-я)
(52 отзывов(-а))
4.5
pjlnel

Dear Sir or Madam, I am a South African based professional Accountant with a proven track record. My qualifications include a post graduate degree in Management Accounting. My software experience include but is not li Больше

$140 AUD за 7 дней(-я)
(2 отзывов(-а))
2.5
DominikKrivarics

Hi, I can develop a custom excel macro for you that can streamline your workflow. Please send me some sample files first so I can get to know the project better. Thanks, Dom

$150 AUD за 7 дней(-я)
(5 отзывов(-а))
2.6
mintu1302k

Hello! I am Excel, Access and VBA expert with 6+ year experience. I have good experience of lots of project in excel,access,outlook,word,power point, web scraping, manipulate data, linking to SQL Server and read data Больше

$100 AUD за 3 дней(-я)
(3 отзывов(-а))
1.5
pushar71

we have a excel based invoice tool where it will pick the revevant fields and put them in to the invoice that you can save as PDF and send it to your end client. we can do a quick demo and make change to it as you need Больше

$140 AUD за 7 дней(-я)
(1 отзыв)
1.3
scripts24

Greetings Php Expert Technologies Pvt. Ltd.! Php Expert Technologies is a full service, design, and development company offering end to end technology solutions for mobile and web platforms. We have proven our expertis Больше

$250 AUD за 7 дней(-я)
(1 отзыв)
0.4
skoli0831

GOOD AT EXCEL AND DATA PROCESSING I DO THIS KIND JOB EVERY DAY AND I AM GOOD AT IT SO HIR ME GET YOUR WORK DONE

$190 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
Rm507704

I need a work please send me project Relevant Skills and Experience I need a work

$155 AUD за 3 дней(-я)
(0 отзывов(-а))
0.0
SimbaTeam

⭐Dear, client⭐ I've read your description and checked through your requirements. I can deliver this project perfectly. Look forward of hearing from you soon. Regards.

$250 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
jayeshvs101

I'm am perfect for this job and have much knowledge in Excel and worksheet .so i want you to hand over the project to me and relax your work is done

$277 AUD за 4 дней(-я)
(0 отзывов(-а))
0.0
manuelmata3000

Hello, I'm an excel specialist. Allow me to participate in this project you won't be disappointed. Regards

$120 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
sailoganathan

Hi boss, Hope all is well!! We went thru your requirement. Hope .your project will be complete as per your terms. Why you offer us? We having a set of peoples with around 8 years experience in database handling, Больше

$140 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
rajgurupramod21

Excel Expert with success in maintaining and organizing data, fill gaps, and sustain quality control [login to view URL] and exported data from text files, saved queries, or databases; used automatic outlining, inserte Больше

$140 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0