Fix Bank Transactions Not Downloading in Money in Excel
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.

- 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.
Ensure you have a stable internet connection and check that your bank has not recently required you to re-authenticate your account credentials.
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.
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.
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.
Once the update is complete, reopen your Money in Excel workbook and wait for the Money in Excel side pane to load completely.
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.

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. Download and Install: Visit the official WPS Office website to download the free suite. Run the installer and launch WPS Spreadsheet.
- 2. Open Your Financial Data: Click 'Open' and select your existing Excel budget files or recently downloaded CSV transaction statements from your bank.
- 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.

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.




