Import QuickBooks Expenses

Pull grant expenses from QuickBooks Online when the organization's books already contain the spending detail. BetterUnite reads purchase lines tagged with the grant's QuickBooks Class, previews where each line will land, and records the previewed spending in the grant's budget-to-actual view.

The connection is read-only for this workflow. Pulling expenses into Grant Center does not create, edit, or delete anything in QuickBooks Online.

Availability: QuickBooks expense pulls require Grant Pro and the QuickBooks integration add-on. Mapping a class or pulling expenses requires Manage Grant Finances or Administer Grant Center.

Before you begin

Make sure all of the following are true:

QuickBooks Online is connected to BetterUnite.
Class tracking is enabled in QuickBooks Online under Account and Settings.
The grant's expense lines are tagged with a dedicated QuickBooks Class.
The grant has budget categories and lines if you want expenses placed automatically.

If QuickBooks returns no classes, confirm that Class tracking is enabled and that active classes exist in QuickBooks Online.

Map the grant to a QuickBooks Class

Open the grant and select Schedule & work → Budget & spending.
Select the Spending tab.
In the QuickBooks card, select Map a class.
Choose the QuickBooks Class used to tag this grant's spending.
Select Save.

The mapping tells BetterUnite which QuickBooks expense lines belong to this grant. A grant can be mapped to one Class at a time. Changing or clearing the mapping does not remove expenses that were already pulled.

Preview a QuickBooks pull

Open the grant's Budget & spending area and select Spending.
In the QuickBooks card, confirm that the displayed Class is correct.
Select Pull spending.
Review the preview. Nothing has been recorded yet.

The pull uses the grant period as its date range. If the grant has no period dates, it uses the previous year through today. QuickBooks cannot filter purchases by a line-level Class before returning them, so a shorter, accurate grant period makes the pull faster and easier to reconcile.

Read the four preview results

Would record — expense lines matched to an existing BetterUnite budget line.
Unallocated — valid QuickBooks expense lines that could not be placed on a budget line. They can still be recorded and assigned later.
Already recorded — QuickBooks lines previously pulled into this grant. They are skipped so a repeated pull does not double the spending.
Only here — expenses entered manually in BetterUnite during the same date range with no corresponding QuickBooks line carrying the mapped Class. Review whether they have reached the books or were tagged correctly.

The preview also shows how many QuickBooks purchase transactions were read and how many expense lines carried the grant's Class. One purchase split across several QuickBooks accounts appears as a separate BetterUnite expense for each matching line.

How QuickBooks accounts match the grant budget

BetterUnite uses the QuickBooks account name to find a budget category. If the account name begins with a code, such as 7020 Travel, it checks the code first and then the name. The expense date determines the budget period.

If no category, line, or period can be matched, the expense appears as Unallocated instead of being discarded. After recording the pull, create or identify the correct budget line and edit the expense to assign it.

Record the previewed expenses

Confirm that the Class, date range, totals, and exceptions look correct.
Review Unallocated and Only here rows.
Select Record expenses.
Return to the Spending list and resolve any Unallocated rows.
Compare the recorded amount with the QuickBooks detail for the same Class and period.

BetterUnite reads QuickBooks again when the expenses are recorded. If a transaction changes after the preview, the final result may differ. The QuickBooks card shows how many expenses have been pulled and the most recent pull activity.

How duplicate protection works

Each QuickBooks purchase line receives a unique external reference. Pulling the same date range again recognizes a previously recorded line and reports it as Already recorded instead of adding it twice. Duplicate protection cannot be turned off for QuickBooks pulls.

A later edit in QuickBooks does not update a line already recorded in BetterUnite. Reconcile material changes and correct the BetterUnite expense when necessary while keeping QuickBooks Online as the book of record.

How refunds and split purchases are handled

A QuickBooks purchase marked as a credit is recorded as a negative expense, reducing actual spending.
A purchase split across several accounts becomes one BetterUnite expense per matching line.
Both account-based and item-based expense lines can be included when they carry the mapped Class.
Zero-amount, undated, unclassified, or differently classified lines are not pulled for the grant.

Know what is included

This workflow reads QuickBooks purchase transactions, including expenses paid by check, credit card, or cash. It does not pull Bills, Journal Entries, or Vendor Credits. As a result, committed but unpaid costs and payroll allocations recorded through those transaction types are not included.

The integration does not run on a schedule and does not map grants through QuickBooks Customers or Projects. Run the pull when the grant view needs to be refreshed.

If the pull did not cover the whole range

BetterUnite warns when QuickBooks has more transactions than one pull can read. A truncated result is incomplete even if some matching lines appear.

The current grant panel uses the grant period as its pull range and does not provide a custom date-range control. Do not treat a truncated result as complete. Contact BetterUnite Support for help pulling the spending in smaller date ranges; duplicate protection makes overlapping passes safe because previously recorded QuickBooks lines are skipped.

Troubleshoot common results

The QuickBooks card says Add QuickBooks

The organization has Grant Pro but not the QuickBooks integration add-on. Add the integration before mapping a Class.

The card says Connect QuickBooks

The add-on is available, but QuickBooks Online has not been connected. Use the connection link in the card, complete the connection, and return to the grant.

No classes are available

Enable Class tracking in QuickBooks Online and confirm that an active Class exists. Then reopen the Class picker.

No spending is tagged with this Class

Confirm that the correct Class is mapped, that the QuickBooks Class is assigned on each expense line rather than only inferred from the transaction, and that the transaction date falls inside the grant period.

Expenses appear as Unallocated

Compare the QuickBooks account code and name with the grant's budget categories, then confirm that the expense date falls within a budget period and that a line exists for that category and period.

Expenses appear under Only here

These are manually entered BetterUnite expenses, not failed QuickBooks imports. Check whether the corresponding transaction is missing from QuickBooks, outside the date range, or missing the grant's Class.