QuickBooks Online (General Ledger)

Overview

The BambooHR + QuickBooks Online (QBO) integration simplifies payroll accounting by automating journal entries and syncing payroll data seamlessly with QBO. Reduce manual data entry, minimize errors, and ensure accurate financial reporting. With customizable memo line mapping, asynchronous data transfer, and secure authentication, this integration helps streamline payroll reconciliation and expense tracking, saving time and improving accuracy.

Automated Data Sharing

You can now send your payroll Journal Entry (JE) reports directly from BambooHR to QuickBooks Online with a click of a button, saving time and reducing errors associated with manual data entry.

Easy Setup and Installation

Account owners in BambooHR can easily install the "QuickBooks Online (General Ledger)" app from the BambooHR Apps page in Settings and connect their payroll data to QBO through a simple authentication process.

Enhanced Data Mapping

You can map your payroll categories, such as wages and deductions, to your QuickBooks Chart of Accounts through bulk editing, ensuring accurate financial reporting. Smart filtering and search functionality have also been updated to help you quickly find and map the correct accounts.

Integration

What data syncs?

BambooHR Field
Sync Direction
QBO Field
Field Logic or Notes
Company ID / EIN
QBO Company ID / Realm ID
Required for authentication and identifying the QBO company to which data is sent.
Chart of Accounts#
Chart of Accounts
Pulled from QBO into BambooHR for mapping during JE setup.
Pay Date
Journal Date
The “Journal Date” in QBO reflects the payroll pay date.
Debit Account
Line Item > Account Ref
Determined by mapping memo lines to accounts from QBO’s Chart of Accounts.
Credit Account
Line Item > Account Ref
Same as above; used for offsetting JE entries.
Description (Memo Line Info)
Line Item > Description
Pulled from BambooHR payroll memo lines; customizable per mapping.
Amount
Line Item > Amount
Derived from BambooHR payroll calculations.
Journal Entry ID
Journal Entry ID
Used for traceability; not typically edited but helpful for reconciliation.

Publisher

BambooHR

Updated: 03/15/2025

Phone Support:

866-872-9123

Email Support:

[email protected]

Payroll Support Hours:

5:00 am - 5:00 pm Pacific Time

Monday - Friday