Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
D
Dev227
April 12, 2022
Solved

Can't Import Stripe Transactions manually

  • April 12, 2022
  • 1 reply
  • 10 views

I'm using QB Self Employed and I understand that it can't interface directly with my Stripe business account. So I'm trying to import the transactions manually, from the Stripe Reports panel - Balance Change from Activity. It's a csv file that I get but QB won't show the data or upload it. I just get the attached error. Can anyone help me?

Best answer by Dev227

Thanks Dev227 - as you're importing on a Mac, please open and re-save the file to check for the option to save this specifically as a Windows CSV. (rather than the default Mac UFT) as this is the only supported type. If you're still unable to import following this, try setting the amount field to display as 2 d.p. so that all values are the same 🙂 


Thanks. I"ve got it now. For anyone who has the same issue... Save as Windows CSV and remove the timestamp from the Date and Time column that Stripe automatically outputs. Thank you again

1 reply

G
GeorgiaC
Level 13
April 12, 2022

Hi Dev227, thanks for joining the Community - I'm unable to view the specific error on the screenshot below, are you able to select the file on the download folder? For tips on formatting the file for successful import, please click here 🙂

D
Dev227Author
April 19, 2022

Just to report that I'm still struggling with this issue of getting QB Self-Employed to import the Stripe transaction data downloads. Could it be that QB doesn't like the way Stripe adds time in the box for date? I attach a sample of the csv file I'm trying to upload

 

DateDescriptionAmount
03/04/21The British School of Bioenergetics - Order 14141319.52
04/04/21The British School of Bioenergetics - Order 14144124.65
05/04/21Invoice 09BC55BC-000248.35
D
Dev227AuthorAnswer
April 19, 2022

Thanks Dev227 - as you're importing on a Mac, please open and re-save the file to check for the option to save this specifically as a Windows CSV. (rather than the default Mac UFT) as this is the only supported type. If you're still unable to import following this, try setting the amount field to display as 2 d.p. so that all values are the same 🙂 


Thanks. I"ve got it now. For anyone who has the same issue... Save as Windows CSV and remove the timestamp from the Date and Time column that Stripe automatically outputs. Thank you again

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement