Archive

Posts Tagged ‘connecting filemaker and quickbooks’

Core5 Starter Edition CRM – Integrating FileMaker with QuickBooks

November 1st, 2017

Core5_to_QB
The Core5 Starter Edition CRM comes with an impressive level of QuickBooks integration right out of the box. It can connect to QuickBooks Desktop or Online.

Core5 is preconfigured to:
1. Import Items, Taxes, Customers, and Vendors from QuickBooks
2. Push contacts to QuickBooks
3. Push invoices to QuickBooks
4. Pull balance due for invoices
5. Pull most recent payment date

It also has the ability to set flags on customer or invoice records to notify the user that something has been updated and the customer or invoice record needs to be re-pushed to QuickBooks.

The Core5 can do single record or batch pushes and pulls of contacts, invoices, and payment information.

How to add a new contact to QuickBooks

When you create a new contact there will be a red icon on the record – this indicates the contact is not in QuickBooks. Click “Push to QB” to push the single, new record.

Once it has successfully pushed, the icon will turn green.

If a contact record has already been pushed to QuickBooks, but has been updated – the QB icon will turn orange – indicating it needs to be re-pushed.

Here is a quick video demoing this:
YouTube Preview Image

If you added or edited multiple records, you can push them all to QuickBooks at one time from the Dashboard.

On the Contacts tab, there is a “Push All to QB” button. This will call a script that looks for all new and updated records and pushes them all to QuickBooks at one time.

If you wish to not push a specific record, you can click the omit checkbox and that record will not be pushed.

Here is another quick video showing these actions:
YouTube Preview Image

How to push an invoice to QuickBooks

One of the nice things about the Core5 Starter Edition is its consistency. It is almost the same process to push an invoice to QuickBooks as it is a customer.

Once an invoice is complete, you can push the “Push to QB” button in the top left. The QB icon will be red if the invoice needs to be pushed to QuickBooks, orange if it needs to be re-pushed, and green if it has been pushed and is up-to-date in QuickBooks.

Check out the video below demonstrating this:

YouTube Preview Image

Invoices can also be pushed en masse from the Dashboard. Similar to Contacts, you can click the “Push All to QB” button to push all new and updated invoices to QuickBooks. The omit checkbox will prevent a specific invoice record from being pushed.

Here is your final video:
YouTube Preview Image

How to pull balance due and payment information
Once an invoice has been pushed to QuickBooks, payments can be recorded in QuickBooks and then pulled into the Core5.

To pull balance information, click the green money icon on the invoice record. This will bring over the invoice balance and the date of the most recent payment.

On the Dashboard, you can also do a batch pull of balances due.

Try Core5 yourself with our online WebDirect demo.

Need QuickBooks Licensing? We can give you a discount on Pro, Premier, Enterprise, and Online licensing.

Let’s talk integration – FileMaker to QuickBooks Integration

September 28th, 2017

FM_to_QB
Earlier in the year our CEO, Marc, did a webinar for the Blue Feather Group/ Atlanta FileMaker Dev Group all about integrating FileMaker and QuickBooks – but before we get into that, let’s talk a bit about why Marc spoke on this topic.

Here at Productive Computing we have made it our business to know all there is about QuickBooks and FileMaker integrations and to offer our clients an array of products and services to help them get up and running with an integration.

We offer:
– The FM Books Connector plug-in for QuickBooks Desktop
– The FM Books Connector Online Edition plug-in for QuickBooks Online
Core4 CRM and Core5 Starter Edition CRM (both of which come preconfigured to connect with QuickBooks)
123sync Accounting Integrator, which offers two fixed-price integration plans for QuickBooks Desktop
– Custom development services to assist you with your integration
– Discounts on both FileMaker and QuickBooks licensing

We actively work to make it as easy as possible for clients to connect two of the most important office software solutions.

We’re also proud to announce that we just released FM Books Connector v10. And, let us tell you, it has aged beautifully. This plug-in is compatible with QuickBooks 2014–2018 and FileMaker Pro 14-16 (32-bit and 64-bit).

As we alluded to earlier, we’re authorized Intuit resellers and, because of that, we are able to offer great rates on QuickBooks Desktop 2018 Pro, Premier, Enterprise, and Online licensing.

Now, for the real reason you clicked on this blog – the FileMaker and QuickBooks integration webinar.

For your viewing pleasure and to be sensitive to the fact you don’t have all day to watch webinars, I have detailed out what topics begin at what time. If you want to start at the beginning, you can just watch it from the video below.

YouTube Preview Image

At minute 7:08 Marc begins his discussion on QuickBooks and FileMaker integrations. He discusses the various QuickBooks integration products mentioned above and why there is no plug-in for QuickBooks Desktop for Mac (hint: it’s because there is no SDK).

At 11:00 minutes he discusses why businesses use QuickBooks and why people want FileMaker and QuickBooks integrations.

Starting at 15:50, he discusses what a typical desktop integration looks like and at 17:20 he reviews how a developer can do a desktop integration (custom integration, integration package, starter solution).

At 26:10 Marc begins his first demo to show importing contacts and items from QuickBooks into FileMaker and at 33:10 he turns on the debugger to show the “under the hood” of the import for items, taxes, customers, and vendors.

At 45:10 Marc demonstrates a FileMaker to QuickBooks push, specifically of a new customer.

At 48:20 Marc answers the question, why not just use the FileMaker field validation functions and discusses handling field validation.

At 57:00 Marc starts to discuss batch pushes to QuickBooks.

At 1:01:30 Marc discusses some QuickBooks rules that affect FileMaker and QuickBooks integrations and begins to answer some Q&A.

At 1:06:40 Marc discusses the Intuit OSR (onscreen reference).

At 1:08:00 David, a FileMaker developer, shares his own story learning how to do a custom integration with QuickBooks and FileMaker.

Hopefully this helped you and answered a few questions you might have had about integrating FileMaker with QuickBooks. For more information please feel free to check out our website www.productivecomputing.com or contact us at sales@productivecomputing.com.