Tally ERP 9 for Marble Granite Dealers Tally
Tally. ERP 9 for Marble & Granite Dealers © Tally Solutions Pvt. Ltd. All Rights Reserved
Agenda • Marble & Granite – An Overview • Structure of Marble & Granite Dealer Operations • Tally. ERP 9 for Marble & Granite Dealers • Primary Requirement • Tally. ERP 9 – Fitment © Tally Solutions Pvt. Ltd. All Rights Reserved 2
Structure of Marble & Granite Dealer Operations Marble & Granite Moulding Calculations Billing © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Accounts & Payroll 3
Marble & Granite – An Overview © Tally Solutions Pvt. Ltd. All Rights Reserved 4
Marble & Granite - Moulding Calculations Marble & Granite Moulding Calculations Billing © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Accounts & Payroll 5
Primary Requirement – Moulding Calculations Category / Module Moulding Calculations Major Requirement Explanation Area calculations Automatic calculations are very useful for dealers. To take care of wastage and losses due to small width (non saleable) pieces left, this industry has typical method of billing. The selling Rate is mostly Rs. per sft. , however calculations of area is done after rounding off the length and width to nearest 1 inch or 3 inch or 6 inch on higher side. Moulding details in invoices After cutting the stone to the required size, there further operations like grooving, edge polishing, double polishing, format cutting etc. These calculations are done on Running Foot basis i. e. depends upon length and width. It is necessary to add these details in invoices for better clarity. © Tally Solutions Pvt. Ltd. All Rights Reserved 6
Tally. ERP 9 Fitment – Moulding Calculations SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Area calculations as per the mould type 2 Units of measurements Yes 3 Rounding off of measurements Yes 4 Slab table with slab options Yes 5 Moulding types in invoice Yes 6 Moulding description in invoice Yes 7 Moulding calculations adjusting rounding Yes 8 Rounding adjustment 9 Machinery masters Yes 10 Length, width along with total area details in invoice Yes 11 Moulding rates in invoice Yes 12 VAT excluding moulding charges Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes 7
Marble & Granite- Billing Marble & Granite Moulding Calculations Billing © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Accounts & Payroll 8
Primary Requirement – Billing Category / Module Billing Major Requirement Explanation Contractor management Several contractors are involved in sales processes. The details of the contractor are to be captured for tracking the contribution from each contractor. In many cases contractor payments are made without rounding off. Marble-granite billing Invoices should be detailed, explaining the moulding costs, dimensions of granite or marble slabs, or tile numbers, adding VAT and service tax © Tally Solutions Pvt. Ltd. All Rights Reserved 9
Tally. ERP 9 Fitment – Billing SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Contractor details management Yes 2 Contractor information in invoice Yes 3 Contractor payments – without rounding Yes 4 Tiles billing Yes 5 Order management Yes 6 Quotation management Yes 7 Marble-Granite sales order with moulding options Yes 8 Marble-Granite sales invoice with moulding options Yes 9 Marble-Granite delivery note with moulding options Yes 10 Marble-Granite GRN with moulding options Yes 11 Purchase bills Yes 12 Shipment details Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Contd. . 10
Tally. ERP 9 Fitment – Billing SL No. Requirement Part of Tally. ERP 9 Part of Solution 13 Marble allotment to contracts Yes 14 Marble export report Yes 15 Consignment delivery Yes 16 Bill wise details Yes 17 Order tracking using tracking numbers Yes 18 Optional vouchers Yes 19 Reorder levels Yes 20 Bank deposit slips Yes 21 Price levels and price lists Yes 22 Godown details in bills Yes 23 Job work and job costing Yes 24 Batch details Yes © Tally Solutions Pvt. Ltd. All Rights Reserved 11
Marble & Granite – Accounts & Payroll Marble & Granite Moulding Calculations Billing © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Accounts & Payroll 12
Primary Requirement – Accounts and Payroll Category / Module Accounts Management Major Requirement Explanation Statement of accounts Balance sheet, profit and loss statements in schedule VI format, trial balance are needed for the management to track the profitability and expenses. Auditing – direct and remote Annual auditing is an important factor. Dealers can get their accounts audited against declared details Branch Management More than one branches are found in different cities, states & countries. It is important to track the profitability individually and as group of companies. Remote access and SMS All the company details can be accessed from anywhere, at anytime. Details are also retrievable from mobile phones. Revised schedule VI provides more flexibility and ease of reporting as per international standards © Tally Solutions Pvt. Ltd. All Rights Reserved 13
Tally. ERP 9 Fitment – Accounts and Payroll SL No. Requirement Part of Tally. ERP 9 1 Balance sheet – Schedule VI Yes 2 Profit and loss statement – Schedule VI Yes 3 Daily receipts and payments Yes 4 Multiple payment mode handling Yes 5 Stock summery report Yes 6 Branch wise reports 7 Staff database handling Yes 8 Outstanding receivable and payable Yes 9 Trial balance Yes 10 Multiple cheque payment option Yes 11 Reminder letter, e-mails 12 Company grouping (branch companies) © Tally Solutions Pvt. Ltd. All Rights Reserved Part of Solution Yes Yes Contd. . 14
Tally. ERP 9 Fitment – Accounts and Payroll SL No. Requirement Part of Tally. ERP 9 13 Payroll management for company staff Yes 14 Employee attendance and leaves Yes 15 Employee cost tracking Yes 16 Employee income tax and e-return Yes 17 Branch transfer management Yes 18 Branch synchronization Yes 19 Branch-wise revenue management Yes 20 Branch-wise cost tracking Yes 21 Cash flow, fund flow statements Yes 22 Ageing analysis of receivables, debtor wise Yes 23 Scenario management Yes 24 Ratio analysis Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Part of Solution Contd. . 15
Tally. ERP 9 Fitment – Accounts and Payroll SL No. Requirement Part of Tally. ERP 9 25 Interest calculation Yes 26 Remote auditing Yes 27 Foreign currency handling Yes 28 Budget and variance Yes 29 Bank reconciliation Yes 30 Remote access Yes 31 Export invoices with marble granite options 32 Security Yes 33 User access level , Authentication Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Part of Solution Yes 16
Marble & Granite- Billing Marble & Granite Moulding Calculations Billing © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Accounts & Payroll 17
Primary Requirement – MIS Reports Category / Module MIS Reports Major Requirement Explanation Contractor wise reports It is important to track how much business was done through different contractors. This will help the dealers to also focus on large contractors. Sales analysis reports To understand the past performance of the company, management can see the sales performance bases on period, customer/ customer group, item/ item group. Machine wise reports To understand how many slabs of marble/granites were readied by what machines. This would help the management to plan machine utilization better. © Tally Solutions Pvt. Ltd. All Rights Reserved 18
Tally. ERP 9 Fitment – MIS Reports SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Contractor wise reports Yes 2 Machine wise reports Yes 3 Sales analysis Yes 4 Machine wise expense reports Yes 5 Profitability reports Yes 6 Expenditure reports Yes 7 Outstanding summary Yes 8 Top selling product Yes 9 Labour contract reports Yes 10 Cash flow and fund flow statements © Tally Solutions Pvt. Ltd. All Rights Reserved Yes 19
Thank You For any queries, write to us : ti@tallysolutions. com To find out more, visit : http: //www. tallysolutions. com/website/html/solutions/segment-vertical-solutions. php © Tally Solutions Pvt. Ltd. All Rights Reserved
- Slides: 20