[Webinar] Streamline your web hosting managementRegister Today


quickbooks and filemaker

Posted on 2008-02-03
Medium Priority
Last Modified: 2012-08-13
are there many people use filemaker to create financial statement?
i just want to know what would be the benefit of using quickbooks.
experienced filemaker developer can create same as quickbooks quality of database?
Question by:Hiroyuki Tamura
  • 2
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 340 total points
ID: 20809817
Quickbooks is a ready-to-run accounting system that's been in use for many years. Normally this means that the bugs have been worked out and the program works as expected. Compare that to a custom-built system that is not yet proven, and that would take months or even years to develop and test. IMO, there's little need to re-invent the wheel if Quickbooks will suit your needs. If you need features that are not found in QB, however, it might be worth the time and money to build a custom solution - or just use QB and have someone "extend" it.
LVL 28

Assisted Solution

lesouef earned 160 total points
ID: 20813696
I agree, make specific dev when you need specific requirements. but don't expect to customize quickbooks either. all you can do is export from it and have a complementary app. handy enough? or be rich and stop counting yr money!
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 340 total points
ID: 20813831
QuickBooks does provide an API/SDK that you can use to "get at" most of the data (note I said "most of" since all sections of QuickBooks are not yet supported through the API). There's also a "driver" available that you can use to get at the data (http://www.qodbc.com/) if you don't want to deal with the API (which is oddly constructed in some cases).

That said, the best you'll hope for in QB is to get to the data and deal with it outside of QuickBooks (for example, get Customer lists, Inventory lists, etc) and use those to interact back with QB (i.e. add Invoices, checks etc). There are also quite a few 3rd party apps that interface with QB, so depending on what you're trying to do someone may have already gone to the trouble to handle it.


Expert Comment

ID: 20858542
We use FileBooks Link, http://filebookslink.com/, to link our custom solution to QuickBooks, it uses qbxml for two-way syncronization. Theres also FMBooksConnector, http://www.fmbooksconnector.com/index.php, both work basically the same.

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Use this step by step method when setting up QuickBooks Online. They will allow you to explore the various features of the advanced settings available to you.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Suggested Courses

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question