{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tables","Instructions","General Information","Transaction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Tables","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Test/Prod","Mode","Schedule Codes","UOM"]
["T","A","1A","CSE","Acct Nbr:",2002533,{"$f":"TEXT(F2,\"00000000\")","v":"02002533"}]
["P","CE","2A","CAR","Begin:","2012-10-10"]
[null,"J","7A","PAK","End:","2012-10-11"]
[null,"R","10B","STK","Version","1.1.BOE"]
[null,"S","F","SMP"]
[null,null,null,"OTH",null,{"$f":"LEN(F2)","v":7}]

{"sheet":"Instructions","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1],[12,0,15,1]]}
["Cigarette Tax eFiling Program Schedule/Transaction File Instructions"]
[]
["1.","Enter the transaction information for all schedules applicable to this filing on the \"Schedule/Transaction\" worksheet.  Additional information on reporting transactions is available on the \"General Information\" worksheet."]
[]
["2.","Save this completed Excel workbook for your records."]
[]
["3.","Click the “Create Schedule/Transaction File” button below.  This will generate a Schedule/Transaction File with a “.txt” extension.  You will be required to identify a file name and location for your Schedule/Transaction File. "]
[null,"- Or -"]
[null,"If you are participating in the optional electronic testing process,  click the “Create Test File” button below.  This will generate a Schedule/Transaction File with a “.txt” extension.  You will be required to identify a file name and location for your Schedule/Transaction Test File. "]
[null,"Note: If the program does not execute and display a \"Save As\" pop-up box or opens the \"Microsoft Visual Basic\" macro editor, your security settings may be set too high."]
[null,"Click here for instructions on changing the security setting"]
[]
["Create Schedule/Transaction File                                     Create Test File"]
[]
[]
[]
[]
["4.","Attach the Schedule/Transaction File to your tax form when eFiling.  Note: The Schedule/Transaction File has a \".txt\" extension, not \".xls.\""]

{"sheet":"General Information","index":2,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["General Information"]
[]
[null,"General Data Entry"]
["1.","All numbers must be entered as whole numbers.  Do not use decimals.  Round to the nearest whole number."]
["2.","CDTFA account numbers should be entered using only the 8-digit numeric portion of the account number.  No letters or dashes should be included.  An account number, like CR 02-123456, should be entered as 02123456."]
["3.","FEINs and SSNs should be entered using only the 9-digit numeric portion of the number.  No dashes should be included.  An FEIN, like 95-1234567, should be entered as 951234567, and an SSN, like 987-65-4321, should be entered as 987654321."]
["4.","Transactions do not need to be grouped by schedule number or be in numeric order."]
[]
[null,"Mode Codes"]
[null,"A       Air (airplane)"]
[null,"CE    Summary Item - Filers may use this mode code only when provided for in the schedule instructions."]
[null,"           Use this mode code to indicate that quantities reported are summarized."]
[null,"J       Truck"]
[null,"R      Rail"]
[null,"S       Ship (ocean marine vessel)"]
[]
[null,"Unit of Measure (UOM) Codes"]
[null,"CSE.   Case of product."]
[null,"CAR.  Carton of product."]
[null,"PAK.   Pack of product."]
[null,"STK.   Cigarette."]
[null,"SMP.  Sample of product."]
[null,"OTH.  Other."]
[]
[null,"Document Numbers"]
[null,"Enter the bill of lading (BOL) number issued when the product is shipped, unless the schedule description specifies other expected values.  Report the document number as provided on the BOL.  If a BOL is not available, a shipping document or manifest number may be used.  All parties to the transaction must report the same document date and number to the CDTFA.  If the document or BOL number is greater than 15 digits, report only the last 15 digits of the number."]
[]
[null,"Additional Information"]
[null,"For schedule descriptions and instructions on completing schedules as well as Schedule Codes, UOM Codes, and other transaction reporting information:"]
[null,"https://www.cdtfa.ca.gov/formspubs/cdtfa810cte.pdf"]
[null,"For mode codes:"]
[null,"https://www.cdtfa.ca.gov/formspubs/cdtfa810cte.pdf"]
[null,"For schedule code information:"]
[null,"https://www.cdtfa.ca.gov/formspubs/cdtfa810cte.pdf"]
[null,"For more information about the Cigarette Tax Electronic Filing Program:"]
[null,"http://www.cdtfa.ca.gov/taxes-and-fees/cigarette-tax-filing.htm"]
[]
[null,"Excel 2007 Security Settings"]
[null,"If the \"Save As\" pop-up box does not appear when you click on the \"Create Flat File\" button, your security settings may be set too high to allow the associated program to function.  To change your security setting, follow these steps:"]
["1.","Save the Excel workbook containing your tax information."]
["2.","Close all open Excel workbooks."]
["3.","Still in Excel, click on the round \"Windows\" icon in the top left corner."]
["4.","Click on the \"Excel Options\" button at the bottom of the pop-up window."]
["5.","Select \"Trust Center\" from the left column of the Excel Options pop up window."]
["6.","Click on the \"Trust Center Settings\" button in the primary window."]
["7.","Select \"Macro Settings\" from the left column of the Trust Center pop up window."]
["8.","Choose \"Enable All Macros\" from the Macro Settings option list."]
["9.","\"OK\" the change in the Trust Center pop up window."]
["10.","\"OK\" the change in the Excel Options pop up window."]
["11.","Open your Excel workbook and repeat Step 5 on the Instructions worksheet."]
["12.","Once you have successfully created a Flat File, it is highly recommended that you change your security settings back to a higher level."]
[]
[null,"Click here to return to Instructions worksheet"]
[]
[]
[null,"Contact the CDTFA "]
[null,"If you have any questions about the schedule instructions or reporting requirements, contact Special Taxes and Fees at:"]
[null,"Email: CDTFACTeFile@cdtfa.ca.gov"]
[null,"Mail:"]
[null,"     California Department of Tax and Fee Administration"]
[null,"     Special Taxes and Fees"]
[null,"     PO Box 942879"]
[null,"     Sacramento, CA 94279-0088"]
[]
[null,"Disclaimer"]
[null,"This document summarizes the law and applicable regulations in effect when it was published.  However, changes in the law or regulations may have occurred.  If there is a conflict between this document and the law, decisions will be based on the law."]

{"sheet":"Transaction","index":3,"n_rows":2,"n_cols":25,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Schedule","Mode","Product","UPC",null,"Document/","Document/",null,"Tax Paid",null,"Buyer's",null,"Seller's","Destination","Destination","Dest","Dest","Dest","Dest",null,null,"Orig","Orig","Orig","Orig"]
["Code","Code","Brand/Variant Name","(Optional)","UOM","BOL Date","BOL Number","Quantity","(Y/N)","Buyer's Name","Acct/ID","Seller's Name","Acct/ID","Street","City","State","ZIP","ZIP + 4","Country","Origin Street","Origin City","State","ZIP","ZIP + 4","Country"]