Archive

Archive for the ‘FM Books Connector Online’ Category

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.

macOS High Sierra Compatibility

October 17th, 2017

macoshighsierra-800x464

macOS High Sierra was released on September 25 and we worked diligently to test and update each of our plug-ins to confirm compatibility with the new OS. If you have updated to High Sierra make sure you download an updated plug-in.

Each plug-in comes with an updated demo file and many plug-ins feature new functionality, updated documentation, and bug fixes.

Plug-ins:
FM Books Connector Online v2.0.3.1: Available for client or server-side deployment and compatible with FileMaker Cloud, the FM Books Connector Online Edition connects FileMaker with QuickBooks Online. Users can save time and money by eliminating double entry of contacts, invoices or sales transactions. This release also includes additional plug-in enhancements and functionality.

Address Book Manipulator v4.0.2.1: The Address Book Manipulator allows users to update all contacts in FileMaker or Apple Contacts and then easily push the information from one application to the other, ensuring contact information is always up-to-date.

iCal Manipulator v2.0.2.1: The iCal Manipulator plug-in directly connects FileMaker with Apple Calendar. The plug-in supports multiple calendars, recurring events, and tasks. This release also includes additional plug-in enhancements and functionality.

FM Credit Card v2.0.0.0: Available for client and server-side deployments, FM Credit Card connects a user’s FileMaker solution to their preferred merchant services provider. Productive Computing also offers low-priced, basic integration packages for this plug-in.

PDF Manipulator DC v1.0.2.1: The PDF Manipulator DC Edition enables users to create a searchable document management system and process forms faster by extracting and inserting data between PDF form fields and FileMaker.

File Manipulator v4.0.2.1: File Manipulator can copy, move, rename, or delete files and folders directly from a FileMaker solution. In addition, it can compress and encrypt file data with password protection, as well as decompress and decrypt file data.

Change Printer v4.0.8.1: The Change Printer plug-in automatically changes printers, sets optional printing attributes, facilitates the coordination of large and complex print procedures, and easily switches between various types of printers/drivers.

Solutions:
Core5 Starter Edition v1.0.2.1: The Core5 Starter Edition is an intuitive and easy-to-use CRM solution. Pre-configured to connect with QuickBooks Desktop or Online, the Core5 is designed to be easy to customize and immediately deployable.

Core4 CRM v3.0.0.5: Core4 is a robust and expandable CRM solution. This business tool allows users to track everything from contacts to sales transactions and calendar appointments to notes and documents. The Core4 can connect with QuickBooks and Outlook for Windows, Apple Contacts, and Apple Calendar.

For additional information on product functionality, updates, and integration details, please contact sales@productivecomputing.com or call 760-510-1200.

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.

Get your QuickBooks Licensing at Discount Through Productive Computing

August 25th, 2017

authorized_reseller_rgb_small

Big News! Well, if you’re a QuickBooks user or thinking of getting started with QuickBooks then this is big news! We are officially an authorized Intuit Reseller – meaning we can save you money on your QuickBooks licensing.

We pursued becoming an Intuit authorized reseller because we wanted to make it even easier for our clients to get up and running with their FileMaker and QuickBooks integrations; our aim was to create a one-stop shop for the convenience of our clients. Now you can purchase the FM Books Connector plug-in, FileMaker licensing, and QuickBooks licensing all from us. With our custom development services, we can even complete the integration for you – or help you with your FileMaker scripts.

Our QuickBooks offerings will focus on:
CB_QB_Pref_PNG

QuickBooks Pro – the ideal accounting solution for your office with up to 3 users.

QuickBooks Premier – get all the features of Pro, plus industry specific features with up to 5 users.

QuickBooks Enterprise (Silver, Gold, and Platinum plans) – this is end-to-end business management with advanced user permissions and capabilities. Connect with up to 30 users!

QuickBooks Online (Simple Start, Essentials, and Plus plans) – get the flexibility you need to access your accounting files from anywhere and additional ease of use features that are not available with QuickBooks Desktop.

As an authorized reseller, we have the ability to resell any Intuit product, including Point of Sale hardware and software, Intuit Payroll, and QuickBooks Accountant licensing. Our clients can get their QuickBooks licensing at a discount and we will beat any advertised price. If you have unique license requirements or don’t see what you are looking for on our website – give us a call! We’ll work with you to get you what you want at the best price. Please email sales@productivecomputing.com or call 760-510-1200.

We have an entire suite of plug-ins and solutions that help you connect with your QuickBooks file:

FM_to_QB_Products_grey

FM Books Connector plug-in– connects your FileMaker solution to your QuickBooks Desktop file (Windows only).
FM Books Connector Online plug-in – connects your FileMaker solution to (you guessed it) your QuickBooks Online file. This plug-in is available for client-side or server-side deployment for Windows server, Mac OS server, and FileMaker Cloud)
123sync – two fixed price integration packages offer you the ability to connect your FileMaker solution to your QuickBooks Desktop file – without the need for custom development.
Core5 Starter Edition – a starter FileMaker CRM that is preconfigured to connect with QuickBooks Desktop or Online.
Core4 CRM – a comprehensive FileMaker CRM that is preconfigured to connect to your QuickBooks Desktop file.

Why you should integrate QuickBooks with FileMaker:

FM_to_QB

– Push data directly from your FileMaker app to your QuickBooks file – eliminating double data entry.

– Reduce the errors associated with re-keying data in QuickBooks from other applications, PDFs, or paper forms.

– Protect your QuickBooks file by using FileMaker as a central location for all customer account information.

– Give your employees access to up-to-date customer invoices and balance data so they can operate more efficiently.

For more information, please visit www.productivecomputing.com/QuickBooks-Desktop-Enterprise.

Our First FileMaker Cloud Compatible Plug-in – FM Books Connector Online Edition

August 8th, 2017

Logo_FMBOE

With the advent of FileMaker Cloud (FMC), we took a close look at our list of plug-ins and selected the one we felt was the best candidate for Linux compatibility. As any business owner knows – most business decisions come down to time and resources. We knew making a plug-in Linux compatible was not necessarily going to be a small investment on the part of our plug-in developer’s time and talent.

We needed to choose the plug-in that we felt would be most attractive to FMC users and we decided that our FM Books Connector Online Edition plug-in was the best choice. We felt the customer profile for this plug-in was a good fit. Given the fact that QuickBooks Online users are already hosting their QuickBooks files in the cloud, they may be more likely to host their FileMaker solution in the cloud, as well.

With the FMC compatible version of the FM Books Connector Online Edition plug-in clients can now host their FileMaker solutions in the cloud, giving their staff access to pertinent customer information and the ability to push and pull customers, invoices, and other transaction information from anywhere and on any device.

fmboe_client_server_purple
What is the difference between a single user (client-side) and server-side plug-in?

A client-side plug-in needs to be installed on a user’s computer for them to run any push and pull scripts between FileMaker and QuickBooks. If you plan on having multiple users, integrating with a client-side plug-in requires that you purchase multiple users and install the plug-in on multiple computers. Additionally, users will only be able to push or pull data between FileMaker and QuickBooks when running the solution in FileMaker Pro. With a client-side plug-in, there is no ability to update records or communicate with QuickBooks when using FileMaker Go or WebDirect.

Installing a server-side plug-in on your server allows unlimited users (per server) to push and pull data between FileMaker and QuickBooks. By utilizing the server-side plug-in to handle the processing, users on FileMaker Pro, iPad and iPhone (via FileMaker Go), and WebDirect have the ability to push and pull data between FileMaker and QuickBooks Online without having to install a client-side plug-in.

Cloud-Final_200

Why FileMaker Cloud?

It is important that your solution is as mobile as your workforce. FileMaker Cloud runs on the Amazon Web Services (AWS) platform and is considered to be an affordable and easily scalable hosting option for FileMaker users.

If you are interested in hosting your solution, but are unfamiliar with AWS, we offer setup and consultation services that cover the initial setup of your FileMaker Cloud account on AWS. This service can also include training if you intend to manage the server yourself. For those not interested in managing their FileMaker Cloud account, we offer monthly managed services that include all labor associated with maintaining your server – so you can be as hands on or hands off as you want.

FM_to_QB

Why Integrate FileMaker with QuickBooks?

Does your sales team spend time filling out orders that your accountant then has to spend additional time re-typing into QuickBooks to create an invoice? With a FileMaker and QuickBooks integration, your sales team can create an order in FileMaker and push it to QuickBooks, where it is automatically turned into an invoice.

In your office, is your bookkeeper the only person with access to customer data in QuickBooks? If this is the case, something as simple as following up on a recent payment or invoice balance can require a call or email from a sales team member to the accounting department and then a subsequent QuickBooks search and a return call or email from accounting with the answer. This workflow not only interrupts and distracts your team, it causes delays when a sales team member is trying to follow up with a client.

A potential workaround would be for the accountant to send out weekly or monthly spreadsheets with all clients and corresponding outstanding balances. However, these spreadsheets take time to create and become out of date and inaccurate the moment a new payment is received.

Another workaround to this situation is buying multiple QuickBooks licenses and giving your sales team access to QuickBooks, but that can result in too many people accessing your sensitive QuickBooks file.

Integrating FileMaker and QuickBooks can solve these issues and help avoid workarounds, giving your sales team access to customer balances and payment information directly in FileMaker – ensuring the information is always readily available and up-to-date.