• Home
  • Anti virus/Anti malware
    • How to Remove Keyloggers
    • How to Remove Conficker Malware
    • How to Remove Locky and AutoLocky Ransomeware for Free
  • How to Remove a Spyware Infection
  • Article Directory
    • How to Protect Computers using Free Version Antivirus Protection Software
    • Computer/Internet >
      • Audio/Visual >
        • How to Add a Cursor (Mouse Pointer) to a Print Screen Image >
          • Automotive >
            • How to Change Seized Up Spark Plugs
            • How to Change Automatic Transmission Filters
            • How to Do Auto Body Repair Work
            • How to Increase Fuel Economy
            • How to Install Truck Hitch Accessories/Attachments
            • How to Make a Poor Man's Fuel Heater
            • How to mix your own Fuel Additive
            • How to Replace a Door Panel
            • How to Replace Rear Leaf Springs
            • How to Tune-Up a Car Yourself
          • Business >
            • How to Appeal Denial of Unemployment Insurance Benefits
            • How to Create Order Forms
            • How to Perform Maryland Judiciary Case Searches Online
            • How to Promote your New Small Business
            • How to Recover Microsoft Office Professional for free
        • How to Convert qcp to wav
        • How to Create Watermark Protected Images
        • How to Crop a Print Screen Image
        • How to Disable your built-in Camera
        • How to Disable your built-in Microphone
        • How to Draw a Rose Bouquet
        • How to Print Digital Images Actual Size
        • How to Resize an Image to 424 X 282 Pixels, Without Distortion
        • How to Stream M3U's on Websites
      • How to Access a No Boot Hard Drive
      • How to Add Downloads to the Start Menu
      • How to Add a Hibernate Shortcut to your Windows Desktop
      • How to Add a Log Off Shortcut to your Windows desktop
      • How to Add a Restart Shortcut to your Windows desktop
      • How to Add a Second HDD (a Slave Drive) to your PC
      • How to Add a Shutdown Shortcut to your Windows desktop
      • How to Add a Standby Shortcut to your Windows desktop
      • How to Add Keywords to Your Website
      • How to Add Safe Mode to your Windows Boot Menu, by editing the BOOT.INI file
      • How to Backlink your online content
      • How to Block a Pinterest Follower
      • How To Comply with Amazon FTC Regulations
      • How to Connect to a Public WiFi Network
      • How to Create a Bookmarks Favicon
      • How to Create a Downloads Library in Windows Explorer
      • How to Create an active Click to Call Link
      • How to Create an h1 Header
      • How to Defragment the Paging File aka Virtual RAM
      • How to Disable sharing on Windows 7 and 8
      • How to Enable and Disable WiFi on Laptops and Tablets
      • How to Fix an Optical Scroll Mouse
      • How to Force Safe Mode on restart without editing BOOT.ini
      • How to Improve Computer Performance
      • How to Install a Bluetooth USB
      • How to Open Affiliate HTML Ads in New Tabs
      • How to Optimize your online content
      • How to Repair Windows Offline Help and Support
      • How to Replace a Dell Vostro 2510 LCD Inverter
      • How to Replace a Dell Vostro 2510 LCD Screen
      • How to Safely Eject ReadyBoost
      • How to Securely Wipe a Hard Disk Drive
      • How to Set Single-Click Customization on Desktop and Laptop Computers
      • How to Turn Num Lock on by Default in Windows 7 & 8
      • How to Tweet from a Flip Phone
    • Food & Drink >
      • Homemade Spaghetti Sauce with Shiitake Mushrooms and roasted Bell Pepper
      • How to Bake a fantastic Zucchini Pie
      • How to Bake Candied Pecans
      • How to Bake Rosemary-Maple Glazed Pork Loin
      • How to Boil Eggs Without Cracking Shells
      • How to make Ramen Noodles more interesting
      • How to Make your own Chopsticks
      • How to scratch Hearty Turkey and Rice Soup
      • How to Slow Cook Beans & Rice with Sausage
      • How to Slow Cook Venison Stew
    • Health >
      • How to Build a Strong Freestanding Inversion Rack
      • How to Pack a Blood Specimen for Air Travel
      • How to Tell if you have Bed Bugs
    • Holidays & Celebrations >
      • How to Easter Egg Hunt with Candy Filled Eggs
      • How to Hang the American Flag
    • Home Improvement >
      • Concrete >
        • How to Apply/Repair Ornamental Mapping on Historic Field Stone Construction
        • How to Install a vented Glass Block window
        • How to Pour Concrete Footers for Jack Posts
      • Electrical >
        • How to Control Outdoor and Ceiling Lights with a Timer
        • How to Install a Breaker Panel Receptacle
        • How to Install a Switched Receptacle
        • How to Install Outdoor Motion Lights
        • How to Replace a Doorbell
        • How to Replace a Door Chime
        • How to Wire multiple lights on a Porch Circuit
      • Exterior >
        • How to Calculate a Roof Pitch in Degrees
        • How to Frame a Dormer
        • How to Install Vinyl Outdoor Swings
        • How to Install Vinyl Soffit
        • How to Paint Wood Doors
        • How to Reduce your Cooling costs by painting your Roof white
      • Interior >
        • How to Build a Hide A Safe to Protect The Family Jewels
        • How to Build Boxed Ceiling Beams
        • How to Frame Interior Walls
        • How to Install Crawl Space Insulation
        • How to Increase your Cordless Phone Range
        • How to Install Vinyl Mini Blinds
        • How to Remove Spray Foam Insulation From Hands
        • How to Resize an Interior Composite Hollow Core Door
      • Plumbing >
        • How to Repair Copper Pipes
        • How to Replace a Water Heater Thermocouple
        • How to Solder a Plumbing Joint
        • How to Stop Water Pipes From Vibrating
    • Pets >
      • How to Administer a bitter pill to a Cat
      • How to Administer subcutaneous hydrating fluids to an ailing Cat
      • How to Paper train a Green Iguana
    • Wildlife >
      • How to Escape from a Bear in the Woods
      • How to Field Dress a Whitetail Deer
      • How to Legally live-trap and relocate Squirrels in the State of Maryland
    • Yard & Garden >
      • How to Build a Concrete Outdoor Fire Pit
      • How to Build your own Pond
      • How to Change the Tire on a Riding Lawn Mower
      • How to Install a Chain Link Fence Gate
      • How to Seed Flagstone Walkways With Moss
  • Contact Me
  • Amazon Deals
  • Zazzle.com/TomCom
TomComKnowsHow
  • Home
  • Anti virus/Anti malware
    • How to Remove Keyloggers
    • How to Remove Conficker Malware
    • How to Remove Locky and AutoLocky Ransomeware for Free
  • How to Remove a Spyware Infection
  • Article Directory
    • How to Protect Computers using Free Version Antivirus Protection Software
    • Computer/Internet >
      • Audio/Visual >
        • How to Add a Cursor (Mouse Pointer) to a Print Screen Image >
          • Automotive >
            • How to Change Seized Up Spark Plugs
            • How to Change Automatic Transmission Filters
            • How to Do Auto Body Repair Work
            • How to Increase Fuel Economy
            • How to Install Truck Hitch Accessories/Attachments
            • How to Make a Poor Man's Fuel Heater
            • How to mix your own Fuel Additive
            • How to Replace a Door Panel
            • How to Replace Rear Leaf Springs
            • How to Tune-Up a Car Yourself
          • Business >
            • How to Appeal Denial of Unemployment Insurance Benefits
            • How to Create Order Forms
            • How to Perform Maryland Judiciary Case Searches Online
            • How to Promote your New Small Business
            • How to Recover Microsoft Office Professional for free
        • How to Convert qcp to wav
        • How to Create Watermark Protected Images
        • How to Crop a Print Screen Image
        • How to Disable your built-in Camera
        • How to Disable your built-in Microphone
        • How to Draw a Rose Bouquet
        • How to Print Digital Images Actual Size
        • How to Resize an Image to 424 X 282 Pixels, Without Distortion
        • How to Stream M3U's on Websites
      • How to Access a No Boot Hard Drive
      • How to Add Downloads to the Start Menu
      • How to Add a Hibernate Shortcut to your Windows Desktop
      • How to Add a Log Off Shortcut to your Windows desktop
      • How to Add a Restart Shortcut to your Windows desktop
      • How to Add a Second HDD (a Slave Drive) to your PC
      • How to Add a Shutdown Shortcut to your Windows desktop
      • How to Add a Standby Shortcut to your Windows desktop
      • How to Add Keywords to Your Website
      • How to Add Safe Mode to your Windows Boot Menu, by editing the BOOT.INI file
      • How to Backlink your online content
      • How to Block a Pinterest Follower
      • How To Comply with Amazon FTC Regulations
      • How to Connect to a Public WiFi Network
      • How to Create a Bookmarks Favicon
      • How to Create a Downloads Library in Windows Explorer
      • How to Create an active Click to Call Link
      • How to Create an h1 Header
      • How to Defragment the Paging File aka Virtual RAM
      • How to Disable sharing on Windows 7 and 8
      • How to Enable and Disable WiFi on Laptops and Tablets
      • How to Fix an Optical Scroll Mouse
      • How to Force Safe Mode on restart without editing BOOT.ini
      • How to Improve Computer Performance
      • How to Install a Bluetooth USB
      • How to Open Affiliate HTML Ads in New Tabs
      • How to Optimize your online content
      • How to Repair Windows Offline Help and Support
      • How to Replace a Dell Vostro 2510 LCD Inverter
      • How to Replace a Dell Vostro 2510 LCD Screen
      • How to Safely Eject ReadyBoost
      • How to Securely Wipe a Hard Disk Drive
      • How to Set Single-Click Customization on Desktop and Laptop Computers
      • How to Turn Num Lock on by Default in Windows 7 & 8
      • How to Tweet from a Flip Phone
    • Food & Drink >
      • Homemade Spaghetti Sauce with Shiitake Mushrooms and roasted Bell Pepper
      • How to Bake a fantastic Zucchini Pie
      • How to Bake Candied Pecans
      • How to Bake Rosemary-Maple Glazed Pork Loin
      • How to Boil Eggs Without Cracking Shells
      • How to make Ramen Noodles more interesting
      • How to Make your own Chopsticks
      • How to scratch Hearty Turkey and Rice Soup
      • How to Slow Cook Beans & Rice with Sausage
      • How to Slow Cook Venison Stew
    • Health >
      • How to Build a Strong Freestanding Inversion Rack
      • How to Pack a Blood Specimen for Air Travel
      • How to Tell if you have Bed Bugs
    • Holidays & Celebrations >
      • How to Easter Egg Hunt with Candy Filled Eggs
      • How to Hang the American Flag
    • Home Improvement >
      • Concrete >
        • How to Apply/Repair Ornamental Mapping on Historic Field Stone Construction
        • How to Install a vented Glass Block window
        • How to Pour Concrete Footers for Jack Posts
      • Electrical >
        • How to Control Outdoor and Ceiling Lights with a Timer
        • How to Install a Breaker Panel Receptacle
        • How to Install a Switched Receptacle
        • How to Install Outdoor Motion Lights
        • How to Replace a Doorbell
        • How to Replace a Door Chime
        • How to Wire multiple lights on a Porch Circuit
      • Exterior >
        • How to Calculate a Roof Pitch in Degrees
        • How to Frame a Dormer
        • How to Install Vinyl Outdoor Swings
        • How to Install Vinyl Soffit
        • How to Paint Wood Doors
        • How to Reduce your Cooling costs by painting your Roof white
      • Interior >
        • How to Build a Hide A Safe to Protect The Family Jewels
        • How to Build Boxed Ceiling Beams
        • How to Frame Interior Walls
        • How to Install Crawl Space Insulation
        • How to Increase your Cordless Phone Range
        • How to Install Vinyl Mini Blinds
        • How to Remove Spray Foam Insulation From Hands
        • How to Resize an Interior Composite Hollow Core Door
      • Plumbing >
        • How to Repair Copper Pipes
        • How to Replace a Water Heater Thermocouple
        • How to Solder a Plumbing Joint
        • How to Stop Water Pipes From Vibrating
    • Pets >
      • How to Administer a bitter pill to a Cat
      • How to Administer subcutaneous hydrating fluids to an ailing Cat
      • How to Paper train a Green Iguana
    • Wildlife >
      • How to Escape from a Bear in the Woods
      • How to Field Dress a Whitetail Deer
      • How to Legally live-trap and relocate Squirrels in the State of Maryland
    • Yard & Garden >
      • How to Build a Concrete Outdoor Fire Pit
      • How to Build your own Pond
      • How to Change the Tire on a Riding Lawn Mower
      • How to Install a Chain Link Fence Gate
      • How to Seed Flagstone Walkways With Moss
  • Contact Me
  • Amazon Deals
  • Zazzle.com/TomCom

How to Create Order Forms

Picture
Excel Template
Use a Microsoft Excel Template to easily create a simple Order Form. Or you could keep it low tech and create a virtual shopping list of all the possible items you purchase from a given source, enter the count and amount manually and use a calculator.

Things You'll Need:
* Computer

* Microsoft Excel
* Printer
* Calculator

Picture
Manual Price List
1. Taking the low-tech approach can serve you well, if nothing more than to act as a backup option. Compile the information, from various recent receipts, and enter it into a simple text document. Once satisfied you have covered every item in that category, print a dozen or so. Keep in mind that you may need to create versions for other categories as well. For example, a Gutter & Downspout business would need them for different sizes, different shapes and metals such as copper, aluminum and galvanized steel.

Picture
Excel Template 10100133.XLT
2. Use Excel Template 10100133.XLT (from Microsoft.com), provided you have Microsoft Office. This type of document allows you to enter quite a bit of information, including your own Company Name & Logo. Embedded Java script allows it to automatically multiply the Unit price by the Quantity to give each line total. Once you have completed adding to your order, the Subtotal reflects the pre tax amount. Enter the applicable sales tax % and the Total automatically tabulates the sum. For repeat orders, you can leave the Quantity blank and save the document as 5" K Aluminum, for example. This allows you to save one in each category required. Once you have saved a template in each category, right-click on the closed file, go into properties changing it to 'read only' to protect it from accidental alteration or deletion. The program will prompt you to give each new save a different name. The Job name is a good choice!


3. Verify current prices at regular intervals, no matter which type of document you decide to create. Check with your suppliers to find out when they normally update their pricing. Availability, changes in Taxes and Shipping costs, etc., often influence price fluctuations.

Tips
* With 'low tech' printed Order Forms, you can easily figure Materials & Taxes, add your Labor and write Estimates on-site, without the expense of a Laptop Computer & portable Printer. While the Hardware & Software may be deductible, it can break down and fail at the most inconvenient time.

Copyright 05/06/2009 All Rights Reserved. Questions? Comments?
Contact Me
Related Articles:
Business

Copyright © TomComKnowsHow

  • Home
  • Anti virus/Anti malware
    • How to Remove Keyloggers
    • How to Remove Conficker Malware
    • How to Remove Locky and AutoLocky Ransomeware for Free
  • How to Remove a Spyware Infection
  • Article Directory
    • How to Protect Computers using Free Version Antivirus Protection Software
    • Computer/Internet >
      • Audio/Visual >
        • How to Add a Cursor (Mouse Pointer) to a Print Screen Image >
          • Automotive >
            • How to Change Seized Up Spark Plugs
            • How to Change Automatic Transmission Filters
            • How to Do Auto Body Repair Work
            • How to Increase Fuel Economy
            • How to Install Truck Hitch Accessories/Attachments
            • How to Make a Poor Man's Fuel Heater
            • How to mix your own Fuel Additive
            • How to Replace a Door Panel
            • How to Replace Rear Leaf Springs
            • How to Tune-Up a Car Yourself
          • Business >
            • How to Appeal Denial of Unemployment Insurance Benefits
            • How to Create Order Forms
            • How to Perform Maryland Judiciary Case Searches Online
            • How to Promote your New Small Business
            • How to Recover Microsoft Office Professional for free
        • How to Convert qcp to wav
        • How to Create Watermark Protected Images
        • How to Crop a Print Screen Image
        • How to Disable your built-in Camera
        • How to Disable your built-in Microphone
        • How to Draw a Rose Bouquet
        • How to Print Digital Images Actual Size
        • How to Resize an Image to 424 X 282 Pixels, Without Distortion
        • How to Stream M3U's on Websites
      • How to Access a No Boot Hard Drive
      • How to Add Downloads to the Start Menu
      • How to Add a Hibernate Shortcut to your Windows Desktop
      • How to Add a Log Off Shortcut to your Windows desktop
      • How to Add a Restart Shortcut to your Windows desktop
      • How to Add a Second HDD (a Slave Drive) to your PC
      • How to Add a Shutdown Shortcut to your Windows desktop
      • How to Add a Standby Shortcut to your Windows desktop
      • How to Add Keywords to Your Website
      • How to Add Safe Mode to your Windows Boot Menu, by editing the BOOT.INI file
      • How to Backlink your online content
      • How to Block a Pinterest Follower
      • How To Comply with Amazon FTC Regulations
      • How to Connect to a Public WiFi Network
      • How to Create a Bookmarks Favicon
      • How to Create a Downloads Library in Windows Explorer
      • How to Create an active Click to Call Link
      • How to Create an h1 Header
      • How to Defragment the Paging File aka Virtual RAM
      • How to Disable sharing on Windows 7 and 8
      • How to Enable and Disable WiFi on Laptops and Tablets
      • How to Fix an Optical Scroll Mouse
      • How to Force Safe Mode on restart without editing BOOT.ini
      • How to Improve Computer Performance
      • How to Install a Bluetooth USB
      • How to Open Affiliate HTML Ads in New Tabs
      • How to Optimize your online content
      • How to Repair Windows Offline Help and Support
      • How to Replace a Dell Vostro 2510 LCD Inverter
      • How to Replace a Dell Vostro 2510 LCD Screen
      • How to Safely Eject ReadyBoost
      • How to Securely Wipe a Hard Disk Drive
      • How to Set Single-Click Customization on Desktop and Laptop Computers
      • How to Turn Num Lock on by Default in Windows 7 & 8
      • How to Tweet from a Flip Phone
    • Food & Drink >
      • Homemade Spaghetti Sauce with Shiitake Mushrooms and roasted Bell Pepper
      • How to Bake a fantastic Zucchini Pie
      • How to Bake Candied Pecans
      • How to Bake Rosemary-Maple Glazed Pork Loin
      • How to Boil Eggs Without Cracking Shells
      • How to make Ramen Noodles more interesting
      • How to Make your own Chopsticks
      • How to scratch Hearty Turkey and Rice Soup
      • How to Slow Cook Beans & Rice with Sausage
      • How to Slow Cook Venison Stew
    • Health >
      • How to Build a Strong Freestanding Inversion Rack
      • How to Pack a Blood Specimen for Air Travel
      • How to Tell if you have Bed Bugs
    • Holidays & Celebrations >
      • How to Easter Egg Hunt with Candy Filled Eggs
      • How to Hang the American Flag
    • Home Improvement >
      • Concrete >
        • How to Apply/Repair Ornamental Mapping on Historic Field Stone Construction
        • How to Install a vented Glass Block window
        • How to Pour Concrete Footers for Jack Posts
      • Electrical >
        • How to Control Outdoor and Ceiling Lights with a Timer
        • How to Install a Breaker Panel Receptacle
        • How to Install a Switched Receptacle
        • How to Install Outdoor Motion Lights
        • How to Replace a Doorbell
        • How to Replace a Door Chime
        • How to Wire multiple lights on a Porch Circuit
      • Exterior >
        • How to Calculate a Roof Pitch in Degrees
        • How to Frame a Dormer
        • How to Install Vinyl Outdoor Swings
        • How to Install Vinyl Soffit
        • How to Paint Wood Doors
        • How to Reduce your Cooling costs by painting your Roof white
      • Interior >
        • How to Build a Hide A Safe to Protect The Family Jewels
        • How to Build Boxed Ceiling Beams
        • How to Frame Interior Walls
        • How to Install Crawl Space Insulation
        • How to Increase your Cordless Phone Range
        • How to Install Vinyl Mini Blinds
        • How to Remove Spray Foam Insulation From Hands
        • How to Resize an Interior Composite Hollow Core Door
      • Plumbing >
        • How to Repair Copper Pipes
        • How to Replace a Water Heater Thermocouple
        • How to Solder a Plumbing Joint
        • How to Stop Water Pipes From Vibrating
    • Pets >
      • How to Administer a bitter pill to a Cat
      • How to Administer subcutaneous hydrating fluids to an ailing Cat
      • How to Paper train a Green Iguana
    • Wildlife >
      • How to Escape from a Bear in the Woods
      • How to Field Dress a Whitetail Deer
      • How to Legally live-trap and relocate Squirrels in the State of Maryland
    • Yard & Garden >
      • How to Build a Concrete Outdoor Fire Pit
      • How to Build your own Pond
      • How to Change the Tire on a Riding Lawn Mower
      • How to Install a Chain Link Fence Gate
      • How to Seed Flagstone Walkways With Moss
  • Contact Me
  • Amazon Deals
  • Zazzle.com/TomCom