Skip to main content
MattB
October 30, 2022
Question

Santander - missing transactions

  • October 30, 2022
  • 1 reply
  • 0 views

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

1 reply

L
LeizylM
October 30, 2022

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.

MattBAuthor
October 30, 2022

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?

thanks

KlentB
KlentB
October 31, 2022

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.

Terms & ConditionsAccessibility statement