| Profit & Loss as at | Sample Accounts under each groups | |||||||||||||||||||||||
| AccountType | AccountGroup (As per GAAP) | AccSubGroup/Analysisgroup | Simulation1 | Simulation 2 | Account1 | Account2 | Account3 | Account4 | Account5 | Account6 | Account7 | Account8 | Account9 | Account10 | Account11 | Account12 | ||||||||
| Income | Sales | Product Sales | 10 | 3000 | Sales 5% VAT | Sales 15% VAT | Sales 0% VAT Exports | |||||||||||||||||
| Services Sales | 4 | 1000 | Services 0% | Services 12% | ||||||||||||||||||||
| Other Sales | 8 | 1000 | AMC | Commissions | purch returns | |||||||||||||||||||
| Direct Income | 22 | 5000 | ||||||||||||||||||||||
| Expenses | Less: Cost of Sales / Manufacturing | Opstock | 0 | 0 | ||||||||||||||||||||
| Purchase | 5 | 1200 | Purchase 5% | Purchase 15% | Freight | ImportDuty | TransporterCharges | |||||||||||||||||
| Cl Stock | 0 | 100 | Consumption A/C | |||||||||||||||||||||
| Cost of Materials used | 5 | 1300 | ||||||||||||||||||||||
| Labour Costs | 2 | 0 | Salary of Operators | Service Purchase | Labour Subcontract | |||||||||||||||||||
| Manufacturing Overhead | 1 | 0 | Other Manufac Overheads | Building Maintenance | Depr of Plant and Equip | Machinery & Tool Maintenance | Property Insurance | Property Taxes | ||||||||||||||||
| Cost of Goods Sold/Manufactured | 8 | 1300 | ||||||||||||||||||||||
| Gross Profit | 14 | 3700 | ||||||||||||||||||||||
| Expense | Selling, General and Admin Expenses | Sales and Marketing Expenses | 2 | 100 | Printing & Stationary | Communication | Internet Subscriptions | Post&Courier | Demo Expenses | |||||||||||||||
| General and Administrative Expenses | 1 | 200 | Office | Entertainment | Repairs&Maintenance | Memberships | Staff welfare | Electricity | ||||||||||||||||
| Direct Expenses | 3 | 300 | ||||||||||||||||||||||
| Operating Profit (EBIDTA) | 11 | 3400 | ||||||||||||||||||||||
| Income | Add: Interest, Depr & Amortization | |||||||||||||||||||||||
| Interest | 1 | 200 | Bank Interest | FD Interest | Customer Paid Interest | |||||||||||||||||||
| Depreciation & Amortization | 1 | 200 | Depreciation | Amortization | ||||||||||||||||||||
| Indirect Income | 2 | 400 | ||||||||||||||||||||||
| Operating Profit after Interest, Depreciation & Amortization | 13 | 3800 | ||||||||||||||||||||||
| Income | Add: Other Income | Other Income | 1 | 300 | Rent | |||||||||||||||||||
| Other Income | 1 | 300 | ||||||||||||||||||||||
| Expenses | Sub: Indirect Expenses | |||||||||||||||||||||||
| Loss on sale/provision for investments | 1 | 200 | Mutual Fund Loss | |||||||||||||||||||||
| Provision for contigencies | 1 | 200 | Contigencies Provisions | |||||||||||||||||||||
| Provision for e-inventing the company | 1 | 200 | e-inventing Provisions | |||||||||||||||||||||
| Indirect Expenses | 3 | 600 | ||||||||||||||||||||||
| Profit before tax and extraordinary items | 11 | 3500 | ||||||||||||||||||||||
| Expenses | Sub: Provisional Expenses | |||||||||||||||||||||||
| Provision for tax - earlier period | 0 | 300 | Provision for tax - earlier period | |||||||||||||||||||||
| Provision for tax - current period | 1 | 360 | Provision for tax - current period | |||||||||||||||||||||
| Provisional Expenses | 1 | 660 | ||||||||||||||||||||||
| Profit after tax from ordinary activities | 10 | 2840 | ||||||||||||||||||||||
| Income | Add: Tax free Income | |||||||||||||||||||||||
| Extraordinary tax free income | 3 | 200 | Farming | |||||||||||||||||||||
| Tax free Income | 3 | 200 | ||||||||||||||||||||||
| Net Profit | 13 | 3040 | ||||||||||||||||||||||
| Balance Sheet as at | ||||||||||||||||||||||||
| Sources of Funds | Shareholder's Funds | Share Capital | 7 | 0 | ||||||||||||||||||||
| Liability | Owners Equity | Owner's investment | Founders | Angel Investor | Directors | Employees | Venture capital | PrivatePlacement | QIBs | Public | ||||||||||||||
| Reserves & Surplus | ||||||||||||||||||||||||
| Retained earnings | 94 | 0 | Earnings FY1 | Earnings FY2 | Earnings FY3 | |||||||||||||||||||
| Profit and Loss | 13 | 3040 | Profit and Loss | |||||||||||||||||||||
| Loan Funds | Secured Loans | 0 | 0 | |||||||||||||||||||||
| Liability | Long Term Liabilities | Long-term debt | 5 year Term Loan | |||||||||||||||||||||
| Unsecured Loans | 0 | 0 | ||||||||||||||||||||||
| Deferred taxes | Deferred income tax | |||||||||||||||||||||||
| Other | Loans from Directors | |||||||||||||||||||||||
| Total Sources of Funds | 114 | 3040 | ||||||||||||||||||||||
| Application of Funds | Fixed Assets | Original Costs | 71 | 0 | ||||||||||||||||||||
| Assets | Fixed Assets | Property, plant, and equipment | Land | Building | Vehicals | PCs/Mobiles | Softwares | Office Equip | Furniture | Machines | ||||||||||||||
| Intangible assets | Knowhow | Copyright | Trademark | Patent | ||||||||||||||||||||
| Less: Depreciation & Amortization | 25 | 0 | ||||||||||||||||||||||
| Liability | Depreciation | (Less accumulated depreciation) | Accumulated Depreciation | Accumulated Amortization | ||||||||||||||||||||
| Net book value | 46 | 0 | ||||||||||||||||||||||
| Assets | Add Capital-work-in process | 7 | 0 | Factory under construction | Office under construction | Software under development | ||||||||||||||||||
| Total Fixed Assets | 53 | 0 | ||||||||||||||||||||||
| Investment | Long-term investments | 5 | 0 | 3 Year Mutual Fund | ||||||||||||||||||||
| Assets | Long-term investments | |||||||||||||||||||||||
| Deffered Tax Assets | Misc. Expenses (Other Assets) | 1 | 0 | Deferred Tax Liability | ||||||||||||||||||||
| Assets | Misc. Expenses (Other Assets) | |||||||||||||||||||||||
| Current Assets, Loans & Advances | Inventories | 0 | 0 | |||||||||||||||||||||
| Assets | Current Assets | Stock in Hand | FG Stock | WIP Stock | RM Stock | |||||||||||||||||||
| Sundry Debtors | 18 | 1480 | ||||||||||||||||||||||
| Accounts receivable | Customer 1 | Customer 2 | Customer 3 | Customer 4 | Customer 5 | Customer6 | Customer7 | Customer8 | ||||||||||||||||
| Cash & Bank Balances | 14 | 2500 | ||||||||||||||||||||||
| Bank/Cash | Cash on Hand | Bank1 | Bank2 | Bank3 | ||||||||||||||||||||
| Loans & Advances | 38 | 0 | ||||||||||||||||||||||
| Short-term investments | 3 month FD | 1 year FD | EMPLOYEE LOAN | |||||||||||||||||||||
| Prepaid expenses | Advances to Suppliers | |||||||||||||||||||||||
| Total Current Assets | 70 | 3980 | ||||||||||||||||||||||
| Less: Current Liabilities | Sundry Creditors | 3 | 50 | |||||||||||||||||||||
| Liability | Current Liability | Accounts payable | 190 | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 3 | Supplier 4 | Supplier 5 | |||||||||||||||
| Credit Balance | ||||||||||||||||||||||||
| Short-term loans | Bank OD | |||||||||||||||||||||||
| Accrued salaries and wages | Leave Encash | Bonuses | Security Deposit | Accrued Salary | ||||||||||||||||||||
| Unearned revenue | Refund to customer | |||||||||||||||||||||||
| Current portion of long-term debt | Current portion of long-term debt | |||||||||||||||||||||||
| Duties & Taxes | ||||||||||||||||||||||||
| Taxes payable | 0 | 50 | VAT 5% | VAT 15% | ST 0% | ST 12% | CST | HS Edu Cess | S Edu Cess | PLA | RG23 A | RG23 C | TDS | FBT | ||||||||||
| Less: Provisions | Provisions | 10 | ||||||||||||||||||||||
| Liability | Provisions | Provisions for unpaid taxes | 12 | 0 | VAT Provisions | ExciseDuty Provisions | TDS Provisions | FBT Provisions | CST Provisions | ST Provisions | IT Provisions | |||||||||||||
| Provisions for suppliers | 0 | 0 | Supplier Controlling | Freight Controlling | ||||||||||||||||||||
| Total Current Liabilities | 15 | 300 | ||||||||||||||||||||||
| Net current Assets | Total Working Capital | 55 | 3680 | |||||||||||||||||||||
| Total Application of Funds | 114 | 3680 | ||||||||||||||||||||||
| Common Financial Ratios | ||||||||||||||||||||||||
| Debt Ratio (Total Liabilities / Total Assets) | Accounts in bold indicates it needs to be created in ERP, others are pre-defined in ERP. | |||||||||||||||||||||||
| Current Ratio (Current Assets / Current Liabilities) | ||||||||||||||||||||||||
| Working Capital (Current Assets - Current Liabilities) | ||||||||||||||||||||||||
| Assets-to-Equity Ratio (Total Assets / Owner's Equity) | ||||||||||||||||||||||||
| Debt-to-Equity Ratio (Total Liabilities / Owner's Equity) | ||||||||||||||||||||||||
| 3380 | ||||||||||||||||||||||||