How to Permanently Change Transaction Categories in Money in Excel
Question details
The user wants to know how to permanently modify transaction categories, merchant names, and transfer classifications in Money in Excel so they do not revert after the account synchronizes.

- Product
- Money in Excel
- Device & OS
- not provided
- Scenario
- Modifying transaction data and categorizing expenses within the Money in Excel spreadsheet template.
- Observed behavior
- Manual changes made to transaction categories and merchant names are overwritten and restored to their original bank data state during the next account synchronization.
Before attempting to permanently alter transaction categories, ensure your bank accounts are fully synchronized and save a backup copy of your current Money in Excel workbook.
Manage Sync Behavior and Transaction Rules
Understand how synchronization affects manual edits and utilize supported transaction rules to manage your categories.
Money in Excel is designed to pull raw data directly from your linked financial institutions. Because of this automated synchronization process, any manual changes you make to transaction categories or merchant names in the spreadsheet are typically overwritten during the next sync to match the bank's actual records.
Manual edits will generally not remain permanent unless you use built-in transaction rules.
Make all your manual categorization changes only after you have pressed the 'Update' button in the Money in Excel pane to pull the latest transactions.
Look in the Money in Excel task pane settings for 'Transaction Rules' or 'Custom Categories' options. If supported by your current version, set up rules to automatically categorize specific merchants moving forward.
If your manual edits are continually overwritten and no rules are available, visit the Microsoft Tech Community forums for up-to-date workarounds regarding your specific financial institution.

Manage Your Finances Securely with WPS Spreadsheet
Since Money in Excel forces synchronization overwrites and has been discontinued, building a budget in WPS Spreadsheet gives you absolute control over your financial data. WPS Office is a highly compatible, free alternative to Microsoft Office that lets you track expenses your way.
- 1. Download WPS Office: Install WPS Office Free on your device and open WPS Spreadsheet.
- 2. Choose a budget template: Browse the built-in template library and select a personal finance or expense tracking template.
- 3. Import bank data manually: Download your bank statements as a CSV file from your bank's website and open them in WPS Spreadsheet.
- 4. Categorize your transactions: Copy the data into your budget template and manually categorize your transactions. Your changes will be permanent and will not be overwritten by unexpected background syncs.

Frequently Asked Questions
Why do my merchant names change back after I edit them in Money in Excel?
Money in Excel continuously syncs with your linked bank accounts. When it pulls fresh data, it often overwrites manual edits with the default raw merchant name provided by the bank.
Can I stop Money in Excel from overwriting my manual changes?
Generally, manual edits cannot be made permanent if the sync process identifies a mismatch with the bank's records. You can only prevent this if you configure specific transaction rules, provided your version still supports them.
Is Money in Excel still supported by Microsoft?
Microsoft has discontinued the Money in Excel premium template. Consequently, ongoing synchronization bugs, overwrites, or feature limitations are no longer receiving official updates or fixes.
How can I track my expenses without my categories being overwritten?
You can export your bank transactions as a CSV file and manually import them into a standard spreadsheet program like WPS Spreadsheet or standard Excel. This offline method prevents background synchronization from modifying your customized categories.




