Syncing Stripe with QuickBooks

Pool Service Software — https://poolofficemanager.com/

Pool Office Manager and Stripe Guides:

1. Billing Overview

2. Connecting Stripe and Pool Office Manager

3. Creating and Sending Invoices

4. Capturing and Collecting Payments

5. Viewing Accounts Receivable in Stripe

6. Syncing Stripe with QuickBooks

7. Refunding a charge with Stripe

_______________________________________________________________

All Transactions from Stripe can be imported quickly into QuickBooks.

Notice: Importing does NOT create customer invoices in QuickBooks. Please view this guide, in addition to documentation from Stripe, for details on how Stripe will post to QuickBooks: https://stripe.com/docs/reporting/quickbooks

QuickBooks Online -

users can automate the transfer for QuickBooks Online using this tool https://cloudbusinessllc.com/business-payments/

  1. Starting in QuickBooks Online, in the App tab, search for Stripe and Paypal sync — Business Payments
Image for post
Image for post

2. Install the app, Connect

3. Connect Stripe and proceed to sign-in to your stripe account

4. Select the Bank account in QuickBooks that stripe auto-deposits your funds into

5. Select any settings on how you would like the items posted

6. We track Sales tax in Pool Office Manager, so leave ‘Apply Taxes’ to Off

7. Process payments to Yes, if No the app won’t synchronize payouts

8. Import any existing transactions, to sync your QuickBooks to current, select Sync All

QuickBooks Desktop Users

  1. From your Stripe.com dashboard, select Settings then Data
Image for post
Image for post

2. Export to QuickBooks.

Image for post
Image for post

3. Choose the date range you wish to export, then select Export to IIF.

Image for post
Image for post

4. Now is the time to backup your QuickBooks. Please make a backup prior to importing. It helps to include a date on backups for future reference.

5. In QuickBooks Desktop, choose File> Utilities > Import > IIF Files

Browse for the file you exported from Stripe and continue.

Image for post
Image for post

You will receive a success message informing you the data has been imported.

6. Viewing your imported data, without changing the system defaults, will look like it does below.

Stripe Sales will be an income category. The customer emails will display the total invoice amount by customer. Details such as exact items sold will not be visible in QuickBooks.

Image for post
Image for post

Fees will be itemized and visible for each transaction.

Image for post
Image for post

Try starting with 1 or 2 transactions to see how Stripe and QuickBooks interact.

Stripe by defauly deposits the funds into your Stripe checking Account. When verifying the deposits have been made in your company account, you can modify those deposits to be made into your actually company account versus the stripe checking account

Original — When viewing the Stripe Checking Account, this shows the net deposits into your bank account.

By opening the transaction, you can select the correct account the funds were deposited into:

Image for post
Image for post

The below table explains all of the Stripe accounts that are used:

Image for post
Image for post

For more details: https://stripe.com/docs/reporting/quickbooks

Recording Manual Payments

If you have manually changed an invoice status to Paid these transactions will not be included in the above transfer to your QuickBooks, and will need to be manually recorded.

To view the invoices manually marked as Paid, navigate to:

Settings > Edit Company > Billing Info

Run a report for the desired date range and Export

Image for post
Image for post

In the report, in the InvoiceStatus column, you can view which invoices were manually paid:

Image for post
Image for post

You can sort or filter to isolate the manual payments, then in the account where you deposited the money, you can record the transaction with the Account name as the customer name/email, and the amount

Image for post
Image for post

Sales Tax

Sales tax reports can be viewed through Settings > Edit Company > Billing Info

Select the dates and view the report:

Image for post
Image for post

For an itemized report, select the Export button

To record in QuickBooks, you will need to deduct the sales tax from your Sales account.

For example, if on a cash basis, our taxable receipts total $2.70. We would record the sales tax in QuickBooks, paid from the account used.

Image for post
Image for post

Written by

Business Management Software for Pool Services Companies

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store