Closed

Do some Excel Work

We are looking for somebody who is able to assist us in the 'mapping' process of importing and exporting excel data into and out of Quickbooks. We are looking to integrate with another software package to extend our quickbooks functionality. The system we are looking to integrate with allows for importing/exporting CSV files.

We would like to integrate in 2 ways:

1) Exporting:

- We would like to export all our customer data from Quickbooks and import this into other software. The data that we would need to export is the customer ID, Last/first name, PH number and credit card details.

2) Importing

a) We are looking to integrate with a system that processes payments once a month. After each monthly payment is processed, the system creates a CSV file that can be exported – we want to be able to import this back into Quickbooks. We would like for the payments that were applied against each customers Bank Account OR Credit card to be automatically applied to the invoice against in each account. We plan to do this, by setting up a “schedule” payment where each schedule will be applied against a particular invoice number (setup as a merchant reference field) which Quickbooks should be able to understand and apply that payment against the particular invoice number automatically.

We are wondering whether there is anybody that can assist us with this task. This requires excel and quickbooks mapping [url removed, login to view] are negotiable.

Skills: Big Data, Data Entry, Data Processing, Excel, Intuit QuickBooks

See more: work reference, quickbooks export csv, customers bank, applied bank, setting quickbooks, quickbooks number, credit card number work, credit card csv, customer data excel, work schedule, data entry quickbooks, customer data entry software, quickbooks import file, quickbooks import data, task export data, entry processes, credit invoice excel, quickbooks export, invoice entry quickbooks, excel import export, excel need bank, export plan, monthly work plan, csv bank file, excel name card

About the Employer:
( 0 reviews ) Australia

Project ID: #5863065

26 freelancers are bidding on average $177 for this job

sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than More

$147 USD in 7 days
(82 Reviews)
6.0
maverick44000

Hi Daniel. I am ready to work with the export and mapping of data from QBooks. I have significant experience in Excel to do this task for you. Kindly discuss the fine details so we may proceed. Regards. Usman.

$300 USD in 5 days
(38 Reviews)
6.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$200 USD in 7 days
(90 Reviews)
5.7
nswapsj

Hi Daniel, I am a CPA qualified accountant, a native English speaker. I will provide you with a high quality and time committed service with outcomes you actually need. I worked with similar projects including Xero an More

$263 USD in 10 days
(9 Reviews)
4.6
wkcompany

Sir I'm expert on Data Entry and Web Research and Excel. I have done many project like this . I will give you best quality and service. Hope positive reply from you. I'm ready to start now . Thanks

$250 USD in 3 days
(11 Reviews)
3.0
Nanda555

HI, I would like to work on this project, i already worked on quickboos with PHP for one of my client. In that project we did the following things, - Admin have the ability to import data from excel file, in this More

$556 USD in 10 days
(1 Review)
2.8
SKBS

Hi! Using Quickbooks Pro 2012, I have done uploading bulk data from pdf bank statements > Ms Excel > IIf files > into Quickbooks. Let's discuss the details over skype/teamviewer to see how I have done in the past an More

$250 USD in 7 days
(3 Reviews)
2.2
fadiamro

Hi, I am highly qualified and experience able in this field. I have talented skill to solve your projects within your time and just as per your budget. Contact me soon and get best results. Promises 100% satisfacti More

$155 USD in 3 days
(1 Review)
0.2
mukundworks

A proposal has not yet been provided

$133 USD in 3 days
(0 Reviews)
0.0
Mesbah2001

Dear sir, I am expert in word, excel & data processing.........I have a very big team to do this job...... pls msg if u want..... thank u.

$55 USD in 3 days
(0 Reviews)
0.0
ankitgautam1993

i can understand the project very well.i hv a greater exprience under this project so i can successfuly and efiiciently complete dis project on time.

$155 USD in 5 days
(0 Reviews)
0.0
aks2007

Hi, I have more than 10 years of accounting experience and presently working with a US based company as an Manager so I have knowledge of processing till closing books and have a good idea to work on QB so please gi More

$88 USD in 3 days
(0 Reviews)
0.0
julialbertrand

I am writing to present to you how my positive attitude and outlook as an Executive Assistant will benefit your firm immensely. It would be a pleasure to meet with you so that I might demonstrate how my abilities fit More

$277 USD in 3 days
(0 Reviews)
0.0
muthonijw

Hi, I have wide array of experience of exporting c.s.v files from quickbooks and importing to the same with different fields that you may need or as customizable in quickbooks, I have in the past ,on a monthly basi More

$183 USD in 1 day
(0 Reviews)
0.0
agnibina17

A proposal has not yet been provided

$138 USD in 3 days
(0 Reviews)
0.0
ChrysalisThorne

I am a trained Financial Analyst with an MBA in Finance. I possess skills in financial-market analysis, investment research, fixed-income pricing, modeling and analytics, structured-product design, financial statement More

$133 USD in 3 days
(0 Reviews)
0.0
Saheharam

I have 5 years experiencing in java technology as well as admin related jobs like excel,word,powerpoint etc.I assure you that I have never disappointed anyone and will never disappoint you.

$155 USD in 3 days
(0 Reviews)
0.0
toha99

Hi I am fully undestand your requirements and ready to start futher discussion with you please let me know if you are interested to working with me. Best Regards toha

$30 USD in 3 days
(0 Reviews)
0.0
ariwidiansyah

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
mouhsineelachbi

I'm the best freelancer who can do this work without any problems so It also will be my first so please let me do It

$155 USD in 3 days
(0 Reviews)
0.0