How to organise bank statements (in excel format) to see total in/outgoings?

[peacemf]

So i downloaded a years worth of bank statements in excel format.

 

 

I looking for either a template or application where i can either attach or copy the bank statement data so that it organises it in a useful way.

I want to see how much went out each month or for the whole year and incoming for the month/year.

 

Is there something that will do it? for free? and on a mac?

 

Merry christmas!

[+BudMan MVC]

It would be easier if your bank allows you to download your transactions in qif format..

 

Vs trying to do what your asking in excel - you might want to look at say gnucash, its free runs on pretty much anything, linux, windows, mac

 

http://www.gnucash.org/

 

But if you are limited to excel format (or csv) you can import that as well.

[+Warwagon MVC]

All Downloaded and played gncash .. and christ all mighty is that only ugly SOB. Not the friendliest app either. But it is free.

[+BudMan MVC]

Its got a bit of learning curve sure   And its more about function than pretty..

 

But like you said its free.. There are some nice online tools - mint for example.  https://www.mint.com/