{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","SchDataEntry"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Instructions","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,19,2],[18,0,18,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],[8,0,8,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],[19,0,19,1]]}
["There are two worksheets in this workbook - Instructions and Schedule Data Entry.  Use the down arrow to navigate through the workbook.  If you receive a Security Warning, select Enable Content to allow the macros to run.                                                                                                                                                              CDTFA-501-MIT REV. 7 (9-22)  ","STATE OF CALIFORNIA","Intentionally left blank"]
["SCHEDULE — MANUFACTURER/IMPORTER REPORT OF TOBACCO PRODUCTS DELIVERED \nOR SHIPPED INTO CALIFORNIA                                                                           ","CALIFORNIA DEPARTMENT OF TAX AND FEE ADMINISTRATION"]
["DATA ENTRY FORM INSTRUCTIONS"]
["The \"SchDataEntry\" worksheet is provided as a tool to key reportable transactions into an accepted format that will generate a flat file to be uploaded to \nCalifornia Department of Tax and Fee Administration (CDTFA) computer system(s).  "]
["The following instructions are provided as a guideline on how to use this workbook to generate a flat file."]
["1. Make sure Excel will allow macros to run\n   Go to the Tools Menu, select Macros, and then select Security\n   The Security window will pop up\n   Go to the Security Level tab\n   Select Medium \n   Click OK"]
["2. Clean up SchDataEntry worksheet\n   Click the Clear Schedule Data button.\n   OR\n\n   If you are using this workbook after creating a schedule for another account period code combination, make sure to clear the data so that it is not accidentally \n   included in this schedule flat file generation process.  \n\n       Clear or delete the account number in cell A5. Do not delete the row; only delete the contents of the cell by selecting the cell and clicking the Delete key.\n\n       Clear the PERIOD CODE in cell B5. Do not delete the row; only delete the contents of the cell by selecting the cell and clicking the Delete key.\n\n       Remove transactions. You can either delete the rows or clear the contents of the transaction rows. To delete a row, select the row(s) to delete by selecting the row \n       (such as row 8) and then right-clicking on the row number and selecting Delete. Otherwise, selecting rows and pressing the Delete key will clear out the contents of \n       the row (selected area)."]
["3. Enter Schedule Data for an account and period code combination\n   Enter the schedule information including the ACCOUNT NUMBER (XXXXXXXXX) and the PERIOD CODE (in MMYY format, where MM is the two-digit \n   month and YY is the two-digit year) in row (5).\n\n   If there is at least one transaction for the reporting period, enter transaction information starting on row (8). The following are line-by-line instructions for entering \n   data for a transaction:\n                \n    \n   "]
["   Column A: DATE OF DELIVERY OR SHIPMENT\n   Enter date of the delivery or shipment (in MM/DD/YYYY format) of tobacco products into California."]
["   Column B: NAME OF PURCHASER\n   Enter the name of the purchaser. Length of name will be reduced to the first 40 characters."]
["   Column C: DISTRIBUTOR'S CA LICENSE NUMBER OR EXEMPT CODE\n   Enter the California license number (XXXXXXXXX) or enter the following codes for other sales (do not include dashes or leave blank spaces):  \n   100 — Interstate and Foreign Commerce (Export out of California or country)\n   200 — Common Carrier engaged in interstate and foreign passenger service\n   300 — U.S. Army, Air Force, Navy, Marine Corps, or Coast Guard exchanges and commissaries and Navy or Coast Guard Ships' stores and/or sales to \n                U.S. Department of Veterans Affairs\n   400 — Sale or transfer to law enforcement (requires prior authorization from CDTFA)"]
["  Column D: INVOICE OR DOCUMENT NUMBER FOR DELIVERY OR SHIPMENT\n  Enter the invoice or document number associated with the delivery or shipment. \n  Length of invoice or document number will be reduced to the first 20 characters."]
["  Column E: TYPE OF TOBACCO PRODUCT\n  Enter the number below that corresponds with the type of tobacco products delivered or shipped: \n     1 — Snuff\n     2 — Chewing Tobacco\n     3 — Pipe Tobacco\n     4 — Cigars\n     5 — Roll-Your-Own\n     6 — eCigarettes/Vapes\n     7 — Other type of tobacco product"]
["  Column F: TOBACCO PRODUCT BRAND NAME\n  Enter the tobacco product brand name. Length of name will be reduced to the first 40 characters."]
["  Column G: ROLL-YOUR-OWN TOBACCO\n  Enter the ounces only if the product was roll-your-own tobacco delivered or shipped."]
["  Column H: WHOLESALE COST OF TOBACCO PRODUCTS\n  Enter the wholesale cost of tobacco products delivered or shipped into California."]
["  NO TRANSACTIONS TO ENTER\n  If there are no transactions to enter for the reporting account and reporting period combination, follow these instructions:\n\n     Make sure there are no transactions on the worksheet. You can either delete the rows or clear the contents of the transaction rows. To delete a row, select the row(s) to delete \n     by selecting the row (such as row 8) and then right-clicking on the row number and selecting Delete. Otherwise, selecting rows and clicking the Delete key will clear out the \n     contents of the row (selected area)."]
["4. Generate a Flat File\n   Click on the button Press Enter to Create Schedule Flat File.\n\n   If an error was encountered while an attempt was made to create a flat file of the schedule, an error will display in the status area cell (C4) as well as in \n   Column I Error/Warning Messages. \n\n   If a flat file was created, the status area cell (C4) will display a message stating that a flat file was created. There may be warning messages on rows for potential issues \n   with specific transaction data.\n\n   If there were no transactions, a message box will pop up asking if you want to create a No Activity Schedule. If you select Yes, a no activity flat file schedule will be created as \n   long as the reporting ACCOUNT NUMBER and PERIOD meet the flat file standards and requirements.\n"]
["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).                                                                                                                                         Customer 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":"SchDataEntry","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,9,1048575,9],[4,8,5,8],[3,2,3,8],[4,2,4,6],[5,2,5,6],[0,0,0,8],[1,0,1,8],[2,0,2,8]]}
["Enter your account number on A5 and Period on B5.  Proceed to enter the schedule information on A8.  You can create a Schedule Flat File on A6 or clear the Schedule Data on B6.  Use the down and right arrow to navigate through the worksheet.  Data ends on Column I.  After creating a Schedule Flat File, you can view for any errors on cell C4 or column I.\nCDTFA-501-MIT REV. 7 (9-22)",null,null,null,null,null,null,null,null,"Intentionally left blank"]
["SCHEDULE — MANUFACTURER/IMPORTER REPORT OF TOBACCO PRODUCTS DELIVERED OR SHIPPED INTO CALIFORNIA"]
["DATA ENTRY FORM"]
["ACCOUNT NUMBER","PERIOD (MMYY)","File creation messages will populate this cell."]
[null,null,"intentionally left blank",null,null,null,null,"SUM OF COL(H)","Intentionally left blank"]
["Press Enter to \nCreate Schedule Flat File","Press Enter to \nClear Schedule Data","intentionally left blank",null,null,null,null,{"$f":"IF(ISERROR(SUM(VALUE(H8:H1048576))),\"Error in Column H\",SUM(VALUE(H8:H1048576)))","v":0}]
["A\nDATE OF DELIVERY\nOR SHIPMENT","B\nNAME OF\nPURCHASER","C\nDISTRIBUTOR'S\nCA LICENSE NUMBER","D\nINVOICE OR DOCUMENT NUMBER\nFOR DELIVERY OR SHIPMENT","E\nTYPE OF\nTOBACCO PRODUCT","F\nTOBACCO PRODUCT\nBRAND NAME","G\nROLL-YOUR-OWN\nTOBACCO","H\nWHOLESALE COST OF\nTOBACCO PRODUCTS","I\nERROR/WARNING\nMESSAGE"]