QuickBooks 2016: The Missing Manual

Chapter 26. Integrating QuickBooks with Other Programs

Most companies use other programs in addition to QuickBooks to keep their businesses running smoothly. For example, you can use QuickBooks data in other programs to study your company’s financial ratios, calculate employee bonuses based on services sold, send special sales letters to customers on their birthdays, and so on. Similarly, other programs may contain data that would be useful to pull into QuickBooks. For example, if you use an estimating program that has all the products and services you sell in its database, there’s no reason to manually enter that info in QuickBooks.

QuickBooks doesn’t share its most intimate details with just any program. It reserves its data for a few select programs—and the ones you tell it to play nicely with. For example, you can set up letters in QuickBooks to send to customers, and the program automatically opens Microsoft Word with your customer data merged into form letters and envelopes. And if you manage contacts with Microsoft Outlook (not Outlook Express), keeping records up to date is easy. By synchronizing your QuickBooks company file and your contact database, you enter changes in one place and both programs automatically reflect the updates.

Programs that can read a QuickBooks company file still have to ask permission to grab QuickBooks data. The QuickBooks administrator (or other QuickBooks users whom the administrator anoints) can say whether another program can have access and ...