final account statements from tally.erp 9 | tally downloads | tally amc | tally.net services
DESCRIPTION
For more information about this link. Please visit http://www.tallyspot.com (or) contuct +91-9025294445Ideal spot for a obtain Tally 9 ERP and download free Tally.ERP 9 versions. Up-grade Tally Accounting Software & .NET Subscription, Advanced Web Interface Accounting Software for Asia & Most ERP Software Products. Import data from tally & Data Connectivity to Tally.ERP 9 Import.TRANSCRIPT
Final Account Statements from Tally.ERP 9
The information contained in this document represents the current view of Tally Solutions Pvt. Ltd., (‘Tally’ in short) on the topics discussed as of the date of publication. Because Tally must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Tally, and Tally cannot guarantee the accuracy of any information presented after the date of publication.
This document is for informational purposes only. TALLY MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form, by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Tally Solutions Pvt. Ltd.
Tally may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written licence agreement from Tally, the furnishing of this document does not give you any licence to these patents, trademarks, copyrights, or other intellectual property.
© 2011 Tally Solutions Pvt. Ltd. All rights reserved.
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Shoper, Shoper 9, Shoper POS, Shoper HO, Shoper 9 POS, Shoper 9 HO, TallyDeveloper, Tally Developer, Tally.Developer 9, Tally.NET, Tally Development Environment, Tally Extender, Tally Integrator, Tally Integrated Network, Tally Service Partner, TallyAcademy & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
Version: Final Account Statements from Tally.ERP 9/Version 1.0/November 2011
Contents
Contents
1. Balance Sheet1.1 Horizontal Balance Sheet with Percentage/Working Capital ........................................................... 1
1.2 Comparative Balance Sheet – Monthly ............................................................................................ 3
2. Profit and Loss Account2.1 Vertical Profit and Loss Account ...................................................................................................... 4
2.2 Comparative Profit & Loss Account – Monthly ...............................................................................6
3. Ratio Analysis3.1 Ratio Analysis ................................................................................................................................... 7
4. Trial Balance 4.1 Trial Balance ..................................................................................................................................... 9
5. Outstandings5.1 Bills Receivable .............................................................................................................................. 11
5.2 Agewise Bills Receivable ............................................................................................................... 13
5.3 Bills Payable ................................................................................................................................... 15
5.4 Ledger Outstandings ....................................................................................................................... 17
5.5 Group Outstanding .......................................................................................................................... 19
5.6 Group Outstanding – Party-wise ..................................................................................................... 22
6. Cash Flow Summary6.1 Cash Flow Summary ....................................................................................................................... 23
7. Cash Flow Projection7.1 Cash Flow Projection ...................................................................................................................... 24
8. Exception Reports8.1 Overdue Receivables ..................................................................................................................... 26
8.2 Overdue Payables ........................................................................................................................... 28
9. Accounting Registers and Reports9.1 Cost Category Summary ................................................................................................................. 30
9.2 Sales Register .................................................................................................................................. 31
9.3 Job Work Analysis .......................................................................................................................... 32
9.4 POS Register ................................................................................................................................... 33
9.5 Bank Reconciliation Statement ....................................................................................................... 33
9.6 Ledger Vouchers Report Involving Foreign Currency ................................................................... 34
10. Inventory Registers and Reports10.1 Stock Summary .............................................................................................................................35
10.2 Godown Summary – Total ............................................................................................................36
10.3 Stock Summary – Gross Profit ..................................................................................................... 37
10.4 Purchase Order .............................................................................................................................. 38
10.5 Purchase Voucher ......................................................................................................................... 40
i
Contents
10.6 Sales Order .................................................................................................................................... 42
10.7 Sales Invoice with Multiple Items ............................................................................................... 44
10.8 Sales Invoice in Foreign Currency ................................................................................................ 46
10.9 Purchase Order (Due Only) .......................................................................................................... 47
10.10 Sales Orders (Due Only) ............................................................................................................. 48
10.11 Purchase Bills Pending .............................................................................................................. 50
10.12 Stock Query ................................................................................................................................ 51
10.13 Stock Ageing Analysis ................................................................................................................ 52
10.14 Price List .................................................................................................................................... 54
10.15 Reorder Status .............................................................................................................................55
10.16 Stock Item Register with Profit .................................................................................................. 56
11. Payroll Reports 11.1 Pay Sheet ....................................................................................................................................... 57
11.2 Pay Slips – Multiple Employees ................................................................................................... 57
11.3 SIF Records ................................................................................................................................... 59
11.4 Expat Reports ................................................................................................................................ 6011.4.1 Passport Expiry ..................................................................................................................................... 60
11.4.2 Visa Expiry ............................................................................................................................................. 60
11.4.3 Contract Expiry ..................................................................................................................................... 61
ii
Contents
ــــات محتوي
ـــــة .1 ـــــة العمومي ..................................................................................................................... الميزاني 1.............................................................................................................. حســــاب األربــــاح والخســــائر .2 4........................................................................................................................... تحليــــــل النســــــبة .3 7ميزان مـراجع .4 ................................................................................................................................. 9مســـــتحقات .5 ................................................................................................................................... 11
الفواتــــــــير مســــــــتحقة للتحصــــــــيل 5.1 .......................................................................................................11
ـــــر 5.2 ـــــتحقة حســـــب العم ـــــير المس 13.................................................................................................... الفوات
15......................................................................................................... الفواتــــــــير مســــــــتحقة للتســــــــديد 5.3
ــدد 5.4 ــير مس 17.............................................................................................................................. حســاب غ
19.......................................................................................................... المجموعـــة الحســـابات غـــير مســـدد 5.5
ــــدي .6 ــــدفق النق ................................................................................................................. ملخــــص ت 23ـــــقاط .7 ـــــدي اإلس ـــــدفق النق ............................................................................................................ الت 24ـــــــارير إســـــــتثناء .8 ..................................................................................................................... تق 26
ــأخرات مــن العمــالء 8.1 26.......................................................................................................................... مت
ــــأخرات للمــــوردين 8.2 28.......................................................................................................................... مت
ـــــارير .9 ـــــابات و تق ـــــاتر حس ......................................................................................................... دف 30ـــــة 9.1 ـــــة الفئ ـــــص تكلف 30...................................................................................................................... ملخ
ــــــات 9.2 ــــــتر المبيع 31.............................................................................................................................. دف
33............................................................................................................................. دفـــــتر نقـــــاط بيـــــع 9.4
ــــف 9.5 ــــك المصــــالحة كش 33.................................................................................................................... البن
ــــارير .10 ــــزون و تف ــــاتر مخ ......................................................................................................... دف 3535................................................................................................................................ موجـــز بضـــائع 10.1
خزون 10.2 ــالي– موجز الم إجم ...................................................................................................................36
37.................................................................................................... موجــــز البضــــائع - إجمــــالي الــــربح 10.3
شراء 10.4 مر 38......................................................................................................................................... أ
ـــراء 10.5 ـــيمة ش 40.................................................................................................................................. قس
42......................................................................................................................................... أمـــر بيـــع 10.6
44.............................................................................................. فــــاتورة مبيعــــات مــــع متعــــدد األصــــناف 10.7
47..................................................................................................................... أوامــر شــراء - مســـتحقة 10.9
48.................................................................................................................... أوامــــر بيــــع - مســــتحقة 10.10
ــــم صــــدرت 10.11 ــــتريات - ل ــــير مش 50................................................................................................... فوات
51.......................................................................................................................... معلومـــات الصـــنف 10.12
ــــر 10.13 ــــل البضــــاعة حســــب العم 52...................................................................................................... تحلي
54.............................................................................................................................. عــرض األســعار 10.14
ــة أعــاد الطلــب 10.15 55............................................................................................................................ حال
56............................................................................................................ دفــــتر األصــــناف مــــع الــــربح 10.16
iii
Contents
ـــــب .11 ـــــارير الروات .................................................................................................................... تق 5757.............................................................................................................................. قســـــيمة الراتـــــب 11.1
متعـــــدد المـــــوظفين– كشــــوف الرواتــــب 11.2 ...............................................................................................57
ــــــوظفين األجنبيــــــة 11.4 ــــــارير الم 60....................................................................................................... تقـــي 11.4.1 ـــاء ف ـــفر إنتھ ـــواز الس ج .......................................................................................................................... 60
ــــي 11.4.2 ــــاء ف ــــيرة إنتھ ................................................................................................................................ تأش 60
ـــي 11.4.3 ـــاء ف ـــد إنتھ ...................................................................................................................................... عق 61
iv
1. Balance Sheet الميزانيـــــة العموميـــــة
1.1 Horizontal Balance Sheet with Percentage/Working Capital
Go to Gateway of Tally > Balance Sheet > press F12 and set 'Show Percentages' and 'Show Working Capital figures' to 'Yes' > press Alt+F1
Figure 1.1 Horizontal Balance Sheet with Percentage/Working Capital
1
Balance Sheet
Figure 1.2 Horizontal Balance Sheet with Percentage/Working Capital – Arabic
2
Balance Sheet
1.2 Comparative Balance Sheet – Monthly
In detailed Balance Sheet, press F2 and change period from 1-1-2011 to 31-1-2011 > press C: New Column button (Alt+C) and set period from 1-2-2011 to 28-2-2011 for comparison
Figure 1.3 Comparative Balance Sheet – Monthly (Page 1)
Figure 1.4 Comparative Balance Sheet – Monthly (Page 2)
3
2. Profit and Loss Account حســـاب األربـــاح والخســـائر
2.1 Vertical Profit and Loss Account
Go to Gateway of Tally > Profit & Loss A/c > Press F12 and set 'Show Vertical Profit & Lossto 'Yes' > press Alt+F1
Figure 2.1 Vertical Profit and Loss Account
4
Profit and Loss Account
Figure 2.2 Vertical Profit and Loss Account – Arabic
5
Profit and Loss Account
2.2 Comparative Profit & Loss Account – Monthly
In detailed Profit & Loss Account press F2 and change period from 1-1-2011 to 31-1-2011 > press C: New Column button (Alt+C) and set period from 1-2-2011 to 28-2-2011 for comparison
Figure 2.3 Comparative Profit & Loss Account – Monthly (Page 1)
Figure 2.4 Comparative Profit & Loss Account – Monthly (Page 2)
6
3. Ratio Analysis تحليــــــل النســــــبة
3.1 Ratio Analysis تحليــــــل النســــــبة
Go to Gateway of Tally > Ratio Analysis
Figure 3.1 Ratio Analysis
7
Ratio Analysis
Figure 3.2 Ratio Analysis – Arabic
8
4. Trial Balance مـيزان مـراجع
4.1 Trial Balance مراجع ميزان
Go to Gateway of Tally > Display > Trial Balance > Press Alt+F1
Figure 4.1 Trial Balance Detailed
9
Trial Balance
Figure 4.2 Trial Balance Detailed – Arabic
10
5. Outstandings ـــــتحقات مس
5.1 Bills Receivable ـــــــير مســـــــتحقة للتحصـــــــيل الفوات
Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Receivables (select All Items or the required group)
Figure 5.1 Bills Receivable
11
Outstandings
Figure 5.2 Bills Receivable – Arabic
12
Outstandings
5.2 Agewise Bills Receivable الفواتــــير المســـــتحقة حســـــب العمـــــر
Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Receivables (select All Items or the required group) > press F6 and select Ageing by Due Date and specify the slabs. Press F12 and set the option Include Post-Dated Transactions to Yes.
Figure 5.3 Agewise Bills Receivable
13
Outstandings
Figure 5.4 Agewise Bills Receivable – Arabic
14
Outstandings
5.3 Bills Payable ـــــــير مســـــــتحقة للتســـــــديد الفوات
Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Payables(select All Items or the required group)
Figure 5.5 Bills Payable
15
Outstandings
Figure 5.6 Bills Payable – Arabic
16
Outstandings
5.4 Ledger Outstandings حســاب غــير مســدد
Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Ledger (select the appropriate Ledger) > press Alt+F1
Figure 5.7 Ledger Outstandings
17
Outstandings
Figure 5.8 Ledger Outstandings – Arabic
18
Outstandings
5.5 Group Outstanding المجموعــة الحســابات غـــير مســـدد
Go to Gateway of Tally > Multi Account Printing > Outstanding Statements > Ledger > Group of Accounts > select Sundry Debtors > In Printing Ledger Outstanding screen set Show Group Name to Yes and Start fresh page for each Account to No
Figure 5.9 Group Outstanding (Page 1)
19
Outstandings
Figure 5.10 Group Outstanding (Page 2)
20
Outstandings
Figure 5.11 Group Outstanding (Page 1) – Arabic
21
Outstandings
Figure 5.12 Group Outstanding (Page 2) – Arabic
5.6 Group Outstanding – Party-wise
Go to Gateway of Tally > Multi Account Printing > Outstanding Statements > Ledger > Group of Accounts > select Sundry Debtors > In Printing Ledger Outstanding screen set Show Group Name to No and Start fresh page for each Account to Yes
Figure 5.13 Group Outstanding – Party-wise
Figure 5.14 Group Outstanding – Party-wise
22
6. Cash Flow Summary ملخــــص تــــدفق النقــــدي
6.1 Cash Flow Summary ملخــــص تــــدفق النقــــدي
Go to Gateway of Tally > Display > Cash/Funds Flow > Cash Flow (Select the required month or press F2 and specify the required period)
Figure 6.1 Cash Flow Summary
Figure 6.2 Cash Flow Summary – Arabic
23
7. Cash Flow Projection التـــــدفق النقـــــدي اإلســـــقاط
7.1 Cash Flow Projection التـــــدفق النقـــــدي اإلســـــقاط
Go to Gateway of Tally > Display > Cash/Funds Flow > Cash Flow Projection (Press F2 and select the required projection period. Press Alt+F1 for Detailed)
Figure 7.1 Cash Flow Projection Report (Page 1)
Figure 7.2 Cash Flow Projection Report (Page 2)
24
Cash Flow Projection
Figure 7.3 Cash Flow Projection Report (Page 1) – Arabic
Figure 7.4 Cash Flow Projection Report (Page 2) – Arabic
25
8. Exception Reports تقــــــارير إســــــتثناء
8.1 Overdue Receivables متــأخرات مــن العمــالء
Go to Gateway of Tally > Display > Exception Reports > Overdue Receivables
Figure 8.1 Overdue Receivables
26
Exception Reports
Figure 8.2 Overdue Receivables – Arabic
27
Exception Reports
8.2 Overdue Payables ـــوردين ـــأخرات للم مت
Go to Gateway of Tally > Display > Exception Reports > Overdue Payables
Figure 8.3 Overdue Payables
28
Exception Reports
Figure 8.4 Overdue Payables – Arabic
29
9. Accounting Registers and Reports دفـــــاتر حســـــابات و تقـــــارير
9.1 Cost Category Summary ملخــــص تكلفــــة الفئــــة
Go to Gateway of Tally > Display > Statement of Accounts > Cost Centres > Category Summary
Figure 9.1 Cost Category Summary
30
Accounting Registers and Reports
Figure 9.2 Cost Category Summary
9.2 Sales Register ـــــات ـــــتر المبيع دف
Go to Gateway of Tally > Display > Account Books > Sales Register > press F7
Figure 9.3 Sales Register
31
Accounting Registers and Reports
Figure 9.4 Sales Register – Arabic
9.3 Job Work AnalysisGo to Gateway of Tally > Display > Statement of Accounts > Job Work Analysis
Figure 9.5 Job Work Analysis
32
Accounting Registers and Reports
9.4 POS Register ــــع ــــاط بي ــــتر نق دف
Go to Gateway of Tally > Display > Account Books > POS Register
Figure 9.6 POS Register
9.5 Bank Reconciliation Statement البنــــك المصــــالحة كشــــف
Go to Gateway of Tally > Banking > Bank Reconciliation > Select the required bank ledger > enter the Bank Date
Figure 9.7 Bank Reconciliation Statement
33
Accounting Registers and Reports
9.6 Ledger Vouchers Report Involving Foreign Currency
Go to Gateway of Tally > Display > Account Books > Ledger > Select the Ledger
Figure 9.8 Ledger Voucher Report Involving Foreign Currency
34
10. Inventory Registers and Reports دفــــاتر مخــــزون و تفــــارير
10.1 Stock Summary ـــائع ـــز بض موج
Go to Gateway of Tally > Stock Summary > press F12 and set Show Opening Balance, Show Goods Inwards, Goods Outwards, Closing Balance and Expand all levels in Detailed Format to 'Yes'
Figure 10.1 Stock Summary
35
Inventory Registers and Reports
10.2 Godown Summary – Total إجمــالي– موجز المخــزون
Go to Gateway of Tally > Display > Statement of Inventory > Godowns > select Main Location, press C: New Column button (Al+C), enter the period, select another godown, press F12 and set Show Total Column to ‘Yes’
Figure 10.2 Godown Summary
36
Inventory Registers and Reports
10.3 Stock Summary – Gross Profit ـــربح ـــالي ال ـــائع - إجم ـــز البض موج
Go to Gateway of Tally > Stock Summary > press F12 and set Show Goods Outwards, Closing Balance and Expand all levels in Detailed Format to 'Yes' > press F7
Figure 10.3 Stock Summary with Profit (Page 1)
Figure 10.4 Stock Summary with Profit (Page 2)
37
Inventory Registers and Reports
10.4 Purchase Order أمر شــراء
Go to Gateway of Tally > Order Vouchers > press Alt+F4
Figure 10.5 Purchase Order
38
Inventory Registers and Reports
Figure 10.6 Purchase Order – Arabic
39
Inventory Registers and Reports
10.5 Purchase Voucher قســـيمة شـــراء
Go to Gateway of Tally > Accounting Vouchers > press F9
Figure 10.7 Purchase Invoice
40
Inventory Registers and Reports
Figure 10.8 Purchase Invoice – Arabic
41
Inventory Registers and Reports
10.6 Sales Order أمــر بيــع
Go to Gateway of Tally > Order Vouchers > press Alt+F5
Figure 10.9 Sales Order
42
Inventory Registers and Reports
Figure 10.10 Sales Order – Arabic
43
Inventory Registers and Reports
10.7 Sales Invoice with Multiple Items فـــاتورة مبيعـــات مـــع متعـــدد األصـــناف
Go to Gateway of Tally > Accounting Vouchers > press F8 > (press F12 and set 'Use Common Ledger A/c for Item Allocation' to 'No')
Figure 10.11 Sales Invoice with Multiple Items
44
Inventory Registers and Reports
Figure 10.12 Sales Invoice with Multiple Items – Arabic
45
Inventory Registers and Reports
10.8 Sales Invoice in Foreign Currency
Go to Gateway of Tally > Accounting Vouchers > press F8 > (press F12 and set 'Use Common Ledger A/c for Item Allocation' to 'No')
Figure 10.13 Sales Invoice using Foreign Currency
46
Inventory Registers and Reports
10.9 Purchase Order (Due Only) أوامــر شــراء - مســتحقة
Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > All Orders
Figure 10.14 Purchase Orders (Due Only)
Figure 10.15 Purchase Orders (Due Only) – Arabic
47
Inventory Registers and Reports
10.10 Sales Orders (Due Only) ـــتحقة ـــع - مس ـــر بي أوام
Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > All Orders
Figure 10.16 Sales Orders (Due Only)
48
Inventory Registers and Reports
Figure 10.17 Sales Orders (Due Only) – Arabic
49
Inventory Registers and Reports
10.11 Purchase Bills Pending ــــم صــــدرت ــــير مشــــتريات - ل فوات
Go to Gateway of Tally > Display > Statements of Inventory > Purchase Bills Pending
Figure 10.18 Purchase Bills Pending
Figure 10.19 Purchase Bills Pending – Arabic
50
Inventory Registers and Reports
10.12 Stock Query ـــات الصـــنف معلوم
Go to Gateway of Tally > Display > Statements of Inventory > Stock Query (select the required Stock Item and press Enter)
Figure 10.20 Stock Query
51
Inventory Registers and Reports
10.13 Stock Ageing Analysis تحليــــل البضــــاعة حســــب العمــــر
Go to Gateway of Tally > Display > Inventory Books > Ageing Analysis (select 'Primary' or the required Stock Group and press Enter)
Figure 10.21 Stock Ageing Analysis (Page 1)
52
Inventory Registers and Reports
Figure 10.22 Stock Ageing Analysis (Page 2)
53
Inventory Registers and Reports
10.14 Price List عــرض األســعار
Go to Gateway of Tally > Inventory Info. > Price List (Select 'All Items' or the required Stock Group and press Enter)
Figure 10.23 Price List
54
Inventory Registers and Reports
10.15 Reorder Status عاد الطلـب لة أ حا
Go to Gateway of Tally > Display > Statements of Inventory > Reorder Status (Select 'Primary' or the required Stock Group and press Enter)
Figure 10.24 Reorder Status
55
Inventory Registers and Reports
10.16 Stock Item Register with Profit ـــربح ـــع ال ـــناف م ـــتر األص دف
Go to Gateway of Tally > Display > Inventory Books > Stock Item > select Volume Change Gauge - VCG-01 > Stock Item Monthly Summary > select the month > Stock Vouchers >press F12 and set Show Consumption & Gross Profit for Outwards to Yes
Figure 10.25 Item Register with Profit
56
11. Payroll Reports تقـــــارير الرواتـــــب
11.1 Pay Sheet ــــب ــــيمة الرات قس
Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Sheet (Select 'All Items' or the required Employee/Employee Group and press Enter)
Figure 11.1 Pay Sheet
11.2 Pay Slips – Multiple Employees ـــب ـــوف الروات ــــوظفين– كش ــــدد الم متع
Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Slip > Multi Pay Slip (Select 'All Items' or the required Employee/Employee Group and press Enter)
Figure 11.2 Pay Slip – Employee 1
57
Payroll Reports
Figure 11.3 Pay Slip – Employee 2
Figure 11.4 Pay Slip – Employee 3
58
Payroll Reports
Figure 11.5 Pay Slip – Arabic
11.3 SIF Records
Go to Gateway of Tally > Display > Payroll Reports > SIF Records
Figure 11.6 SIF Records
59
Payroll Reports
11.4 Expat Reports ــــــة تقــــــارير المــــــوظفين األجنبي
11.4.1 Passport Expiry ـــي ـــاء ف جـــواز الســـفر إنتھ
Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Passport Expiry
Figure 11.7 Passport Expiry Report
11.4.2 Visa Expiry ــــي تأشــــيرة إنتھــــاء ف
Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Visa Expiry
Figure 11.8 Visa Expiry Report
60
Payroll Reports
11.4.3 Contract Expiry عقـــد إنتھـــاء فـــي
Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Contract Expiry
Figure 11.9 Contract Expiry Report
61