Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)

Yes to your question: off to the right in the transaction table, the very last column, I make sure that all expense categories are negatives. (It is interesting, isn't it, that some financial institutions report them as negatives, others as positives, so it's up to us to make them consistent.)

FYI, here are the columns in my transactional database.

• Account: the relevant bank or credit card account (name, not number)
• Date: self explanatory
• Action: the description that comes when I download the data from the bank or credit card co.
• Add'l description (some accounts give add'l info, sometimes helpful in categorizing sometimes confusing
• Category1 (High level budget category)
• Category2 (Medium level budget category)
• Sub (lowest level budget category; not always used; but useful if I want to differentiate get more details that Category2 provides. For example, if Category2 is "Video Streaming" then Sub might be where I'd note Apple, HBOMax, Prime, etc.
• Abs: that aforementioned calculation to render all expense items as negatives.

To assure data integrity, I use data validation to create drop down menus for Budget Categories 1 and 2. I've designed it so I can add new categories if the need arises. Those tables are complicated; In addition to roughly 10 types of "income", I actually have over 140 buckets to put expenses into, and those are grouped under "Charity" "Fixed" "Basic" "Discretionary" and "Travel" --- nevertheless, using  the Pivot Table, I can see quickly and neatly how much income of the ten different types, and how expenses fall into each of the 140 buckets, all nicely summarized in terms of Fixed, Basic , etc.

It may sound overwhelming, but once the structure is established it easy to maintain. It's a matter of getting the data from the financial institutions on a timely basis and doing what you need to do to apply the various budget category labels to each line.