Forum Discussion
excell
Could I ask what you are planning to do with the data?
I ask because I also download bank statements and credit card statements, all into a single comprehensive database where I then assign budget categories. Some items are income (typically positive from the bank/credit card); some are expense (typically, but not always, negative). And there are subcategories by type of income, type of expense. But I emphasized that "but not always" regarding credit card statements because I've realized credit card companies don't all follow the same convention. So I approach that a different way, as described below.
I have a special column that only after I've slotted the entry into income or expense makes sure that all expenses are negative, all incomes are positive. That way I can easily create a Pivot Table that summarizes all items on a month-by-month basis, category-by-category basis and the grand total automatically subtracts all expenses from all incomes, easy because they're all in a single column.