Stripe and QuickBooks Integration

Stripe and QuickBooks Integration

Handling QuickBooks to manage your business accounts is crucial. But if your business involves sending and receiving payments online using Stripe then make sure you have Stripe and QuickBooks integration done. This is because otherwise, you will end up importing and exporting from one app to the other app.

What is Stripe?

Stripe provides payment functionalities to website owners to accept or transfer online payments. It is one of the most popular payment gateway available today after PayPal. A Stripe account is similar to a bank account. You are allowed to create multiple Stripe accounts for your products. Every single account you have created will have:

  • With his unique payment process in place,
  • Dashboard, and
  • Will have his own set of approved users.

Every stripe account created will have its currency. The best part is whenever you use other currencies to make payments then Stripe will convert the currency automatically for you. You are also allowed to make or receive payments from and to your bank.

Stripe Payment

Stripe payments are authorized to get paid with all major cards from customers across the globe on the web or in mobile applications. It allows you to configure payment forms with:

  • Stripe Checkout helps you with the fastest setup,
  • Stripe Elements for a more personalized design
  • Stripe’s API for a completely custom implementation
  • Stripe takes a fee for each payment.

Integrate Stripe with QuickBooks (Desktop and Online)

Your stripe account can be easily integrated with your QB account. You just need to follow the steps given below to get your account synced with ease.

Step 1: Export Stripe Account Activity to QuickBooks

  • First, download or export your Stripe account data to your desktop QuickBooks.
  • Before exporting the file, you would need to format your CSV file with:
    • Refunds,
    • Fees, and
    • Payouts that are available on your QB desktop account that is compatible with .IIF file.
    • You can perform a download for this within the data settings in the Dashboard.
    • If face an issue IIF import error in QuickBooks click here to fix it.

Step 2: QuickBooks User Accounts

The exported IIF file generates nine accounts in QuickBooks. All of the Stripe-created accounts are introduced by Stripe to make them easy to identify. The nine accounts are:

  • Stripe account,
  • Stripe Checking account,
  • Stripe payment processing fees,
  • Stripe returns,
  • Stripe sales,
  • Stripes third-party account,
  • Stripe fees,
  • stripe processing fees Adjust
  • Stripe other income.

Step 3: Date Format

The format of the IIF file is MM/DD/YYYY. QB account uses the same format for the dates as is displayed within your operating system. In case the format alters from the exported file, you can change your operating system’s date format for a temporary period by following the below steps:

  • Configure the date format in your operating system to MM/DD/YYYY.
  • Now import the QuickBooks IIF file.
  • Revert your operating system’s date format to your wish.

Step 4: Integrating QuickBooks Accounts

For you to have your Stripe and QuickBooks integration done you would need to choose one of the 9 accounts created and merge that with QuickBooks. In case you may want to merge the Stripe Checking Account that symbolizes the bank that receives your Stripe payouts, then below are the steps, of how you can do that.

  • Choose Lists, then choose the COA tab to view all of your accounts.
  • Make sure that both accounts are merged on the same level.
  • Choose the account that you are not going to use.
  • Click on the Accounts tab and click on the edit button of the Chart of Accounts window at the bottom.
  • After the name of this account matches the name of the other account.
  • Click on Save.
  • Then you will get a prompt about integrating the Stripe account with an existing
  • QuickBooks account. Click yes to proceed.
  • Your accounts will now be merged successfully.

Try and do the verification test to make sure that whatever info is being processed in your Stripe account is being imported into QuickBooks automatically. If you can get the details synced automatically when you have integrated the 2 software successfully. But if in case you are facing issues then get help. You can even give us a call at our QuickBooks support helpline number and talk to our Experts now.