Adding a Stripe Deposit

We use the program Stripe to process online purchases. Stripe also allows us to receive online card payments. A Stripe Deposit is how we make bank deposits for all the purchases that have been made. We will do this each day. Each stripe deposit is done for the current day's purchases. Below is a list of the steps for completing a stripe deposit.

Steps in Stripe

1. On Stripe, go to the "Balances" tab.

2. On the left, choose the third option that says "Payouts"

3. Choose the current date’s payout or the First green Paid option. Payouts that say "In transit" are not ready to be deposited. 

4. Scroll down about halfway and hit Export on the far right.

5. Save the file to the desktop and open it

Steps in Excel

1. Once you have the document opened in Excel, highlight and delete the following:

• Columns A (type), B (ID), and C (Created).
• Columns B (Amount) and C (Currency) 
• Columns E (Converted Currency), F (Details), G (Customer ID), and H (Customer Email) 

2. After deleting the previous columns, you should be left with only four columns at this point. If done right, the remaining columns should shift into columns A-D Follow the following steps to sort the remaining columns.

• Highlight columns A-D 
• Click "Sort & Filter" and choose "Custom Sort"
• Sort by Description
• Click "+ Add level"
• Then by "Converted Amount" and hit "OK"

3.  Separate the Hard Hat orders from the rest of the orders. (You will need them later) 

4. Under columns B (Converted Amount), C (Fees), and D (Net):

• Click "Autosum" and press enter on your keyboard
• Make sure the decimal place shows up to the hundredth place. (2 numbers after the decimal) 

Note: Stripe charges a processing fee (OL Fee) for every training product and order purchased from our website. Most of the fees in column C are from Stripe. However, customers can also purchase courses directly through Talent's E-commerce tool as well. You will notice that these marketplace fees from Talent are much higher.

Steps in QuickBooks

1. In QuickBooks under "Customer" search “Stripe”

2. Choose “Online Individual Stripe"

3. Select “New Transaction” 

4. Select “Invoice”

5. Enter all of the courses with their associating prices and quantities. 

• Include refunded Hard Hat orders (orders with a negative total, enter negative into QuickBooks)

6. Add in the “OL Fee” and ensure the total matches the “Net” 

• QuickBooks doesn't differentiate between OSHA, Canada, or Spanish courses. You must manually alter the price if the conversation rate from USD to CAD changes our normal pricing. Competent person courses also do not cost more than our regular courses.

7. Hit “Save and Close”

8. Select “Receive Payment”

9. Copy the payout total and paste it to “Memo”

10. Set the payment method to “Stripe”

11. Save and Close

12. In QuickBooks, select “New” and “Bank deposit”

13. Check the box on the left of the “Online Individual” Stripe

14. Check the box on the left of the Hard Hat orders

15. The total at the bottom should match the “Payout” total in Stripe

16. End by selecting “Save and Close”

If you have any questions, don't suffer in silence! Ask those around you for help.