Katana's integration with QuickBooks Online simplifies inventory and financial management by synchronizing sales, purchases, and stock data. This integration allows you to easily transfer sales orders, purchase orders, and stock adjustments, streamlining accounting and ensuring accurate financial records.
Connecting your QuickBooks account to Katana should only take a few minutes, but you can only integrate with QuickBooks Online, not the QuickBooks Desktop version.
Head here to learn how to configure your QuickBooks Online integration with Katana.
How data is managed between QuickBooks and Katana
Data sent from Katana to QuickBooks
The choices you make on the configuration page determine what data is sent to QuickBooks.
Purchase orders are sent to QuickBooks as Bills. Read more
This can include Additional costs, Stock adjustment value, and Manufacturing operations cost.
You can choose specific accounts in QuickBooks where each value/cost will go to.
Note: You'll need to have Bills enabled on your QuickBooks account for this to work (you must be subscribed to QuickBooks Essentials package or higher).
Cost of goods sold (COGS)
Sales orders are sent to QuickBooks as Invoices. You can choose a default income account in QuickBooks for invoices to be sent to and then further personalize by linking item categories (in Katana) to specific QuickBooks income accounts. Read more
This can include Shipping fees
You can also sync payment status from QuickBooks back to Katana
Data sent from QuickBooks to Katana
You can import both Customers and Suppliers from QuickBooks to Katana as many times as you'd like.
Data matched/mapped between Katana and QuickBooks
Through the integration configuration, you can map certain parts of Katana to QuickBooks (and vice versa) and then have that data matched through the integration.
Tax rates and types used in Katana can be mapped to select QuickBooks tax types.
Customers and Suppliers from QuickBooks are matched in Katana by email address and/or name and updated if duplicates are found
If you have multiple Income accounts in QuickBooks, you may want to assign different Katana Item categories to specific Income accounts.
Inventory vs non-inventory items
Since Katana tracks inventory and will sync this value to QuickBooks, it's important that products created in QuickBooks are non-inventory items to avoid duplication.
To further elaborate, if you were to create a product as an inventory item in QuickBooks, inventory tracking will occur in QuickBooks for that item. If Katana sends over value to QuickBooks for a matching item, a duplicate item is created in QuickBooks.
Learn more about non-inventory items in QuickBooks Online.
Find out more about how to connect QuickBooks to Katana.
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]