Kasun Madhushanka Abeysiriwardhana

KEY FINANCIALS XXX (Private) Limited For the month ended 30 April 2019 Note: Sensitive financial information have been removed / amended accordingly to protect client information. SCOPE 01 Explore over the main expenditure categories of the company for better understanding of its behavior with graphical presentation. 02 03 Present the behavior of company revenue over the recent six month of period to a have clear understanding on company revenue and its aging. Present the net gain over the period and the direction of the company in long term by suggesting respective steps to follow. PAYMENTS April - 2019 Staff Salary 82.3% 8.7% Rs. 1,106,000/Main expenditure category of the company. Petty cash expenses and T Shirt printing Rs. 116,815/Include the funds transferred for petty cash & T shirt printing expenses Rent Expenses 8.2% Rs. 110,000/Fixed expense to the company Other 0.08% Rs. 11,632/Includes mainly travelling, data charges, stationery expenses etc. Revenue (Cash received) - Aging Aging of invoices settled during the month – April-% 15.29% Invoices over 90 days 0.82% 13.41% Total Rs. 103,000/- Invoices 60 – 90 days Revenue (Cash Received) Rs. 768,075/- 0.82% Total Rs. 6,325/- Invoices 30 – 60 days 70.48% Total Rs. 541,325/- Invoices Less than 30 days 70.48% 15.29% Total Rs. 117,425/- REVENUE Cash Received – Last 06 months 4,599,009.00 3,951,556.40 1,262,-,400.00 NOVEMBER 768,075.00 204,000.00 DECEMBER December & January recorded a rapid increase with invoice receipts from XXX. JANUARY FEBRUARY March 2019 approached nearby the funds requirement of the month, with invoice receipts from XXX MARCH APRIL February 2019 remained below the average with receipts only from XXX REVENUE Accrued basis – Last 06 months 3,744,803.00 3,694,058.26 2,390,459.54 1,964,495.00 1,765,852.82 1,085,534.00 NOVEMBER DECEMBER January 2019 exceeded 3Mn. With XXX and XXX (Pvt) Ltd. invoices. JANUARY FEBRUARY April 2019 recorded the best with main contribution from XXX & XXX invoices MARCH APRIL February 2019 main contribution received from XXX Ltd. SUGGESTIONS -Posting of Invoices- INVOICE DATE PAYMENT DUE DATE PAYMENT DATE 01 02 03 Invoice date is crucial for every subsequent analysis. So, the most accurate date is essential. Project completion date or handing over date is more accurate. Part completion of jobs better to be invoiced separately. Payment due date also essential to have perfect analysis on aging. Better to decide the due date depending on nature of the job and interrelation with client. Payment receipt date is essential for both aging and cash basis profit calculation. Attention is required for end of the month transactions. SYSTEM UPDATION XXX Project APRIL 2019 Net Gain / Loss Total Invoices Rs. 53,505/- Rs. 54,425/- General Expenses Rs. 920/- Item Purchases No Purchases during the month THANK YOU.