QuickBooks Commerce

Last update: Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time) Topics: Commerce Tables Data Warehouse Manager Data Integration Data Import/Export CREATED FOR: Beginner Intermediate Admin Developer User With the QuickBooks integration, your business finances can now live along side your sales and marketing data, allowing you to quickly and easily keep tabs on your expenses, identify overspending, and more. Add QuickBooks as a data source in Commerce Intelligence Go to the Integrations page under Manage Data > Data Sources. Click Add Integration, located on the right side of the screen above the Data Sources table. Click the QuickBooks icon. Click Connect to Quickbooks. Grant Commerce Intelligence access to your QuickBooks data After clicking Connect to Quickbooks, log in to your Intuit account and authorize the connection: In the Search for a company dropdown, select your company. Click Next. You are redirected to Commerce Intelligence and a Connection Successful! message displays at the top of the screen. Expected QuickBooks data Reauthenticating integrations

For merchants using Square and Stripe, Commerce Sync can transfer deposit information into QuickBooks. Commerce Sync first transfers the invoice and payments, typically the following day you will see the deposit transfer. When the deposit is created, it reconciles the payments from Undeposited Funds and adds the fees to the deposit.Bank Account: Select the bank account that you have in QuickBooks that you want the deposits to be created in. Typically this bank account is named after the bank account that the deposits are actually going into.Merchant Fees: Commerce Sync will use an expense account to use for your bank fees. The setting can be updated to the account of your choice.Uncategorized Expenses: Commerce Sync will use an expense account for your uncategorized expenses that are coming from Square or Stripe. A typical uncategorized expense that we see is a Capitol Loan from your point of sale. Uncategorized Income: Commerce Sync will use an income account for your uncategorized income. A typical uncategorized expense that we see is when your point of sales owes you a rebate.Here are the settings in the Commerce Sync Dashboard:The accounts, items, and customers in your Commerce Sync settings are populated by the information Commerce Sync receives from QuickBooks. Commerce Sync will create place-holder items and accounts to use when you install and connect to QuickBooks.

– $50 per month QuickBooks Quickbooks is a cloud-based accounting software for businesses with inventory management, sales reporting, and accounting features. Its’ inventory management feature covers stock-level monitoring and reporting, inventory accounting, and multi-channel sales tracking Pros: Comprehensive inventory management with robust accounting Quickbooks offer integration with e-commerce platforms Cons: Quickbooks tends to be expensive for businesses starting with a tight budget It has a steep learning curve for users new to inventory management software Quickbooks lacks order fulfillment tracking and barcode scanning Pricing: Quickbooks offers these plans with a 30-day trial period: Simple Start – $30 per month Essentials – $60 per month Plus – $90 per month Advanced – $200 per month Ordoro Ordoro is a centralized e-commerce inventory management software for businesses tracking sales and order fulfilment through multiple channels. It covers order and shipping management, inventory management and drop shipping management. Pros: Integrates with multiple e-commerce platforms Offers discounted rates to users to save on shipping costs. Cons: Requires integration with accounting software to create reports available only on the most expensive plan Ordoro’s prices tend to be high for small businesses Pricing: Ordoro offers three plans with a trial period: Essentials – Free Advanced – $59 per month Premium- $149 per month Zoho Inventory Zoho Inventory is an inventory management system for businesses offering integration with e-commerce platforms, sales tracking, vendor and client management, barcode scanning, order tracking, and reporting. It offers warehouse management and integrates with other Zoho Suite programs. Pros: Zoho inventory offers warehouse management for multiple locations as well as e-commerce integrations It is easy to use for businesses without previous inventory management software experience Cons: Zoho inventory has limited e-commerce integrations compared to alternatives It offers limited customization to users Pricing Zoho Inventory offers these plans and a trial period: Free