Can't Import Stripe Transactions manually

Forum|Forum|4 years ago
April 12, 2022
1 reply
0 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?

QuickBooks Self-Employed

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

GeorgiaC

Level 13

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 🙂

Dev227Author

Thanks for the link, I'll check that out. Here's the image again. It opens for me when downloaded, not sure why it doesn't otherwise

GeorgiaC

Level 13

Thanks Dev227, I'm still only able to view the import screen on the screenshot without any specific error showing - is the file saved in CSV format on your computer?

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded