{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tables (CDTFA Staff Only)","Instructions","Transaction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Test/Prod","Schedule Code","Tax Jurisdiction Codes","UOM"]
["T","2C","6A","CAR","Acct Nbr:",555888222,{"$f":"TEXT(F2,\"000000000\")","v":"555888222"}]
["P","2c","7A","PAK","Begin:","2021-03-01"]
["t",null,"8A","car","End:","2021-03-31"]
["p",null,"6a","pak","Version","3.0"]
[null,null,"7a","caR"]
[null,null,"8a","cAr",null,{"$f":"LEN(F2)","v":9}]
["MSA Status",null,null,"cAR"]
["PM",null,null,"Car"]
["NPM",null,null,"CaR"]
["pm",null,null,"CAr"]
["npm",null,null,"paK"]
["Pm",null,null,"pAk"]
["Npm",null,null,"pAK"]
["pM",null,null,"Pak"]
["npM",null,null,"PaK"]
["NPm",null,null,"PAk"]
["NpM"]
["nPM"]
["nPm"]

{"sheet":"Instructions","index":1,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,0,50,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[39,0,39,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[49,0,49,1],[51,0,51,1],[0,2,51,2],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1]]}
["This workbook has 2 active worksheets - Instructions 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 the macros to run.\nCDTFA-810-CTF-F (10-22)                                                                                                                                                                                                                                                                                                                              ","STATE OF CALIFORNIA","Intentionally left blank"]
["CIGARETTE MANUFACTURER—CIGARETTE TAX DISBURSEMENT SCHEDULE                       ","  CALIFORNIA DEPARTMENT OF TAX AND FEE ADMINISTRATION"]
["INSTRUCTIONS"]
["1. Enter the transaction information for the Cigarette Tax Disbursement Schedule on the Transaction worksheet. Additional information about reporting transactions is available below under General Information."]
["2. Save this completed Excel file for your records."]
["3. Create a Schedule/Transaction flat (FLT) file by clicking on the button below. An FLT file will have a .txt 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 does not display a Save As pop-up box or opens the Microsoft Visual Basic macro editor, your security settings \nmay be set too high."]
["Click here for instructions on changing the security settings"]
["Press Enter to create Schedule/Transaction FLT file","Intentionally left blank"]
["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."]
["Click here to go to the login webpage"]
["GENERAL INFORMATION"]
["General Data Entry"]
["1. All numbers must be entered as whole numbers. Do not use decimals. Round to the nearest whole number."]
["2. California Department of Tax and Fee Administration (CDTFA) account numbers should be entered using the nine-digit numeric account number, excluding the dash. For example, account number 123-456789 should be entered as 123456789."]
["3. Employer identification numbers (EIN) and social security numbers (SSN) should be entered using the nine-digit numeric number, excluding the dash. For example, EIN of 95-1234567 should be entered as 951234567, and SSN of 987-65-4321 should be entered as 987654321."]
["4. Transactions do not need to be grouped by schedule number or be in numeric order."]
["Unit of Measure (UOM) Codes"]
["CAR—Carton of product"]
["PAK—Pack of product"]
["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 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, Tax Jurisdiction Codes, UOM Codes, and other transaction reporting information:"]
["Click here for schedule descriptions and instructions"]
["For schedule code information:"]
["Click here for schedule code information"]
["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 settings, 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 three in the Instructions section."]
["12. Once you have successfully created an FLT file, it is highly recommended that you change your security settings back to a higher level."]
["Click here to view an example template with data"]
["Contact CDTFA "]
["If you have any questions about the schedule instructions or reporting requirements, contact the Business Tax and Fee Division at:"]
["Email: CDTFACTeFile@cdtfa.ca.gov"]
["Mail:\nCalifornia Department of Tax and Fee Administration\nBusiness Tax and Fee Division\nPO Box 942879\nSacramento CA 94279-0088"]
["Disclaimer"]
["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."]
["For more information, visit our website at www.cdtfa.ca.gov. You may also call our Customer Service Center at 1-800-400-7115 (CRS:711).\nCustomer service representatives are available Monday through Friday from 7:30 a.m. to 5:00 p.m. (Pacific time), except state holidays."]
["End of sheet"]

{"sheet":"Transaction","index":2,"n_rows":1,"n_cols":30,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,29,987,29]]}
["Schedule\nCode","Tax Jurisdiction\nCode","Manufacturer\nName","MSA\nStatus","Product\nBrand/Variant Name","UPC","UPC's\nUnit of Measure\n(UOM) Code","Document/\nBOL Date","Document/\nBOL Number","Quantity","Total\nCigarettes","Total\nCigarettes\nSales Price","Buyer Name","Buyer ID","Destination\nStreet","Destination\nCity","Destination\nState","Destination\nZIP","Destination\nZIP + 4","Destination\nCountry","Delivery Service\nName","Delivery Service\nEIN","Delivery Service\nStreet","Delivery Service\nCity","Delivery Service\nState","Delivery Service\nZIP","Delivery Service\nZIP + 4","Delivery Service\nTelephone","Delivery Service\nPrice","Intentionally left blank"]