{"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":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["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."]
["California Department of Tax and Fee Administration"]
["DATA ENTRY FORM INSTRUCTIONS FOR\nSCHEDULE - MANUFACTURER/IMPORTER REPORT OF TOBACCO PRODUCTS \nDELIVERED OR SHIPPED INTO CALIFORNIA"]
["The \"SchDataEntry\" worksheet is provided as a tool to key reportable transactions into a California \nDepartment of Tax and Fee Administration (CDTFA) accepted format that will generate a flat file that can be uploaded to the 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, then select Security\n   The Security window will pop-up\n   Go to the Security Level Tab\n   Select Medium \n   Press 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\n   combination, make sure to clear the data so that it is not accidentally included in this schedule\n   flat file generation process.  \n\n                     Clear or delete the account number in cell A5:E5. Do not delete the row, only\n                     delete the contents of the cell by selecting the cell and pressing the Delete key.\n\n                    Clear the PERIOD CODE in cell F5. Do not delete the row, only delete the\n                    contents of the cell by selecting the cell and pressing the Delete key.\n\n                    Remove transactions. You can either delete the rows or clear the contents of the\n                    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 select Delete.  \n                    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\n   PERIOD CODE (in MMYY format, where the MM is for the numeric version of month \"01\" \n   through \"12\", and the YY is the numeric value of year, \"07\" is equal to \"2007\") in row (5).\n\n  If there is at least one transaction for the reporting period, enter transaction information starting\n  on row (8). The following are line by line instructions for entering 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\n   products into California."]
["   Column B: NAME OF PURCHASER\n   Enter the name of the purchaser. Length of name will be truncated to the first 40\n   characters."]
["      Column C: DISTRIBUTOR'S CA LICENSE NO. OR EXEMPT CODE\n      Enter the California license number (XXXXXXXXX) or enter the following codes\n      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 \n      commissaries and Navy or Coast Guard Ships' stores and/or sales to U.S.\n      Department of Veterans Affairs\n      400 -- Sale or transfer to law enforcement (requires prior authorization from the\n      California Department of Tax and Fee Administration)"]
["  Column D: INVOICE OR DOCUMENT NUMBER FOR DELIVERY OR \n  SHIPMENT\n  Enter the invoice or document number associated with the delivery or shipment. \n  Length of invoice or document number will be truncated to the first 20 characters."]
["  Column E: TYPE OF TOBACCO PRODUCT\n  Enter the number below that corresponds with the type of tobacco products \n  delivered or shipped: \n     1 -- Snuff\n     2 -- Chewing Tobacco\n     3 -- Pipe Tobacco\n     4 -- Cigars\n     5 -- Roll-Your-Own\n     6 -- e-Cigs/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 truncated to the \n  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.  Add   \n  the total wholesale cost for the reporting period and enter the total amount on line 1A of   \n  form CDTFA-501-TIM."]
["NO TRANSACTIONS TO ENTER\nIf 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\n         or clear the contents of the transaction rows. To delete a row, select the row(s) to\n         delete by selecting the row (such as row 8) and then right clicking on the row number\n         and select Delete.Otherwise selecting rows and pressing the Delete key will clear out\n         the contents of the row (selected area)."]
["4 Generate a Flat File\n\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,\n   an error will display in the status area cell (A3) as well as in Column I Error/Warning\n   Messages. \n\n   If a flat file was created the status area cell (A3) will display a message stating that a flat file\n   was created. There may be warning messages on rows for potential issues with specific\n   transaction data.\n\n   If there were no transactions, a message box will pop up asking if you want to create a No\n   Activity Schedule.  If you select Yes, a no activity flat file schedule will be created as long\n   as the reporting ACCOUNT NUMBER and PERIOD meet the flat file standards and\n   requirements.\n"]
["End of worksheet"]

{"sheet":"SchDataEntry","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,0,5,3],[2,2,2,8],[3,2,3,6],[4,2,4,6],[0,0,0,8],[1,0,1,8]]}
["Enter your account number on A4 and Period on B4.  Proceed to enter the schedule information on A7.  You can create a Schedule Flat File on A5 or clear the Schedule Data on B5.  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 A6 or column I."]
["DATA ENTRY FORM\nSCHEDULE - MANUFACTURER/IMPORTER REPORT OF TOBACCO PRODUCTS DELIVERED OR SHIPPED INTO CALIFORNIA"]
["ACCOUNT NUMBER","PERIOD (MMYY)","intentionally left blank"]
[null,null,"intentionally left blank",null,null,null,null,"SUM OF COL(H)"]
["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 NO.","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"]