---
title: "QuickBooks to Databricks Connector | OWOX"
canonical: "https://www.owox.com/connectors/quickbooks-connector-to-databricks"
updated: "2026-11-09"
---

# Collect QuickBooks journal entries in Databricks

Load QuickBooks journal entries and the chart of accounts into your own Databricks workspace with a custom OWOX connector. Manual adjustments become rows you can audit, join and run models on.

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)QuickBooks · Connected · A/P Aging Summar… · A/R Aging Summar… · Accounts · Balance Sheet re…

Data Mart · Published · one definition

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Realm · Report · ReportDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get started free](https://www.owox.com/app-signup)

## Endpoints

## QuickBooks Endpoints

[Documentation](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account)

26 QuickBooks endpoints you can import. Each lands in its own table in your data warehouse.

*   [A/P Aging Summary report A/P Aging Summary as of report\_date (window end): one row per vendor with aging buckets. 11 fields · Time series](/data-sources/quickbooks#schema-a-p-aging-summary-report)

*   [A/R Aging Summary report A/R Aging Summary as of report\_date (window end): one row per customer with Current, 1-30, 31-60, 61-90, 91+ and Total columns. 11 fields · Time series](/data-sources/quickbooks#schema-a-r-aging-summary-report)

*   [Accounts Chart of accounts, active and inactive. 20 fields](/data-sources/quickbooks#schema-accounts)

*   [Balance Sheet report Balance Sheet as of the run window end (Assets, Liabilities, Equity by account). 12 fields · Time series](/data-sources/quickbooks#schema-balance-sheet-report)

*   [Bill payments Payments against vendor bills; joins to Bill through Line\[\].LinkedTxn. 23 fields](/data-sources/quickbooks#schema-bill-payments)

*   [Bills Vendor bills (payables). 25 fields](/data-sources/quickbooks#schema-bills)

*   [Cash Flow report Statement of Cash Flows for the run window. 12 fields · Time series](/data-sources/quickbooks#schema-cash-flow-report)

*   [Company info One row per company: names, country, fiscal-year start. 15 fields](/data-sources/quickbooks#schema-company-info)

*   [Credit memos Credits issued to customers (reduce receivables; negative revenue in reconciliations). 23 fields](/data-sources/quickbooks#schema-credit-memos)

*   [Customers Customers, including inactive ones and sub-customers, with open balance and a flattened billing address. 28 fields](/data-sources/quickbooks#schema-customers)

*   [Deposits Bank deposits, including the ones that group undeposited customer payments. 21 fields](/data-sources/quickbooks#schema-deposits)

*   [General Ledger Detail report General Ledger: every posting line per account for the run window, with opening balance and totals. 12 fields · Time series](/data-sources/quickbooks#schema-general-ledger-detail-report)

*   [Invoice changes (CDC, incl. deletes) Change data capture for Invoice: every invoice created, updated or deleted since the run window start, full payload, deleted ones with status = Deleted. 9 fields · Time series](/data-sources/quickbooks#schema-invoice-changes-cdc-incl-deletes)

*   [Invoices Invoices with header amounts, customer and Line\[\] as JSON (SalesItemLineDetail.ItemRef, Qty, UnitPrice, Amount). 36 fields](/data-sources/quickbooks#schema-invoices)

*   [Items Products and services with price, purchase cost and the three account links. 25 fields](/data-sources/quickbooks#schema-items)

*   [Journal entries Manual and adjusting journal entries; the postings the transaction tables miss. 15 fields](/data-sources/quickbooks#schema-journal-entries)

*   [Payments Customer payments. 21 fields](/data-sources/quickbooks#schema-payments)

*   [Preferences One row per company: home currency, multi-currency flag, fiscal-year and tracking settings. 17 fields](/data-sources/quickbooks#schema-preferences)

*   [Profit and Loss report Profit and Loss per run window, one column per month (summarize\_column\_by=Month), rows nested by account group. 12 fields · Time series](/data-sources/quickbooks#schema-profit-and-loss-report)

*   [Purchases Expenses paid directly (cash, check, card) without a bill. 26 fields](/data-sources/quickbooks#schema-purchases)

*   [Refund receipts Money refunded to customers. 26 fields](/data-sources/quickbooks#schema-refund-receipts)

*   [Sales by Customer report Sales by Customer Summary for the run window. 12 fields · Time series](/data-sources/quickbooks#schema-sales-by-customer-report)

*   [Sales receipts Sales paid at the time of sale (no receivable). 27 fields](/data-sources/quickbooks#schema-sales-receipts)

*   [Transfers Money moved between balance-sheet accounts. 16 fields](/data-sources/quickbooks#schema-transfers)

*   [Vendor Expenses report Expenses by Vendor for the run window. 12 fields · Time series](/data-sources/quickbooks#schema-vendor-expenses-report)

*   [Vendors Vendors, including inactive ones, with open payable balance. 19 fields](/data-sources/quickbooks#schema-vendors)

## S00 · Why

## Why bring journal entries into the same place as the rest

Journal entries are where the books are adjusted by hand, which is why they matter at the close and why they are hard to see in reports. Loading them with the accounts into a [data warehouse](/data-storages) lets you read every adjustment against the account it touched.

*   Audit manual adjustments by date and by account
*   Join entries to the chart of accounts in SQL
*   Feed forecasting or anomaly models from the same tables

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)QuickBooks · Entries, accounts

Finance model · Forecasts

Operations · Costs by team

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · QuickBooks · Forecast · OperationsJoined by id · Adjustment posted · Account reviewedOne query lists the adjustments an account received.

## S01 · Step 1

## Step 1: Connect QuickBooks and pick the fields

Create a Data Mart, choose QuickBooks as the [data source](/data-sources) and authorize QuickBooks Online with OAuth. Add the company (realm) id, open an endpoint and tick only the fields you need.

*   Journal entries sits beside Accounts among the 26 endpoints
*   A custom connector: the credential and company id are yours

New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Cg%20clip-path%3D%22url\(%23clip0_14430_15244\)%22%3E%0A%3Cpath%20d%3D%22M40.1006%209.24272C40.0674%209.00032%2039.8556%208.86584%2039.6798%208.8512C39.5054%208.83656%2036.0883%208.78464%2036.0883%208.78464C36.0883%208.78464%2033.2305%206.0094%2032.9482%205.72708C32.6659%205.44477%2032.1146%205.52999%2031.9002%205.59391C31.8975%205.59525%2031.3635%205.76038%2030.4646%206.0387C30.3142%205.5513%2030.093%204.95204%2029.7774%204.35012C28.7601%202.40853%2027.2699%201.3818%2025.4694%201.37914C25.4668%201.37914%2025.4654%201.37914%2025.4628%201.37914C25.3376%201.37914%2025.2138%201.39113%2025.0886%201.40178C25.0354%201.33786%2024.9821%201.27527%2024.9262%201.21401C24.1418%200.375052%2023.1364%20-0.0337745%2021.9312%200.0021809C19.6061%200.068765%2017.2903%201.74802%2015.4126%204.73098C14.0916%206.82971%2013.0862%209.46648%2012.8012%2011.5079C10.1312%2012.3349%208.26414%2012.9128%208.22286%2012.9262C6.87519%2013.3496%206.83258%2013.3909%206.6568%2014.6614C6.5263%2015.6214%203%2042.889%203%2042.889L32.5514%2048L45.3594%2044.8159C45.3594%2044.8159%2040.1339%209.48512%2040.1006%209.24272ZM28.9851%206.49679C28.3046%206.7072%2027.5309%206.9469%2026.6919%207.20658C26.6746%206.02938%2026.5348%204.39141%2025.9862%202.97582C27.7506%203.31008%2028.6189%205.30627%2028.9851%206.49679ZM25.1458%207.68598C23.5971%208.16536%2021.9072%208.68872%2020.212%209.21344C20.6887%207.38769%2021.593%205.56994%2022.7036%204.37809C23.1164%203.93464%2023.6943%203.44058%2024.3788%203.15826C25.022%204.5006%2025.1618%206.40091%2025.1458%207.68598ZM21.9778%201.54959C22.5238%201.53761%2022.9832%201.65746%2023.3761%201.91581C22.7475%202.24207%2022.1402%202.71082%2021.5703%203.32206C20.0934%204.90677%2018.9615%207.36638%2018.5101%209.73944C17.1025%2010.1749%2015.7255%2010.6024%2014.4578%2010.9939C15.2582%207.25852%2018.3889%201.65346%2021.9778%201.54959Z%22%20fill%3D%22%2395BF47%22%2F%3E%0A%3Cpath%20d%3D%22M39.6812%208.85246C39.5068%208.83782%2036.0897%208.7859%2036.0897%208.7859C36.0897%208.7859%2033.2319%206.01065%2032.9496%205.72834C32.8444%205.62313%2032.7019%205.56853%2032.5527%205.5459L32.5541%2047.9986L45.3609%2044.8159C45.3609%2044.8159%2040.1354%209.48638%2040.1021%209.24398C40.0687%209.00158%2039.8557%208.8671%2039.6812%208.85246Z%22%20fill%3D%22%235E8E3E%22%2F%3E%0A%3Cpath%20d%3D%22M25.4536%2015.4377L23.9662%2021.0028C23.9662%2021.0028%2022.3069%2020.2477%2020.34%2020.3716C17.4555%2020.554%2017.4249%2022.3731%2017.4543%2022.8299C17.6114%2025.3188%2024.1592%2025.8621%2024.5268%2031.6922C24.8158%2036.2785%2022.0938%2039.416%2018.172%2039.6636C13.4645%2039.9606%2010.873%2037.184%2010.873%2037.184L11.8705%2032.9413C11.8705%2032.9413%2014.4792%2034.9096%2016.5673%2034.7777C17.931%2034.6912%2018.4183%2033.5819%2018.3691%2032.7975C18.164%2029.5508%2012.8319%2029.7426%2012.4951%2024.4079C12.2114%2019.9188%2015.1598%2015.3698%2021.665%2014.9596C24.1712%2014.7985%2025.4536%2015.4377%2025.4536%2015.4377Z%22%20fill%3D%22white%22%2F%3E%0A%3C%2Fg%3E%0A%3Cdefs%3E%0A%3CclipPath%20id%3D%22clip0_14430_15244%22%3E%0A%3Crect%20fill%3D%22white%22%20height%3D%2248%22%20transform%3D%22translate\(3\)%22%20width%3D%2242.4%22%2F%3E%0A%3C%2FclipPath%3E%0A%3C%2Fdefs%3E%0A%3C%2Fsvg%3E%0A)Shopify · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)QuickBooks · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · AuthorizeConnected · Endpoint · Journal entries · A/P Aging Summary… · A/R Aging Summary… · Accounts

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Journal entries · 15 fields · txn\_datetotal\_amtdoc\_numberprivate\_notecurrency\_id

## S02 · Step 2

## Step 2: Load QuickBooks into Databricks

Each endpoint becomes its own table, and refresh settings are set in the Data Mart. Run it and the first load lands as a table in a schema of the main catalog in Databricks. The location is pre-filled from your [data storage](/data-storages), and you can change it.

*   Journal entries land in their own table in the main catalog
*   Every run is logged in Run History

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · quickbooks · Table · journal\_entry · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.quickbooks.journal\_entry

## S03 · Step 3

## Step 3: Get a business-friendly QuickBooks output schema

After the first run you get the output schema: every field with its type. total\_amt is documented as the sum of one side of the entry, and the debit and credit lines stay as JSON.

*   The line array holds PostingType, Debit or Credit, to unnest in SQL
*   private\_note keeps the preparer's remark

![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.quickbooks.journal\_entry · Output schema · Field · Descriptiontxn\_date · Business date of the… · total\_amt · Sum of one side of the entry. · doc\_number · Document number shown on the… · private\_note · Internal memo entered on the… · currency\_id · Currency code of the document…

## S04 · Step 4

## Step 4: Keep the QuickBooks tables linked

Company info, accounts and journal entries stay separate tables that share realm\_id as the company key; a journal line reaches its account through AccountRef. Together they become the adjustments part of one QuickBooks [data model](/product/data-modeling).

*   Entries and accounts both carry the company id
*   Account references inside the lines join to Accounts.id

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Company info · realm\_id · company\_name

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Accounts · id · realm\_id · account\_type

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)Journal entries · realm\_id · txn\_date · total\_amt

## S05 · Step 5

## Step 5: Schedule the QuickBooks refresh and backfill history

Set it once. A daily scheduled refresh keeps the tables current, and a manual backfill loads earlier periods.

*   Daily runs with no pipeline to maintain
*   Backfill entries for the periods under review

Schedule · Run on a schedule · Daily 09:00

Backfill · Run backfill

Run History · Daily schedule · Manual backfill · Daily schedule

## S06 · Step 6

## Step 6: Reuse the same QuickBooks table everywhere

One table feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) and scheduled insights in Slack or email.

*   Define an adjustment once
*   Every report reads the same table

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Crect%20width%3D%2248%22%20height%3D%2248%22%20rx%3D%2210%22%20fill%3D%22%232CA01C%22%2F%3E%0A%3Cpath%20transform%3D%22translate\(9%209\)%20scale\(1.25\)%22%20fill%3D%22%23fff%22%20d%3D%22M12%200A12%2012%200%200%200%200%2012a12%2012%200%200%200%2012%2012%2012%2012%200%200%200%2012-12A12%2012%200%200%200%2012%200zm.642%204.1335c.9554%200%201.7296.776%201.7296%201.7332v9.0667h1.6c1.614%200%202.9275-1.3156%202.9275-2.933%200-1.6173-1.3136-2.9333-2.9276-2.9333h-.6654V7.3334h.6654c2.5722%200%204.6577%202.0897%204.6577%204.667%200%202.5774-2.0855%204.6666-4.6577%204.6666H12.642zM7.9837%207.333h3.3291v12.533c-.9555%200-1.73-.7759-1.73-1.7332V9.0662H7.9837c-1.6146%200-2.9277%201.316-2.9277%202.9334%200%201.6175%201.3131%202.9333%202.9277%202.9333h.6654v1.7332h-.6654c-2.5725%200-4.6577-2.0892-4.6577-4.6665%200-2.5771%202.0852-4.6666%204.6577-4.6666Z%22%2F%3E%0A%3C%2Fsvg%3E%0A)QuickBooks · Data Mart · Published

Your data model

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets

![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards

![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT

![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email

## Related connectors

[QuickBooks to Claude](/connectors/quickbooks-connector-to-claude)[Stripe to Databricks](/connectors/stripe-connector-to-databricks)[QuickBooks to ChatGPT](/connectors/quickbooks-connector-to-chatgpt)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks) · Show 6 more · Show fewer

## Recent updates

*   [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)
*   [0.41.0 · Shared SQL logic stays in one place: build a Data Mart on top of another](https://docs.owox.com/docs/changelog/#shared-sql-logic-stays-in-one-place-build-a-data-mart-on-top-of-another-0410)
*   [0.41.0 · Rotating a connector key is one change: Sources share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-connector-key-is-one-change-sources-share-reusable-credentials-0410)
*   [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog/#connecting-a-plan-from-google-sheets-takes-fewer-guesses-0400)

## Why OWOX

## Why OWOX for QuickBooks in Databricks

Journal entries rarely reach analytics. OWOX loads them into your own Databricks workspace beside everything else you model.

*   **You own the data.** It lands in your own data warehouse, in tables you control.
*   **Adjustments you can audit.** Every entry is a row with its date, amount and note.
*   **Notebook-ready.** Tables in Databricks are ready for the models your data team already runs.
*   **One place to fix.** When QuickBooks's API changes, you publish one new connector version.

[Book a call](/book-a-call)

[Get started free](https://www.owox.com/app-signup)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get started free](https://www.owox.com/app-signup)
- [A/P Aging Summary reportA/P Aging Summary as of report_date (window end): one row per vendor with…](https://www.owox.com/data-sources/quickbooks) — /data-sources/quickbooks.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md
- [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [QuickBooks to Claude](https://www.owox.com/connectors/quickbooks-connector-to-claude) — /connectors/quickbooks-connector-to-claude.md
- [Stripe to Databricks](https://www.owox.com/connectors/stripe-connector-to-databricks) — /connectors/stripe-connector-to-databricks.md
- [QuickBooks to ChatGPT](https://www.owox.com/connectors/quickbooks-connector-to-chatgpt) — /connectors/quickbooks-connector-to-chatgpt.md
- [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md
- [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md
- [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md
- [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md
- [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md
- [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md
- [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md