{"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":4,"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":51,"n_cols":1,"rows_kept":51,"cut":false,"hidden":false,"merged":[[9,0,9,2],[13,0,13,2]]}
["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-501-CM-F (8-21)                                                                                                                                                                                                                                                                                                                               STATE OF CALIFORNIA"]
["CIGARETTE MANUFACTURER ONLINE FILING TEMPLATE                         CALIFORNIA DEPARTMENT OF TAX AND FEE ADMINISTRATION"]
["Instructions"]
["1. Enter the transaction information for all schedules applicable to this filing on the Transaction worksheet. Additional information on reporting transactions is available below in 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 setting 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 file to your tax form when filing online. Note: The Schedule/Transaction file has a \".txt\"  extension, not \".xlsm.\""]
["Click here to go to the log-in 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 only the nine-digit numeric portion of the account number. No letters or dashes should be included. An account number, like 002-123456, should be entered as 002123456."]
["3. Federal tax identification numbers (FEIN) and social security numbers (SSN) should be entered using only the nine-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."]
["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 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, 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 setting 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 three in the Instructions section."]
["12. Once you have successfully created an FLT file, it is highly recommended that you change your security setting back to a higher level."]
["Click here to view an example template with data."]
["Contact the 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:"]
["California 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."]

{"sheet":"Transaction","index":2,"n_rows":10,"n_cols":29,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["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\nFEIN","Delivery Service\nStreet","Delivery Service\nCity","Delivery Service\nState","Delivery Service\nZIP","Delivery Service\nZIP + 4","Delivery Service\nPhone","Delivery Service\nPrice"]
["2C","6A","XYZ MANUFACTURING","PM","BATISKA RED 100","182452358421","CAR","2021-08-15","54812",100,20000,16800,"123 DISTRIBUTING","458421523","8542 J ST","SACRAMENTO","CA","95816","0001","US"]
["2C","6A","123 MANUFACTURING","NPM","ACENTOS KING BOX","145254128542","PAK","2021-08-16","54813",100,2000,1600,"ABC DISTRIBUTING","458421524","2854 WILLOW CIR","BAKERSFIELD","CA","95843","0002","US"]
["2C","6A","ABC MANUFACTURING","PM","ROCKSTAR MENTHOL 100","154851238542","CAR","2021-08-17","54814",50,10000,8400,"XYZ DISTRIBUTING","458421525","4852 BANK ST","CARLSBAD","CA","98452","0003","US"]
["2C","7A","XYZ MANUFACTURING","NPM","CAPRICORN FILTER KING","256666251325","CAR","2021-08-18","54815",100,20000,null,"NM DISTRIBUTING","458548954","2856 G ST","MEXICO CITY","NM","95842","0003","US","WAYFAIR FREGHT","845123658","8390 HALL ST","ST LOUIS","MO","63147","0002","3143811752",458]
["2C","7A","123 MANUFACTURING","PM","RICH GOLD 100","854745859610","CAR","2021-08-19","54816",50,10000,null,"NV DISTRIBUTING","458451254","1600 ALAMO WY","LAS VEGAS","NV","48452","0002","US","CARRIER LINES","845556952","205 SOCCER PARK ROAD","FENTON","MO","63026","0001","6363268283",854]
["2C","7A","ABC MANUFACTURING","PM","STONE SILVER 100","228546952013","PAK","2021-08-20","54817",75,1500,null,"KY DISTRIBUTING","458548955","2857 G ST","LOUISVILLE","KY","54152","0004","US"]
["2C","8A","XYZ MANUFACTURING","NPM","FIREFLY MENTHOL BLUE","227458502142","CAR","2021-08-21","54818",150,30000,null,"S.T. MILITARY EXCHANGE","458548955","3542 BAKER DR","MODESTO","CA","95845","0215","US"]
["2C","8A","123 MANUFACTURING","PM","BLUEJAY RED 100","685346582105","PAK","2021-08-22","54819",225,4500,null,"J.D. VETERANS ADMIN","458548956","3152 CLEMSON ST","STOCKTON","CA","95842","0385","US"]
["2C","8A","ABC MANUFACTURING","NPM","SCARLETT 100 SOFT","875325469852","CAR","2021-08-23","54820",345,69000,null,"SMF COMMISARY","458548957","2452 AIRPORT WY","SACRAMENTO","CA","95842","0351","US"]