Summaries a Income / Expenses Report from your Bank statement.
A small code that can assist you in creating a report of Income and expenditure form your Bank statement.
After setting up the Template and inserting your bank statement you will be able to :
1) Create Report of Income & Expenditure summarized across all banks.
2) Create Report for Each Bank.
3) A consolidated Pivot table for Incomes and Banks.
Bank Summary Report version 1.04.xlsm (771k)
Click here to Download
______________________________________________________________________________________
Please Note:
The font of this spreadsheet is set of Currency with Indian Rupee symbol. If the same appears as [?] on your system you can download the Microsoft update from the following link.