Forum Discussion
Solved
Using the program "Money" in Excel 365 on a PC
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 ...
- 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.
If it's just a few transactions a month you need to split, you can use manual transactions.
Let's say your rent is $1000/month, and $70 is for electric and $30 is for gas.
You would download this transaction from your bank:
Rent -$1000
Then create three manual transactions:
Rent +$100 (positive 100 dollars)
Gas -$30 (negative 30)
Electric -$70 (negative 70)
Let's say your rent is $1000/month, and $70 is for electric and $30 is for gas.
You would download this transaction from your bank:
Rent -$1000
Then create three manual transactions:
Rent +$100 (positive 100 dollars)
Gas -$30 (negative 30)
Electric -$70 (negative 70)