jagomart
digital resources
picture1_Excel Sheet Download 31194 | Out Of State Tobacco Example


 192x       Filetype XLSX       File size 0.12 MB       Source: www.oregon.gov


File: Excel Sheet Download 31194 | Out Of State Tobacco Example
sheet 1 outofstate sch transaction tobacco schedule transactions enter the count of rows you need and the click quot increase rows quot button to increase rows for guidance refer to ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Out-of-state Sch_Transaction
| Tobacco Schedule Transactions

Enter the count of rows you need and the click "Increase Rows" button to increase rows.





For guidance refer to the 'ODOR Excel Template User Guide'





































Row Count
Enter Rows Needed










































Increase Rows 100


Validate
Copy Last Schedule





















































































Do you have any Schedules? YES If “NO” is selected, delete all data in Sch_Transaction to validate the tab.


























































































Transaction Document






Name and Address








Transactions














Delivery Service












Schedule Type Date Document Type Document Number Customer Type EIN State EIN Customer ID Business Name Line 1 Business Name Line 2 Type of Address Foreign Address? Address Line 1 Address Line 2 City State (or Province) Country Code* Zip (or Postal Code) Federal Description State Description MSA Status Price Tax Jurisdicion Product Description Manufacturer Manufacturer EIN Brand Family Unit Unit Description Weight Volume Value Quantity Stick Count Extended Taxable Amount Is Delivery Service Used? Business Name Line 1 * Business Name Line 2 EIN Foreign Address? * Address Line 1* Address Line 2 City* State (or Province)* Country Code* Zip (or Postal Code) * In Care of Name Phone Number *

1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Roll Your Own OR-TP1 N/A 98.64 OR Ciggy's Tobacco Manufacturer 1 123456789 Ciggy's 1.00 PCH 0.65 2.74 36 0 98.64 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Pipe Tobacco OR-TP1 N/A 32.00 OR Smokey's Pipe Tobacco Manufacturer 1 123456789 Smokey's 1.00 BAG 6.00 4.00 8 0 32.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Snuff OR-MS1 N/A 83.30 OR Penguin Fine Cut Manufacturer 2 567890123 Penguin 1.00 CAN 1.20 2.38 35 0 35.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Snuff OR-MS1 N/A 29.85 OR Penguin Pouch Straight Manufacturer 2 567890123 Penguin 1.00 CAN 0.82 1.99 15 0 15.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Snuff OR-MS2 N/A 48.06 OR Penguin Straight Big TUB Manufacturer 2 567890123 Penguin 1.00 TUB 7.20 16.02 3 0 21.60 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Chewing Tobacco OR-MS3 N/A 13.80 OR M.L Mini Chew Manufacturer 2 567890123 M.L 1.00 PCH 1.15 2.43 12 0 12.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Chewing Tobacco OR-MS4 N/A 111.84 OR M.L Chew Manufacturer 2 567890123 M.L. 1.00 PCH 3.00 4.66 24 0 72.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Chewing Tobacco OR-MS4 N/A 35.04 OR Pluggy Plug Chewing Tobacco Manufacturer 2 567890123 M.L. 1.00 PLG 2.00 2.92 12 0 24.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Large Cigar OR-CGR1 N/A 92.50 OR Big O's Cigar Manufacturer 3 890123456 Big O 1.00 STK 0.34 3.70 25 25 25.00 NO












1A 2019-01-10 Invoice 5009 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Small Cigar OR-CGR2 N/A 86.00 OR Big O's Cigarillo JR 2pk Manufacturer 3 890123456 Big O 1.00 FOI 0.00 0.86 100 200 86.00 NO












1A 2019-01-15 Invoice 5013 Retailer 787878787 999999999 789999 Tobacco 4 Less
Location NO 98922 Center St.
Salem OR
97301 Snuff OR-MS1 N/A 119.00 OR Penguin Fine Cut Manufacturer 2 567890123 Penguin 1.00 CAN 1.20 2.38 50 0 50.00 NO












1A 2019-01-15 Invoice 5013 Retailer 787878787 999999999 789999 Tobacco 4 Less
Location NO 98922 Center St.
Salem OR
97301 Snuff OR-MS1 N/A 69.65 OR Penguin Pouch Straight Manufacturer 2 567890123 Penguin 1.00 CAN 0.82 1.99 35 0 35.00 NO












1A 2019-01-15 Invoice 5013 Retailer 787878787 999999999 789999 Tobacco 4 Less
Location NO 98922 Center St.
Salem OR
97301 Chewing Tobacco OR-MS4 N/A 111.84 OR M.L Chew Manufacturer 2 567890123 M.L 1.00 PCH 3.00 4.66 24 0 72.00 NO












2D 2019-01-22 Credit Memo CM5020 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Roll Your Own OR-TP1 N/A 16.44 OR Ciggy's Tobacco Manufacturer 1 123456789 Ciggy's 1.00 PCH 0.65 2.74 6 0 16.44 NO












2D 2019-01-22 Credit Memo CM5020 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Snuff OR-MS1 N/A 11.90 OR Penguin Fine Cut Manufacturer 2 567890123 Penguin 1.00 CAN 1.20 2.38 5 0 5.00 NO












2D 2019-01-22 Credit Memo CM5020 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Chewing Tobacco OR-MS4 N/A 55.92 OR M.L. Chew Manufacturer 2 567890123 M.L. 1.00 PCH 3.00 4.66 12 0 36.00 NO












2D 2019-01-22 Credit Memo CM5020 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Large Cigar OR-CGR1 N/A 92.50 OR Big O's Cigar Manufacturer 3 890123456 Big O 1.00 STK 0.34 3.70 25 25 25.00 NO












2D 2019-01-22 Credit Memo CM5020 Retailer 666666666 999999999 987987 Tobacco Store
Location NO 555 1st 2nd St
Portland OR
97203 Small Cigar OR-CGR2 N/A 8.60 OR Big O's Cigarillo JR 2pk Manufacturer 3 890123456 Big O 1.00 FOI 0.00 0.86 10 20 8.60 NO





























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 2: Out-of-state Invoices
Out of State Tobacco Distributor



Invoice #: 5009
Customer (Buyer)

Date: 1/10/2019
Tobacco Store



5252 Portland St.



Portland, OR 97203




Unit Price Wt (oz) Extended Price
Ciggy's Tobacco 36 $5.00 0.65 $180.00
Smokey's Pipe Tobacco 8 $7.00 6 $56.00
Penguin Fine Cut 35 $4.95 1.2 $173.25
Penguin Pouch Straight 15 $4.95 0.82 $74.25
Penguin Straight Big Tub 3 $30.00 7.2 $90.00
M.L. Mini Chew 12 $5.25 1.15 $63.00
M.L Chew 24 $10.25 3 $246.00
Pluggy Plug Chewing Tob 12 $7.00 2 $84.00
Big O's Cigar 25 $6.00 0.34 $150.00
Big O's Cigaraillo JR 2pk 100 $1.50 0 $150.00











Invoice Total:

$1,266.50

























Out of State Tobacco Distributor



Invoice #: 5013
Customer (Buyer)

Date: 1/15/2019
Tobacco 4 Less



98922 Center St



Salem, OR 97301




Unit Price Wt (oz) Extended Price
Penguin Fine Cut 50 $4.95 1.2 $247.50
Penguin Pouch Straight 35 $4.95 0.82 $173.25
M.L. Chew 24 $10.25 3 $246.00











Invoice Total:

$666.75

























Out of State Tobacco Distributor
CREDIT MEMO - Return Product from Inv.4500

Invoice #: CM5020
Customer (Buyer)

Date: 1/22/2019
Tobacco Store



5252 Portland St.



Portland, OR 97203




Unit Price Wt (oz) Extended Price
Ciggy's Tobacco -6 $5.00 0.65 -$30.00
Penguin Fine Cut -5 $4.95 1.2 -$24.75
M.L. Chew -12 $10.25 3 -$123.00
Big O's Cigar -25 $6.00 0.34 -$150.00
Big O's Cigarillo JR 2pk -10 $2 0 -$15.00






Invoice Total:

($342.75)











The words contained in this file might help you see if this file matches what you are looking for:

...Sheet outofstate sch transaction tobacco schedule transactions enter the count of rows you need and click quot increase button to for guidance refer odor excel template user guide row needed validate copy last do have any schedules yes if ldquo no rdquo is selected delete all data in tab document name address delivery service type date number customer ein state id business line foreign city or province country code zip postal federal description msa status price tax jurisdicion product manufacturer brand family unit weight volume value quantity stick extended taxable amount used care phone a invoice retailer store location st nd portland roll your own ortp na ciggy s pch pipe smokey bag snuff orms penguin fine cut can pouch straight big tub chewing ml mini chew pluggy plug plg large cigar orcgr o stk small cigarillo jr pk foi less center salem d credit memo cm...

no reviews yet
Please Login to review.