Assign multiple categories to 1 transaction and break down 1 transaction - Money in Excel

Copper Contributor

Hi, 

I follow Dave Ramsey and use cash for numerous areas (groceries, fuel, spending, etc.) I am relatively new to Money in Excel and love it - however when I do 1 cash withdrawal that I want assigned to multiple categories, I want to be able to breakdown the 1 withdrawl and attach those subcategories to the appropriate amounts, but I can't seem to do this. 

I edited my 1 transaction and then added lines and copy/paste the formulas to try and attach them to the appropriate accounts, but that did not work, it just threw the accounts into 'Unknown'. 

Is there a way to accomplish what I am wanting? 

 

Example: Cash withdraw of $800. $125 for personal care $400 for groceries, $100 for hair, $125 clothes, $50 spending. I want to break down this 1 transaction and assign the multiple categories according to the amounts so I can properly track spending according to the categories/subcategories I have alloted. 

0 Replies