Skip to main content

How to configure the QuickBooks Online integration

Configure the QuickBooks Online integration with Katana to have seamless synchronization of financial and inventory data.

Dayvid Lorbiecke avatar
Written by Dayvid Lorbiecke
Updated over 2 weeks ago

Integrating QuickBooks Online with Katana enables seamless synchronization of sales, purchases, and inventory data between the two platforms. Proper configuration ensures accurate financial tracking and efficient operations.


Configuration overview

After connecting your QuickBooks account to Katana, you'll need to configure the integration before activation. The configuration consists of four main sections:

  1. Workflows

  2. Accounts by Category

  3. Tax Mapping

  4. Data Transfer

Note: Consult with your accounting department during configuration to ensure correct setup.


1. Workflows

The Workflows tab allows you to define how Katana transactions are recorded in QuickBooks.

Workflows tab for configuring the QuickBooks integration

Purchasing and inventory

  • Enable purchase order sync:

    • Toggle on Send Katana purchase orders as bills to QuickBooks.

      Screenshot showing the Send Katana purchase orders as bill to QuickBooks toggle enabled

    • Choose how bills are recorded in QuickBooks:

      • Inventory Asset (Recommended):

        Screenshot highlighting the bills as an inventory asset selection for quickbooks
      • Expense:

        • Select the QuickBooks expense account for recording purchases.

        • Optionally, include additional costs as above.

          Including additional costs for bills as an expense in the QuickBooks configuration

Cost of Goods Sold (COGS)

COGS toggle in the QuickBooks configuration
  • Enable COGS Sync:

    • Toggle on Send Cost of goods sold to QuickBooks.

    • Select the QuickBooks expense account for COGS.

    • Further mapping can be done in the Accounts by Category tab.

Sales revenue

Sending sales orders to QuickBooks toggle in the QuickBooks configuration
  • Enable sales order sync:

    • Toggle on Send Katana sales orders as invoices to QuickBooks.

    • Select the QuickBooks income account for sales revenue.

    • Optionally:

      • Include SO shipping fees in the QuickBooks invoice.

      • Sync the QuickBooks invoice payment status back to Katana.

        • Ensure the Shipping option is enabled in QuickBooks under Settings > Sales.


2. Accounts by Category

Screenshot highlighting the Accounts by category tab in the quickbooks configuration

This section allows for detailed mapping of Katana item categories to specific QuickBooks accounts:

  • Sales revenue:

    • Assign different item categories to specific QuickBooks income accounts.

  • COGS:

    • Assign different item categories to specific QuickBooks expense accounts.

Note: Unmapped categories will default to the accounts selected in the Workflows tab.


3. Tax mapping (Non-U.S. QuickBooks accounts)

Tax mapping tab for configuring the QuickBooks integration

For non-U.S. QuickBooks accounts, tax rates in Katana must be mapped to corresponding QuickBooks tax rates:

  • Navigate to the Tax Mapping tab.

  • Map each Katana tax rate to a QuickBooks tax rate.

  • All tax rates must be mapped before activation.

  • To manage Katana tax rates, click Manage Katana tax rates.

Note: Katana does not differentiate between sales and purchase taxes. To apply different rates, create separate tax rates in Katana and map them accordingly in QuickBooks.


4. Data transfer

Data transfer tab for configuring the QuickBooks integration

Import existing customers and suppliers from QuickBooks into Katana:

  • Navigate to the Data transfer tab.

  • Click Import customers and/or Import suppliers.

  • Imports can be performed multiple times as needed.

  • A timestamp indicates the last import time.


Activating the integration

After completing all configuration steps:

  1. Click Activate to enable the integration.

    Screenshot showing the activation button for quickbooks
  2. Upon activation:

    • A new Invoice column appears in the Sell screen.

    • A new Bill column appears in the Buy screen.

    • Creating an invoice or bill in Katana will generate a corresponding document in QuickBooks.

Note: If a customer or supplier does not exist in QuickBooks, Katana will automatically create a new profile upon syncing.


Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]

Did this answer your question?