Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

How to Integrate Stripe with QuickBooks using PayTraQer?

PayTraQer - Stripe and QuickBooks Integration


TABLE OF CONTENTS



Introduction


Integrating Stripe and QuickBooks is very simple and is just a few clicks away with PayTraQer. SaasAnt PayTraQer - #1 user rated and Intuit trusted automation tool built exclusively for QuickBooks to synchronize Stripe data with QuickBooks Online. PayTraQer synchronizes Stripe Customers, Sales, Payouts, Fees, Taxes, etc.. with your QuickBooks Online, keeping your books accurate and precise without the hassles of manual data entry.



Steps for Integrating Stripe and QuickBooks


Connect your QuickBooks company with PayTraQer as mentioned in this article.


Once your QuickBooks account is connected, you will be navigated to the Payment Systems menu screen, where you can select the Stripe tile and click the Connect button. Once clicked, a new window opens up redirecting to the Stripe screen for granting permission. 


stripe quickbooks integration


The connection to your Stripe account is private and secure. PayTraQer requests just for a READ only connection to your Stripe account and can be disconnected anytime through the settings screen.


quickbooks stripe


Click the "Connect my Stripe Account" button, this will authorize the connection and redirect you back to the PayTraQer screen.


You will then have to configure some simple settings for this Stripe account so that your sync is accurate. 


Sales Preferences


Stripe Sales account configuration in PayTraQer:


This setting will govern how your sales transactions will be recorded in your QuickBooks. Default values provided will automatically be created for you in your QuickBooks and is recommended for accurate bookkeeping.


For more information about each field in the settings, refer to this article.


Stripe Sales configuration paytraqer


Product Settings


Stripe Product configuration in PayTraQer:


This configuration will determine how Products/ Services are synced. If "Create Product/Services automatically" turned ON, then missing items in your QuickBooks will be auto-created during sync.


For more information about each field in the settings, refer to this article.


Stripe product configuration paytraqer


Tax Settings


Stripe Tax configuration in PayTraQer:


Enabling this setting will record sync with tax calculation. Otherwise, the tax amount will be added to the transaction amount and recorded without tax.


For more information about each field in the settings, refer to this article.


Stripe tax configuration paytraqer


Fee Settings


Stripe Fees configuration in PayTraQer:


This setting will govern how the Stripe fee details get recorded in your QuickBooks. You can configure the default vendor, expense category, and expense bank account for creating the expense transaction corresponding to the Stripe fees component.


For more information about each field in the settings, refer to this article.


Stripe fees configuration paytraqer


Expense Settings


Stripe Expense configuration in PayTraQer:


Set the default vendor, expense category, and expense bank account for creating the expense transaction corresponding to the Stripe expense transactions.


For more information about each field in the settings, refer to this article.


Stripe expenses configuration paytraqer


Payout Settings


Stripe Payout configuration in PayTraQer:


Enable the "Process the Payout" with "Transfer To" account, so that all your Stripe Payouts gets processes as Transfer transaction in your QuickBooks and will be very handy during reconciliation.


For more information about each field in the settings, refer to this article.


Stripe payout configuration paytraqer


This is just a quick start setting and the complete set of settings is available under the Sync Settings menu. More on this is available in this article.


stripe and quickbooks integration


Recording Historical Transactions from Stripe:


Once the above configurations are completed, you are all set up and PayTraQer will automatically pull your last 30 days transactions from your Stripe account.


record stripe transactions in quickbooks


Related articles - Stripe QuickBooks Integration

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.