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.

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

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:

• Manually upload transactions
• Categorize and match online bank 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.