Skip to Content
0
Former Member
Nov 21, 2012 at 09:06 AM

Banking Report Template

68 Views

Hi All

am creating a Deposit report.

currently I have done it in this layout.

Deposit Account I Deposit Account Name I Amount

12020401 Barclays Bank 1000

12020402 KCB Bank 1000

12020403 Guardian Bank 1000

12020404 Equity Bank 1000

i wanted to convert it to the following layout.

Deposit Source I Account Name I Barclays Bank I KCB Bank I Guardian Bank I Equity Bank

12020301 Chq Control A/c Amount Amount Amount Amount

12020201 Cash Control A/c Amount Amount Amount Amount

12020302 Chq Control A/c Amount Amount Amount Amount

12020202 Cash Control A/c Amount Amount Amount Amount

12020303 Chq Control A/c Amount Amount Amount Amount

12020203 Cash Control A/c Amount Amount Amount Amount

12020304 Chq Control A/c Amount Amount Amount Amount

12020204 Cash Control A/c Amount Amount Amount Amount

__________________________________________________________________________________________________

Total Total Deposited Total Deposited Total Deposited Total Deposited

Source is the Deposit Source- 1202030* are Control Accounts for Cheque Deposits

1202020* are Control Accounts for Cash Deposits

Anybody who can help to go about this.