Recording Stripe Transaction Fees

by Martina
(Canada)

How do you record Stripe fees and Canadian taxes?<br>Does Stripe have monthly bank statements / financial reporting?

How do you record Stripe fees and Canadian taxes?
Does Stripe have monthly bank statements / financial reporting?

I have been doing books for a friend who recently changed directions with her business, which is now an online training program. Her business is Canadian based, and her clients pay her in US dollars using Stripe (which charges an additional fee).


For her Canadian clients, I need to separate the stripe fees and Canadian taxes for her. Can you please advise how I would record all of this?

I am using QuickBooks and have set up the item charge to USD. For simplicity reasons, can we say the charge in USD to the client is $300 and the Stripe fee is $9.00 and we are only charging the 5% GST?



section divider



Hi Martina,

You need to have your client download three Excel files for each period you are reconciling (i.e. a month, a quarter, a year) - one for transactions, one for transfers and one for balances. If you don't have a lot of transactions, you could book it by each sale but that doesn't work if you have a lot of sales.

My preference is to book a summary sales invoice - one for Canadian sales so I can deal with the taxes and one for Foreign sales.

My understanding is that Stripe does not capture the sales tax information for you if you are using someone else's shopping cart. The sales AMOUNT information found in your transaction download file includes any sales tax collected. The way I've seen it, the tax information comes from the shopping cart data. Here's the general steps you may have to modify based on the information you have:

1. Record your sales summary invoice for the month. I used to do this with a sales receipt form but eventually switched to an invoice form in QuickBooks as sometimes there are some timing issues between the shopping cart and Stripe at the beginning or end of the month. As I said above, I do two invoices - one for Canadian sales and one for foreign sales. It is here where you calculate the appropriate sales tax from your shopping cart data.

2. Receive payment on the invoice. You'll find this information in the Stripe downloaded transaction file.

3. Deposit the funds in the QuickBooks Stripe bank accounts - I usually have two - one for CAD and one for USD.

4. Record a bank transfer from the Stripe transfer file for the amount of funds transferred out to your operating account. Again you can do this for each transfer but it can be tedious especially if the account is set to transfer funds daily. I usually do this as a lump sum figure for the month if a
bank feed isn't being used. If the bank feed is available, then I just accept the transfer sitting in the bank feed (i.e. Scotia, RBC, BMO, CIBC or ...) and it creates the entry you need in the Stripe "bank" account (i.e. DR Bank Account CR Stripe Account).

5. Record any refunds that occurred. You'll find this data in your Stripe transaction file. Depending on the dates of the refunds, you may need to record more than one transaction if any items are in transit at the end of the month.

6. When you reconcile the Stripe bank account, enter the MONTHLY TOTAL of Stripe fees taken after each sale in the service charge field of the reconciliation window. This will book your Stripe service charge fees in one lump sum amount.

7. Proceed with your reconciliation. This step is harder than it sounds and is MY PET PEEVE with the developer. Unlike PayPal which allows you to download monthly financial statements so you can easily reconcile your account, Stripe does NOT have monthly financial reports that I have found. (Update by Editor: see comments below on how to access the monthly statement which makes the rest of this post unnecessary.)

How ridiculous is that!!! It makes it difficult to determine your opening and closing balances each month to ensure you are correctly balanced. This is particularly important step ... especially if you accept payments for your products / services from other services like PayPal or Square. So here is what I do:

I create my own financial summary report in an Excel template that looks something like this ...

Opening Balance (you need to figure this out the first time after that just carry forward the closing balance) so for simplicity let's use zero dollars for this example.

Sales Activity found in your Stripe transactions download file increase the Stripe account so we'll use your example of $315 ($300 x 1.05 GST).

Refunds listed in your Stripe balance download file decrease the Stripe account so we'll use ($50) in this example.

Transfer to the bank from your Stripe transfers download file reduces the funds in the Stripe account. For this example we'll say ($200) has been transferred.

Stripe fees from your Stripe transactions download file also reduce the funds in the Stripe account. In this example we'll use your ($9) even though fees pertaining to any refunds would have been returned.

Closing Balance $56.

As I said this is just a general example. You will have to tweak the directions for your situation but I hope it puts you on there right track. Let me know if it helped and if I missed any steps.

Comments for Recording Stripe Transaction Fees

Click here to add your own comments

Mar 28, 2015
Stripe Monthly Statements
by: Lake

After writing this post, I decided to contact Stripe about why they don't have a monthly financial statement. Guess what? They do but it's hard to find ... and it downloads as an Excel file (not the best for a third party statement) ... from inception of your account! Does anyone see this as a problem the longer you have your account?

Did I mention it is hard to find? Here is the link to the instructions:

https://support.stripe.com/questions/monthly-statement

Apr 25, 2017
Stripe and QBO
by: Lake

If you use QBO ... and accept the Stripe transfers showing in the bank feed ... you will have to go in and edit each transfer if it is in USD. Here's what I do:

Add the bank transfer in the USD account. I usually have a bank rule setup for this but post manually from the bank feed. I usually add a note to the memo field for the USD amount.

Find the transaction in the bank account register or the Stripe USD register; click to edit.

Change the currency from CAD to USD. Change the dollar value to the USD amount. You can quickly see what it is by clicking on the bank match link at the top left hand side of the screen/form.

I find this much quicker with less data entry than keying it all in manually.

Click here to add your own comments

Return to Self-Employed Bookkeepers.

 
 

Back to top