Data Import & Export

How to Fix Missing Account and Institution Details in Money in Excel

Elise WilliamsElise Williams Nov 2, 2026 868 views

Question details

Users are encountering an issue where imported transactions in Money in Excel are missing specific financial institution data.

How to Fix Missing Account and Institution Details in Money in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing or syncing recent financial transactions into the Money in Excel workbook template.
Observed behavior
The tool successfully imports transaction dates, merchants, categories, and amounts, but the Account, Account Number, and Institution fields remain entirely blank in both the Transactions and Net Worth sheets.
Before you start

Before attempting to fix your template, ensure that your Microsoft 365 subscription is active and that your internet connection is stable enough to allow the Money in Excel add-in to sync securely with Plaid.

Solution 1Recommended

Download a Fresh Money in Excel Template

Deleting your current template and starting with a fresh download is the most effective way to restore the missing fields without having to reconnect your accounts.

Recent updates to the Money in Excel backend can occasionally cause syncing bugs in older workbook versions. Updating to a completely new template forces the add-in to refresh its data mapping.

1
Delete the existing template

Locate your currently saved Money in Excel workbook on your computer and delete it. You may want to save a backup copy first if you have added custom sheets.

2
Download a new template

Open Excel, click on 'File' > 'New', search for 'Money in Excel' in the online templates search bar, and download a fresh copy.

3
Sync your accounts

Open the newly downloaded template, click 'Trust this add-in' if prompted, and sign in to the Money in Excel pane on the right side. Your existing accounts will automatically sync and populate the previously missing institution fields.

Download a Fresh Money in Excel Template
No Need to Re-link Accounts: You do not need to reload or re-authenticate your financial institutions. Your Plaid connections are tied to your Microsoft account, not the local file.
Free Microsoft Office alternative

Manage Your Finances Securely with WPS Office

If you are tired of troubleshooting broken add-ins and missing data in Microsoft Office, consider switching to WPS Office. It is a highly compatible, fast, and free alternative that lets you build reliable personal finance dashboards and budget trackers without relying on buggy automatic syncing templates.

  1. 1. Download and install: Download WPS Office for free from the official website and install it on your PC or Mac.
  2. 2. Open your financial exports: Export your transaction history from your bank as a CSV or Excel file, then open it directly in WPS Spreadsheets.
  3. 3. Use free templates: Click 'New' to explore the WPS template library and find beautifully designed budget and net worth trackers to organize your data.
100% compatible with Microsoft Excel (.xlsx, .xls) and CSV financial exports.Completely free to use with dozens of built-in personal finance and budget templates.Lightweight architecture ensures large transaction datasets open instantly.Familiar tabbed interface makes migrating from Microsoft Office effortless.
microsoft office alternative - wps office

Frequently Asked Questions

Why are my account and institution names also blank in the Net Worth sheet?

The Net Worth sheet pulls its data from the same backend connection as the Transactions sheet. If the syncing bug causes fields to drop in one sheet, it affects the entire workbook. Downloading a fresh template usually resolves the issue globally.

Will downloading a new Money in Excel template delete my historical transactions?

No, your historical transactions are synced from your connected financial institutions. When you download a new template and sign in, it will re-fetch your historical data securely from Plaid.

Is Money in Excel still officially supported?

Microsoft officially ended support for Money in Excel on June 30, 2023. If you continue to experience missing data or broken syncing, it is highly recommended to manually export your bank data as CSV files or transition to a dedicated personal finance alternative.