Fix Money in Excel Not Downloading Older Bank Transactions
Question details
The user is trying to retrieve a full year of bank transactions using Money in Excel, but the system only downloads recent data, prompting a need to understand the historical synchronization limits.

- Product
- Microsoft Excel (Money in Excel)
- Device & OS
- not provided
- Scenario
- Importing historical bank transaction data spanning back a full year for financial tracking.
- Observed behavior
- The Money in Excel add-in only retrieves bank transactions dating back to December 2021, failing to sync older historical data.
Ensure that your financial accounts are actively connected to the Money in Excel pane and that you have clicked the Update button to fetch the latest available data.
Understand the Transaction Sync Limitation
Money in Excel has a strict historical data limit and cannot automatically download transactions older than 90 days from the initial connection date.
Money in Excel does not support fetching unlimited historical data. By design, the service only retrieves transactions from 30 to 90 days before the exact date you first connected your financial institution to the spreadsheet.
Because of this limitation, if you need older transactions (such as a full year's worth of data), you cannot rely on the automatic sync feature and will need to explore alternative manual import methods.
Open the Money in Excel pane. Keep in mind the date you first linked the specific bank account, as the system will only pull data 30 to 90 days prior to this date.
For transactions occurring after your initial connection date, simply click the 'Update' button in the sync bar located within the Money in Excel pane.
If you are dissatisfied with this limitation, you can send suggestions directly to the development team by using the Feedback option within the Money in Excel pane.

Manage Your Finances Efficiently with WPS Office
Microsoft has officially discontinued the Money in Excel feature. If you need a reliable, fast, and feature-rich spreadsheet application to manage your exported bank CSV files without ongoing subscription fees, consider switching to WPS Office. It provides robust data analysis tools to track your full financial history.
- 1. Download Your Bank Statement: Log in to your online banking portal and export your yearly historical transactions as a CSV or Excel file.
- 2. Open in WPS Spreadsheets: Launch WPS Office, click on Spreadsheets, and open the downloaded bank statement file.
- 3. Analyze Your Data: Use WPS Spreadsheets' built-in formatting tools, PivotTables, and charts to effortlessly track and categorize your financial data.

Frequently Asked Questions
Can I force Money in Excel to download transactions older than 90 days?
No, Money in Excel is strictly limited to retrieving 30 to 90 days of historical data from the date you first connected the financial institution. You must manually download a CSV from your bank to view older data.
How do I update my ongoing bank transactions in Excel?
Once your account is initially connected, you can retrieve new transactions by clicking the 'Update' button located in the sync bar of the Money in Excel pane.
Why did Money in Excel stop syncing my bank data entirely?
If your data stops syncing, your bank account connection may have expired or may require re-authentication. Open the Money in Excel pane to check for any connection errors and re-enter your bank credentials if prompted.
Is Money in Excel still supported by Microsoft?
Microsoft announced the deprecation of Money in Excel, and the service was officially discontinued on June 30, 2023. Users are encouraged to manually export bank data or use alternative spreadsheet software and personal finance apps.




