Showing results for 
Search instead for 
Did you mean: 
Visit this post for a list of recent banking issues in QuickBooks Online.
Level 1

Santander - missing transactions

Santander users - I’m missing 2 months of transactions in Quickbooks. I have the instructions how to do it but with Santander you can only download as XLS, QIF, PDF or TXT.
Tried TXT but doesn’t work as it gives me message; ‘your file does not contain the three required columns…’ Well txt files don’t have tables in them? Any ideas how to download the statements to quick? Thank you

QuickBooks Team

Santander - missing transactions

Good day, MattB. 


Let me help you by making sure you'll be able to download statements to QuickBooks Online.


This error occurs when the mapping of your CSV file is incorrect. Make sure to use a supported file type and format to successfully bring your bank statements into QuickBooks Online (QBO).


QuickBooks Online supports 2 CSV formats (3/4 columns) when manually uploading bank transactions. The former has the Date, Description, and Amount. While the latter contains the following information: Date, Description, Credit, and Debit column.

3 column format



4 column format


Here are some of our helpful articles you can read more about uploading bank transactions to QuickBooks:


• Format CSV files in Excel to get bank transactions into QuickBooks

• Manually upload transactions into QuickBooks Online


Lastly, I've also included this helpful article that'll guide you in categorizing your bank transactions: Download, Match, and Categorize your Bank Transactions in QuickBooks Online.


Feel free to reach back to us if you have further questions about downloading bank data QBO. I’d be happy to answer it for you.

Level 1

Santander - missing transactions

Hi LeizyIM,

Thanks for yo reply. All is good when your bank let you select CSV file, the only option is XLS but I use Apple and cannot see XLS file. 
any advise for Mac users?



Santander - missing transactions

I'll share some tips on you can import your transactions, MattB.


Currently, the supported file types for importing bank transactions are QBO and CSV files only. They are formatted specifically for QuickBooks Online.


Since Santander Bank doesn't support these options, you may need to use a third-party application to convert the XLS file. There are plenty of converter tools that you can search online. You can also visit our to go to the Apps menu within your QuickBooks company to find one. Here's how:


  1. Sign in to QuickBooks Online.
  2. Select Apps from the sidebar menu.
  3. Head to the Find Apps tab.
  4. Enter a keyword in the search bar or click Browse category to filter the results.

Once you're ready, follow the steps in these articles to be guided in importing and reviewing the transactions:


Lastly, I also recommend checking our Reconciliation Workflow to learn how to keep your accounts balanced and up-to-date.


Keep me posted if you need more help in managing your bank transactions. I'll be more than happy to assist you again.

Need to get in touch?

Contact us