Quickbooks has an API so in theory, you could use one of the free plug ins for API calls or possibly Insert Fron URL to create your own integration.
You can go here as Phil stated:
I looked thru it and it's a little over my head, but I plan to work on it in my slow season (June/July). They also have a forum and you may find some guidance there. I think it's completely doable, just not by me...yet.
What I simply did, because I just want to import customer balances & open invoices to my DB is this:
-Add an account field to QB and put the customers primary key as the account number. This will always have to be performed manually (in this case) and when you add a new customer (double entry).
-In QB you can export customer balances to Excel. So I export a report to Excel.
-Then in FM, you can script an import of customer balances, open invoices, to the import table, which is connected by relationship to the customers table (or whichever table you select).
The whole operation takes about 2 minutes (the script runs almost a minute.
Once again, this is a very simplified approach and my main reason for this is by having this info in the DB is I can send out payment reminders, and look up balances in FM. I use FM all the time for my business and QB just for invoicing.
This is not syncing QB & FM, just to be clear. And the 'fly in the ointment' is possible data entry error putting the primary key in QB. But for a single user always solution, it works for me.
QuickBooks Desktop, QuickBooks Online or both?
Also specify platform(s) and versions.
Sent from miPhone
A quick search shows theses:
Search this forum for 'quickbooks' for other suggestions previously made.
I'm planning to use QuickBooks Online.
Im using FileMaker 15 Pro Advanced on Windows.
And if you really only need small occasional updates of QuickBooks, you might be able to export the data from FileMaker in then import the data from that file into QB. Not nearly as nice as the API route--whether by third party tool or your own, but also cheep and relatively easy to do if you can figure out the necessary QB import part of the process.