{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tables (CDTFA Staff Only)","Instructions","General Information","Transaction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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 (CDTFA Staff Only)","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:",123456789,{"$f":"TEXT(F2,\"000000000\")","v":"123456789"}]
["P","CE","2A","CAR","Begin:","2019-01-01"]
[null,"J","7A","PAK","End:","2019-03-31"]
[null,"R","10B","STK","Version","1.1.BOE"]
[null,"S","F","SMP"]
[null,null,null,"OTH",null,{"$f":"LEN(F2)","v":9}]

{"sheet":"Instructions","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["This workbook has 3 active worksheets - Instructions, General Information, and Transaction.  There is a hidden worksheet labeled Tables which you will not have access to.  Press the down arrow to read through the worksheet.  If you receive a Security Warning, select Enable Content to allow Macros to run."]
["Cigarette Distributor Online Filing Schedule/Transaction File Instructions"]
["This file contains sample schedule/transaction records in the \"Transaction\" worksheet as an example to illustrate how the records are converted from this Excel file to a flat (FLT) file."]
["1.  Enter the transaction information for all schedules applicable to this filing on the \"Transaction\"\n     worksheet.  Additional information on reporting transactions is available on the \"General Information\"\n     worksheet."]
["2.  Save this completed Excel file for your records."]
["3.  Create a Schedule/Transaction flat (FLT) file by clicking on the button below. A FLT file will have a “.txt”  \n     extension. You will be required to identify a file name and location to save your Schedule/Transaction FLT file. "]
["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."]
["Click here for instructions on changing the security setting"]
["Press Enter to create Schedule/Transaction FLT file"]
["4.  Attach the Schedule/Transaction FLT file to your tax form when filing online.  Note: The Schedule/Transaction FLT file has a \".txt\" extension, not \".xlsm.\""]
["End of worksheet"]

{"sheet":"General Information","index":2,"n_rows":53,"n_cols":1,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["General Information"]
["General Data Entry"]
["1.  All numbers must be entered as whole numbers.  Do not use decimals.  Round to the nearest whole\n     number."]
["2.  CDTFA account numbers should be entered using only the 9-digit numeric portion of the account\n     number.  No letters or dashes should be included.  An account number, like 002-123456, should be\n     entered as 002123456."]
["3.  FEINs and SSNs should be entered using only the 9-digit numeric portion of the number.  No dashes\n     should be included.  An FEIN, like 95-1234567, should be entered as 951234567, and an SSN, like\n     987-65-4321, should be entered as 987654321."]
["4.  Transactions do not need to be grouped by schedule number or be in numeric order."]
["Mode Codes"]
["A       Air (airplane)"]
["CE    Summary Item - Filers may use this mode code only when provided for in the schedule instructions.\n         Use this mode code to indicate that quantities reported are summarized."]
["J       Truck"]
["R      Rail"]
["S       Ship (ocean marine vessel)"]
["Unit of Measure (UOM) Codes"]
["CSE   Case of product."]
["CAR  Carton of product."]
["PAK   Pack of product."]
["STK   Cigarette."]
["SMP  Sample of product."]
["OTH  Other."]
["Document Numbers"]
["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."]
["Additional Information"]
["For schedule descriptions and instructions on completing schedules as well as Schedule Codes, UOM Codes, and other transaction reporting information:"]
["Click here for Schedule descriptions and instructions on completing schedules."]
["For mode codes:"]
["Click here for a list of mode codes."]
["For schedule code information:"]
["Click here for a list of valid schedule codes."]
["For more information about cigarette online filing:"]
["Click here for more information about cigarette online filing."]
["Excel 2016 Security Settings"]
["If the \"Save As\" pop-up box does not appear when you click on the \"Press Enter to create Schedule/Transaction FLT 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 file containing your tax information."]
["2.  Close all open Excel files."]
["3.  Click on the File tab."]
["4.  Click on the Excel Options button at the bottom of the pop-up window."]
["5.  Select Trust Center from the left column options 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 options 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 file and repeat Step 3 on the 'Instructions' worksheet."]
["12.  Once you have successfully created a FLT File, it is highly recommended that you change your\n        security settings back to a higher level."]
["Click here to return to Instructions worksheet"]
["Contact the CDTFA "]
["If you have any questions about the schedule instructions or reporting requirements, contact the Business Tax and Fee Division at:"]
["Click here to Email: CDTFACTeFile@cdtfa.ca.gov"]
["Mail:"]
["     California Department of Tax and Fee Administration\n     Business Tax and Fee Division\n     PO Box 942879\n     Sacramento, CA 94279-0088"]
["Disclaimer"]
["This document summarizes the law and applicable regulations in effect when it was published.  However,  \n changes in the law or regulations may have occurred.  If there is a conflict between this document and the  \n law, decisions will be based on the law."]
["End of worksheet"]

{"sheet":"Transaction","index":3,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Schedule\nCode","Mode","Product\nBrand/Variant Name","UPC\n(Optional)","UOM","Document/\nBOL Date","Document/\nBOL Number","Quantity","Tax Paid\n(Y/N)","Buyer's Name","Buyer's\nAcct/ID","Seller's Name","Seller's\nAcct/ID","Destination\nStreet","Destination\nCity","Dest\nState","Dest\nZIP","Dest\nZIP + 4","Dest\nCountry","Origin Street","Origin City","Orig\nState","Orig\nZIP","Orig\nZIP + 4","Orig\nCountry"]
["2A",null,"Smokey 100s","123456789012","CSE","2012-10-10","445619",100,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["2A",null,"Smokey Lights","234567890123","CSE","2012-10-10","445619",200,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["2A",null,"Smokey Menthol","345678901234","CSE","2012-10-10","445619",300,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["2A",null,"Smokey 100s","123456789012","CSE","2012-10-15","505777",400,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["2A",null,"Smokey Lights","234567890123","CSE","2012-10-25","654123",75,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["2A",null,"Smokey Lights","234567890123","CSE","2012-10-02","657",10,null,null,null,"CA Distributor","002654321",null,null,null,null,null,null,"123 Main Street","Anytown","CA","91234"]
["2A",null,"Smokey Lights","234567890123","CSE","2012-10-17","858",5,null,null,null,"CA Distributor","002654321",null,null,null,null,null,null,"123 Main Street","Anytown","CA","91234"]
["2A",null,"Smokey Lights","234567890123","CSE","2012-10-30","1014",7,null,null,null,"CA Distributor","002654321",null,null,null,null,null,null,"123 Main Street","Anytown","CA","91234"]
["7A",null,"Smokey Lights","234567890001","CAR","2012-10-18","852",70,"N","Nevada Retailer","955577331",null,null,"555 Elm Street","Somewhere","NV","12345"]
["7A",null,"Smokey Menthol","345678901234","CSE","2012-10-22","963",15,"N","Nevada Retailer","955577331",null,null,"555 Elm Street","Somewhere","NV","12345"]
["7A",null,"Smokey Lights","234567890001","CAR","2012-10-18","852",30,"Y","Nevada Retailer","955577331",null,null,"555 Elm Street","Somewhere","NV","12345"]
["7A",null,"Smokey Lights","234567890123","CSE","2012-10-13","777",10,"Y","Nevada Retailer","955577331",null,null,"555 Elm Street","Somewhere","NV","12345"]
["10B",null,"Asian De-Lights","987654321098","CSE","2012-10-06","757",50,null,"CA Distributor","002654321",null,null,"123 Main Street","Anytown","CA","91234"]
["10B",null,"Asian De-Lights","987654321008","CAR","2012-10-06","757",44,null,"CA Distributor","002654321",null,null,"123 Main Street","Anytown","CA","91234"]
["10B",null,"European Menthol","222333444555","CSE","2012-10-19","852",25,null,"CA Distributor","002654321",null,null,"123 Main Street","Anytown","CA","91234"]
["10B",null,"Latin Slims","333555777111","CSE","2012-10-21","963",101,null,"CA Distributor","002654321",null,null,"123 Main Street","Anytown","CA","91234"]
["F","CE","Smokey 100s","123456780002","CAR","2012-10-31","SCHF1012",7147,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["F","CE","Smokey Lights","234567890001","CAR","2012-10-31","SCHF1012",22822,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["F","CE","Smokey Menthol","345678900004","PAK","2012-10-31","SCHF1012",214953,null,null,null,"Big Cigarette Manufacturer Inc","032123456",null,null,null,null,null,null,"147 Filter Way","Anytown","CA","91234"]
["F","CE","Smokey Lights","234567890123","CSE","2012-10-31","SCHF1012",4835,null,null,null,"CA Distributor","002654321",null,null,null,null,null,null,"123 Main Street","Anytown","CA","91234"]
["F","CE","European Menthol","222333444500","CAR","2012-10-31","SCHF1012",6352,null,null,null,"Foreign Manufacturer Inc","555667778",null,null,null,null,null,null,"777 Sunrise Way","London",null,null,null,"GBR"]