Completed

Import XLS invoices into Xero

Take import from xls, listing:

Client Name

Date Paid

Debtor Name

Client Ref

Amount Paid

Connect to a Xero account

Match the Client name in the xls to the client name in Xero (1. [login to view URL]), if the client name does not match, I should be able to match it to one and save this for future imports

Allow me to set a percentage commission rate for each client (this should be saved for future imports)

Work out an invoice line amount, based on the 'Amount Paid' from the xls, and the percentage commission rate for that client (this % will vary per client)

Generate one invoice per client, the invoice may have multiple lines for each amount paid and debtor name

Each invoice line should show in the following format:

Debtor Name - Client Ref - Amount Paid

And be set to a specific nominal with vat rate, in a draft state in Xero.

Skills: Accounting, Excel, PHP, Xero

See more: import invoice data into xero, scan invoices into xero, tax type xero import, xero import purchase order, xero batch invoices, import purchase invoices into xero, can you import invoices into xero, xero help, import xls postgresql, instructions import excel invoices quickbook, import xls oscommerce, import xls postgres php, import xls file mysql, business plan pro import xls file, can import excel invoices quickbooks, import xls mdb code, import xls html php, import xls mpp vbnet, import xls zencart

About the Employer:
( 8 reviews ) Belfast, United Kingdom

Project ID: #18670737

Awarded to:

MohanKumar28

Hi I have gone through the requirements. Will do this import application using Laravel. I'm available to start now. Please share additional details. Regards, Mohan

£300 GBP in 5 days
(82 Reviews)
5.4

34 freelancers are bidding on average £415 for this job

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

£500 GBP in 6 days
(311 Reviews)
7.7
claudiu07

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

£333 GBP in 5 days
(49 Reviews)
7.3
Tanmoy236

"I am fast and Extremely Detailed Oriented. Completed more than 150+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great More

£300 GBP in 2 days
(212 Reviews)
6.8
sukum

Hi, I am a PHP programmer. I have experience integrating Xero to other web apps using its API, including syncing client and invoice details. I will be able to create a web app in PHP that syncs the client, calculate More

£555 GBP in 12 days
(69 Reviews)
6.9
madhurna

Greetings! I am Qualified Accountant and Xero Certified with ten years of experience in xero accounting. We have developed number of apps based on the xero developer kit. Please PM to discuss. Thank you.

£470 GBP in 10 days
(84 Reviews)
6.9
deepabittu

Hello Sir i am done this type job last time with good result xero account update. pls view my profile i am done AUS client. i have good experience and i have good feedback for this work

£250 GBP in 7 days
(223 Reviews)
6.5
Mickelson

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some autom More

£500 GBP in 10 days
(50 Reviews)
6.0
texotech

Hello Sir / Madam, I have 5 years of experience in Accounting and Taxation and I am providing Expert solutions for Quickbooks and XERO Conversion (Including BAS , Payroll, Fixed Assets Sch More

£250 GBP in 2 days
(70 Reviews)
6.2
uhostings

** UK Qualified Professional accountants with Xero bronze partner status to handle your project with due care ** Dear Sir, Greetings ! I would like to offer my expertise for preparation of your project stateme More

£250 GBP in 10 days
(59 Reviews)
6.2
Waqas441

Hi, I am a Qualified Chartered Accountant and have an experience of 8 years in the fields of Accounting, Finance and Bookkeeping. I am XERO expert and have worked for numerous clients on Xero, I have read all yo More

£250 GBP in 3 days
(107 Reviews)
6.6
greenforest0204

Hello, Dear! I'm Dmitrii, a senior expert of web development. Until now I have been worked in this job for about 6 years. So I have many rich experience on web development. Specially I have top skill on Accounting, More

£555 GBP in 10 days
(25 Reviews)
5.4
superbpartner

Hi,dear! I am quite interested in your project - 'Import XLS invoices into Xero'. :) I am a skillful software developer who has rich experience in this field. If you contact me, you and I will be happy. Thank you in ad More

£555 GBP in 3 days
(8 Reviews)
4.6
SecureForYou

Hello. How are you? I have read the project description of 'Import XLS invoices into Xero' and I have confidence that I can carry the job to success. Cuz I am a professional full stack developer with over 10 years of e More

£555 GBP in 3 days
(4 Reviews)
4.4
valor312

VERY EASY FOR ME Hi, Nice to meet you. Please see product I made recently using VBA https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f https://www.freelancer.com/projects/visual-ba More

£250 GBP in 10 days
(14 Reviews)
4.3
labibhasan01718

Hi, I read your project description properly. I can do your project according to your instruction. please massage me to do some sample for you. waiting your message. thanks

£250 GBP in 7 days
(27 Reviews)
4.0
Priyanshu1

Hi What do you want to do with the matched records? Where will this functionality be (web or your laptop)? How often do you need this done? Please message me if interested and we can get started asap. Regards Priyan More

£750 GBP in 20 days
(5 Reviews)
4.0
norjonline

Hi there! I can help you fulfill this project. I have been working as an accountant for more than 5 years using various accounting software such as QuickBooks, SAP and XERO. I am very much keen to work in any indust More

£250 GBP in 30 days
(12 Reviews)
3.7
ecombucketsoft

Hi there, Hope you doing great. I have done the xero and quickbook integration in past. I have Build the custom solution like: Shipping Provider: FedEx, UPS, DHL, AUSPOST, Fetchr Payment gateways: Paypal, Stripe, More

£700 GBP in 10 days
(3 Reviews)
3.6
ronhessing

Glad to help you Import XLS invoices into Xero using the API. I worked with Xero before and PHP have no secrets for me. I speak fluent English and when you hire me, I can ensure quality communication which is a More

£599 GBP in 10 days
(1 Review)
2.0
vperotti22

Hello - hope this message finds you well. I've got experience in managing (as well as analysing) data throught out my experience as a Senior Analyst and Consultant for different clients and projects, with the ultimate More

£277 GBP in 1 day
(0 Reviews)
0.0