Products‎ > ‎

Bank Summary

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)

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.

Ratan Tikyani,
28 Dec 2012, 02:07