Data Import & Export

Fix Money in Excel Not Downloading Older Bank Transactions

Natalie TaylorNatalie Taylor Nov 2, 2026 868 views

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.

How to Fix Money in Excel Not Downloading Older Bank Transactions
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.
Before you start

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.

Solution 1Recommended

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.

1
Verify your initial connection date

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.

2
Sync ongoing transactions

For transactions occurring after your initial connection date, simply click the 'Update' button in the sync bar located within the Money in Excel pane.

3
Submit feedback to Microsoft

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.

Understand the Transaction Sync Limitation
Manual Import Required for Older Data: To analyze older transactions, log into your bank's website directly, download your historical statements as a CSV or Excel file, and manually copy that data into your Money in Excel spreadsheet.
Free Microsoft Office alternative

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. 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. 2. Open in WPS Spreadsheets: Launch WPS Office, click on Spreadsheets, and open the downloaded bank statement file.
  3. 3. Analyze Your Data: Use WPS Spreadsheets' built-in formatting tools, PivotTables, and charts to effortlessly track and categorize your financial data.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formats.Easily import, format, and analyze years of bank transaction data from CSV files.Includes powerful pivot tables, charts, and financial formulas.Free, lightweight, and fast performance across Windows, Mac, and mobile devices.
microsoft office alternative - wps office

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.