{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["P.F.","E.S.I.","Other Funds","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","INTER","Enable Macros","Help"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":7,"defined_names":186,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"P.F.","index":0,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["EmployeePFESIfunds","P.F.",6,"4.03.50.10.*.00"]
[]
["Due date","Paid on","Amount  paid","Amount collected","Disallowance^"]
["P.F.Contributions"]
["-","-","-","-","-","-","-"]

{"sheet":"E.S.I.","index":1,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["EmployeePFESIfunds","E.S.I.",5,"4.03.50.30.*.00"]
[]
["E.S.I. Contributions"]
["-","-","-","-","-","-","-"]

{"sheet":"Other Funds","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["EmployeePFESIfunds","Other Funds",6,"4.03.50.45.*.00"]
[]
["Other Welfare Funds"]
["Due date","Paid on","Amount  paid","Amount collected",null,"Name of Fund"]
["-","-","-","-","-","-","-"]

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet6","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet7","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet8","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet9","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet10","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet11","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet12","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet13","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet14","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet15","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"INTER","index":15,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["$WiNsArAlXlImPoRt$","6.3.1","1061","2019-2020","F",null,""]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Gratuity Fund"]
[null,null,null,null,null,"Other"]
[null,null,null,null,null,"Superannuation Fund"]

{"sheet":"Enable Macros","index":16,"n_rows":251,"n_cols":3,"rows_kept":251,"cut":false,"hidden":false,"merged":[[79,1,79,2],[100,1,100,2],[138,1,138,2],[184,1,184,2],[16,1,16,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[58,1,58,2],[59,1,59,2],[1,0,1,1],[3,1,3,2],[6,1,6,2],[11,1,11,2],[14,1,14,2],[15,1,15,2]]}
["Macros Instructions"]
["INSTRUCTIONS"]
[]
[null,"Enable Macros:"]
[null,"To ensure proper working of this Excel file,"]
[null,"EXCEL 97 to 2003"]
[null,"If Security Warning window is displayed with the message \"contains macros by Winman Software Private Limited\", then "]
[null,"Click here for solution."]
[]
[null,"EXCEL 2007 onwards"]
[null,"                 1. While exporting format to Excel, if the following error message is displayed  then, "]
[null,"             \"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features\""]
[null,"Click here for solution."]
[null,"                 2. If 'Security Warning' with the message \"Some active content has been disabled\" is displayed, then"]
[null,"Excel 2007: Click here for solution"]
[null,"Excel 2010: Click here for solution"]
[]
[null,"END of Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Security Warning - Excel 97-2003"]
[]
[null,"1. The following 'Security Warning' appears"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. In the above window, select the check box \"Always trust macros from this source.\""]
[null,"3. Click on 'Enable Macros' button"]
[null,null,"Back to Main Instructions"]
[]
[]
[]
[]
[null,"Macro Installation procedure in Excel 2007 and later versions"]
[null,"If \"Visual Basic for Application\" which is essential for running macros was not installed at the time of  the installation of MS Office 2007/2010, the following error appears while opening the Excel file."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To solve this problem;"]
[null,"1. Close all Excel files."]
[null,"2. Go to the Control Panel  --> go to \"Add or Remove Programs\" in Windows XP or \"Programs and Features\" in Windows Vista/windows 7."]
[null,"3. Select Microsoft Office in the list and click on the 'Change' button."]
[null,"4. Select \"Add or Remove Features\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Select \"Visual Basic for Applications\" in the \"Office Shared Features\" list and set it to \"Run from My Computer\". Then, click on the continue button at the bottom."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. Now, Excel Macros can run in your computer."]
[null,null,"Back to Main Instructions"]
[]
[]
[null,"Security Warning - Excel 2007"]
[]
[null,"1. The following 'Security Warning' appears"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Now, click on 'Options…' button. The following window will be displayed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Select the last item 'Trust all documents from this publisher'."]
[null,"4. Click on 'OK'."]
[null,null,"Back to Main Instructions"]
[]
[]
[null,"Security Warning - Excel 2010"]
[]
[null,"1. The following 'Security Warning' appears"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Click on 'Click for more details'. The following window will be displayed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Click on 'Enable Content' and then 'Advanced Options'. The following window will be displayed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Select the last item 'Trust all documents from this publisher'."]
[null,"5. Click on 'OK'."]
[]
[null,null,"Back to Main Instructions"]

{"sheet":"Help","index":17,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[[9,3,9,4]]}
["Instructions"]
[null,"INSTRUCTIONS"]
[]
[null,"1. Steps:"]
["i","Enter data in the required sheets."]
["ii","On completion of the data entry in Excel, click on 'Copy' button shown in the first row of the Excel sheet. Alternatively, you may copy only the required rows containing the data excluding the headings."]
["iii","Go to Winman CA-ERP / GST ® open the concerned sub-table ® click the Excel picture or right click on the concerned blank row ® 'Paste from Excel' ® 'Overwrite'/ 'Add to existing data'."]
[]
[null,"2. Others:"]
["i","You can insert/paste rows, drag the data to the next rows or use other utilities of excel."]
["ii","Please do not insert/delete columns or change the order of the columns.The data entry sheet contains all the relevant columns of the corresponding table in Winman CA-ERP / GST."]
["iii","Please do not change rows containing column heading and the rows above the heading."]
["iv","Do not fill the grey colored columns, if any. Values for these columns will be calculated automatically in Winman CA-ERP / GST."]
[]
[null,"3. Notes for  GST:"]
["i","'State of supply' is auto-filled in the software based on the GSTIN of Recepient. Therefore, enter the 'State of Supply' only if it is different from Recepient's registered State."]
["ii","If single Invoice No. contains transaction of different tax rates, enter the details each Tax rate in different rows. But, the 'Tax rate' shall not be repeated for a invoice.  "]
["iii","In GSTR-1 & 4, outward supplies tables, IGST, Central Tax and State tax are auto-filled in the software based on Taxable value, Tax Rate & State of supply. "]
["iv"," If there are more than 200 rows in excel, ‘State of supply’ column will not be auto-filled in software. To auto-fill, go to Tools menu --> Settings --> select Yes against ‘Auto-fill data while importing > 200 rows from Excel?’"]
["v","In case of outwards supplies: \nIf 'Invoice No.' is repeated, all the values except Tax rate, Taxable Value, IGST, Central Tax, State tax and Cess are auto-filled. \nTherefore, such columns need not be entered in repeated rows."]
["vi","In case of inwards supplies:\nIf Invoice No. and GSTIN are repeated in next rows, all the values except Tax rate, Taxable Value, IGST, Central Tax and State tax are auto-filled. \nTherefore, such columns need not be entered in repeated rows."]
[]
[null,"3. 26AS import cases in CA-ERP:"]
["i","TDS_Detailed' and 'TCS_Detailed' sheets contain values as appearing in the 26AS page. The data shown in these sheets are only for your reference and these data are not imported to the Winman CA-ERP."]
["ii","The values shown in other sheets can be directly imported to Winman CA-ERP."]