Orion · QBO Mapping Setup
← My Shop

QuickBooks Mapping Setup

Invoice GL → QBO item / income account

Map each income GL code to a QuickBooks item before invoices can sync. Nothing posts from this page. Unmapped lines block the push.

⚠ Restrict editing of synced invoices in QuickBooks

Once Joker syncs an invoice to QuickBooks it becomes accounting-locked in Joker — its lines, totals, customer, and number can't be edited; corrections go through Void & recreate (before payment) or a future credit-and-rebill (after payment). Joker reads QBO status back, but it cannot stop someone editing the invoice directly inside QuickBooks. Big Sky must restrict QBO user permissions so synced invoices aren't edited in QuickBooks by unauthorized users — that part is a QuickBooks-side (Big Sky) responsibility.

① Import Big Sky GL chart (CSV)

Optional. Loads income & COGS accounts from your QuickBooks export. Updates existing codes; deletes nothing.

② Confirm income mappings

For each income GL code, pick the QuickBooks income account and item, then Confirm. Suggested matches are pre-selected where found.

GL CodeGL NameQBO Income AccountQBO ItemStatusAction
Click Refresh to load.

②b Station → QBO location

Map each station to its QuickBooks Location. Fetch to pick from your Departments; matches are pre-selected.

②c Tax Setup

Joker calculates tax (and manages exemptions). QBO must not silently recalculate. Pick the QBO TaxCodes and enable the override to send Joker's calculated tax. Until enabled with a taxable code, taxed invoices stay blocked.

Taxable TaxCode
Exempt TaxCode

②d Customer Deposit

A received customer deposit is a liability — it posts to QuickBooks as a SalesReceipt using the Customer Deposit item, whose income account is the confirmed liability account 2040 — Shop Work Deposits (not 2020). No revenue is recognized on receipt. It's later applied to the final invoice as a negative Customer Deposit line. Pick the item and the 2040 account below.

Customer Deposit Item
Liability Account (2040)
Clearing / Deposit-To (optional)

②e Invoice Custom Fields

Map the WO # and Tail # to QBO custom fields. Fetch the definitions or enter the DefinitionId (1/2/3). The invoice number stays the DocNumber.

Work Order # → ID
Aircraft Tail # → ID

②f Card Processing Fees

Gross payment posts to the invoice. Fees post by Journal Entry: debit Expense, credit Clearing (usually Undeposited Funds). Pick both accounts.

Fee Expense Account (debit)
Clearing Account (credit)

②g Customer Credit / Billing Adjustment

Credit memos use a generic Customer Credit / Billing Adjustment item. Do not use the Customer Deposit item or 2040 Shop Work Deposits — that's a liability for deposits, not an AR correction. Pick the generic credit item below.

Customer Credit Item

③ Invoice sync preview

Enter an invoice # to see how its lines resolve against the confirmed mappings. Unmapped lines are listed as exceptions and block the push.