I am currently going thru my credit card statement and adding up all of the charges by categories so I can enter the charges into MYOB Accountedge - this is to keep my accounting correct and I pay the credit card from AccountEdge. I'm thinking that a pencil and calculator is so 1980. Maybe Numbers can be used?

I made a very simple template and listed the expense categories going down the left and have each row showing a total on the far right. Then all of the totals are added up to a grand total on the bottom. If I do it right, I enter each charge manually in the correct category and Numbers does the math for me.

But I have a hunch that I'm not doing it the best way. This is my first time really using Numbers or any spreadsheet. I'm afraid that printing this out can be a real pain. For example if I enter each auto fuel charge for the month the spreadsheet will have to get very wide. Printing will be a challenge.

Does anyone have suggestions? Has anyone made a template to consolidate their credit card charges by category? This has to be a common task that someone has figured out. I hate reading manuals...

Thanks.