Overview:

  1. General settings

  2. Sales

  3. Products/Services

  4. Taxes

  5. Fees

  6. Application Fees

  7. Payouts

  8. Multicurrency

Having connected your company and your accounts, you can start customizing your settings for Stripe QuickBooks integration. You can always find them by selecting the organization needed at the top right of the page – – > Settings button on the left menu of the app – – > find payment platform (if you have several connected) you want to customize settings for – – > click on the Configure button:

1. General settings

  1. Synchronize Automatically – when “ON”, the system will automatically synchronize transactions that come into the app after the setting has been enabled. When “OFF”, you can manually choose transactions to be synced.                                                                           
    Learn more about auto-sync Synder mode.
  2. Skip synchronization for duplicated transactions – when “ON”, transactions that already exist in your QuickBooks Online company will not be synced again.
  3. Apply payments to unpaid Invoice/Bill transactions – when “ON”, once the system encounters a payment that matches an unpaid invoice, it will be automatically applied to it.
  4. Skip synchronization for transactions in a foreign currency – when “ON”, the system will synchronize transactions in your home currency only. Synchronization of transactions in other currencies will be skipped.
  5. Apply location – when “ON” you can select a location from the ones you have in your QuickBooks Online to sync your transactions with the location selected in the drop-down menu.
Connect Stripe with QuickBooks Online: General settings

2. Sales

Check out the Synder setup guide with our recommended way of a setup.

  1. Bank account – a buffer account that QuickBooks sales receipts, refund receipts and payments will be deposited into. In case you do not have an account with “Stripe” in its name, it will be auto-created in your Chart of Accounts.
  2. Enable QuickBooks Doc Numbers – by enabling this configuration your transactions will follow the standard QuickBooks Doc Number sequence.
  3. Apply default customer – when “ON”, it assigns a default customer name to all of your transactions. Click on to select a name. Choose from existing ones or type in a custom name.
  4. Payment Method – choose a payment method (cash, check, credit card, or Stripe) that will be set for QuickBooks sales receipts, refund receipts, payments, and expenses.
  5. Customer Name search Priority – drag and drop to the top of the list the field where the name of the customer should be taken from. If the name will not be in the field specified on the top of the list, then the app will look at the second specified field and so on. Check out our helpful guide to learn more about Customer Name search priority.
Connect Stripe with QuickBooks Online: Sales settings

3. Products and Services tab

This setting tab is targeted at new products and services which are created during the synchronization. Product/service type can only be non-inventory or service, because when Synder creates a new product, it does not have an access to its Quantity on hand. Existing inventory products will be properly updated.

The income account specified here will be used for creating new products and services only.

Use “Create additional settings” option only in case you would like to categorize different types of transactions. We recommend to use the same Bank account for Sales and Fees.

  1. Generic product – when “ON”, it assigns a generic product name to all of your transactions instead of sending over each product on sales transaction individually.
  2. Product/Service type – choose between Non-inventory or Service. This will be used for creating products and services which do not exist in your accounting company.
  3. Get product name from a description in the Stripe charge – when “ON”, the app will be searching for a product name in the description of a Stripe charge.
  4. Product mapping – Synder is able to identify existing products in your accounting company and apply them to transactions. If product names in your payment system and accounting company don’t match 100%, fill in the product names from your payment platform in the right field to map it to product names from your QuickBooks in the left field. Check out an additional guide about product mapping feature.
  5. Default Product – choose or type in a name to be used if there is no product name to be found in your transaction.
  6. Product Income account – choose an account that will be used for creating new products and services which do not exist in your accounting company during the synchronization.
Integrate Stripe with QuickBooks Online: Products and Services settings

4. Taxes tab settings

  1. Apply taxes – when “ON”, the system will search for a matching tax code. In case the system cannot find it, a tax amount will be included in the total sum.
  2. Sales Tax settings. Default tax code – choose a tax code name the app will use for all Sales transactions marked as “taxable” in your payment system without changing the tax amount in these transactions.
  3. Sales tax settings. Zero-rated tax code – choose a zero-rated tax code the app will apply to every item (line)/shipping line which doesn’t contain any other tax rate in the original transaction.
  4. Sales tax settings. Apply generic tax code – when “ON”, the app will apply the tax rate you specify in the settings to both taxable and non-taxable Sales transaction you sync with the app.
  5. Expense tax settings. Apply generic tax code – when “ON”, the app will apply the tax rate you specify in the settings to both taxable and non-taxable Sales transaction you sync with the app.

*This screen will be slightly different for US and Non-US companies. Check out how sales tax work in Synder.

5. Fees tab settings

  1. Bank account – this setting specifies the bank to which the Stripe fees are applied. We recommend using the same account as in the Sales – Bank account. 
  2. Vendor – the app will use this QuickBooks Vendor to store your Stripe fees. Select available, or type in a custom one.
  3. Category – this setting specifies the category to which the Stripe fees are applied.
Sync Stripe with QuickBooks Online: Fees settings

6. Application fees tab settings

  1. Bank account – this setting specifies the bank to which the application fees are applied. We recommend using the same account as in the Sales – Bank account.
  2. Generic Vendor – the app will use QuickBooks Vendor you select to store your application fees. Select available, or type in a custom one.
  3. Category – this setting specifies the category to which the application fees are applied.
  4. Default Vendor name – сhoose or type in a default name to be used if there is no vendor name to be found in your transaction.

7. Payouts tab settings

This tab allows you to track Payouts that Stripe deposits to your checking account. The app will record them in QuickBooks, allowing for a simple matching of your actual deposits from Stripe to payments that you have received in Stripe and synced using the app.

It is matched under For Review tab in the QuickBooks Banking tab.

  1. Process payouts – when “ON”, the app will track and create deposit receipts reflecting Stripe payouts to your checking account.
  2. Transfer Funds To – Choose the checking account that you deposit the funds from Stripe to.

8. Multi currency

You can find how to customize Multiple Currencies here in the Multicurrency tab. Follow the link to find how to enable multicurrency in QuickBooks.

Stripe QuickBooks Integration

Do you have any questions? We would love to hear from you. Send an email to the address specified in the footer of this page.


Was this article helpful?
YesNo

Leave a Reply

Your email address will not be published. Required fields are marked *