Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 8, 2020
Question

STRIPE

  • September 8, 2020
  • 1 reply
  • 2 views

I just noticed  that all of my client's Stripe transfers are posting to Uncategorized Assets and then transferring to the checking account register. As transfers I cannot assign them to the category of Sales of Services.  I took this client on in April 2020 and downloaded everything from the bank account for the year. The checking account has been reconciled every month and now I have no idea what to do to clear this up.

1 reply

JasroV
Level 8
September 8, 2020

Hope you’re having a great day, @kevynq.

 

Allow me to share some insights on how online banking works with QuickBooks Online (QBO). Once you’ve connected your bank, QBO automatically downloads the recent 90 days of transactions. It also depends on the information sent from your bank.

 

To get around this, you’ll want to exclude the transactions and manually import them into your QBO account. This way, we can ensure to use the correct format in uploading the file then categorize it after importing. Let me show you how.

 

  1. Go to the Banking or Transactions menu and select the Banking tab.
  2. Select your Stripe bank account.
  3. From the For review tab, put a check-mark inside the box beside the DATE column to select the transactions by batch.
  4. Click Exclude to delete.
  5. Then, download the transactions from the bank and manually add them in QBO. Ensure to download file format and the transactions that haven’t been reconciled to avoid duplication.
  6. Once added in the For review tab, select the transaction and categorize it. 

For more details about uploading and categorizing your bank transactions, you can refer to these articles below:

Let me also add this article that you can utilize in when you’re ready to reconcile the account: Reconcile an account in QuickBooks Online.

 

You can always get back to me if you have other follow-up questions about your banking feeds or managing your QBO account. I’m just a few clicks away from you. Keep safe and stay healthy!
 

kevynqAuthor
September 9, 2020

So I did not set Stripe up as a bank account. I was expecting the money to come into the checking account as a deposit and download to QBO as  a deposit. Is this a fatal error on my part? And how would I fix it back to the first of the year on the months that have been reconciled? Somehow this is just not making logical sense in my mind. I have attached a screen shot of a Stripe transaction. Thank you for your patience!

September 14, 2022

Did you ever figure this out?
I have the same issue... thanks!