Guides
QuickBooks guides from the people who build QuickBooks apps
Straight answers on checks, QuickBooks Desktop access, reporting in SQL and moving between systems.
Check printing
PrintCHECKHow to print checks from QuickBooks Online
QuickBooks Online can print checks on its own, and for a handful of checks a month that is often enough. This guide walks through the built-in process, the problems people usually run into, and when a dedicated check printing app is worth it.
7 min read
What is a MICR line? Reading the numbers at the bottom of a check
The strip of odd-looking numbers along the bottom of a check is the MICR line. It is how banks read a check automatically — and getting it right is the one part of printing your own checks that is not optional.
6 min read
How to prevent duplicate vendor payments before checks go out
Paying the same invoice twice is one of the most common accounts payable mistakes — and by check it is the slowest to recover. Most duplicates can be caught with a few simple checks before a batch is printed.
6 min read
Desktop web access
QBWebSyncQuickBooks Desktop remote access: every option compared
QuickBooks Desktop was designed to run on a computer in the office. When the people who need it are at home, on the road or at their accountant's desk, there are four realistic ways to reach it. Here is how they compare.
8 min read
How to enter QuickBooks Desktop bills from a PDF
Most vendor bills now arrive as PDFs, but QuickBooks Desktop still expects someone to type them in. Here are the options, from fully manual to AI-assisted, and the checks that keep your payables clean either way.
5 min read
Data export & BI
QBSyncHow to get QuickBooks Desktop data into a SQL database
QuickBooks Desktop keeps its data in a company file that other software cannot query directly. If you want QuickBooks data in reports, dashboards or other systems, the first job is getting it into a real database. These are the options.
7 min read
Useful SQL queries for QuickBooks data
Once QuickBooks data is in a database, the most useful reports are a few lines of SQL. These examples use the table names QBSync creates; the ideas carry over to any QuickBooks schema with header and line tables.
5 min read
Accounting platform
GFS