Sample Reports in Tally.ERP 9

Sample Reports in 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, TallyDevel¬oper, Tally Developer, Tally.Developer 9, Tally.NET, Tally Development Environment, Tally Extender, Tally Integrator, Tally Inte¬grated 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: Sample Reports in Tally.ERP 9/ Release 3.0/Mar 2011

Contents

Contents 1. Financial Statements and Reports 1.1 Vertical Balance Sheet ...................................................................................................................... 1 1.2 Vertical Balance Sheet with Working Capital .................................................................................. 2 1.3 Horizontal Balance Sheet .................................................................................................................. 3 1.4 Horizontal Balance Sheet with Percentage/Working Capital ........................................................... 4 1.5 Comparative Quarterly Balance Sheet .............................................................................................. 5 1.6 Comparative Half yearly Balance Sheet ........................................................................................... 6 1.7 Comparative Yearly Balance Sheet .................................................................................................. 7 1.8 Vertical Profit and Loss Account ...................................................................................................... 8 1.9 Horizontal Profit and Loss Account ................................................................................................. 9 1.10 Income and Expenditure Statement .............................................................................................. 10 1.11 Comparative Profit and Loss Account .......................................................................................... 11 1.12 Receipts and Payments Account ................................................................................................... 12 1.13 Vertical Receipts and Payments Account ..................................................................................... 13 1.14 Receipts and Payments Account with Nett Opening & Closing Balance ..................................... 14 1.15 Trial Balance ................................................................................................................................. 15 1.16 Ratio Analysis ............................................................................................................................... 17 1.17 Comparative Ratio Analysis ......................................................................................................... 18 1.18 Cash Flow Summary ..................................................................................................................... 19 1.19 Funds Flow Summary ................................................................................................................... 20 1.20 Cash Flow Projection .................................................................................................................... 21 1.21 Cash Flow Projection with Cash A/c, Scenarios & Overdues ...................................................... 22 1.22 Budgets ......................................................................................................................................... 23 1.23 Cost Category Summary ............................................................................................................... 24 1.24 Cost Centre BreakUp .................................................................................................................... 24 1.25 Ledger Cost BreakUp ................................................................................................................... 25 1.26 Group Cost BreakUp .................................................................................................................... 25 1.27 Stock Valuation Methods .............................................................................................................. 26 1.28 Daybook ........................................................................................................................................ 38 1.29 Scenario- Projected Half yearly Gross Profit ............................................................................... 40

2. Account Books and Registers 2.1 Ledger ............................................................................................................................................. 41 2.2 Cash Book ....................................................................................................................................... 42 2.3 Bank Book ...................................................................................................................................... 43 2.4 Multi- Column Cash Book .............................................................................................................. 44 2.5 Receipt Voucher ............................................................................................................................. 45 2.6 Payment Voucher ............................................................................................................................ 46

i

Contents

2.7 Purchase Register ............................................................................................................................ 47 2.8 Purchase Register - Columnar ........................................................................................................ 48 2.9 Purchase Register - Extract ............................................................................................................. 50 2.10 Sales Register ................................................................................................................................ 51 2.11 Sales Register - Columnar ............................................................................................................ 52 2.12 Sales Register - Extract ................................................................................................................. 54 2.13 Group Summary ............................................................................................................................ 55 2.14 Group Vouchers ............................................................................................................................ 56 2.15 Journal Register ............................................................................................................................ 58 2.16 Journal Register - Extract ............................................................................................................. 59 2.17 Bills Receivable ............................................................................................................................ 60 2.18 Bills Payable ................................................................................................................................. 61 2.19 Overdue Receivables .................................................................................................................... 62 2.20 Overdue Payables ......................................................................................................................... 63 2.21 Agewise Bills Receivable ............................................................................................................. 64 2.22 Negative Ledger ............................................................................................................................ 65 2.23 Debit Note Register ...................................................................................................................... 66 2.24 Credit Note Register ..................................................................................................................... 67 2.25 Memorandum Register ................................................................................................................. 68 2.26 Reversing Journal Register ........................................................................................................... 68 2.27 Optional Vouchers ........................................................................................................................ 69 2.28 Post-dated Vouchers ..................................................................................................................... 70 2.29 Interest Calculations ..................................................................................................................... 70 2.30 Confirmation Letter ...................................................................................................................... 71 2.31 Reminder Letter ............................................................................................................................ 72 2.32 Statistics ........................................................................................................................................ 73

3. Banking Reports 3.1 Bank Reconciliation Statement ....................................................................................................... 74 3.2 Bank Reconciliation Statement - Detailed ...................................................................................... 75 3.3 Deposit Slip ..................................................................................................................................... 76 3.4 Deposit Slip Report ......................................................................................................................... 77 3.5 Cheque Printing .............................................................................................................................. 77 3.6 Cheque Printing Report .................................................................................................................. 78 3.7 Payment Advice .............................................................................................................................. 79

4. Inventory Registers and Reports 4.1 Stock Summary ............................................................................................................................... 80 4.2 Stock Summary - Gross Profit ........................................................................................................ 81 4.3 Stock Category Summary ............................................................................................................... 82 4.4 Purchase Order ................................................................................................................................ 83 ii

Contents

4.5 Receipt Note ................................................................................................................................... 84 4.6 Purchase Voucher ........................................................................................................................... 85 4.7 Sales Order ...................................................................................................................................... 86 4.8 Delivery Note .................................................................................................................................. 87 4.9 Sales Invoice with Single Item ....................................................................................................... 88 4.10 Sales Invoice with Multiple Items ................................................................................................ 89 4.11 Rejections In Voucher .................................................................................................................. 90 4.12 Rejections Out Voucher ................................................................................................................ 91 4.13 Job Work In Order Voucher ......................................................................................................... 92 4.14 Material In Voucher (To Receive the Raw Materials from the Principal) ................................... 93 4.15 Material Out Voucher (To Deliver the Finished Goods to the Principal) .................................... 94 4.16 Job Work Out Order Voucher ....................................................................................................... 95 4.17 Material Out Voucher (To Send the Raw Materials to the Job Worker) ...................................... 96 4.18 Material In Voucher (To Receive the Finished Goods from the Job Worker) ............................. 97 4.19 Purchase Order Book .................................................................................................................... 98 4.20 Sales Order Book .......................................................................................................................... 99 4.21 Sales Order Book with Profit ........................................................................................................ 99 4.22 Purchase Order Stock Group Outstandings ................................................................................ 100 4.23 Purchase Order Stock Item Outstandings ................................................................................... 100 4.24 Purchase Order Group Outstandings .......................................................................................... 101 4.25 Purchase Order Ledger Outstandings ......................................................................................... 102 4.26 Purchase Order (Due Only) ........................................................................................................ 103 4.27 Sales Order Stock Group Outstandings ...................................................................................... 104 4.28 Sales Order Stock Item Outstandings ......................................................................................... 104 4.29 Sales Order Group Outstandings ................................................................................................ 105 4.30 Sales Order Ledger Outstandings ............................................................................................... 105 4.31 Sales Orders (Due Only) ............................................................................................................. 106 4.32 Sales Order with Pre-Closure Order Details ............................................................................... 107 4.33 Purchase Bills Pending ............................................................................................................... 108 4.34 Sales Bills Pending ..................................................................................................................... 109 4.35 Batch Report ............................................................................................................................... 109 4.36 Batch Summary ........................................................................................................................... 110 4.37 Batch Summary with Mfrg & Expiry Details ............................................................................. 110 4.38 Stock Query ................................................................................................................................ 111 4.39 Negative Stock ............................................................................................................................ 112 4.40 BOM - Cost Estimate .................................................................................................................. 112 4.41 Stock Group Cost Analysis ......................................................................................................... 113 4.42 Stock Item Cost Analysis ............................................................................................................ 113 4.43 Item Cost Track Break-up ........................................................................................................... 114 4.44 Item Movement Analysis ............................................................................................................ 115 4.45 Stock Ageing Analysis ................................................................................................................ 116 iii

Contents

4.46 Price List ..................................................................................................................................... 118 4.47 Stock Transfer Register .............................................................................................................. 119 4.48 Reorder Status ............................................................................................................................. 120

5. Job Work Registers and Reports 5.1 Job Orders Outstandings (Job Orders In) ..................................................................................... 121 5.2 Job Orders Details (Job Orders In) ............................................................................................... 121 5.3 Components Order Summary (Job Orders In) .............................................................................. 122 5.4 . Components Orders Details (Jobs Order In) ............................................................................... 122 5.5 Job Work In Orders Book ............................................................................................................. 123 5.6 Material Out Register (Job Orders In) .......................................................................................... 123 5.7 Material In Register (Job Orders In) ............................................................................................. 124 5.8 Material Movement Register ........................................................................................................ 124 5.9 Stock with Job Worker - Item-wise (Job Orders In) ..................................................................... 126 5.10 Stock with Job Worker - Party-wise (Job Orders In) .................................................................. 126 5.11 Stock Ageing Analysis (Job Orders In) ...................................................................................... 127 5.12 Issue Variance - Job Work In Analysis ...................................................................................... 128 5.13 Receipt Variance - Job Work In Analysis .................................................................................. 128 5.14 Job Orders Outstandings (Job Orders Out) ................................................................................. 129 5.15 Job Orders Details (Job Orders Out) ........................................................................................... 129 5.16 Components Order Summary (Job Orders Out) ......................................................................... 130 5.17 . Components Orders Details (Jobs Order Out) .......................................................................... 130 5.18 Job Work Out Orders Book ........................................................................................................ 131 5.19 Material Out Register (Job Orders Out) ..................................................................................... 132 5.20 Material In Register (Job Orders Out) ........................................................................................ 133 5.21 Material Movement Register ...................................................................................................... 134 5.22 Stock with Job Worker - Item-wise (Job Orders Out) ................................................................ 136 5.23 Stock with Job Worker - Party-wise (Job Orders Out) ............................................................... 136 5.24 Stock Ageing Analysis (Job Orders Out) ................................................................................... 137 5.25 Issue Variance - Job Work Out Analysis .................................................................................... 138 5.26 Receipt Variance - Job Work Out Analysis ................................................................................ 138 5.27 Stock Summary - Our Stock with Us and Third Party ............................................................... 139 5.28 Stock Summary - Our Stock and Third Party with Us ............................................................... 140 5.29 Stock Summary - Our Stock with Third Party ............................................................................ 140 5.30

Stock Summary - Our Stock with Us ......................................................................................... 141

5.31 Stock Summary - Third Party Stock with Us ............................................................................. 142

6. Job Costing Registers and Reports 6.1 Transfer Journal Voucher ............................................................................................................. 143 6.2 Consumption Journal Voucher ..................................................................................................... 144 6.3 Manufacturing Journal Voucher ................................................................................................... 145 iv

Contents

6.4 . Godown Summary - Transfer Status .......................................................................................... 146 6.5 Godown Summary - Consumption Status .................................................................................... 146 6.6 Godown Summary - Manufacturing Status .................................................................................. 147 6.7 Job Work Analysis - Building Bricks ........................................................................................... 147 6.8 Material Consumption Summary - Building Bricks ..................................................................... 148 6.9 Godown Summary - Building Bricks ........................................................................................... 148 6.10 Comparative Job Work Analysis Report .................................................................................... 149

7. POS Registers and Reports 7.1 Pos Invoice .................................................................................................................................... 151 7.2 POS Invoice - Multiple Sales Ledger ........................................................................................... 152 7.3 Cash Book ..................................................................................................................................... 153 7.4 Columnar Cash Book .................................................................................................................... 154 7.5 Sales Register ................................................................................................................................ 156 7.6 Columnar Sales Register ............................................................................................................... 157 7.7 Stock Item Summary .................................................................................................................... 159 7.8 Item Movement Analysis .............................................................................................................. 160

8. Value Added Tax Reports 8.1 Andhra Pradesh ............................................................................................................................. 161 8.2 Arunachal Pradesh ........................................................................................................................ 161 8.3 Assam ............................................................................................................................................ 161 8.4 Bihar .............................................................................................................................................. 161 8.5 Chandigarh .................................................................................................................................... 162 8.6 Chhattisgarh .................................................................................................................................. 162 8.7 Dadra and Nagar Haveli ............................................................................................................... 162 8.8 Daman and Diu ............................................................................................................................. 163 8.9 Delhi .............................................................................................................................................. 163 8.10 Goa .............................................................................................................................................. 163 8.11 Gujarat ........................................................................................................................................ 164 8.12 Haryana ....................................................................................................................................... 165 8.13 Himachal Pradesh ....................................................................................................................... 165 8.14 Jammu and Kashmir ................................................................................................................... 166 8.15 Jharkhand .................................................................................................................................... 166 8.16 Karnataka .................................................................................................................................... 166 8.17 Kerala .......................................................................................................................................... 167 8.18 Madhya Pradesh .......................................................................................................................... 167 8.19 Maharashtra ................................................................................................................................ 167 8.20 Manipur ....................................................................................................................................... 168 8.21 Meghalaya ................................................................................................................................... 168 8.22 Mizoram ...................................................................................................................................... 168 v

Contents

8.23 Orissa .......................................................................................................................................... 169 8.24 Puducherry .................................................................................................................................. 169 8.25 Punjab ......................................................................................................................................... 170 8.26 Rajasthan ..................................................................................................................................... 171 8.27 Sikkim ......................................................................................................................................... 171 8.28 Tamil Nadu ................................................................................................................................. 172 8.29 Tripura ........................................................................................................................................ 172 8.30 Uttar Pradesh ............................................................................................................................... 173 8.31 Uttarakhand ................................................................................................................................. 173 8.32 West Bengal ................................................................................................................................ 174

9. Service Tax Reports 9.1 GAR - 7 Challan ........................................................................................................................... 175 9.2 Service Tax Payable - Bill Date Wise .......................................................................................... 176 9.3 Service Tax Payable - Realisation Date Wise .............................................................................. 176 9.4 Service Tax Payable - Tax on Service Received .......................................................................... 177 9.5 Service Tax Payable - Import of Services .................................................................................... 177 9.6 Input Credit Summary .................................................................................................................. 178 9.7 ST 3 Report ................................................................................................................................... 179

10. Tax Collected at Source Reports 10.1 Form 27D .................................................................................................................................... 186 10.2 Form 27 B ................................................................................................................................... 187 10.3 ETCS Forms ............................................................................................................................... 188

11. Tax Deducted at Source Report 11.1 TDS Challan ............................................................................................................................... 189 11.2 TDS Computation ....................................................................................................................... 190 11.3 TDS Challan Reconciliation ....................................................................................................... 191 11.4 Form 16A .................................................................................................................................... 192 11.5 Form 26Q .................................................................................................................................... 193 11.6 Annexure to 26Q ......................................................................................................................... 195 11.7 Form 27Q .................................................................................................................................... 196 11.8 Annexure to 27Q ......................................................................................................................... 198 11.9 Form 26 ....................................................................................................................................... 199 11.10 Annexure to 26 .......................................................................................................................... 200 11.11 Form 27 ..................................................................................................................................... 201 11.12 Annexure to Form 27 ................................................................................................................ 202 11.13 Print Form 27A ......................................................................................................................... 203 11.14 E-TDS Returns .......................................................................................................................... 204

vi

Contents

11.15 TDS Payables ............................................................................................................................ 204 11.16 TDS Ledger Outstandings ........................................................................................................ 205 11.17 TDS Nature of Payment Outstandings ...................................................................................... 205 11.18 TDS Not Deducted .................................................................................................................... 206 11.19 PAN Not Available ................................................................................................................... 206 11.20 Unknown Deductee Type ......................................................................................................... 207

12. Excise for Dealer Reports 12.1 Excise Stock Register ................................................................................................................. 208 12.2 Excise Purchase Bill Register ..................................................................................................... 209 12.3 Party Wise Duty Extract ............................................................................................................. 210 12.4 Customs Clearance Register ....................................................................................................... 211 12.5 Sales and Purchase Extract ......................................................................................................... 212 12.6 Form RG 23D ............................................................................................................................. 214 12.7 Form RG 23D - Sales Bill Wise ................................................................................................. 215 12.8 Quarterly Returns - Form 2 ......................................................................................................... 216 12.9 E-Return ...................................................................................................................................... 217

13. Excise for Manufacturer Reports 13.1 Excise Computation.................................................................................................................... 218 13.2 Daily Stock Register ................................................................................................................... 219 13.3 PLA Register ............................................................................................................................... 220 13.4 Form ER 1 ................................................................................................................................... 221 13.5 Form ER - 5 ................................................................................................................................ 225 13.6 Form ER - 6 ................................................................................................................................ 226 13.7 E-Return ...................................................................................................................................... 227 13.8 Credit Summary .......................................................................................................................... 227 13.9 Credit Availed ............................................................................................................................. 228 13.10 RG 23 Part I .............................................................................................................................. 229 13.10.1 RG 23A Part I .................................................................................................................................... 229 13.10.2 RG 23C Part I .................................................................................................................................... 229

13.11 RG 23 Part II ............................................................................................................................. 230 13.11.1 RG 23A Part II ................................................................................................................................... 230 13.11.2 RG 23C Part II ................................................................................................................................... 230

13.12 Annexure – 10 ........................................................................................................................... 231 13.13 Abstract ..................................................................................................................................... 232

14. Payroll Registers and Reports 14.1 Payroll voucher ........................................................................................................................... 233 14.2 Attendance Voucher ................................................................................................................... 235 14.3 Pay Slip ....................................................................................................................................... 236

vii

Contents

14.4 Pay Sheet ..................................................................................................................................... 236 14.5 Payroll Statement ........................................................................................................................ 237 14.6 Payment Advice .......................................................................................................................... 238 14.7 Payroll Register ........................................................................................................................... 239 14.8 Employee Profile ........................................................................................................................ 241 14.9 Employee Pay Head Breakup ..................................................................................................... 242 14.10 Employee Head Count Report .................................................................................................. 243 14.11 Pay Head Employee BreakUp .................................................................................................. 244 14.12 Attendance Sheet ...................................................................................................................... 244 14.13 Attendance Register .................................................................................................................. 245 14.14 Gratuity Report ......................................................................................................................... 246 14.15 Passport Expiry Report ............................................................................................................. 246 14.16 Visa Expiry Report ................................................................................................................... 247 14.17 Contract Expiry Report ............................................................................................................. 247 14.18 Statutory Summary/Computation Report ................................................................................. 248 14.19 Provident Fund Form 5 ............................................................................................................. 249 14.20 Provident Fund Form 10 ........................................................................................................... 250 14.21 Provident Fund Form 12A ........................................................................................................ 251 14.22 Provident Fund Monthly Statement .......................................................................................... 252 14.23 Provident Fund Form 3A .......................................................................................................... 253 14.24 Provident Fund Form 6A .......................................................................................................... 254 14.25 ESI Monthly Statement ............................................................................................................. 256 14.26 ESI Form 3 ................................................................................................................................ 257 14.27 ESI Form 5 ................................................................................................................................ 258 14.28 ESI Form 6 ................................................................................................................................ 261 14.29 Professional Tax Computation Report ...................................................................................... 264 14.30 Professional Tax Monthly Statement ........................................................................................ 265 14.31 Income Tax Computation Report ............................................................................................. 266 14.32 Salary Projection Report ........................................................................................................... 267 14.33 Income Tax - Form 16 .............................................................................................................. 269 14.34 Income Tax - Form 12BA ......................................................................................................... 271 14.35 Form ITR - 1 ............................................................................................................................. 273 14.36 TDS Variance Report ................................................................................................................ 277

viii

1.

Financial Statements and Reports

1.1 Vertical Balance Sheet Go to Gateway of Tally > Balance Sheet > press F12 and set Show Vertical Balance Sheet to Yes.

Figure 1.1 Vertical Balance Sheet

1


1.2 Vertical Balance Sheet with Working Capital Go to Gateway of Tally > Balance Sheet > press F12 and set 'Show Vertical Balance Sheet' and 'Show Working Capital figures' to 'Yes' > press Alt+F1

Figure 1.2 Vertical Balance Sheet with Working Capital

2


1.3 Horizontal Balance Sheet Go to Gateway of Tally > Balance Sheet > press Alt+F1

Figure 1.3 Horizontal Balance Sheet

3


1.4 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.4 Horizontal Balance Sheet with Percentage/Working Capital

4


1.5 Comparative Quarterly Balance Sheet Go to Gateway of Tally > Balance Sheet > press Alt+F1 >press Alt+N (select 'Quarterly' Column Details)

Figure 1.5 Comparative Quarterly Balance Sheet

5


1.6 Comparative Half yearly Balance Sheet Go to Gateway of Tally > Balance Sheet > press Alt+F1 > press Alt+N (select 'Half Yearly' Column Details)

Figure 1.6 Comparative Half yearly Balance Sheet

6


1.7 Comparative Yearly Balance Sheet Go to Gateway of Tally > Balance Sheet > press Alt+F1 > press Alt+N (select 'Yearly' Column Details)

Figure 1.7 Comparative Yearly Balance Sheet

7


1.8 Vertical Profit and Loss Account Go to Gateway of Tally > Profit & Loss A/c > Press F12 and set 'Show Vertical Profit & Loss' to 'Yes' > press Alt+F1

Figure 1.8 Vertical Profit and Loss Account

8


1.9 Horizontal Profit and Loss Account Go to Gateway of Tally > Profit & Loss A/c > press Alt+F1

Figure 1.9 Horizontal Profit and Loss Account

9


1.10 Income and Expenditure Statement Go to Gateway of Tally > (press F11 Company Features and set 'Income/Expense Statement instead of P & L' to 'Yes') > Income & Expense A/c > press Alt+F1

Figure 1.10 Income and Expenditure Statement

10


1.11 Comparative Profit and Loss Account Go to Gateway of Tally > Profit & Loss A/c > press F2 and change period to 01.04.2010 to 30.09.2010 > or press Alt+N (select 'Half Yearly' Column Details)

Figure 1.11 Comparative Profit and Loss Account

11


1.12 Receipts and Payments Account Go to Gateway of Tally > Display > Receipts and Payments > Press Alt+F1

Figure 1.12 Receipts and Payments Account

12


1.13 Vertical Receipts and Payments Account Go to Gateway of Tally > Display > Receipts and Payments > Press F12 and set Yes to Show Vertical Receipts and Payments.

Figure 1.13 Vertical Receipts and Payments Account

13


1.14 Receipts and Payments Account with Nett Opening & Closing Balance Go to Gateway of Tally > Display > Receipts and Payments > Press F12 and set Yes to Show Nett Opening & Closing Balance only.

Figure 1.14 Vertical Receipts and Payments Account with Nett Opening & Closing Balance

14


1.15 Trial Balance Go to Gateway of Tally > Display > Trial Balance > Press Alt+F1

Figure 1.15 Trial Balance Detailed

15


Figure 1.16 Trial Balance Detailed

16


1.16 Ratio Analysis Go to Gateway of Tally > Ratio Analysis

Figure 1.17 Ratio Analysis

17


1.17 Comparative Ratio Analysis Go to Gateway of Tally > Ratio Analysis > press Alt+N (select 'Half Yearly' Column Details)

Figure 1.18 Comparative Ratio Analysis

18


1.18 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 1.19 Cash Flow Summary

19


1.19 Funds Flow Summary Go to Gateway of Tally > Display > Cash/Funds Flow > Funds Flow (Select the required month or press F2 and specify the required period).

Figure 1.20 Funds Flow Summary

20


1.20 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 1.21 Cash Flow Projection Report

21


1.21 Cash Flow Projection with Cash A/c, Scenarios & Overdues Go to Gateway of Tally > Display > Cash/Funds Flow > Cash Flow Projection > Press F12 and set Yes to Include Cash Account, Scenarios and Overdues. Press F2 and select the required projection period. Press Alt+F1 for Detailed.

Figure 1.22 Cash Flow Projection with Cash A/c, Scenarios & Overdues

22


1.22 Budgets Go to Gateway of Tally > Display > Trial Balance > press Alt+B and select 'Expenditure Budget' and Press Enter (also create one more column for variance)

Figure 1.23 Budgets

Figure 1.24 Budgets

23


1.23 Cost Category Summary Go to Gateway of Tally > Display > Statement of Accounts > Cost Centres > Category Summary

Figure 1.25 Cost Category Summary

1.24 Cost Centre BreakUp Go to Gateway of Tally > Display > Statement of Accounts > Cost Centres > Cost Centre Break-up (select the required Cost Centre and press Enter)

Figure 1.26 Cost Centre Breakup 24


1.25 Ledger Cost BreakUp Go to Gateway of Tally > Display > Statement of Accounts > Cost Centres > Ledger Breakup (select the required Ledger and Press Enter)

Figure 1.27 Ledger Cost Breakup

1.26 Group Cost BreakUp Go to Gateway of Tally > Display > Statement of Accounts > Cost Centres >Group Break-up (select the required Group and Press Enter)

Figure 1.28 Group Cost Breakup

25


1.27 Stock Valuation Methods Go to Gateway of Tally > Balance Sheet > press Alt+N and select Stock Valuation Methods and press Enter

Figure 1.29 Stock Valuation Methods

26



27



28



29



30



31



32



33



34



35




37


1.28 Daybook Go to Gateway of Tally > Display > Day Book

Figure 1.41 Daybook

38


Figure 1.42 Daybook

39


1.29 Scenario- Projected Half yearly Gross Profit Go to Gateway of Tally > Profit & Loss A/c > press F2 and change date to 01.04.2010 to 30.09.2010 and press Alt+C and type date as 01.10.2010 to 31.03.2011 and select 'Gross Profit Scenario' as 'Types of Value to Show' and press Enter

Figure 1.43 Scenario- Projected Half yearly Gross Profit

40

2.

Account Books and Registers

2.1 Ledger Go to Gateway of Tally > Display > Account Books > Ledger (select the required ledger and press Enter)

Figure 2.1 Ledger

41


2.2 Cash Book Go to Gateway of Tally > Display > Account Books > Cash/Bank Book(s) > Cash (select the required month and press Enter)

Figure 2.2 Cash Book

42


2.3 Bank Book Go to Gateway of Tally > Display > Account Books > Cash/Bank Book(s) > Canara Bank (select the required month and press Enter)

Figure 2.3 Bank Book

43


2.4 Multi- Column Cash Book Go to Gateway of Tally > Multi-Account Printing > Account Books > Multi-Column Cash/ Bank (Type the required period and press Enter)

Figure 2.4 Multi- Column Cash/ Bank Book

44


2.5 Receipt Voucher Go to Gateway of Tally > Accounting Vouchers > press F6

Figure 2.5 Receipt Voucher

45


2.6 Payment Voucher Go to Gateway of Tally > Accounting Vouchers > press F5

Figure 2.6 Payment Voucher

46


2.7 Purchase Register Go to Gateway of Tally > Display > Account Books > Purchase Register (select the required month and press Enter)

Figure 2.7 Purchase Register

47


2.8 Purchase Register - Columnar Go to Gateway of Tally > Display > Account Books > Purchase Register (select the required month and press Enter) > press F5 and accept the columns

Figure 2.8 Purchase Register – Columnar

48


Figure 2.9 Purchase Register – Columnar

49


2.9 Purchase Register - Extract Go to Gateway of Tally > Display > Account Books > Purchase Register (Select the required month or press F2 and specify the required period) > press F6

Figure 2.10 Purchase Register – Extract

50


2.10 Sales Register Go to Gateway of Tally > Display > Account Books > Sales Register (select the required month and press Enter)

Figure 2.11 Sales Register

51


2.11 Sales Register - Columnar Go to Gateway of Tally > Display > Account Books > Sales Register (select the required month and press Enter) > press F5 and accept the columns

Figure 2.12 Sales Register - Columnar

52


Figure 2.13 Sales Register - Columnar

53


2.12 Sales Register - Extract Go to Gateway of Tally > Display > Account Books > Sales Register (Select the required month or press F2 and specify the required period) > press F6

Figure 2.14 Sales Register - Extract

54


2.13 Group Summary Go to Gateway of Tally > Display > Account Books > Group Summary (Select the required month or press F2 and specify the required period)

Figure 2.15 Group Summary

55


2.14 Group Vouchers Go to Gateway of Tally > Display > Account Books > Group Vouchers (Select the required month or press F2 and specify the required period)

Figure 2.16 Group Vouchers

56


Figure 2.17 Group Vouchers

57


2.15 Journal Register Go to Gateway of Tally > Display > Account Books > Journal Register >Journal Register (Select the required month or press F2 and specify the required period)

Figure 2.18 Journal Register

58


2.16 Journal Register - Extract Go to Gateway of Tally > Display > Account Books > Journal Register >Journal Register (Select the required month or press F2 and specify the required period) > press F6

Figure 2.19 Journal Register - Extract

59


2.17 Bills Receivable Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Receivables (select All Items or the required group)

Figure 2.20 Bills Receivable

60


2.18 Bills Payable Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Payables (select All Items or the required group)

Figure 2.21 Bills Payable

61


2.19 Overdue Receivables Go to Gateway of Tally > Display > Exception Reports > Overdue Receivables

Figure 2.22 Overdue Receivables

62


2.20 Overdue Payables Go to Gateway of Tally > Display > Exception Reports > Overdue Payables

Figure 2.23 Overdue Payables

63


2.21 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

Figure 2.24 Agewise Bills Receivable

64


2.22 Negative Ledger Go to Gateway of Tally > Display > Exception Reports > Negative Ledgers

Figure 2.25 Negative Ledger

65


2.23 Debit Note Register Go to Gateway of Tally > Display > Account Books > Journal Register > Debit Note Register (Select the required month or press F2 and specify the required period)

Figure 2.26 Debit Note Register

66


2.24 Credit Note Register Go to Gateway of Tally > Display > Account Books > Journal Register > Credit Note Register (Select the required month or press F2 and specify the required period

Figure 2.27 Credit Note Register

67


2.25 Memorandum Register Go to Gateway of Tally > Display > Exception Reports > Memorandum Vouchers (Select the required month or press F2 and specify the required period)

Figure 2.28 Memorandum Register

2.26 Reversing Journal Register Go to Gateway of Tally > Display > Exception Reports > Reversing Journals (Select the required month or press F2 and specify the required period)

Figure 2.29 Reversing Journal Register

68


2.27 Optional Vouchers Go to Gateway of Tally > Display > Exception Reports > Optional Vouchers

Figure 2.30 Optional Vouchers

69


2.28 Post-dated Vouchers Go to Gateway of Tally > Display > Exception Reports > Post-Dated Vouchers

Figure 2.31 Post-dated Vouchers

2.29 Interest Calculations Go to Gateway of Tally > Display > Statement of Accounts > Interest Calculations > Interest Receivable (drill down and select the required ledger and press Enter)

Figure 2.32 Interest Calculations 70


2.30 Confirmation Letter Go to Gateway of Tally > Display > Account Books > Ledger (select the required ledger and press Enter) > press Alt+P and select the Confirmation of A/cs as Style of Report and press Enter

Figure 2.33 Confirmation Letter

71


2.31 Reminder Letter Go to Gateway of Tally > Display > Statement of Accounts > Outstandings > Ledger (select the required Ledger and press Enter) > press Alt+P and set 'Print Reminder Letter' to 'Yes' (specify the required slabs) and press Enter

Figure 2.34 Reminder Letter

72


2.32 Statistics Go to Gateway of Tally > Display > Statement of Accounts > Statistics

Figure 2.35 Statistics

73

3.

Banking Reports

3.1 Bank Reconciliation Statement Go to Gateway of Tally > Banking > Bank Reconciliation > Select the required Bank Account > Print. BRS can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Press F5.

Figure 3.1 Bank Reconciliation Statement

74

Banking Reports

3.2 Bank Reconciliation Statement - Detailed Go to Gateway of Tally > Banking > Bank Reconciliation > Select the required Bank Account > press F12 and Set Yes to Show Remarks also and Show Payment Favouring/Received From > Print. BRS can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Press F5.

Figure 3.2 Bank Reconciliation Statement with Remarks and Payment Favouring/Received From details.

75

Banking Reports

3.3 Deposit Slip Go to Gateway of Tally > Banking > Deposit Slip > Select the required Bank Account > press Alt+P to print All the receipts or press Spacebar to select the required receipt row(s) and then press Alt+P > Print. (Set Yes to Print Company’s PAN/IT Number at Print Report). Deposit Slips can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Ctrl+F6.

Figure 3.3 Deposit Slip

76

Banking Reports

3.4 Deposit Slip Report Go to Gateway of Tally > Banking > Deposit Slip > Select the required Bank Account > press Alt+P. At the Print Report set No to Print Deposit Slip > Print. (Set Yes to Show Received From) Deposit Slip Report can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Press Ctrl+F6.

Figure 3.4 Deposit Slip Report

3.5 Cheque Printing Go to Gateway of Tally > Banking > Cheque Printing > Select the required Bank Account > press Alt+P to print All the cheques or press Spacebar to select the required payment row(s) and then press Alt+P > Print. Cheques can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Press Alt+F6, and also from Payment Voucher Printing.

Figure 3.5 Printed Cheque

77

Banking Reports

3.6 Cheque Printing Report Go to Gateway of Tally > Banking > Cheque Printing > Select the required Bank Account > press Alt+P > At the Print Report Set No to Print Cheque > Print. (Set Yes to Include Printed Cheques also and Show Payment Favouring) Cheques Printing Report can also be printed from Gateway of Tally > Display > Accounts Book > Ledger > select the required Bank Account > Press Alt+F6.

Figure 3.6 Cheque Printing Report

78

Banking Reports

3.7 Payment Advice Go to Gateway of Tally > Banking > Payment Advice > Select the required Ledger Account > press Alt+P to print all the listed payments or press Spacebar to the required payment row(s) and then press Alt+P > Print (At the Print Report Set Yes to Print Due Date and Print Company’s PAN/IT Number) Payment Advice can also be printed from Payment Voucher Printing.

Figure 3.7 Payment Advice

79

4.

Inventory Registers and Reports

4.1 Stock Summary Go to Gateway of Tally > Stock Summary > press F12 and set Show Goods Inwards, Goods Outwards and Closing Balance to 'Yes'

Figure 4.1 Stock Summary

80


4.2 Stock Summary - Gross Profit Go to Gateway of Tally > Stock Summary > press F12 and set Show Goods Inwards, Goods Outwards, and Closing Balance to 'Yes' > press F7

Figure 4.2 Stock Summary - Gross Profit

81


4.3 Stock Category Summary Go to Gateway of Tally > Display > Statement of Inventory > Categories (select Primary and press Enter)

Figure 4.3 Stock Category Summary

82


4.4 Purchase Order Go to Gateway of Tally > Order Vouchers > press Alt+F4

Figure 4.4 Purchase Order

83


4.5 Receipt Note Go to Gateway of Tally > Inventory Vouchers > press Alt+F9

Figure 4.5 Receipt Note

84


4.6 Purchase Voucher Go to Gateway of Tally > Accounting Vouchers > press F9

Figure 4.6 Purchase Invoice

85


4.7 Sales Order Go to Gateway of Tally > Order Vouchers > press Alt+F5

Figure 4.7 Sales Order

86


4.8 Delivery Note Go to Gateway of Tally > Inventory Vouchers > press Alt+F8

Figure 4.8 Delivery Note

87


4.9 Sales Invoice with Single Item Go to Gateway of Tally > Accounting Vouchers > press F8

Figure 4.9 Sales Invoice with Single Item

88


4.10 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 4.10 Sales Invoice with Multiple Items

89


4.11 Rejections In Voucher Go to Gateway of Tally > Inventory Vouchers > press Ctrl+F6

Figure 4.11 Rejections In Voucher

90


4.12 Rejections Out Voucher Go to Gateway of Tally > Inventory Vouchers > press Alt+F6

Figure 4.12 Rejections Out Voucher

91


4.13 Job Work In Order Voucher Go to Gateway of Tally > Order Vouchers > press Alt+W

Figure 4.13 Job Work In Order Voucher

92


4.14 Material In Voucher (To Receive the Raw Materials from the Principal) Go to Gateway of Tally > Inventory Vouchers > press Ctrl+W

Figure 4.14 Material In Voucher to receive the raw materials from the Principal

93


4.15 Material Out Voucher (To Deliver the Finished Goods to the Principal) Go to Gateway of Tally > Inventory Vouchers > press Ctrl+J

Figure 4.15 Material Out Voucher to deliver the finished goods to the Principal

94


4.16 Job Work Out Order Voucher Go to Gateway of Tally > Order Vouchers > press Alt+J

Figure 4.16 Job Work Out Order Voucher

95


4.17 Material Out Voucher (To Send the Raw Materials to the Job Worker) Go to Gateway of Tally > Inventory Vouchers > press Ctrl+J

Figure 4.17 Material Out Voucher to send the raw materials to the Job Worker

96


4.18 Material In Voucher (To Receive the Finished Goods from the Job Worker) Go to Gateway of Tally > Inventory Vouchers > press Ctrl+W

Figure 4.18 Material In Voucher to receive the finished goods from the Job Worker

97


4.19 Purchase Order Book Go to Gateway of Tally > Display > Inventory Books > Purchase Orders Book

Figure 4.19 Purchase Order Book

98


4.20 Sales Order Book Go to Gateway of Tally > Display > Inventory Books > Sales Orders Book

Figure 4.20 Sales Order Book

4.21 Sales Order Book with Profit Go to Gateway of Tally > Display > Inventory Books > Sales Orders Book > press F7 (Show Profit)

Figure 4.21 Sale Order Book with Profit

99


4.22 Purchase Order Stock Group Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > Stock Group > Select Primary or the required Stock Group and press Enter.

Figure 4.22 Purchase Order Summary

4.23 Purchase Order Stock Item Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > Stock Item > Select the required Stock Item and press Enter. (Press F12 and set Yes to Show Opening Orders, Orders Booked and Cleared Orders)

Figure 4.23 Purchase Order Stock Item Outstandings

100


4.24 Purchase Order Group Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > Group > Select the required Group and press Enter. (Press F12 and set Yes to Show Orders Booked and Cleared Orders)

Figure 4.24 Purchase Order Group Outstandings

101


4.25 Purchase Order Ledger Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > Ledger > Select the required Ledger and press Enter.

Figure 4.25 Purchase Order Ledger Outstandings

102

4.26 Purchase Order (Due Only) Go to Gateway of Tally > Display > Statements of Inventory > Purchase Order Outstandings > All Orders

Figure 4.26 Purchase Orders (Due Only)


4.27 Sales Order Stock Group Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Group > Select Primary or the required Stock Group and press Enter.

Figure 4.27 Sales Order Summary

4.28 Sales Order Stock Item Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Item > Select the required Stock Item and press Enter. (Press F12 and set Yes to Show Opening Orders, Orders Booked and Cleared Orders)

Figure 4.28 Sales Order Stock Item Outstandings

104


4.29 Sales Order Group Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Group > Select the required Group and press Enter. (Press F12 and set Yes to Show Orders Booked and Cleared Orders)

Figure 4.29 Sales Order Group Outstandings

4.30 Sales Order Ledger Outstandings Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Ledger > Select the required Ledger and press Enter.

Figure 4.30 Sales Order Ledger Outstandings

105


4.31 Sales Orders (Due Only) Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > All Orders

Figure 4.31 Sales Orders (Due Only)

106


4.32 Sales Order with Pre-Closure Order Details Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > All Orders > press F12 and set Yes to Show Cleared Sales Orders, Show Pre-Closure order details and Show Reason.

Figure 4.32 Sales Orders with Pre-Closure Details

107


4.33 Purchase Bills Pending Go to Gateway of Tally > Display >Statements of Inventory > Purchase Bills Pending

Figure 4.33 Purchase Bills Pending

108


4.34 Sales Bills Pending Go to Gateway of Tally > Display >Statements of Inventory > Sale Bills Pending

Figure 4.34 Sales Bills Pending

4.35 Batch Report Go to Gateway of Tally > Display > Inventory Books > Batch (select the required Stock Item and the Batch and press Enter)

Figure 4.35 Batch report

109


4.36 Batch Summary Go to Gateway of Tally > Display > Inventory Books > Batch > Select the required Stock Item and the Batch > Press F6:Batch Summary and press Enter. Press F12 and set Yes to Show Opening Balance, goods inward and goods outward. Press Alt+F1 for detail)

Figure 4.36 Batch Summary report

4.37 Batch Summary with Mfrg & Expiry Details Go to Gateway of Tally > Display > Inventory Books > Batch > Select the required Stock Item and the Batch > Press F6:Batch Summary and press Enter. Press F12 and set Yes to Show Mfg Date, Expiry Date and No. of days for expiry.

Figure 4.37 Batch Summary with Manufacturing & Expiry Details

110


4.38 Stock Query Go to Gateway of Tally > Display >Statements of Inventory > Stock Query (select the required Stock Item and press Enter)

Figure 4.38 Stock Query

111


4.39 Negative Stock Go to Gateway of Tally > Display > Exception Reports > Negative Stock

Figure 4.39 Negative Stock

4.40 BOM - Cost Estimate Go to Gateway of Tally > Display >Statements of Inventory > Cost Estimation (select the required Stock Group and press Enter)

Figure 4.40 Cost Estimation

112


4.41 Stock Group Cost Analysis Go to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis > Stock Group (Select Primary or the required Stock Group and press Enter. Press Alt+F1 for Detailed)

Figure 4.41 Stock Group Cost Analysis

4.42 Stock Item Cost Analysis Go to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis > Stock Item (Select the required Stock Item and press Enter)

Figure 4.42 Stock Item Cost Analysis

113


4.43 Item Cost Track Break-up Go to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis > Cost Track Break-up (Select the required Item Cost Track and press Enter)

Figure 4.43 Item Cost Track Break-up

114


4.44 Item Movement Analysis Go to Gateway of Tally > Display > Inventory Books > Movement Analysis >Stock Item Analysis (select the required Stock Item and press Enter)

Figure 4.44 Item Movement Analysis

115


4.45 Stock Ageing Analysis Go to Gateway of Tally > Display > Inventory Books > Ageing Analysis (select 'Primary' or the required Stock Group and press Enter)

Figure 4.45 Stock Ageing Analysis (Page 1)

116


Figure 4.46 Stock Ageing Analysis (Page 2)

117


4.46 Price List Go to Gateway of Tally > Inventory Info. > Price List (Select 'All Items' or the required Stock Group and press Enter)

Figure 4.47 Price List

118


4.47 Stock Transfer Register Go to Gateway of Tally > Display > Inventory Books > Stock Transfers (Select the required month or press F2 and specify the required period)

Figure 4.48 Stock Transfer Register

119


4.48 Reorder Status Go to Gateway of Tally > Display >Statements of Inventory > Reorder Status (Select 'Primary' or the required Stock Group and press Enter)

Figure 4.49 Reorder Status

120

5.

Job Work Registers and Reports

5.1 Job Orders Outstandings (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Order Outstandings > Orders > (Press Alt+F1 for Detail)

Figure 5.1 Job Orders Summary (Job Work In)

5.2 Job Orders Details (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Order Outstandings > Orders > Select the required Stock Item (Press Alt+F1 for Detail)

Figure 5.2 Job Orders Details

121


5.3 Components Order Summary (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Order Outstandings > Components

Figure 5.3 Components Order Details

5.4 . Components Orders Details (Jobs Order In) Go to Gateway of Tally > Display > Job Work In Reports > Order Outstandings > Components > Select the required Stock Item (press Alt+F1 for Detail)

Figure 5.4 Components Orders Details

122


5.5 Job Work In Orders Book Go to Gateway of Tally > Display > Job Work In Reports > Job Work Registers > Job Work In Orders Book (press F2 to select the required period)

Figure 5.5 Job work In Order Register

5.6 Material Out Register (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Job Work Registers > Material Out Register (press F2 to select the required period)

Figure 5.6 Material Out Register

123


5.7 Material In Register (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Job Work Registers > Material In Register (press F2 to select the required period)

Figure 5.7 Material In Register

5.8 Material Movement Register Go to Gateway of Tally > Display > Job Work In Reports > Job Work Registers > Material Movement Register (press F2 to select the required period)

Figure 5.8 Material Movement Register 124


Figure 5.9 Material Movement Register


125


5.9 Stock with Job Worker - Item-wise (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Stock > From Party (press F2 to select the required period)

Figure 5.11 Stock with Job Worker (Item-wise)

5.10 Stock with Job Worker - Party-wise (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Stock > From Party > press F5: Party Wise

Figure 5.12 Stock with Job Worker (Party-wise)

126


5.11 Stock Ageing Analysis (Job Orders In) Go to Gateway of Tally > Display > Job Work In Reports > Stock > Ageing Analysis > select the required Stock Group and press Enter.

Figure 5.13 Stock Ageing Analysis


127


5.12 Issue Variance - Job Work In Analysis Go to Gateway of Tally > Display > Job Work In Reports > Job Work Analysis > Issue Variance (press F2 to select the required period).

Figure 5.15 Issue Variance

5.13 Receipt Variance - Job Work In Analysis Go to Gateway of Tally > Display > Job Work In Reports > Job Work Analysis > Receipt Variance (press F2 to select the required period).

Figure 5.16 Receipt Variance

128


5.14 Job Orders Outstandings (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Order Outstandings > Orders > (Press Alt+F1 for Detail)

Figure 5.17 Job Orders Summary (Job Work Out)

5.15 Job Orders Details (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Order Outstandings > Orders > Select the required Stock Item (Press Alt+F1 for Detail)

Figure 5.18 Job Orders Details

129


5.16 Components Order Summary (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Order Outstandings > Components

Figure 5.19 Components Order Details

5.17 . Components Orders Details (Jobs Order Out) Go to Gateway of Tally > Display > Job Work Out Reports > Order Outstandings > Components > Select the required Stock Item (press Alt+F1 for Detail)

Figure 5.20 Components Orders Details 130


5.18 Job Work Out Orders Book Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Registers > Job Work In Orders Book (press F2 to select the required period)

Figure 5.21 Job work In Order Register

131


5.19 Material Out Register (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Registers > Material Out Register (press F2 to select the required period)

Figure 5.22 Material Out Register

132


5.20 Material In Register (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Registers > Material In Register (press F2 to select the required period)

Figure 5.23 Material In Register

133


5.21 Material Movement Register Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Registers > Material Movement Register (press F2 to select the required period)



134




135


5.22 Stock with Job Worker - Item-wise (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Stock > From Party (press F2 to select the required period)

Figure 5.28 Stock with Job Worker (Item-wise)

5.23 Stock with Job Worker - Party-wise (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Stock > From Party > press F5: Party Wise

Figure 5.29 Stock with Job Worker (Party-wise)

136


5.24 Stock Ageing Analysis (Job Orders Out) Go to Gateway of Tally > Display > Job Work Out Reports > Stock > Ageing Analysis > select the required Stock Group and press Enter.



137


5.25 Issue Variance - Job Work Out Analysis Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Analysis > Issue Variance (press F2 to select the required period).

Figure 5.32 Issue Variance (Item-wise)

5.26 Receipt Variance - Job Work Out Analysis Go to Gateway of Tally > Display > Job Work Out Reports > Job Work Analysis > Receipt Variance (press F2 to select the required period).

Figure 5.33 Receipt Variance (Item-wise)

138


5.27 Stock Summary - Our Stock with Us and Third Party Go to Gateway of Tally > Stock Summary > Press Alt+G or Click G: Godown Type > Select Our Stock with us & Third Party from Types of Values (press F2 to select the required period).

Figure 5.34 Stock Summary - Our Stock with Us & Third Party

139


5.28 Stock Summary - Our Stock and Third Party with Us Go to Gateway of Tally > Stock Summary > Press Alt+G or Click G: Godown Type > Select Our Stock & Third Party Stock with us from Types of Values (press F2 to select the required period).

Figure 5.35 Stock Summary - Our Stock & Third Party with Us

5.29 Stock Summary - Our Stock with Third Party Go to Gateway of Tally > Stock Summary > Press Alt+G or Click G: Godown Type > Select Our Stock with Third Party from Types of Values (press F2 to select the required period).

Figure 5.36 Stock Summary - Our Stock with Third Party 140


5.30 Stock Summary - Our Stock with Us Go to Gateway of Tally > Stock Summary > Press Alt+G or Click G: Godown Type > Select Our Stock with us from Types of Values (press F2 to select the required period).

Figure 5.37 Stock Summary - Our Stock with Us

141


5.31 Stock Summary - Third Party Stock with Us Go to Gateway of Tally > Stock Summary > Press Alt+G or Click G: Godown Type > Select Third Party Stock with us from Types of Values (press F2 to select the required period).

Figure 5.38 Stock Summary - Third Party Stock with Us

142

6.

Job Costing Registers and Reports

6.1 Transfer Journal Voucher Go to Gateway of Tally > Inventory Vouchers > press Alt+F7 and select Transfer Journal

Figure 6.1 Transfer Journal Voucher

143


6.2 Consumption Journal Voucher Go to Gateway of Tally > Inventory Vouchers > press Alt+F7 and select Consumption Journal

Figure 6.2 Consumption Journal Voucher

144


6.3 Manufacturing Journal Voucher Go to Gateway of Tally > Inventory Vouchers > press Alt+F7 and select Mfg. Journal

Figure 6.3 Manufacturing Journal Voucher

145


6.4 . Godown Summary - Transfer Status Go to Gateway of Tally > Display > Statement of Inventory > Godowns

Figure 6.4 Godowns Summary - Transfer Status

6.5 Godown Summary - Consumption Status Go to Gateway of Tally > Display > Statement of Inventory > Godowns

Figure 6.5 Godowns Summary - Consumption Status

146


6.6 Godown Summary - Manufacturing Status Go to Gateway of Tally > Display > Statement of Inventory > Godowns

Figure 6.6 Godown Summary - Manufacturing Status

6.7 Job Work Analysis - Building Bricks Go to Gateway of Tally > Display > Statement of Accounts > Job Work Analysis > select Building Bricks

Figure 6.7 Job Work Analysis - Building Bricks 147


6.8 Material Consumption Summary - Building Bricks Go to Gateway of Tally > Display > Statement of Accounts > Job Work Analysis > select Building Bricks > highlight Consumption and press Enter

Figure 6.8 Material Consumption Summary - Building Bricks

6.9 Godown Summary - Building Bricks Go to Gateway of Tally > Display > Statement of Accounts > Job Work Analysis > Select New Manufacturing Job > highlight Consumption and press Enter > Highlight Kiln-I and press Enter

Figure 6.9 Godowns Summary - New Manufacturing Job

148


6.10 Comparative Job Work Analysis Report Go to Gateway of Tally > Display > Statement of Accounts > Job Work Analysis > select Building Bricks > press Alt+C and select New Manufacturing Job as new column to be inserted

Figure 6.10 Comparative Job Work Analysis Report

149


Figure 6.11 Comparative Job Work Analysis Report

150

7.

POS Registers and Reports

7.1 Pos Invoice Go to Gateway of Tally > Accounting Vouchers > press F8 (select POS Invoice Voucher Type)

Figure 7.1 Pos Invoice

151


7.2 POS Invoice - Multiple Sales Ledger Go to Gateway of Tally > Accounting Vouchers > press F8 (select POS Invoice Voucher Type)

Figure 7.2 POS Invoice - Multiple Sales Ledger

152


7.3 Cash Book Go to Gateway of Tally > Display > Account Books > Cash/Bank Book(s) > Cash (Select the required month or press F2 and specify the required period)

Figure 7.3 Cash Book

153


7.4 Columnar Cash Book Go to Gateway of Tally > Display > Account Books > Cash/Bank Book(s) > Cash > (Select the required month or press F2 and specify the required period) > press Alt +F8 and accept the column classifications

Figure 7.4 Columnar Cash Book

154


Figure 7.5 Columnar Cash Book

155


7.5 Sales Register Go to Gateway of Tally > Display > Account Books > Sales Register (Select the required month or press F2 and specify the required period)

Figure 7.6 Sales Register

156


7.6 Columnar Sales Register Go to Gateway of Tally > Display > Account Books > Sales Register (select the required month) > press F5 and accept the column classifications

Figure 7.7 Columnar Sales Register

157


Figure 7.8 Columnar Sales Register

158


7.7 Stock Item Summary Go to Gateway of Tally > Display > Inventory Books > Stock Item (select the required Stock Item)

Figure 7.9 Stock Item Summary

159


7.8 Item Movement Analysis Go to Gateway of Tally > Display > Inventory Books > Movement Analysis > Stock Item Analysis (select the required Stock Item)

Figure 7.10 Item Movement Analysis

160

8.

Value Added Tax Reports

Tally.ERP 9 provides statutory VAT Returns, Reports and annexures for the following states in India.

8.1 Andhra Pradesh Form / Report Name Form VAT 200 Form VAT 226A Form VAT 226B Form VAT 227A Form VAT 227B Form VAT 228A Form TOT 060B Form TOT 007 Form TOT 060A Form C.S.T. VI

Category VAT Return - Monthly VAT Return - Quarterly VAT Return - Quarterly VAT Return - Quarterly VAT Return - Quarterly VAT Return - Quarterly VAT Composite Return - Quarterly VAT Composite Return - Quarterly VAT Composite Return - Quarterly Central Sales Tax Return

8.2 Arunachal Pradesh Form / Report Name Form FF - 01

Category VAT Return - Monthly/Quarterly

8.3 Assam Form / Report Name Form 13 Form 13 Form No. III

Category VAT Return - Quarterly VAT Return - Monthly Central Sales Tax Return

8.4 Bihar Form / Report Name RT - I RT - III RT - IV Form I

Category VAT Return - Quarterly VAT Return - Annual VAT Composite Return - Quarterly Central Sales Tax Return 161


8.5 Chandigarh Form / Report Name Form VAT 15 Form VAT 16 Form VAT 20 Form VAT 18 Form VAT 19 Form VAT 23 Form VAT 24 Form VAT 15 Form VAT 18 Form VAT 19 Form VAT 23 Form VAT 24

Category VAT Return - Quarterly VAT Return - Monthly VAT Return - Annual VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly eVAT Return - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly

8.6 Chhattisgarh Form / Report Name Form VAT 17 Form VAT 18 E-VAT Purchases E-VAT Sales Form 7

Category VAT Return - Quarterly VAT Return - Annual eVAT Return eVAT Return VAT Composite Return - Quarterly

8.7 Dadra and Nagar Haveli Form / Report Name Form DVAT 16 Form DVAT 30 Form DVAT 31 Form DVAT 17

Category VAT Return - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Composite Return - Quarterly

162


8.8 Daman and Diu Form / Report Name Form DVAT 16 Form DVAT 30 Form DVAT 31 Form DVAT 17

Category VAT Return - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Composite Return - Quarterly

8.9 Delhi Form / Report Name Form DVAT 16 Form DVAT 17 Form DVAT 30 Form DVAT 31 Form DVAT 51 Annexure 2A Annexure 2B Form 1 Form 4 Form DVAT 20

Category VAT Return - Monthly/Quarterly VAT Composite Return - Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT/CST Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly Central Sales Tax Return Register of Interstate Sales Payment Challan

8.10 Goa Form / Report Name Form VAT-III Form VAT - IV Form 1 Form VAT - V

Category VAT Return - Monthly/Quarterly VAT Composite Return - Monthly/Quarterly Central Sales Tax Return Payment Challan

163


8.11 Gujarat Form / Report Name Form VAT 201 Form VAT 205 Form 201 A Form 201 B Form 201 C Form VAT 202A Form VAT 202A Form VAT 202 Form VAT 202 Form VAT 216 Form VAT 216 Form III(B) Appendix - I Appendix - II Form 201 Form 201 A Form 201 B Form 201 C Form III(B) Appendix - I Appendix - II

Category VAT Return - Monthly VAT Return - Annual VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Composite Annexures - Quarterly VAT Composite Annexures - Annual VAT Composite Return - Quarterly VAT Composite Return - Annual VAT Composite Return - Quarterly VAT Composite Return - Annual Central Sales Tax Return CST Appendix - Monthly CST Appendix - Monthly eVAT Form - Monthly eVAT Annexures - Monthly eVAT Annexures - Monthly eVAT Annexures - Monthly eCST Return eCST Appendix - Sales Details - Monthly eCST Appendix - Purchase Details - Monthly

164


8.12 Haryana Form / Report Name Form VAT - R1 Form VAT - R2 Annual Return Form LP-1 Form LP-2 Form LP-3 Form LP-4 Form LP-5 Form LP-6 Form LP-7 Form LP-8 Form LS-1 Form LS-2 Form LS-3 Form LS-4 Form LS-5 Form LS-6 Form LS-7 Form LS-8 Form LS-9 Form LS-10 Form 1 Form VAT C4 - Issuable & Receivable Form VAT - C1

Category VAT Return - Quarterly VAT Return - Annual Editable Annual Return VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly VAT Annexures - Quarterly Central Sales Tax Return VAT Certificate - Quarterly Payment Challan

8.13 Himachal Pradesh Form / Report Name Form VAT-XV Form VAT-XV-A Form LP-1 Form LS-1 Form I Form VAT II

Category VAT Return - Quarterly VAT Return - Annual VAT Annexure - Quarterly VAT Annexure - Quarterly Central Sales Tax Return Payment Challan

165


8.14 Jammu and Kashmir Form / Report Name Form VAT 11-A Form VAT 11 Form VAT - 48 Form VAT - 49 Form VAT 12

Category VAT Return - Annual VAT Return - Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Composite Return - Quarterly

8.15 Jharkhand Form / Report Name Form VAT - 213 Form VAT - 204 Form VAT - 200 Annexure A JVAT-213 Form JVAT 500 Form JVAT 501 Form JVAT-211 Form - I Form JVAT 205

Category VAT Return - Monthly VAT Return - Annual VAT Return - Quarterly VAT Annexure - Monthly Monthly Accounts of Purchase & Input VAT Monthly Accounts of Sales & Output VAT VAT Composite Return - Annual Central Sales Tax Return Payment Challan

8.16 Karnataka Form / Report Name Form VAT 100 Annexure-I Annexure-II Annexure-III Form VAT 120 eVAT Purchases eVAT Sales E-Forms Requisition E-CST Exports

Category VAT Return - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure VAT Annexure VAT Composite Return - Quarterly eVAT Annexure - Monthly eVAT Annexure - Monthly eCST Form - Quarterly eCST Form - Quarterly

166


8.17 Kerala Form / Report Name Form No. 10 Invoice - Form 8 Invoice - Form 8B Form No. 52 - Sales Form No. 52 - Purchase eVAT Purchases eVAT Sales eVAT Form 53 Form No. 10 Interstate Sales Statement

Category VAT Return - Monthly Invoice Printing Invoice Printing VAT Annexure - Monthly VAT Annexure - Monthly eVAT Annexure - Monthly eVAT Annexure - Monthly e-statement of closing stock - Annual Central Sales Tax Return CST Annexure

8.18 Madhya Pradesh Form / Report Name Form 10 Form 5 Form 10 Form 26

Category VAT Return - Quarterly VAT Composite Return - Quarterly eVAT Return - Quarterly Payment Challan

8.19 Maharashtra Form / Report Name Form 231 Form 233 Form 232 Form III(E) Form 231 Form 232 Form 233 Audit Form 704 Form III(E) Form 201 Form MTR-6

Category VAT Return - Monthly VAT Return - Monthly Composite VAT Return - Quarterly Central Sales Tax Return eVAT Return - Monthly eReturn for Composite VAT - Quarterly eVAT Return - Monthly eAudit Form - Annual eCST Return VAT Payment Challan CST Payment Challan

167


8.20 Manipur Form / Report Name Form - 10 Annexure - A

Category VAT Return - Monthly/Quarterly/Annual VAT Annexure - Monthly/Quarterly/Annual

8.21 Meghalaya Form / Report Name Form VAT 5 Form VAT 6 Format 3 A

Category VAT Return - Quarterly VAT Return - Annual VAT Composite Return

8.22 Mizoram Form / Report Name Form 5

Category VAT Return - Monthly

168


8.23 Orissa Form / Report Name Form VAT 201 Annexure - I Annexure - II Annexure - III Annexure - III-A Annexure - IV Annexure - V Annexure - VII Form 002 Form 1 Annexure A Annexure B Annexure C Annexure D Annexure E Annexure F VAT - 317 Form VAT 201 Form 1

Category VAT Return - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Composite Return - Quarterly Central Sales Tax Return CST Annexure CST Annexure CST Annexure CST Annexure CST Annexure CST Annexure CST Payment Challan eVAT Return - Monthly eCST Return

8.24 Puducherry Form / Report Name Form I Annexure - II Annexure - III Form K eVAT Annexures

Category VAT Return - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Composite Return - Quarterly eVAT Annexures - Monthly

169


8.25 Punjab Form / Report Name Form VAT 15 Form VAT 16 Form VAT 20 Form VAT 18 Form VAT 19 Form VAT 23 Form VAT 24 Form VAT 17 Form VAT 21 Form 1 Form VAT 15 Form VAT 18 Form VAT 19 Form VAT 23 Form VAT 24 Form 1 Form VAT - 2 Form VAT - 2A

Category VAT Return - Quarterly VAT Return - Monthly VAT Return - Annual VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Composite Return - Quarterly VAT Composite Return - Annual Central Sales Tax Return eVAT Return - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eCST Return Payment Challan Payment Challan

170


8.26 Rajasthan Form / Report Name Form VAT – 10 Form VAT – 10A Form VAT – 07 Form VAT – 07A Form VAT – 08 Form VAT – 08A Form VAT – 12 VAT – 48 VAT – 50 Form VAT-11 Form C.S.T. 1 Form VAT 07A Form VAT 08A Form VAT 10 Form VAT 12 Form VAT 48 Form VAT 50

Category VAT Return - Quarterly VAT Return - Annual VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly Composite VAT Return - Annual Central Sales Tax Return eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Return - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly eVAT Annexure - Quarterly

8.27 Sikkim Form / Report Name Form VAT 8 Form VAT 9

Category VAT Return - Quarterly VAT Return - Annual

171


8.28 Tamil Nadu Form / Report Name Form I Form I-1 Form W Annexure I Annexure II Annexure III Annexure IV Annexure I Annexure II Annexure III Form L Form K Form 1 Annexure I Annexure II Annexure III Annexure IV eVAT Form 14 Form 15

Category VAT Return - Monthly VAT Return - Annual Refund application form for exporters VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Annual VAT Annexure - Annual VAT Annexure - Annual VAT Composite Return Monthly VAT Composite Return Monthly Central Sales Tax Return CST Annexure CST Annexure CST Annexure CST Annexure eVAT Annexure - Monthly Extract Report - Quarterly Extract Report - Quarterly

8.29 Tripura Form/Report Name Form X Form XVIII

Category VAT Return - Monthly Payment Challan

172


8.30 Uttar Pradesh Form / Report Name Form XXIV Form XXIVA Form 1 Annexure A Annexure A-1 Annexure A-2 Annexure B Annexure B-1 Annexure A Annexure B Form I Form XXIV Form 1

Category VAT Return - Monthly VAT Composite Return - Monthly Central Sales Tax Return VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Annexure - Monthly VAT Composite Annexure - Monthly VAT Composite Annexure - Monthly Treasury Challan eVAT Return and Annexures eCST Return

8.31 Uttarakhand Form / Report Name Form III Annexure I (Form III) Annexure II (Form III) Form I

Category VAT Return - Monthly/Quarterly VAT Annexure - Monthly/Quarterly VAT Annexure - Monthly/Quarterly Central Sales Tax Return

173


8.32 West Bengal Form / Report Name Form 14 Form 15 Annexure A Annexure B Annexure D Annexure E Annexure F Annexure G Form 1 Form 14 Form 15 Form 1 Form 2380G

Category VAT Return - Quarterly VAT Composite Return - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly VAT Annexure - Quarterly Central Sales Tax Return eVAT Return - Quarterly eReturn for Composite VAT - Quarterly eCST Return Payment Challan

174

9.

Service Tax Reports

9.1 GAR - 7 Challan Go to Display > Daybook > Open the Service Tax Payment entry > Press Alt + P

Figure 9.1 GAR 7 Challan

175

Service Tax Reports

9.2 Service Tax Payable - Bill Date Wise Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > Service Tax Payables > Bill Date Wise

Figure 9.2 Service Tax Payable - Bill Date Wise Report

9.3 Service Tax Payable - Realisation Date Wise Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > Service Tax Payables > Realisation Date Wise

Figure 9.3 Service Tax Payable - Realisation Date Wise Report

176

Service Tax Reports

9.4 Service Tax Payable - Tax on Service Received Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > Service Tax Payables > Tax on Service Received

Figure 9.4 Service Tax Payable - Tax on Service Received Report

9.5 Service Tax Payable - Import of Services Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > Service Tax Payables > Import of Services

Figure 9.5 Service Tax Payable - Import of Services

177

Service Tax Reports

9.6 Input Credit Summary Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > Input Credit Summary

Figure 9.6 Input Credit Summary

178

Service Tax Reports

9.7 ST 3 Report Go to Gateway of Tally > Display > Statutory Reports > Service Tax Reports > ST3 Report

Figure 9.7 Printed ST-3 Returns (Page 1)

179

Service Tax Reports


180

Service Tax Reports


181

Service Tax Reports


182

Service Tax Reports

Figure 9.11 Printed ST-3 Returns (Page 5) 183

Service Tax Reports


184

Service Tax Reports


185

10. Tax Collected at Source Reports

10.1 Form 27D Go to Gateway of Tally > Display > Statutory Reports > TCS Reports > Print Form 27D

Figure 10.1 Form 27D

186

Tax Collected at Source Reports

10.2 Form 27 B Go to Gateway of Tally > Display > Statutory Reports > TCS Reports > Print Form 27B

Figure 10.2 Form 27B

187

Tax Collected at Source Reports

10.3 ETCS Forms Tally.ERP 9 provides the following E-TCS returns in the prescribed format, which can be validated with File Validation Utility and uploaded E-TCS Return Name Form 27E Form 27EQ

Periodicity Annual Quarterly

To export the E-TCS Returns, Go to Gateway of Tally > Display >Statutory Reports >TCS Reports > ETCS Forms.

188

11. Tax Deducted at Source Report

11.1 TDS Challan Go to Display > Day Book > Select TDS Payment voucher > Press Alt +P

Figure 11.1 TDS Challan

189

Tax Deducted at Source Reports

11.2 TDS Computation Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Computation

Figure 11.2 TDS Computation

190


11.3 TDS Challan Reconciliation Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Challan Reconciliation

Figure 11.3 TDS Challan Reconciliation

191


11.4 Form 16A Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Print Form 16A

Figure 11.4 Form 16A

192


11.5 Form 26Q Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Form 26Q

Figure 11.5 Printed Form 26Q (Page 1)

193



194


11.6 Annexure to 26Q Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Annexure to 26Q

Figure 11.7 Printed Annexure to 26Q (Page 1)

Figure 11.8 Printed Annexure to 26Q (Page 2)

195


11.7 Form 27Q Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Form 27Q


196



197


11.8 Annexure to 27Q Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Annexure to 27Q

Figure 11.11 Printed Annexure to 27Q

198


11.9 Form 26 Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Form 26

Figure 11.12 Form 26

199


11.10 Annexure to 26 Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Return > Annexure to 26

Figure 11.13 Annexure to 26

200


11.11 Form 27 Go to Gateway of Tally> Display >Statutory Reports > TDS Reports > Return >Form 27

Figure 11.14 Printed Form 27

201


11.12 Annexure to Form 27 Go to Gateway of Tally> Display >Statutory Reports > TDS Reports > Return > Annexure to 27

Figure 11.15 Annexure to 27

202


11.13 Print Form 27A Go to Gateway of Tally> Display >Statutory Reports > TDS Reports > E–Return > Print Form 27A

Figure 11.16 Printed Form 27 A

203


11.14 E-TDS Returns Tally.ERP 9 provides the following E-TDS returns in the prescribed format, which can be validated with File Validation Utility and uploaded. E-TDS Return Name

Periodicity

Form 26Q

Quarterly

Form 27Q

Quarterly

Form 26

Annual

Form 27

Annual

To export the E-TDS Returns, Go to Gateway of Tally > Display >Statutory Reports >TDS Reports > E-Return > E- TDS

11.15 TDS Payables Go to Gateway of Tally > Display > Statements of Accounts > TDS Outstanding > TDS Payables

Figure 11.17 TDS Payables Report

204


11.16 TDS Ledger Outstandings Go to Gateway of Tally > Display > Statements of Accounts > TDS Outstanding > Ledger

Figure 11.18 TDS Ledger Outstandings

11.17 TDS Nature of Payment Outstandings Go to Gateway of Tally > Display > Statements of Accounts > TDS Outstanding > TDS Nature of Payment Outstandings

Figure 11.19 TDS Nature of Payment Outstandings 205


11.18 TDS Not Deducted Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Outstandings > TDS Not Deducted

Figure 11.20 TDS Not Deducted report

11.19 PAN Not Available Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Exception Reports > PAN Not Available

Figure 11.21 PAN Not Available

206


11.20 Unknown Deductee Type Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Exception Reports > Unknown Deductee Type

Figure 11.22 Unknown Deductee Type

207

12. Excise for Dealer Reports

12.1 Excise Stock Register Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Stock Register

Figure 12.1 Excise Stock Register

208

Excise for Dealer Reports

12.2 Excise Purchase Bill Register Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Purchase Bill Register

Figure 12.2 Excise Purchase Bill Register 209


12.3 Party Wise Duty Extract Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Party Wise Duty Extract

Figure 12.3 Party Wise Duty Extract Report

210


12.4 Customs Clearance Register Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Customs Clearance Register

Figure 12.4 Customs Clearance Register

211


12.5 Sales and Purchase Extract Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Sales and Purchase Extract

Figure 12.5 Sales and Purchase Extract (Page-1) 212


Figure 12.6 Sales and Purchase Extract (Page-2)

213


12.6 Form RG 23D Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Form RG 23D

Figure 12.7 Form RG 23D

214


12.7 Form RG 23D - Sales Bill Wise Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Form RG 23D > Sales Bill Wise

Figure 12.8 Form RG 23D - Sales Bill Wise

215


12.8 Quarterly Returns - Form 2 Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Quarterly Returns - Form 2

Figure 12.9 Quarterly Returns - Form 2 (Page-1)

216


Figure 12.10 Quarterly Returns - Form 2 (Page-2)

12.9 E-Return Tally.ERP 9 provides the Dealer E-Return in the prescribed format, which can be exported in XML format and uploaded. To export the Dealer E-Returns, Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > E-Return

217

13. Excise for Manufacturer Reports

13.1 Excise Computation Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > Excise Computation

Figure 13.1 Excise Computation

218

Excise for Manufacturer Reports

13.2 Daily Stock Register Go to Gateway of Tally > Display > Statutory Reports> Excise Reports > Manufacturer > Daily Stock Register

Figure 13.2 Daily Stock Register

219


13.3 PLA Register Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > PLA Register

Figure 13.3 PLA Register

220


13.4 Form ER 1 Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > Form ER 1

Figure 13.4 Printed Form ER 1 (Page 1)

221



222



223



224


13.5 Form ER - 5 Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > From ER 5

Figure 13.8 Form ER - 5 225


13.6 Form ER - 6 Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > From ER 6

Figure 13.9 Form ER - 6

226


13.7 E-Return Tally.ERP 9 provides the ER1 E-Return in the prescribed format, which can be exported in XML format and uploaded. To export the ER1 E-Returns, Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > E-Return

13.8 Credit Summary Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > CENVAT Summary

Figure 13.10 Credit Summary 227


13.9 Credit Availed Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > Credit Availed

Figure 13.11 Credit Availed

228


13.10 RG 23 Part I 13.10.1 RG 23A Part I Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > RG 23 Part I > in Select Excise Unit screen select the Stock Item Type as Principal Input

Figure 13.12 Form RG 23A Part I

13.10.2 RG 23C Part I Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > RG 23 Part I > in Select Excise Unit screen select the Stock Item Type as Capital Goods

Figure 13.13 Form RG 23C Part I

229


13.11 RG 23 Part II 13.11.1 RG 23A Part II Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > RG 23 Part II > in Select Excise Unit screen select the Stock Item Type as Principal Input

Figure 13.14 Form RG 23A Part II

13.11.2 RG 23C Part II Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > RG 23 Part II > in Select Excise Unit screen select the Stock Item Type as Capital Goods

Figure 13.15 Form RG 23C Part II

230


13.12 Annexure – 10 Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > Annexure - 10

Figure 13.16 Annexure – 10

231


13.13 Abstract Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > Abstract

Figure 13.17 Abstract Report

232

14. Payroll Registers and Reports

14.1 Payroll voucher Go to Gateway of Tally > Payroll Vouchers > press Ctrl+F4 > press Alt+A (Payroll Auto Fill) and select the required details

Figure 14.1 Payroll Voucher

233

Payroll Registers and Reports

Figure 14.2 Payroll voucher

234


14.2 Attendance Voucher Go to Gateway of Tally > Payroll Vouchers > press Ctrl+F5 > press Alt+A (Attd Auto Fill) and select the relevant attendance type and other details

Figure 14.3 Attendance Voucher

235


14.3 Pay Slip Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Slip > Single Pay Slip

Figure 14.4 Pay Slip

14.4 Pay Sheet Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Sheet

Figure 14.5 Pay Sheet

236


Figure 14.6 Pay Sheet

14.5 Payroll Statement Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Payroll Statement

Figure 14.7 Payroll Statement

237


14.6 Payment Advice Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Payment Advice

Figure 14.8 Payment Advice

238


14.7 Payroll Register Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Payroll Register

Figure 14.9 Payroll Register

239


Figure 14.10 Payroll Register

240


14.8 Employee Profile Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Employee Profile > Single Employee

Figure 14.11 Employee Profile - Page 1 241


Figure 14.12 Employee Profile - Page 2

14.9 Employee Pay Head Breakup Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Employee Pay Head Breakup and select the required Ledger

Figure 14.13 Employee Pay Head Breakup

242


14.10 Employee Head Count Report Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Employee Head Count

Figure 14.14 Employee Head Count Report

243


14.11 Pay Head Employee BreakUp Go to Gateway of Tally > Display > Payroll Reports > Statements of Payroll > Pay Head Employee Breakup and select the required Ledger

Figure 14.15 Payhead Employee breakup

14.12 Attendance Sheet Go to Gateway of Tally > Display > Payroll Reports > Attendance Sheet

Figure 14.16 Attendance Sheet

244


14.13 Attendance Register Go to Gateway of Tally > Display > Payroll Reports > Attendance Register

Figure 14.17 Attendance Register

245


14.14 Gratuity Report Go to Gateway of Tally > Display > Payroll Reports > Gratuity Report When Statutory features are enabled, Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Gratuity Report

Figure 14.18 Gratuity Summary

14.15 Passport Expiry Report Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Passport Expiry

Figure 14.19 Passport Expiry Report

246


14.16 Visa Expiry Report Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Visa Expiry

Figure 14.20 Visa Expiry Report

14.17 Contract Expiry Report Go to Gateway of Tally > Display > Payroll Reports > Expat Reports > Contract Expiry

Figure 14.21 Contract Expiry Report

247


14.18 Statutory Summary/Computation Report Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Summary > Press Alt+F1

Figure 14.22 Computation Summary Report

248


14.19 Provident Fund Form 5 Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Provident Fund > Form 5

Figure 14.23 PF Form 5

249


14.20 Provident Fund Form 10 Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Provident Fund > Form 10

Figure 14.24 PF Form 10

250


14.21 Provident Fund Form 12A Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Provident Fund > Form 12A

Figure 14.25 Printed Form 12A

251


14.22 Provident Fund Monthly Statement Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Provident Fund > Monthly Statement

Figure 14.26 PF Monthly Statement

252



Figure 14.27 Printed PF Form 3A

253



Figure 14.28 Printed Form 6A - Page 1

254


Figure 14.29 Printed Form 6A - Page 2

255


14.25 ESI Monthly Statement Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Employee State Insurance > Monthly Statement

Figure 14.30 ESI Monthly Statement

256


14.26 ESI Form 3 Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Employee State Insurance > Form 3

Figure 14.31 Printed Form 3

257



Figure 14.32 Printed Form 5 - Page 1

258



259


Figure 14.34 ESI Form 5 - Page 3

260




261



262



263


14.29 Professional Tax Computation Report Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Professional Tax > Computation Report

Figure 14.38 Printed PT Computation Report

264


14.30 Professional Tax Monthly Statement Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Professional Tax > Statement

Figure 14.39 Professional Tax Monthly Statement

265


14.31 Income Tax Computation Report Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Computation

Figure 14.40 Income Tax Computation Report

266


14.32 Salary Projection Report Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Salary Projection

Figure 14.41 Salary Projection - Page 1

267




268


14.33 Income Tax - Form 16 Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Returns > Form 16

Figure 14.44 Form 16 - Page 1

269


Figure 14.45 Form 16 - Page 1

270


14.34 Income Tax - Form 12BA Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Returns > Form 12BA

Figure 14.46 Form 12BA - Page 1

271


Figure 14.47 Form 12BA - Page 2

272


14.35 Form ITR - 1 Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Returns > ITR - 1

Figure 14.48 ITR -1 - Page 1

273


Figure 14.49 ITR - 1 - Page 2

274


Figure 14.50 ITR -1 - Page 3

275


Figure 14.51 Acknowledgement for ITR

276


14.36 TDS Variance Report Go to Gateway of Tally > Display > Payroll Reports > Statutory Reports > Income Tax > Exception Reports > TDS Variance

Figure 14.52 TDS Variance Report

277

Sample Reports in Tally.ERP 9

Recommend Documents