Code Column in Categories

Tips & Tricks for more effective use of AceMoney & AceMoney Receipts
Post Reply
LittleLulu
Posts: 2
Joined: Thu Feb 14, 2013 11:45 am
Location: Alabama, USA

Code Column in Categories

Post by LittleLulu »

Does anyone use the Code column that appears in Categories? If so, how do you you use it?

I've been trying to figure a way to get Income categories to show up before Expense categories in various reports (which I copy to Excel). I came to the conclusion that numbering the categories would probably work best -- e.g. "100-Income." I think it's not necessarily even necessary to number Expense categories; they would fall in in alpha order after the numbered categories. Still playing with this in a sample file.

But that got me to wondering about the Code column. How does it act when you do use it? What is it good for?

I certainly don't think of myself as a Power User -- but certainly an almost-daily user for 2-1/2 yrs. And I'm still figuring it all out. Maybe a real Power User will have an answer?
Still using Windows XP. Ace Money desktop latest update.
Cape
Posts: 10
Joined: Sun May 19, 2013 11:08 pm

Re: Code Column in Categories

Post by Cape »

Can be used to contain a reference from another system. Legacy so you can go back and find the original transaction.
Or for export and sorting & merging with transactions from other systems - typically general ledger code.
Could contain a smart code for break out into sub sub categories - eg characters 0 to 2 are cat code 1, with a domain of possible values, 3 to 5 another and so on. Then in Excel you could break out into different columns and create interesting drill down reports.
Post Reply