Spreadsheet: 143935d1330631029-excel-2007-if-formula-help-ccl-expense-report-trial
Sheet: Account Codes

Account: | Code: | Mfg Overhead Expense: |  | Type:
 | 5210 | Raw Materials | Product Material | Cost of Goods Sold
 | 6502 | Auto & Truck Expense | Fuel, Gas & Propane | Cost of Goods Sold
 | 6503 | Auto & Truck Expense | Maintenance | Cost of Goods Sold
 | 6504 | Auto & Truck Expense | Other | Cost of Goods Sold
 | 6381 | Calibration-Gage Expense | Calibration Services | Cost of Goods Sold
 | 6382 | Calibration-Gage Expense | Gages | Cost of Goods Sold
 | 6314 | Chemicals | Coolant, Lubricant, Other | Cost of Goods Sold
 | 6315 | Chemicals | Vibratory, Cleaning | Cost of Goods Sold
 | 6318 | Chemicals | Welding Gases | Cost of Goods Sold
 | 6319 | Chemicals | Laser Gases | Cost of Goods Sold
 | 5213 | Discounts | Purchases-Discounts | Cost of Goods Sold
 | 6462 | Employee Relations | Company Meals | Cost of Goods Sold
 | 6463 | Employee Relations | Other | Cost of Goods Sold
 | 6320 | Equipment Tooling | Welding | Cost of Goods Sold
 | 6321 | Equipment Tooling | Other | Cost of Goods Sold
 | 6322 | Equipment Tooling | Machine Tool Holders | Cost of Goods Sold
 | 6323 | Equipment Tooling | Press Brake Tooling | Cost of Goods Sold
 | 6510 | Expense Report | Mileage | Cost of Goods Sold
 | 6865 | Expense Report | Cell Phone | Cost of Goods Sold
 | 6222 | Freight Out/Delivery Expense | Local Contract Delivery | Cost of Goods Sold
 | 6223 | Freight Out/Delivery Expense | Local Expedited Delivery | Cost of Goods Sold
 | 6224 | Freight Out/Delivery Expense | Freight Out Sales 4030 | Cost of Goods Sold
 | 6225 | Freight Out/Delivery Expense | UPS | Cost of Goods Sold
 | 6226 | Freight Out/Delivery Expense | Other | Cost of Goods Sold
 | 6660 | Rent/Lease Expense | Buildings | Cost of Goods Sold
 | 6670 | Rent/Lease Expense | Equipment | Cost of Goods Sold
 | 6680 | Rent/Lease Expense | Copier | Cost of Goods Sold
 | 6610 | Repairs & Maintenance | Buildings | Cost of Goods Sold
 | 6620 | Repairs & Maintenance | Equipment | Cost of Goods Sold
 | 6630 | Repairs & Maintenance | Copier | Cost of Goods Sold
 | 6340 | Shipping & Packing Materials | Packaging Materials | Cost of Goods Sold
 | 6341 | Shipping & Packing Materials | Pallets | Cost of Goods Sold
 | 6310 | Shop Supplies | Other Supplies | Cost of Goods Sold
 | 6311 | Shop Supplies | Abrasive - Perishable | Cost of Goods Sold
 | 6312 | Shop Supplies | Cutting Tool - Perishable | Cost of Goods Sold
 | 6340 | Shop Supplies | Ship - Packaging Supplies | Cost of Goods Sold
 | 6331 | Small Tools | Hand Tools | Cost of Goods Sold
 | 6332 | Small Tools | Power Tools | Cost of Goods Sold
 | 6371 | T&D Expenses | Sub Cont / Other | Cost of Goods Sold
 | 6372 | T&D Expenses | Sub Cont / Wire EDM | Cost of Goods Sold
 | 6373 | T&D Expenses | Die Supplies | Cost of Goods Sold
 | 6374 | T&D Expenses | Tool Steel | Cost of Goods Sold
 | 6805 | Utilities | Electric | Cost of Goods Sold
 | 6810 | Utilities | Gas | Cost of Goods Sold
 | 6815 | Utilities | Sewer | Cost of Goods Sold
 | 7551 | Advertising-Marketing Expense | Website | SG&A Expense
 | 7552 | Advertising-Marketing Expense | Printing-Brochures | SG&A Expense
 | 7553 | Advertising-Marketing Expense | Outsourced Mkt Services | SG&A Expense
 | 7561 | Advertising-Marketing Expense | Company Store | SG&A Expense
 | 7410 | Business Services | Accounting Fees | SG&A Expense
 | 7420 | Business Services | Legal Fees | SG&A Expense
 | 7430 | Business Services | Consulting | SG&A Expense
 | 7431 | Business Services | Sales Representative | SG&A Expense
 | 7440 | Business Services | Professional Fees | SG&A Expense
 | 7442 | Business Services | Business License & Permits | SG&A Expense
 | 7450 | Business Services | ISO 9000 Expense | SG&A Expense
 | 7540 | Business Services | Printing & Reproduction | SG&A Expense
 | 7851 | Communications | Internet/Phone Service | SG&A Expense
 | 7865 | Communications | Cellular | SG&A Expense
 | 7340 | Computer/Software | Computer Equipment | SG&A Expense
 | 7341 | Computer/Software | Computer Software | SG&A Expense
 | 7342 | Computer/Software | Software Maint. Contracts | SG&A Expense
 | 7261 | Employee Educational Expense | Training Expense | SG&A Expense
 | 7262 | Employee Educational Expense | Educational Materials | SG&A Expense
 | 7461 | Employee Relations | Coffe, Tea, etc | SG&A Expense
 | 7462 | Employee Relations | Employee Meals | SG&A Expense
 | 7463 | Employee Relations | Other | SG&A Expense
 | 7501 | Expense Report: Auto & Truck Expense | Mileage | SG&A Expense
 | 7502 | Expense Report: Auto & Truck Expense | Fuel | SG&A Expense
 | 7503 | Expense Report: Auto & Truck Expense | Maintenance | SG&A Expense
 | 7520 | Expense Report: Customer Entertainment | Meals | SG&A Expense
 | 7521 | Expense Report: Customer Entertainment | Entertainment | SG&A Expense
 | 7522 | Expense Report: Customer Entertainment | Lodging | SG&A Expense
 | 7523 | Expense Report: Customer Entertainment | Other | SG&A Expense
 | 7511 | Expense Report: Travel Expense | Air Fare | SG&A Expense
 | 7512 | Expense Report: Travel Expense | Car Rental | SG&A Expense
 | 7513 | Expense Report: Travel Expense | Hotel | SG&A Expense
 | 7514 | Expense Report: Travel Expense | Toll | SG&A Expense
 | 7515 | Expense Report: Travel Expense | Airport Parking | SG&A Expense
 | 7516 | Expense Report: Travel Expense | Advance - Cash Back | SG&A Expense
 | 7270 | Insurance Expense | General Liability | SG&A Expense
 | 7271 | Insurance Expense | Aviation Product Liability | SG&A Expense
 | 7272 | Insurance Expense | Flood | SG&A Expense
 | 7273 | Insurance Expense | Life Insurance | SG&A Expense
 | 7400 | Janitorial/Groundskeeping | Lawn Service | SG&A Expense
 | 7401 | Janitorial/Groundskeeping | Pest Control | SG&A Expense
 | 7890 | Janitorial/Groundskeeping | Refuse Service | SG&A Expense
 | 7351 | Janitorial/Groundskeeping | Janitorial Service | SG&A Expense
 | 7352 | Janitorial/Groundskeeping | [NAME] | SG&A Expense
 | 7310 | Office Equipment/Supplies | Consumable Supplies | SG&A Expense
 | 7311 | Office Equipment/Supplies | Printer Cartriges | SG&A Expense
 | 7320 | Office Equipment/Supplies | Non-Consumable Supplies | SG&A Expense
 | 7360 | Office Equipment/Supplies | Copier Paper | SG&A Expense
 | 7691 | Postage Expense | PO Box Rental | SG&A Expense
 | 7692 | Postage Expense | Postage | SG&A Expense
 | 7694 | Postage Expense | Postage Machine Lease | SG&A Expense
 | 7660 | Rent/Lease Expense | Buildings | SG&A Expense
 | 7670 | Rent/Lease Expense | Equipment | SG&A Expense
 | 7680 | Rent/Lease Expense | Copier | SG&A Expense
 | 7610 | Repairs & Maintenance | Buildings | SG&A Expense
 | 7620 | Repairs & Maintenance | Equipment | SG&A Expense
 | 7625 | Repairs & Maintenance | Phone | SG&A Expense
 | 7630 | Repairs & Maintenance | Copiers | SG&A Expense
 | 7391 | Safety/Medical | Consumable Supplies | SG&A Expense
 | 7392 | Safety/Medical | Non-Consumable Supplies | SG&A Expense
 | 7491 | Security Expense | [NAME] | SG&A Expense
 | 7492 | Security Expense | Security Guard Services | SG&A Expense
 | 7755 | Taxes | Property Expense | SG&A Expense
 | 7756 | Taxes | Car Tags | SG&A Expense
 | 7757 | Taxes | Other | SG&A Expense
 | 7758 | Taxes | Penalty | SG&A Expense
 | 7760 | Taxes | Franchise Tax | SG&A Expense
 | 7780 | Taxes | Utility Taxes | SG&A Expense
 | 7805 | Utilities | Electric | SG&A Expense
 | 7810 | Utilities | Gas | SG&A Expense
 | 7815 | Utilities | Water/Sewer | SG&A Expense