QuickBooks HelpQuickBooksHelpIntuit

Import transactions from your Etsy shop into QuickBooks Online

by Intuit4 Updated 3 months ago

Learn how to automatically import transactions from your Etsy shop into QuickBooks Online.

Do you sell your products on Etsy? You can use the Sync with Etsy app to bring transactions from your Etsy payment account into QuickBooks. The app automatically enters and categorizes each sale, refund, and fee. It’s a great way to save time and keep your books up to date.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

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

To watch more how-to videos, visit our video section.

Step 1: Set up accounts in QuickBooks if you need to

Before the Sync with Etsy app imports your transactions, make sure these accounts are set up in QuickBooks:

  • The bank account where Etsy deposits your money from sales
  • The bank or credit card account where Etsy charges your seller fees

You can check if these accounts are already in QuickBooks by going to your chart of accounts:

  1. Go to Settings ⚙.
  2. Select Chart of Accounts.
  3. Look for the accounts in the list. 

If they don’t exist in QuickBooks yet, follow the steps to add new accounts to your chart of accounts.

Step 2: Set up the Sync with Etsy app

With your accounts set up, you’re ready to connect QuickBooks to your Etsy shop:

  1. Go to Apps, then select Find Apps.
  2. In the Search field, enter “Etsy” and select Sync with Etsy from the list.
  3. Select Get app now.
  4. Follow the instructions on the screen to set up the app, including these steps: 
  • Give Intuit permission to access your Etsy shop.
  • Select the bank accounts you set up in step 1 so the app knows where to enter transactions.
  • Select the import start date. The app can import transactions as far back as January 1 of the previous calendar year.
    Note: If you choose a start date from the past, the app may import Etsy transactions that are already in your books. You may need to make adjustments so these transactions aren’t counted twice. See step 3 below.

After you finish setup, the app begins to import your Etsy transactions into QuickBooks. Depending on the number of transactions, it may take a few hours to finish.

After the first import, the app checks your Etsy payment account at least once every three hours and brings in the latest transactions. 

Important: When Sync with Etsy connects to QuickBooks, it adds accounts, services, and customer and vendor names to your company. We recommend you keep these items exactly as they are to ensure the app imports your Etsy transactions properly.

Step 3: Adjust your books for past transactions if you need to

If you choose to import Etsy transactions from the past in step 2, the app may add transactions that you already have in your books. This may cause them to be counted twice in your accounting.

Review your QuickBooks income and expenses for any Etsy transactions that you posted before you set up the Sync with Etsy app. If you find any, learn how you can make adjustments to your books so your accounting stays accurate. 

Note: You only need to make these kinds of adjustments after the first import. When the Sync with Etsy app imports new transactions, it automatically creates transfers that match to deposits or charges to your bank or credit card account. This helps prevent transactions from being counted twice and your income or expenses from being overstated.

Going forward: Reconcile your Etsy account and bank account

Like other accounts in QuickBooks, you’ll want to review your “Etsy ” account each month and make sure it matches the statement from the bank you use for your Etsy payment account. 

You can use your bank’s monthly statements or download monthly statements from Etsy. Note: Etsy’s statements show the transactions in your payment account for that period but do not have beginning and ending balances.

Learn more about how to reconcile your accounts.

Common questions about the Sync with Etsy app

When Sync with Etsy connects to QuickBooks, it adds accounts, services, and customer and vendor names. To help make sure the app imports your Etsy transactions properly, here’s what you can do:

Accounts

  • Keep all the accounts the app creates and don’t make them inactive.
  • Don’t change the account type or detail type.
  • Don’t rename the parent accounts.

It’s okay to add account numbers to these accounts.

Services

  • Keep all the services the app creates and don’t make them inactive.
  • Don’t change the item type.
  • Don’t rename the parent items.

It’s okay to change the account assigned to the service item.

Customer and vendor names

Keep the customer and vendor the app adds. This helps you better identify the transactions from Etsy.

The app enters all of the transactions in your Etsy payments account in a bank account named “Etsy <Name of your shop>

It enters the following types of transactions in the account:

  • Sales are entered as sales receipts.
  • Fees are entered as expenses.
  • Deposits are entered as transfers from the account “Etsy <Name of your shop>” to the bank account you selected when you set up the app.

Here’s a detailed look at the types of transactions it enters:

Etsy Activity TypeQuickBooks Transaction
SaleSales Receipt
RefundRefund Receipt
Listing  (fee)Expense
Transaction (fee)Expense
Advertising & Promotional (fee)
Etsy Ads (fee)
Offsite Ads (fee)
Expense
Subscription (fee)Expense
Gift Wrap (fee)Expense
Deposit (Merchant deposit from Etsy into seller’s bank account)Transfer
Payment (Merchant charge from Etsy to seller’s credit card account)Transfer

And here are the accounts and subaccounts it uses by default:

Parent AccountAccount NameTypeDetail Type
Etsy (Name of Shop)BankChecking
Etsy Sales Tax ClearingOther Current LiabilitiesOther Current Liabilities
Etsy Shop SalesIncomeSales of Product Income
Product IncomeSales of Product Income
ServicesIncomeService/
Fee Income
DiscountsIncomeDiscounts/
Refunds Given
RefundsIncomeDiscounts/Refunds Given
Etsy Shop FeesExpenseOther Business Expenses
AdvertisingExpenseAdvertising/
Promotional
TransactionExpenseBank Charges
SubscriptionExpenseDues & Subscriptions
ShippingExpenseShipping, Freight & Delivery
MerchantExpenseBank Charges
ListingExpenseAdvertising/
Promotional

You can see them in your chart of accounts.

Etsy sales post to the following income accounts by default:

  • Etsy Shop Sales:Product
  • Etsy Shop Sales:Services
  • Etsy Shop Sales:Discounts

Refund receipts post to the income account Etsy Shop Sales:Refunds. 

Note: Refunds imported before March 8, 2021 will post to Etsy Shop Sales: Product, Etsy Shop Sales: Services, or Etsy Shop Sale: Discounts. Refunds imported after that date will post to Etsy Shop Sales: Refunds.

Here’s what the accounts look like in a Profit and Loss report in QuickBooks:

image

The app creates the following products and services items in QuickBooks:

CategoryNameTypeIncome AccountExpense AccountSales Tax Category
Etsy-QBOProduct SalesServiceEtsy Shop Sales:
Product
Etsy Shop Sales:
Product
Nontaxable
Etsy-QBOShipping ServiceEtsy Shop Sales:
Services
Etsy Shop Fees:
Shipping
Nontaxable
Etsy-QBOPayment FeesServiceEtsy Shop Fees:
Merchant
Etsy Shop Fees: MerchantNontaxable
Etsy-QBOSales Tax CollectedServiceEtsy Shop Sales Tax ClearingEtsy Shop Sales Tax ClearingNontaxable
Etsy-QBOSales Tax  RemittedServiceEtsy Shop Sales Tax ClearingEtsy Shop Sales Tax ClearingNontaxable
Etsy-QBOListingServiceEtsy Shop Fees:ListingEtsy Shop Fees:ListingNontaxable
Etsy-QBOTransactionServiceEtsy Shop Fees:
Transaction
Etsy Shop Fees:
Transaction
Nontaxable
Etsy-QBOMarketingServiceEtsy Shop Fees:
Advertising
Etsy Shop Fees:
Advertising
Nontaxable
Etsy-QBOSubscriptionServiceEtsy Shop Fees: SubscriptionEtsy Shop Fees: SubscriptionNontaxable
Etsy-QBOGift WrapServiceEtsy Shop Sales:
Services
Etsy Shop Fees:
Transaction
Nontaxable
Etsy-QBODiscountServiceEtsy Shop Sales:
Discounts
Etsy Shop Sales:
Discounts
Nontaxable
Etsy-QBOProduct RefundsServiceEtsy Shop Sales: RefundsEtsy Shop Sales: RefundsNontaxable
Etsy-QBOOtherServiceEtsy Shop Fees:
Transaction
Etsy Shop Fees:
Transaction
Nontaxable

No, currently the app doesn’t import the product info from your Etsy listings and inventory. It uses the same name, “Etsy: Product Sales,” for all your products in these transactions.

No, currently the app doesn’t import customer and vendor info from your Etsy transactions. It uses these names for the customer and vendor fields in transactions:

TypeNameUsed in…
CustomerEtsy Inc.  (Sales/Refunds)Sales/Refund Receipts
VendorEtsy Inc. (Charges)Expenses

The app records sales tax that’s collected and remitted for an Etsy order as a line item on the sales receipt or refund receipt. The default account it uses is “Etsy Shop Sales Tax Clearing.”

To see details on how much sales tax Etsy collects and remits for your orders, see the Etsy Help Center article How State Sales Tax Applies to Etsy Orders.

You can change the Etsy shop QuickBooks is connected to by first disconnecting the currently connected shop:

  1. Sign in to the QuickBooks company connected to your Etsy shop.
  2. Go to Apps, then select My Apps.
  3. Select Disconnect.
  4. In the pop-up window, select Confirm Disconnect

You’re now ready to connect another Etsy shop. See “Step 2: Set up the Sync with Etsy app.”

Note: If the previous connection to your other Etsy shop added transactions that you don’t want in your QuickBooks, you’ll need to remove them manually. 

The Sync with Etsy app imports all sales, refunds, and fees from your Etsy payment account into QuickBooks Online and categorizes them. What you see in QuickBooks Online reports will differ from Etsy. Here are the key differences.

Etsy Monthly StatementQuickBooks Profit and Loss Report
Excludes refundsIncludes refunds
Includes merchant FeesMerchant fees reported as an expense
Etsy StatsQuickBooks Sales by Product/Service Summary Report
Includes revenue from sales of listingsIncludes revenue from sales of listings
Excludes refundsIncludes refunds
Excludes revenue from services (shipping, gift wrap etc.)Includes revenue from services (shipping, gift wrap etc.
Excludes discountsIncludes discounts
Excludes merchant feesIncludes merchant fees
Excludes sales tax collected/remittedIncludes sales tax collected/remitted
Etsy 1099-KQuickBooks Profit and Loss Report
Total dollar amount of total reportable payment transactionsBy default, Income from orders are categorized to these accounts:
Etsy Shop Sales:Product
Etsy Shop Sales:Services
Etsy Shop Sales:Discounts

Refunds are categorized to
Etsy Shop Sales:Refunds

Visit the Etsy Help Center for more details on how your Etsy payment account works and How Is the Total on My 1099-K Calculated?

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online LedgerQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this