Excel UDF to produce Quickbooks account balance at a specified date.

$30-250 CAD

Færdiggjort

Slået op

næsten 7 år siden

$30-250 CAD

Betales ved levering

I am looking for a freelancer to help me with my project. The skills required are Excel/VBA, Quickbooks SDK (QBFC or QBXml). I am happy to pay a fixed priced and my budget is up to $250 CAD. I need a working Excel / VBA project which will create an efficient User Defined Function, that will be passed 2 input strings (Account number, Asat Date) that will query Quickbooks to obtain the balance for the specified account asat the specified date. The "solutions" proposed previously used the QODBC driver to import a stored procedure/report and then filter the report using the account number. While this works for one-off balances, if this function is used multiple times this becomes exponentially too slow. I would like a module which sets up the connection using QBFC or QBXml, and includes the public function that can be used in a spreadsheet.

Accounting

Excel

Visual Basic for Apps

Projekt-ID: 14015420

Om projektet

11 forslag

Projekt på afstand

Aktiv 7 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@khanicha

Using QODBC this would be easy as we simply send the query to the connection built over QODBC. I have questions: - what excel version you are using? - what quickbooks version you are using? - could you send me the preferred function names you will set for this UDF? Thank you

$155 CAD på 3 dage

4,9

(2 anmeldelser)

2,9

11 freelancere byder i gennemsnit $177 CAD på dette job

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

$250 CAD på 3 dage

4,9

(299 anmeldelser)

7,8

@sandroshubladze

Hello Hello, I am spreadsheet expert usually specialize in creating automated macros and nice looking excel forms. I have lots of experience in that field. If you are interested, PM me to discuss details of the job. Thanks & regards

$250 CAD på 3 dage

5,0

(197 anmeldelser)

8,0

@abhinovpankaj

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

$177 CAD på 3 dage

4,9

(46 anmeldelser)

5,4

@srinichal

Ready to discuss further details about the project and deliver the same to your specifications and needs

$244 CAD på 6 dage

5,0

(16 anmeldelser)

5,2

@ketas

Dear, With many year working experience with VBA on MS Excel , I could help you finish this request less than one week for sure. Will get paid only the job done and you satisfied . PM me for more detail !

$200 CAD på 4 dage

4,7

(14 anmeldelser)

3,9

@ahmedshabanahmed

I work as a financial accountant and I use Excel professionally I am able to finish the project in a few days If you want to see an example before starting work, I have no objection

$35 CAD på 3 dage

5,0

(1 bedømmelse)

0,4

@BeautiCG

Hi,dear. I am a senior software developer. I have just checked your project report, I am able to perform this task with my developer team. I am looking forward to your proposal...

$155 CAD på 1 dag

0,0

(0 anmeldelser)

0,0

@msmohan

I have extensive knowledge & experience in building Excel based automation solution I have done similar work for importing data from various back-end databases using the specific drivers. I also have finance background to understand and provide a proper solution depending on the business needs Search for Mohan Manicks on Linkedin to view full details on past projects / work experience Thank you Mohan Manicks

$166 CAD på 15 dage