Join Data to QBO Data

Join data to your QuickBooks Online data quickly

Drop your QuickBooks Online file here (or click to browse).
(100 MB or less file)
Sign-up to upload larger files
Join Data Tools QBO Tools
Convert QBO using an API
Join Data

Joining brings your QuickBooks Online file together with a second dataset by matching rows on the columns you choose, so related data ends up in one table. Pick an Inner, Left, Right, or Full join to decide which rows are kept when a match is missing. Perfect for enriching records, adding reference or lookup data.

QuickBooks Online

QBO (QuickBooks Web Connect) is the file banks offer as the "download for QuickBooks" option. A .qbo file is an Open Financial Exchange document with the Intuit fields QuickBooks uses to match the download to a bank account, and it holds the same sign-on, account, and transaction structure as any other OFX file.