Skip to main content
U
userduncanbinetfauve
January 5, 2021
Question

When I import a csv file containing transactions saved from my bank statement, quickbooks only displays income, not expenditure. Why is this and how can I resolve it?

  • January 5, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

G
GeorgiaC
January 5, 2021

Hi userduncanbinetfauve,

 

Thanks for joining us here on the Community. 

 

On the CSV that you're importing, are the amounts displayed in two separate columns for money in and money out? 

 

We've got a guide linked here which covers the formatting of the file and the steps to upload this which may be of use. 👩‍💻

 

 

U
userduncanbinetfauveAuthor
January 7, 2021

Hi

Indeed they are displayed in two separate columns

I have followed the guide but encountered the same issue - only 100 transactions downloaded and no expenses included

 

Santander only allow you to download a CSV file for 2020, I need the file for 2019-20. I therefore have to download the file in .XLS format and manually convert to CSV - when I do so, some of the formatting is lost

Is there a quickbooks specific conversion software that would be more appropriate?

Rubielyn_J
Rubielyn_J
January 7, 2021

Thanks for getting back in here, @userduncanbinetfauve.

 

Currently, there isn't a specific conversion software that is appropriate for this matter. 

 

If you want to add transactions that are older than the ones QuickBooks originally downloaded, it’s a two-step process. You need to export the transactions from your bank and then import them into QuickBooks using your laptop or desktop. Please refer to this article for the detailed steps: Add older transactions to QuickBooks Self-Employed.

 

For additional information, feel free to check out this article: Manually import transactions into QuickBooks Self-Employed.

 

Post again here if you need more help. Have a great day and stay safe.

Terms & ConditionsAccessibility statement