Data Import & Export

Fix Bank Transactions Not Downloading in Money in Excel

Steve KSteve K Nov 3, 2026 869 views

Question details

The user has successfully connected a bank account to Money in Excel and can view their account balance, but individual bank transactions and other account details fail to download into the spreadsheet.

How to Fix Bank Transactions Not Downloading in Money in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to sync linked bank account data (such as Bank of America) into a Money in Excel workbook to track financial transactions and expenses.
Observed behavior
The overall bank account balance is displayed and updated correctly, but the actual individual transactions and specific account fields do not download or populate.
Before you start

Ensure you have a stable internet connection and check that your bank has not recently required you to re-authenticate your account credentials.

Solution 1Recommended

Update Microsoft Excel and Manually Sync Transactions

Updating Excel to the latest version ensures the Money in Excel add-in functions correctly, allowing you to manually trigger a successful sync of your bank transactions.

Money in Excel relies on secure, real-time connections with financial institutions. If your Microsoft 365 installation is out of date, the add-in may fail to securely pull transaction data even if it successfully pulls the overall balance.

1
Open Excel Account Settings

Launch Microsoft Excel. Click on the 'File' menu in the top-left corner of the window, and then select 'Account' from the left-hand navigation pane.

2
Update Microsoft 365

Look for the 'Product Information' section. Click on 'Update Options' and select 'Update Now' from the drop-down menu to install the latest version of Excel.

3
Open Money in Excel

Once the update is complete, reopen your Money in Excel workbook and wait for the Money in Excel side pane to load completely.

4
Manually Update Transactions

Look at the top of the Money in Excel pane. If new transactions are available, a notification bar will appear. Click the 'Update' button to manually load and sync your latest bank transactions into the spreadsheet.

Update Microsoft Excel and Manually Sync Transactions
Transaction Sync Delays: Account balances update automatically, but individual transaction processing can take up to one full day depending on the processing times of your specific financial institution.
Free Microsoft Office alternative

Manage Your Finances Easily with WPS Spreadsheet

If you are experiencing ongoing connection issues with Microsoft add-ins or simply want a more reliable way to manage your finances, WPS Office offers a completely free, lightweight, and highly compatible alternative. You can easily import your CSV bank statements and use powerful built-in financial templates to track your budget without relying on complex, glitchy add-ins.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite. Run the installer and launch WPS Spreadsheet.
  2. 2. Open Your Financial Data: Click 'Open' and select your existing Excel budget files or recently downloaded CSV transaction statements from your bank.
  3. 3. Use Built-in Templates: Alternatively, click on 'New' and search for 'budget' or 'finance' to instantly apply a free tracker template to manage your transactions manually.
100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv), ensuring your downloaded bank statements open perfectly.Completely free to download and use, with a highly familiar user interface that requires zero learning curve.Lightweight software architecture ensures fast loading and smooth scrolling even when analyzing thousands of bank transactions.Includes access to a massive library of free, professionally designed financial tracking and budgeting templates.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my balance update but my transactions do not in Money in Excel?

Banks often clear overall balances faster than individual line-item transactions. It can take up to 24 hours for a cleared transaction from your bank to be securely synced and formatted for the Money in Excel add-in.

Does Money in Excel automatically refresh my transaction data?

No, while account balances update automatically in the background, you must actively open the Money in Excel pane and click the 'Update' button when the notification bar appears to pull in new individual transactions.

What should I do if the Update button is missing in the Money in Excel pane?

If the Update button is not visible, try signing out of the Money in Excel add-in and signing back in. Also, verify that your Microsoft 365 subscription is active and that your Excel application is fully updated to the latest version.