Monthly Revenue Performance Review

2011-12Month : Date : Branch :

1

Monthly Review

Brief Summary for the Month

Particulars

Budget for the month Actual for the Month

% Achieved Revenue

Volume Revenue

Rev Per Cbm

Volume Rev

Rev per Cbm

Product wise Brief

E-Consol (CBM)              

E- FCL Express (TEU)    

        

E- Africa Express (TEU)    

        

I – Consol (CBM)    

        

I – FCL(TEU)              

E- Air Express (KG)    

        

I- Air Express (KG)    

        

STUFFING(TEU)              

Financial Brief

Particulars

For The MonthFor the Previous Month

For Year To Date

%age Achieved (YTD)Budget Actual Budget Actual

Budget Actual

Income in Rs.                

Expenses in Rs.

  

    

    

Net Profit in Rs.

  

    

    

2

Monthly Review

Position of Local Debtors

0 - 30 30 - 60 60 - 90 90 - 180180 & Abv.

TOTAL

As on Day of Review

As on Last day of Review month

Brokerage Receivables

Overseas Outstanding (UAC

5342004)

Total Collections made (over 60days)

CREDITORS1. Highlights of the month (Revenue)

2. Position till review date & the road further ( Revenue)

 

3

Monthly Review

Outstanding over 60 days

Salesman Name Customer Name

61-90

91-180

Abv180

Tota

l B.M.Remar

ks

 

TOTAL

4

Monthly Review

Brokerage Receivables

Shipping line Name 0-30 31-60 61-90

91-180

Ab.180 Total B.M.Remarks

5

Monthly Review

Difference in P&L a/c - E-Freight & Review Slide

P & L Schedule Income as per E-freight P&L A/C

Income as per Review P&L

A/C Reason for the

difference Income ( In INR)      

                       

P & L Schedule E-freight P&L

A/C Review P&L

A/C Reason for the

difference Expenses ( In INR)      

               

Note: Income and not net profit to be considered. Figures has to be in YTD. 6

Monthly Review

Internal Audit Report

Sr. No Adverse

Comment by Auditor

Reason for said Comment

Precaution taken to avoid future mistakes

Name of Auditor :

7

Monthly Review Accounting / Financial Statutory CompliancesSr. No

Particulars Yes/No.

1 Whether Service-Tax is correctly charged in every Invoice issued by TGL?

2 Whether Cenvat Credit is correctly availed?

3 Whether the Service-Tax paid is as per the Books of Account?

4 Whether the Service-Tax Return data advised by the Branches tallies with the Books of Account?

5 Whether TDS has been deducted properly from the payments made by TGL?

6 Whether TDS deducted has been paid to the Government of India on time? A statement that this is taken care of by HO should not be accepted.

7 Whether the TDS Amounts made by our Clients as per our Books of Account tallies with the amounts shown on the NSDL Website. If not, the differences to be reported. This is to be done only in October 2010 and June 2011 Reports.

8 Whether the quarterly TDS Return has been filed on due dates and is in agreement with the Books of Account.

9 Whether the Bank Reconciliation has been completed and is correct? In case any stale cheques are shown they have to be first cancelled before the Bank Reconciliation is finalized.

10 Whether confirmations are available for Loans and Advances? This is to be done while auditing the Accounts of September and March.

11 Whether ESI and Profession Tax have been paid in time.

12 Whether the balances in the Prepaid Deposit Account as per our Books of Account is in confirmation with the Statement issued by the Port / CFSs etc… If not, reconciliation is required.

13 Whether Interbranch Reconciliation is up-to-date? If not, month upto which it has been completed has to be advised.

14 Whether the Break-up of Creditors and Debtors is tallying with the Books of Account.

15 Whether the Cash in Hand tallies with the Books of Account?  

16 Are all sub job Invoicing completed for the shipments done

17 Whether all provision cost has been updated in Job/sub job level

Note: To be validated by Branch Manager and Accountant 8

Monthly Review

Claims and Legal Cases

S. #Segme

nt POL PODAgent Name

Value of

ClaimClaim Date Status as of Date

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

9

Monthly Review

Gross Revenue Budget

Particulars (INR)

Current Month YTD 2010-11Budget 10-

11 Actual 10-

11 Budget 10-

11 Actual 10-

11 E Console Express        

Gross Revenue (Billing)         Operating Expense        

E Console Express Income         Income as %age of Revenue        

I Console Express         Gross Revenue (Billing)        

Operating Expense         I Console Express Income        

Income as %age of Revenue         FCL – Export Express        

Gross Revenue (Billing)        

Operating Expense        

FCL – Export Express Income        

Income as %age of Revenue        

FCL – Import Express        

Gross Revenue (Billing)        

Operating Expense        

Note: Income should tally with Income mentioned in Net Revenue & Expense Slide

10

Monthly Review

Particulars (INR)

Current Month YTD 2010-11Budget 10-

11 Actual 10-

11 Budget 10-

11 Actual 10-

11 FCL – Import Express Income        

Income as %age of Revenue        

Africa Express        

Gross Revenue (Billing)        

Operating Expense        

Africa Express Income        

Income as %age of Revenue        

Air Export        

Gross Revenue (Billing)        

Operating Expense        

Air Export Income        

Income as %age of Revenue        

Air Import        

Gross Revenue (Billing)        

Operating Expense        

Air Import Income        

Income as %age of Revenue        

Project Express        

Gross Revenue (Billing)        

Operating Expense        

Project Express Income        

Income as %age of Revenue        

11

Monthly Review

Net Revenue & Expense Budget

Particulars (INR) Charge Code

Current Month 11-12 YTD 11-12

%age of Total Budget Actual Budget Actual

Income

E Console Express 1301010005          

I Console Express 1301010016          

FCL – Export Express 1301010010          

FCL – Import Express 1301010015          

Africa Express 1301010065          

Air Export 1301050005          

Air Import 1301050010          

Project Express

1301010020 &

1301100005          

Total Income            

12

Monthly Review

Particulars (INR) Charge Code

Current Month11-12 YTD 11-12

%age of Total Budget Actual Budget Actual

Expenditure Employee Cost            

Staff Salary & Wages (Basic) 1405050005          

Staff Welfare 1405050080          

Employee Engagement 1405050150          

Property Cost            

Office Rent 1405100005          

Electricity Charges 1405100050          

Rates & Taxes 1405100010          

Security Charges 1405100015          

Office Insurance 1405100020          

Repairs & Maintenance Office 1405100025          

Repair & Maintenance Computer[Hardware} 1405100035          

Repair & Maintenance Computer[Software} 1405100040

Communication Cost            

Telephone 1405150005          

Mobile 1405150015          

Internet 1405150020          

Postage & Courier 1405150025          

13

Monthly Review

Particulars (INR) Charge Code

Current Month11-12 YTD 11-12

%age of Total Budget Actual Budget Actual

Expenditure Travel          

Business Travel - Domestic 1405200005          

Business Travel - International 1405200010          

Accommodation 1405200012          

Conveyance 1405200015          

Selling & Distribution 1405250005Advertisement &

Publicity 1405250005           Business

Promotion 1405250030Office Expenses 1405300035          

Audit & Consultant Fees

1405400031

Professional Charges

1405400015

Printing & Stationary 1405300015           Subscription & Membership 1405300020          

Books & Periodicals 1405300025           House Keeping

Expenses 1405300026           Donations 1405300030          

Software Expenses 1405300040           MTO Insurance

Charges 1305010032          

14

Monthly Review

Particulars (INR)

Charge Code

   

%age of Total Budget Actual Budget Actua

l Expenditure

             Vehicle Expenses

            Car Parking

Charges 1405350014           Vehicle Insurance 1405350015           Petrol Expenses 1405350016          

Vehicle Repairs & Maintenance 1405350030           Vehicle Hire

Charges 1405350035           Finance & Other

Expenses             Term loan Interest 1410010010          

Business Loan interest 1410010030          

Other Financial Charges 1410010100          

Bank Charges 1410050005           Notional

Expenditure             Interest On

Working Capital             Corporate Expenses            

Depreciation             Total

Expenditure             Net Profit            

15

Monthly Review

Monthly Employee Turnover

Sr. No

No of Employee on 1st of month

Name of Employee

Joined /Dept Name

Name of Employee

Left

No of Employee as on last day of the month

Attrition Rate

                    

                                                                                                                                                          

Note : Attrition Rate = No. of resigned of that month/ Available manpower * 100For example, if in any of the starting day of previous month the manpower was 80 and during that month 5 resigned and 10 joined.. then on the last day of the month Manpower would be 80-5+10 = 85. So Attrition rate = 5/85*100

16

Monthly Review

17