Money In Excel Lost Account Info

%3CLINGO-SUB%20id%3D%22lingo-sub-2932429%22%20slang%3D%22en-US%22%3EMoney%20In%20Excel%20Lost%20Account%20Info%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2932429%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20open%20Money%20in%20Excel%2C%20the%20panel%20is%20showing%20all%20of%20my%20accounts%20as%20Unknown%20and%20with%20zero%20balances%20(which%20is%20not%20correct).%26nbsp%3B%20Does%20anybody%20know%20how%20to%20fix%20this%20issue%3F%26nbsp%3B%20I%20could%20delete%20my%20account%20and%20start%20over%2C%20but%20i%20don't%20want%20to%20lose%20my%20historical%20transactions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2932429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2962009%22%20slang%3D%22en-US%22%3ERe%3A%20Money%20In%20Excel%20Lost%20Account%20Info%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2962009%22%20slang%3D%22en-US%22%3EYou%20need%20to%20start%20over%2C%20and%20you%20will%20not%20lose%20your%20transactions.%20Every%20time%20you%20sync%2C%20Money%20in%20Excel%20is%20making%20a%20copy%20of%20your%20transactions%20and%20categories%20in%20the%20cloud.%20Make%20a%20new%20workbook%20from%20the%20template%2C%20add%20any%20missing%20accounts%2C%20and%20then%20sync.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2983357%22%20slang%3D%22en-US%22%3ERe%3A%20Money%20In%20Excel%20Lost%20Account%20Info%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2983357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1166833%22%20target%3D%22_blank%22%3E%40David_Goodhand%3C%2FA%3E%26nbsp%3Bunfortunately%2C%20that%20didn't%20work%26nbsp%3B%20The%20copy%20of%20my%20transactions%20and%20data%20is%20no%20longer%20accessible%20from%20any%20workbook%20because%20the%20IDs%20for%20institution%20and%20accounts%20have%20changed.%26nbsp%3B%20I've%20found%20another%20product%20to%20use%20instead%20of%20Money%20In%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When i open Money in Excel, the panel is showing all of my accounts as Unknown and with zero balances (which is not correct).  Does anybody know how to fix this issue?  I could delete my account and start over, but i don't want to lose my historical transactions.

 

2 Replies
You need to start over, and you will not lose your transactions. Every time you sync, Money in Excel is making a copy of your transactions and categories in the cloud. Make a new workbook from the template, add any missing accounts, and then sync.

@David_Goodhand unfortunately, that didn't work  The copy of my transactions and data is no longer accessible from any workbook because the IDs for institution and accounts have changed.  I've found another product to use instead of Money In Excel.