SOLVED

Using the program "Money" in Excel 365 on a PC

%3CLINGO-SUB%20id%3D%22lingo-sub-2352932%22%20slang%3D%22en-US%22%3EUsing%20the%20program%20%22Money%22%20in%20Excel%20365%20on%20a%20PC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352932%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20the%20program%20Money%20in%20Excel%20365%20and%20is%20working%20good%20but%2C%20I%20have%20expenses%20that%20need%20to%20be%20broken%20down.%26nbsp%3B%20For%20Example%3A%26nbsp%3B%20Lets%20say%20I%20pay%20rent%20and%20included%20in%20my%20rent%20is%20Electric%20and%20Gas%20Charges%20that%20vary%20month%20to%20month.%26nbsp%3B%20I%20need%20to%20break%20down%20my%20rent%20payment%20to%20track%20how%20much%20I%20spend%20each%20month%20of%20on%20Electricity%20and%20Gas.%26nbsp%3B%20Any%20Suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355379%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20the%20program%20%22Money%22%20in%20Excel%20365%20on%20a%20PC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355379%22%20slang%3D%22en-US%22%3EI%20wasn't%20able%20to%20use%20Money%20in%20Excel%2C%20so%20my%20suggestion%20will%20be%20more%20general.%20(Wasn't%20able%20because%20my%20bank%20account%20uses%20dual%20factor%20authentication%2C%20so%20was%20not%20accessible%3B%20and%20those%20transactions%20were%20critical%20parts%20of%20tracking).%3CBR%20%2F%3ESo%20I'd%20ask%20you%20first%20how%20the%20%22Rent%22%20figure%20appears%20in%20the%20first%20place%3A%20is%20it%20downloaded%20from%20a%20credit%20card%20account%2C%20a%20bank%20account%2C%20or%20do%20you%20enter%20it%20directly%3F%3CBR%20%2F%3EIf%20the%20latter%2C%20just%20separate%20your%20entries.%3CBR%20%2F%3EIf%20from%20an%20external%20account%2C%20are%20you%20able%20to%20delete%20the%20row%20and%20enter%20three%20separate%20rows%2C%20one%20each%20for%20%22Rent%2C%22%20Elect%22%20and%20%22Gas%22%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20question%2C%20though%2C%20how%20precise%20do%20you%20need%20to%20be%20in%20tracking%20your%20utilities%3F%20Could%20you%20not%20just%20(for%20planning%20or%20analytical%20purposes)%20use%20average%20monthly%20figures%20for%20the%20year%2C%20perhaps%20seasonalized%3F%3CBR%20%2F%3E%3CBR%20%2F%3ENow%2C%20if%20that%20was%20just%20an%20example%2C%20and%20what%20you%20really%20are%20wanting%20to%20do%20is%20break%20apart%20a%20single%20payment%20to%2C%20say%2C%20Costco--some%20of%20which%20is%20for%20food%2C%20some%20for%20pharmaceuticals%2C%20some%20for%20electronic%20equipment--whatever%20was%20in%20the%20monster%20cart%20that%20got%20all%20lumped%20together%20into%20a%20single%20figure--then%20you've%20got%20a%20bigger%20issue.%20Then%20I'd%20advise%20keeping%20a%20separate%20spreadsheet%20where%20you%20track%20the%20sub-categories%20on%20your%20own.%20Otherwise%2C%20you're%20going%20to%20be%20pulling%20your%20hair%20out%20trying%20to%20get%20Money%20in%20Excel%20to%20handle%20a%20level%20of%20detail%20it%20may%20not%20be%20able%20to.%3C%2FLINGO-BODY%3E
New Contributor

I am trying to use the program Money in Excel 365 and is working good but, I have expenses that need to be broken down.  For Example:  Lets say I pay rent and included in my rent is Electric and Gas Charges that vary month to month.  I need to break down my rent payment to track how much I spend each month of on Electricity and Gas.  Any Suggestions?

3 Replies
I wasn't able to use Money in Excel, so my suggestion will be more general. (Wasn't able because my bank account uses dual factor authentication, so was not accessible; and those transactions were critical parts of tracking).
So I'd ask you first how the "Rent" figure appears in the first place: is it downloaded from a credit card account, a bank account, or do you enter it directly?
If the latter, just separate your entries.
If from an external account, are you able to delete the row and enter three separate rows, one each for "Rent," Elect" and "Gas"?

Another question, though, how precise do you need to be in tracking your utilities? Could you not just (for planning or analytical purposes) use average monthly figures for the year, perhaps seasonalized?

Now, if that was just an example, and what you really are wanting to do is break apart a single payment to, say, Costco--some of which is for food, some for pharmaceuticals, some for electronic equipment--whatever was in the monster cart that got all lumped together into a single figure--then you've got a bigger issue. Then I'd advise keeping a separate spreadsheet where you track the sub-categories on your own. Otherwise, you're going to be pulling your hair out trying to get Money in Excel to handle a level of detail it may not be able to.

Thank you for the suggestion @mathetes I guess I am stuck with either keeping paper work or a separate spreadsheet.  The spreadsheet sounds more feasible so I can track Kilowatts and Cubic feet and have a running total for each part of the year.  Thanks again

best response confirmed by Franco1940 (New Contributor)
Solution
Kilowatts and Cubic Feet aren't currencies that Money in Excel tracks anyway.

So your example at the start wasn't just an example, I gather. No...if you're wanting to track something like that, not just the dollars spent on electricity and gas, then a separate sheet is the thing. But if it is the dollars, in fact, then I suggest you look at manual entry of the data, first deleting the comprehensive rent figure and then entering the detailed breakout. I would assume that MiE can handle that.