That makes sense @toddarooski. There are so many valid ways to skin this 
in a spreadsheet. I’d also consider using Tags in the workflow you describe since they are helpful in identifying/grouping/aggregating transactions that span multiple categories.