---
title: "QuickBooks to AWS Redshift Connector | OWOX"
canonical: "https://www.owox.com/connectors/quickbooks-connector-to-aws-redshift"
updated: "2026-11-09"
---

# Collect QuickBooks credit memos in AWS Redshift

Load QuickBooks credit memos, invoices and customers into your own AWS Redshift cluster with a custom OWOX connector. Credits land next to the same customer's invoices, so net revenue per customer is computed, not argued about.

![](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/redshift-connector-to-google-sheets/icon/1.png/public)AWS Redshift · 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 look at credit memos beside the invoices they reverse

Revenue in QuickBooks is invoiced minus credited, and the two live on different records. Seeing which customers get the most credit needs invoices and credit memos in one [data warehouse](/data-storages), joined on the customer.

*   Net revenue is invoices minus credit memos, per customer
*   Credits can be set against refunds from the store
*   A rising credit rate is visible before the close

![](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 · Credits, reversals

Refunds · Shopify refunds

Support · Tickets

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)Your data warehouse · AWS Redshift · QuickBooks · Refunds · SupportJoined by id · Invoice issued · Credit memo raisedOne query nets credits against invoices per customer.

## 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.

*   Credit memos mirrors Invoices: customer, dates, amounts and lines
*   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 · Credit memos · 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)Credit memos · 23 fields · txn\_datetotal\_amtcustomer\_namedoc\_numbercurrency\_id

## S02 · Step 2

## Step 2: Load QuickBooks into AWS Redshift

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 your own AWS Redshift cluster or workgroup. The location is pre-filled from your [data storage](/data-storages), and you can change it.

*   Credit memos land in their own table in the Redshift schema
*   Every run is logged in Run History

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)Destination · AWS Redshift · Schema · quickbooks · Table · credit\_memo · Run

Run History · Pending · Running · SuccessIncremental load

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

## 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. Key fields carry a plain description, and your [data quality](/product/data-quality) checks can read it.

*   Amounts stay in the transaction currency, with the exchange rate beside them
*   id and realm\_id identify a credit memo

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)quickbooks.credit\_memo · Output schema · Field · Descriptiontxn\_date · Business date of the… · total\_amt · Total amount of the document… · customer\_name · Name of the customer that… · doc\_number · Document number shown on the… · currency\_id · Currency code of the document…

## S04 · Step 4

## Step 4: Keep the QuickBooks tables linked

Customers, invoices and credit memos stay separate tables, joined by customer\_id. Together they give the net-revenue part of one QuickBooks [data model](/product/data-modeling).

*   Credit memos carry customer\_id, as invoices do
*   Add store refunds to the same model

![](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)Customers · id · display\_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)Invoices · customer\_id · total\_amt · balance

![](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)Credit memos · customer\_id · 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 credits 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 net revenue 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 AWS Redshift](/connectors/stripe-connector-to-aws-redshift)[QuickBooks to ChatGPT](/connectors/quickbooks-connector-to-chatgpt)[Facebook Ads to AWS Redshift](/connectors/free-facebook-ads-connector-to-aws-redshift)[Google Ads to AWS Redshift](/connectors/free-google-ads-connector-to-aws-redshift)[Microsoft Ads to AWS Redshift](/connectors/free-microsoft-ads-connector-to-aws-redshift)[TikTok Ads to AWS Redshift](/connectors/free-tiktok-ads-connector-to-aws-redshift)[Bank of Canada to AWS Redshift](/connectors/bank-of-canada-connector-to-aws-redshift)[Criteo Ads to AWS Redshift](/connectors/free-criteo-ads-connector-to-aws-redshift) · 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 AWS Redshift

A credit memo list from QuickBooks is a list. OWOX makes credits a table you can join, in your own AWS Redshift.

*   **You own the data.** It lands in your own data warehouse, in tables you control.
*   **Credits tied to the customer.** Credit memos and invoices share customer\_id, so net revenue per customer is one query.
*   **Built to extend.** As a custom connector it can gain fields without a vendor roadmap.
*   **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 quality](https://www.owox.com/product/data-quality) — /product/data-quality.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 AWS Redshift](https://www.owox.com/connectors/stripe-connector-to-aws-redshift) — /connectors/stripe-connector-to-aws-redshift.md
- [QuickBooks to ChatGPT](https://www.owox.com/connectors/quickbooks-connector-to-chatgpt) — /connectors/quickbooks-connector-to-chatgpt.md
- [Facebook Ads to AWS Redshift](https://www.owox.com/connectors/free-facebook-ads-connector-to-aws-redshift) — /connectors/free-facebook-ads-connector-to-aws-redshift.md
- [Google Ads to AWS Redshift](https://www.owox.com/connectors/free-google-ads-connector-to-aws-redshift) — /connectors/free-google-ads-connector-to-aws-redshift.md
- [Microsoft Ads to AWS Redshift](https://www.owox.com/connectors/free-microsoft-ads-connector-to-aws-redshift) — /connectors/free-microsoft-ads-connector-to-aws-redshift.md
- [TikTok Ads to AWS Redshift](https://www.owox.com/connectors/free-tiktok-ads-connector-to-aws-redshift) — /connectors/free-tiktok-ads-connector-to-aws-redshift.md
- [Bank of Canada to AWS Redshift](https://www.owox.com/connectors/bank-of-canada-connector-to-aws-redshift) — /connectors/bank-of-canada-connector-to-aws-redshift.md
- [Criteo Ads to AWS Redshift](https://www.owox.com/connectors/free-criteo-ads-connector-to-aws-redshift) — /connectors/free-criteo-ads-connector-to-aws-redshift.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