• Home   /
• Blog
• Here’s the Step-by-Step Guide For QuickBooks ETSY Integration

Here’s the Step-by-Step Guide For QuickBooks ETSY Integration

• 
• By Jonathan Browns
• Jul 15, 2026
• Accounting
• 7 min read

As your Etsy business grows, managing finances, inventory, sales, and taxes manually becomes increasingly challenging. QuickBooks Etsy integration simplifies accounting by automatically syncing Etsy transactions with QuickBooks Online. By connecting your Etsy account with QuickBooks, you can automate bookkeeping, eliminate repetitive manual data entry, and spend more time on your business growth. This helps in improving overall business performance.

In this post, we have covered everything you need to know about QuickBooks Online integration, QuickBooks self-employed integration, and how to import transactions from an Etsy account into QuickBooks.

What is QuickBooks Etsy Integration?

QuickBooks Etsy integration is the process of connecting your Etsy shop with QBO to automatically sync orders, payments, taxes, and customer data. This reduces manual bookkeeping and helps improve financial accuracy.

What is the Benefit of Using QuickBooks and Etsy Together?

Using QuickBooks and Etsy together helps businesses reduce time spent on manual accounting tasks while enhancing financial accuracy.

The following are the advantages of using QuickBooks and Etsy.

1. Automate Bookkeeping-

Integrating both these accounts automates the bookkeeping tasks by importing sales, fees, shipping charges, and refunds automatically.

2. Reduce Human Errors-

Also, it reduces the hours spent on manual data entry, which may lead to data entry errors. However, automating data entry helps in improving bookkeeping.

3. Improve Cash Flow Monitoring-

You can track Etsy payouts and monitor available cash with real-time reports.

4. Simplifies Tax Preparation-

Another major benefit is that maintaining the financial reports accurately simplifies the tax filing process.

5. Business Performance Insights-

With QuickBooks and Etsy accounts, you can generate reports to analyze revenue, expenses, monthly sales, and best-selling products.

How to Set Up QuickBooks Online ETSY Integration

Integrating QBO with your Etsy shop lets you automate your bookkeeping tasks, such as importing orders, taxes, and payments directly into QuickBooks. Now, you can use the Etsy Connector within QuickBooks Online for a better integration experience.

Prerequisites:

Before starting the process, make sure you have;

• An active and valid QuickBooks Online subscription.
• An active Etsy seller account.
• Administrator access is required for both these accounts.

Perform the following steps to connect QuickBooks to Etsy account.

Step 1: Sign in to the QBO Account

Sign in to your QuickBooks Online account with proper credentials.

Step 2: Open the QuickBooks App Marketplace

• Select Integrations (or Apps, according to your QuickBooks version).
• Choose Find Integrations.
• Locate the Etsy Connector by Intuit.

Step 3: Install the Etsy Connector

• Now, tap on Etsy Connector by Intuit.
• Click on Get App Now.
• After this, use the on-screen instructions to install the app.

Step 4: Connect Your Etsy Account

• Provide your Etsy username (or email address) and password.
• Click on Login to access the account.
• To authorize Etsy for sending orders to QuickBooks, hit the Grant Access option.

Step 5: Review and Customize the App Settings

Now, start editing the app settings. You can also edit these settings later on by clicking Settings from the options in the Etsy tile.

Step 6: Choose the Transaction Start Date

Select the date from when you want Etsy to start importing orders. Then, click Done.

Note: QuickBooks supports importing 1 year of historical orders.

Step 7: Configure Integration Settings

In this step, you need to configure how Etsy transactions will appear in QuickBooks.

Sales Settings

Select whether you want Etsy orders to be created as;

• Sales Receipts
• Invoices

You can also change the Automatic Invoice Numbers, Shipping charges, and the discount applied.

Item Settings

Choose how you wish the products to be imported.

• Inventory items
• Non-Inventory items

You can also match the products using the SKU and by the Product Name.

Income Account Mapping

Pick the income account where you have to record the Etsy sales.

• Etsy Sales Income
• Online Sales Revenue

Expense Account Mapping

You have to assign accounts for;

• Etsy transaction fees
• Listing fees
• Payment processing fees
• Shipping expenses

Tax Mapping

If you collect sales tax, you need to map sales tax categories to the corresponding QuickBooks tax codes.

Step 8: Complete the Setup

Cross-check all the settings made, and then click Done for confirmation. QuickBooks will then establish the connection and start importing Etsy transactions automatically.

Step 9: Check Imported Transactions

Browse to App Transactions to monitor the synchronization.

You will see three different tabs within the Apps Transaction Page.

• Processing: It shows all the items and orders in progress and not yet imported.
• Imported: It displays all orders and items that are imported successfully from Etsy.
• Excluded: It shows all orders and items that are manually excluded from being imported.

After creating an order on Etsy, it will appear in the Imported tab of the Apps transaction screen within 4 hours.

Step 10: Match Etsy Deposits

To match Etsy deposits with the imported Etsy transactions;

• Navigate to the QuickBooks Banking menu.
• Go through the downloaded bank transactions.
• Now, match each deposit with the imported Etsy transactions.
• Complete your monthly bank reconciliation to ensure that your accounts are reconciled properly.

How to Connect QuickBooks Self-Employed With Etsy

You can access the QuickBooks Self-Employed connection for organizing the business revenue and outgoings. Here’s the complete procedure for QuickBooks Self-Employed Etsy integration.

• If you wish to connect your QuickBooks Self-Employed account, click the Gear icon.
• Choose the Bank Accounts option.
• If you have previously connected with an account, select Connect another and then click Continue.
• Provide your login credentials and tap on Connect Securely.

You can also choose the Sign Up link if you haven’t previously registered for a QB Self-Employed account. After logging to the account, you will be asked to log in to your Etsy account. Then, complete the process by hitting the Allow Access option.

How to import Etsy transactions into QuickBooks Online?

You can use the Sync with Etsy by Intuit to transfer transactions from Etsy payment account into QuickBooks. The application will then automatically enter and organize each sale, refund, and fee.

Here’s the complete procedure to set up the app and get your Etsy transactions into QuickBooks.

Step 1: Set up accounts in QuickBooks

Before syncing, ensure you have set up the following accounts in QuickBooks.

• A bank account in which Etsy deposits your money from sales.
• Bank or credit card account where Etsy charges your seller fees.

To verify whether these accounts already exist in QuickBooks, browse to the Charts of Accounts.

• Navigate to All Apps > Accounting > Chart of Accounts.
• Search for the account from the available list.

Step 2: Set up the Sync with Etsy app

Once you set up your account, you’re all set to connect QuickBooks to your Etsy shop.

• Navigate to Integrations > Find Integrations.
• Type Etsy in the search pane and choose Sync with Etsy.
• Click Get app now.
• Use the on-screen steps to set up the app, including the following steps;
  • Assign permissions to Intuit to access your Etsy shop.
  • Pick the bank account you set up in step 1 so the app recognizes where to mention transactions.
  • Choose the import start date. The app can import transactions from January 1 of the previous calendar year.

Once the setup is over, the app imports your Etsy transactions into QuickBooks. Depending on the transactions, the app will take some time to finish.

After the first import, app will check your Etsy payment account at least once every three hours.

Step 3: Adjust your books for past transactions

If you want to import the Etsy transactions from the past in step 2, the app will add transactions that already exist in your books.

Also, review your QuickBooks income and expenses for any Etsy transactions that you posted before you set up the Sync with Etsy app.

Step 4: Reconcile your Etsy account and bank account

Like any other accounts in QuickBooks, review your Etsy account every month and compare it with the statement from the bank you use for the Etsy account.

You can either use your bank’s monthly statements or download your monthly statements from Etsy.

Final Thoughts

QuickBooks Etsy integration is an effective solution for Etsy sellers looking to automate bookkeeping, track sales, manage expenses, and simplify tax preparation tasks. Whether you’re running QuickBooks Online or QuickBooks Self-Employed, integrating an Etsy store can help save time and improve financial accuracy. By following the steps outlined above, you can easily integrate QuickBooks Online with Etsy and QuickBooks Self-Employed with Etsy and streamline your accounting tasks.

Frequently Asked Questions

How to enter Etsy sales in QuickBooks?

To enter Etsy sales in QuickBooks;

• Download Etsy sales reports.
• Look for Etsy payouts in QuickBooks and find out the deposit in the Banking section.
• Create a sales receipt.
• Click Review & Reconcile.

What does QuickBooks Etsy integration do?

By integrating QuickBooks and Etsy, automatically transfer Etsy sales, fees, shipping income, taxes, refunds, and payouts into QuickBooks.

Which QuickBooks version is best for Etsy sellers?

QuickBooks Online is the best choice for growing Etsy’s business as it provides advanced reporting, sales tracking, inventory support, and integrations.

Can Etsy integrate with QuickBooks?

Yes, you can use the third-party integration tools to sync Etsy sales, fees, refunds, taxes, and payouts with QuickBooks Online.

What information syncs between Etsy and QuickBooks?

According to the integrated solution, synced data may include sales, customer orders, Etsy fees, payment processing charges, shipping income, refunds, taxes, payouts, and inventory information.