Why QBO Invoices Can't Be Pulled Into BaseBuilders

This article explains why invoices can't be imported or synced from QuickBooks Online into BaseBuilders.

The Short Answer

A QuickBooks Online invoice line is just a finished result: a description, a quantity, a rate, and an amount. A BaseBuilders invoice line item is built from three separate, interconnected sources of data. QBO simply doesn't store the information needed to reconstruct that connection.

What Goes Into a BaseBuilders Invoice Line Item

Every invoice line item in BaseBuilders comes from three places:

Time Slips — the work that was actually done: who did it (Employee), when (Date), how long it took (Hours), what type of work it was (Activity), and any additional context (Comments).

Billing Rates — how that time was valued. Rates are recorded on the time slip itself, can vary by project so each contract has its own pricing, and have effective dates so rates can change over time without altering historical data.

Project Phases — how the work is structured. Phases tie time back to the contracted scope of services (like Schematic Design), allocate fee across phases, and drive reporting on performance, profit, WIP, and backlog.

These three elements combine, linked together by ID fields such as employee ID, rate ID, phase ID, and project ID, to produce a single invoice line item you can trust for billing, reporting, and profitability tracking.

What QuickBooks Online Actually Has

QBO only stores the finished invoice line: a description, quantity, rate, and amount. It has no concept of:

• Detailed time slips — no phases, no activities, no comments behind the hours
• Project-specific billing rates — rates aren't tied to individual projects
• Project phases — there's no structure connecting a line item to a phase of work
• Relationships — no system-of-record IDs linking any of this data together

Why This Matters

Without those interconnecting IDs, there's no way to reverse-engineer a QBO invoice back into a BaseBuilders invoice line item. The rate, the phase, the employee, and the activity that produced that line simply aren't recorded anywhere in QBO. Pulling invoices in from QBO would mean guessing at data that was never captured in the first place.

Best Practice

Treat BaseBuilders as the system of record for time, billing rates, and phases, and let QBO stay downstream as your accounting and financial reporting tool. Invoices should be created in BaseBuilders and pushed to QBO, not the other way around.

Summary

BaseBuilders invoice line items are built from time slips, billing rates, and phases, all linked together by ID fields. QuickBooks Online only keeps the finished invoice line and has no reference for these underlying values, which is why invoices can't be pulled in from QBO.