Skip to main content
shorelinestays
shorelinestays
December 20, 2021
Solved

Cannot download older transactions from Santander. The CSV file is also not recognised by QB

  • December 20, 2021
  • 2 replies
  • 0 views

Am having problems downloading older transactions from my bank Santander.

The CSV file will only go back 12 months and it is not recognised by Quick Books. Please help! I really want to download the last few years of my transactions.

Best answer by shorelinestays

Think i have resolved this!

 

So downloaded as XLS from bank

then opened in Google Sheets

then saved as CSV and sent to QB - it works 12 months worth of transactions at a time

2 replies

shorelinestays
shorelinestaysAuthorAnswer
December 20, 2021

Think i have resolved this!

 

So downloaded as XLS from bank

then opened in Google Sheets

then saved as CSV and sent to QB - it works 12 months worth of transactions at a time

J
JanePendry
July 23, 2023

Sadly this worked in the past, but it doesn't work now. My system just won't convert the xls to cvs and I have tried 10 times. I have 11 months worth of data in my quickbooks but can't get the last month in. I put it in twice but messed up the debit and credit labels and couldn't just delete the whole month, I had to exlude each item. I did this twice. I set the task just to finish the imports with one month import, and its been 4 hours and I feel exhuasted. I think I might have to go back to spreadsheets. This is not making my life easier. I am quite desparate. Any other ideas? I would be do grateful. 

JessT
JessT
July 23, 2023

Hi Jane,

 

Thank you for joining the conversation. I'll share a way so you can create a CSV file.


If you haven't tried yet, you can create a copy of any of the old CSV file and copy the data from the 11th month file paste on it. Then, use that to upload the transactions to QuickBooks Self-Employed so you can review and categorize them.

 

If the above instructions do not work, it's better to call our QBSE Support team to check and root cause of the issue. They can use a tool for screen-sharing to gather more details.

 

Please don't hesitate to go back to this thread if you have more questions in mind.

K
Kyle N
December 17, 2023

Did this get resolved? I've just subscribed and didnt' realise I wouldnt' be able to pull up last tax years bank statements. Like Jane I'm wondering if I will have to go back to a spreadsheet 😞 I was  not looking foward to that

J
JanePendry
December 17, 2023

Yes Kyle. I did it. I duscivetsd you have to log out and log in again for each csv file. I stripped out all extraneous infurnayiin and labelled the y in and money out volume debit and credit (the opposite for credit cards) and any empty columns. I found the bank version if a csv file didn’t work. I pulled of xls files first. Saved them and then exported them to create csv files. 

Then I imported them one at a time. 

I suggest importing your file. Then checking going through them to mark them up. Have cup of tea and log out then back in for the next one. People here were really helpful but I had to really work at it. It may be our bank or our suggested but I think the instructions on importing historical spreadsheets could be clearer. A non book keeper’s guide.


My bank is Santander so I do t know why their csv file didn’t work and it would be helpful to know why you have to log out and in again for each import. That might be something Intuit can fix or it might be a security thing. I spent hours working this out so let me know if that works. 

Good luck. 

 

J
JanePendry
December 17, 2023

Sorry. I discovered it should be… I’m writing this having seen your note in the night. I was so frustrated by this issue and nearly gave up on QuickBooks. I understand how frustrating this is. 

Terms & ConditionsAccessibility statement