Activity Report
For the period Ended ______________Quarter of ________
_________________Department/Branch
Desired Result
s.n.
List of Planned Activities
NB:
1. Planned activities during the quarter
Result Achieved
Measurement
2. Measurement: - either by no. or percentage or frequency as it was stated in the activity plan
3. Target set for current quarter
4. Result Achieved during the quarter- brief explanation on what has been done.
5. Variation from the target set for the quarter, It should answer What percent of the plan was accomplished during the quarter
6. Reason for the difference between plan and accomplishments
eport
______Quarter of ________
Variation from the plan
Reason for Significant Variation
Identified future actions to
be taken to attain the plan
PRF-1
Postion of Deposits
For the period Ended ______________Quar
_________________ Branch/IBD
Actual
Previous
Last Year
Quarter
Same Quarter
Account Title
Demand Deposits
Saving Deposits
Fixed Deposits
Special Saving Deposits
Non Interest Bearing Saving Deposits
Total Deposits
Reason for variations 6% and above
________________________________________________
________________________________________________
________________________________________________
________________________________________________
Progress Report Format
Postion of Deposits
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial
Year ____________
Plan
Actual
______________________________________
______________________________________
______________________________________
_______________________________________
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
PRF-1.1
Postion of Margin Held Acc
For the period Ended ______________Qu
_________________ IBD
Actual
Account Title
Last Year
Same Quarter
A
Previous
Quarter
B
Margin Held
Reason for variations 6% and above
_________________________________________________
_________________________________________________
_________________________________________________
_________________________________________________
Progress Report Format
of Margin Held Accounts
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial
Year ____________
Plan
Actual
C
D
____________________________________
____________________________________
____________________________________
_____________________________________
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
PRF-2
Postion of Accounts
For the period Ended ______________Qua
_________________ Branch/IBD
Actual
Previous
Last Year
Quarter
Same Quarter
Type of Account
Demand Deposits
Saving Deposits
Fixed Deposits
Special Saving Deposits
Non Interest Bearing Saving Deposits
Total Deposit Accounts
Loans & Advances Account
Reason for variations 6% and above
_____________________________________________
_____________________________________________
_____________________________________________
_____________________________________________
Progress Report Format
tion of Accounts
d ______________Quarter of ________
In number
__________Quarter of Financial
Year ____________
Plan
Actual
______________________________________
______________________________________
______________________________________
_______________________________________
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
PRF-3
Postion of Loans & Advances by
For the period Ended ______________Qua
_________________ Branch/IBD
Actual
Previous
Last Year
Quarter
Same Quarter
Account Title
Agricultural Production - Term Loan
- Overdrafts
Transport Loans - Term Loans
- Overdrafts
Manufacturing Production - Term Loans
- Overdrafts
Domestic Trade & Services - Term Loans
- Overdrafts
Export - Term Loans
- Overdrafts
Advance against export bills
Import - Term Loans
- Overdrafts
Advance Against Import Bills
Building & Construction - Term Loans
- Overdrafts
Personal Loans
Loans & Advances in Legal Hands
Non-performing loans (NPLs)
Merchandise Loan- Term Loans
- Overdrafts
Staff Housing Loan and advance
Export-pre-shipment Loan
DTS- Merchandise
Total Term Loans
Total Overdrafts
Advance against Import/export bills
Merchandise Loan- Term Loans
Preshipment Loan
NPL
GRAND TOTAL
Reason for variations 6% and above
__________________________________________________
__________________________________________________
__________________________________________________
__________________________________________________
Progress Report Format
of Loans & Advances by Sector
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Plan
Actual
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
___________________________________
___________________________________
___________________________________
____________________________________
PRF-3.1
Collections of Loans
For the period Ended __________
_________________ Branch
Actual
Previous
Last Year
Quarter
Same Quarter
No.
Account Title
Regular Term Loan
Advance aginst Import/Export Bills
Non-performing loans
Loans & Advances in Legal hands
Total
Reason for variations 6% and above
_________________________________________________
_________________________________________________
_________________________________________________
_________________________________________________
Progress Report Format
ions of Loans & Advances
nded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Plan
Actual
_____________________________
_____________________________
_____________________________
______________________________
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
PRF-4
Share Selling
For the period Ended ______________Quarter of _____
_________________ Branch
Actual
Last Year
Same Quarter
No.
Particulars
1 Cooperatives
2 Indviduals
Total
Previous
Quarter
B
__________Quarter of Financial
Year ____________
Plan
C
Progress Report Format
are Selling
___________Quarter of ________
(In '000 Birr)
_______Quarter of Financial
Year ____________
Actual
D
% variation
(D-A)/A *100
(D-B)/B *100
(D-C)/C *100
PRF-5
Foreign Currency Resource
For the period Ended ______________Quarter of ________
_________________ Branch/IBD
Actual
Previous
Last Year
Quarter
Same Quarter
No.
Particular
1 Total Receipts (1.1+1.2+1.3+1.4+1.5)
1.1 Export
1.2 Transfers
1.3 Cash Purchase through Forex Bureau
1.4 Foreign Direct Investment (FDI)
__________Quarter of Fin
____________
Plan
1.5 Others
2 Total Payements (2.1+2.2+2.3+2.4)
2.1 Imports
2.2 Transfers
2.3 Cash Sales through Forex Bureau
2.4 Others
3 Net Flows (1-2)
Progress Report Format
Foreign Currency Resource
Ended ______________Quarter of ________
(In' 000 US Dollar)
__________Quarter of Financial Year
____________
% variation
Actual
D
(D-A)/A *100
(D-B)/B *100
(D-B)/B *100
PRF-6
Postion of Income & Expense Summar y
For the period Ended ______________Quarter of ___
_________________ Branch/Department
Actual
Last Year
Same Quarter
Account Title
__________Quarter of Financia
____________
Plan
B
TOTAL INCOME
Interest Income
.Interest earned on Loans & Advances
.Interest earned on Surplus Fund
Commission & Service Charges
Other Income
Gain on FCY Translations & Transactions
.Gain on Foreign Exch. Dealings
.Gain on Foreign Currency cash Notes
TOTAL EXPENSES
Interest Expense
Salaries & Benefits
General and Administrative Expenses
Depreciation
PROFIT/ LOSS BEFORE TAX
Reason for variations 6% and above
_________________________________________________
_________________________________________________
_________________________________________________
_________________________________________________
Progress Report Format
Income & Expense Summar y
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
% variation
Actual
C
(C-A)/A *100
__________________________________________________
__________________________________________________
__________________________________________________
___________________________________________________
(C-B)/B *100
PRF-6.1
Breakdown of Interest Expense
For the period Ended ______________Quarter o
_________________ Branch
Actual
No.
1
2
3
4
5
6
Account Title
Last Year
Same Quarter
A
Interest paid on Saving Deposits
Interest paid on Fixed Time Deposits
Interest paid on Demand Deposits
Interest paid on Special Saving Deposits
Interest paid on Correspondents our Account
Interest paid on Short Term Borrowings
Total
Reason for variations 6% and above
_______________________________________
_______________________________________
_______________________________________
_______________________________________
Progress Report Format
of Interest Expense
_____________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Plan
Actual
B
C
% variation
(C-A)/A *100
_______________________________________________
_______________________________________________
_______________________________________________
________________________________________________
(C-B)/B *100
PRF-6.2
Breakdown of Salar y And Benefit Expens
For the period Ended ______________Quarter of _
_________________ Branch/Department
Actual
Account Title
Last Year
Same Quarter
A
__________Quarter of Fin
____________
Plan
B
Clerical Staff Salaries
Non-Clerical Staff Salaries
Provident Fund contribution
Cash Indemnity Allowance and incentive
Uniforms
Training and Education
Severance and leave Pay
Staff Insurance
Medical
Bonus
Other Allowance and Benefits
Fuel and Representation Allowance
Employee Transportation Allowance
Overtime Payements
Penssion Fund Contribution
Total
Reason for variations 6% and above
_____________________________________________
_____________________________________________
_____________________________________________
_____________________________________________
Progress Report Format
alar y And Benefit Expense
______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Actual
C
% variation
(C-A)/A *100
________________________________________________
________________________________________________
________________________________________________
_________________________________________________
(C-B)/B *100
PRF-6.3
Breakdown of General & Administrative Exp
For the period Ended ______________Quarter of
_________________ Branch/Department
No.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
34
35
Account Title
Rent
Stationery & Office Supplies
Business Travel & Transportation
Communication
Fees
Insurance
Taxes
Fuel and Lubricant
Wages
Sundries
Conference and Entertainment
Maintenance - Office & Premises
Maintenance - Motor Vehicles
Maintenance -Office & Other equipment
Maintenance - Furniture & Fittings
Maintenance - Counters and partitions
Transport of Currency
Utility
Bank Charge
Proivsition for Doutful Loans and Advances
Advertisement/Publicity
Donation and Contribution
Loss on Disposal of Assets
Legal
Amortization of Establishment Cost
Loss on Acquired Properties
FCY Trading Cost & Service Charge
Inaguration
Board Allowance
Security and Janitorial Services
Entertainment
Postage
Audit Fee
Maintenance Com-prin & Accessories
Penalty Charges
Depreciation
Actual
Last Year
Same Quarter
A
__________Quarter of
__________
Plan
B
Total
Reason for variations 6% and above
__________________________________________
__________________________________________
__________________________________________
__________________________________________
Progress Report Format
ral & Administrative Expenses
______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Actual
C
% variation
(C-A)/A *100
(C-B)/B *100
_________________________________________________
_________________________________________________
_________________________________________________
__________________________________________________
PRF-6.4
Postion of Interest Income on Loans & Advan
For the period Ended ______________Quarter
_________________ Branch/IBD
Actual
Account Title
No.
Agricultural Production
2
3
- Overdrafts
Transport Loans- Term Loans
4
5
- Overdrafts
Manufacturing Production
6
7
- Term Loans
- Overdrafts
Domestic Trade & Services - Term Loans
8
9
- Term Loan
- Overdrafts
Export
- Term Loans
10
- Overdrafts
11 Advance against export bills
12 Import
- Term Loans
13
- Overdrafts
14 Advance against import bills
15 Building & construction
16
-Term loans
- Overdrafts
17 Personal Loans
18 Loans & Advances in legal hands
19 Non-performing Loans
20 Merchandise - Term loans
21
- Overdrafts
22 Staff Housing Loan and Advance
Last Year
Same Quarter
A
23 Export Pre-shipment Loan
24 DTS- Merchandise
25
26
Total term loans
Total overdrafts
Reason for variations 6% and above
____________________________________________
____________________________________________
____________________________________________
____________________________________________
Progress Report Format
ncome on Loans & Advances by sector
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Plan
Actual
B
C
% variation
(C-A)/A *100
(C-B)/B *100
________________________________________________
________________________________________________
________________________________________________
_________________________________________________
PRF-6.5
Postion of Commission and Ser vice Charge Income
For the period Ended ______________Quarter of _______
_________________ Branch/IBD
Actual
Last Year
Same Quarter
A
No. Account Title
__________Quarter of F
___________
Plan
B
Commission Income On:
1
Import Letters of Credit
Export
M.T's, T.T's & D.D's - Local
Commission on CPO
Commission on Uncleared Effects
Commission on Letter of Guarantee
7
Total Commission
Service Charges Income
1
Service Charges
- Local
Service Charges
- Foreign
Forex Bureau
4
Total Service Charge
Total Commission & Service Charges
Reason for variations 6% and above
___________________________________________
___________________________________________
___________________________________________
___________________________________________
Progress Report Format
Ser vice Charge Income
_______Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Actual
C
% variation
(C-A)/A *100
________________________________________________
________________________________________________
________________________________________________
_________________________________________________
(C-B)/B *100
PRF-6.6
Postion of Other Income
For the period Ended ______________Quarter o
_________________ Branch/Department
No. Account Title
Actual
Last Year
Same Quarter
A
__________Quarter of Financ
____________
Plan
B
1 Bad Debts Collected
2
Cash Surplus
Estimation and Inspection Fees
Gain on Disposal of Assets
Postage/Courier
Legal
Money Bags
Sundries
Telephone & Swift
10 Rent
11 Gain on Disposal Acquired Properties
12 Photo Copy Charges
13
14
Total
Reason for variations 6% and above
________________________________________________
________________________________________________
________________________________________________
________________________________________________
Progress Report Format
stion of Other Income
ded ______________Quarter of ________
(In '000 Birr)
__________Quarter of Financial Year
____________
Actual
C
________________________________________________
________________________________________________
________________________________________________
_________________________________________________
% variation
(C-A)/A *100
(C-B)/B *100
