Initial Set up (10 to 15 minutes in total)

  1. Enter Business Information
  2. Enter Product Categories & Locations
  3. Enter Products in Products sheet
  4. Enter Starting Inventory
  5. Enter Product Prices in Prices sheet
  6. Enter Partners' info in Partners sheet
  7. Review and set up Invoice sheet
  8. Review and set up Purchase Order sheet

 

 

Step 1. Enter Business information 

Enter our Business Information in the Settings sheet. This information will be used to auto-populate in our invoice and purchase orders.


Step 2: Enter a list of product categories. 

This is helpful in analyzing our business performance later. Please enter groups in which you would like to categorize your products.


Enter inventory/warehouse locations.



Step 3: Enter the list of Products in Products sheet.

Let’s enter 4 products and its related information.


  • ID: Unique identification of product. This has to be unique. Please do not repeat the same ID or leave the field blank.
  • NAME: Name of the product
  • DESCRIPTION: Description of the product, as needed in our business.
  • RE-ORDER POINT: The quantity of product at which you would like to replenish by ordering.
  • UNIT: This is how we measure this specific product. This can be used to display on the invoice.
  • CATEGORY: Product category to which this product belongs.
  • TRACK INVENTORY: In our business, if we have products we don’t want to track inventory, we can just enter NO. If we want to track inventory, just leave it blank. By default, inventory will be tracked.
  • TAXABLE: In our business, if we have products that are not taxable, we can enter NO. If tax is applicable, just leave it blank. By default, tax will be applicable.

 

Step 4:  Enter STARTING INVENTORY: This is the quantity of the product we have when we begin using the template. This is entered only once and does not have to be updated daily. 

Step 5: Enter product prices in Prices sheet.

We will enter the purchase and sales prices in the Prices sheet. These prices will auto-populate on the orders later and help save us a lot of time.

We would enter the Product ID, Effective From Date and then the two prices. The Effective From Date represents the date when the prices became effective. 


Purchase Price is the price we pay to purchase a product from our suppliers. Sales Price is the price at which we sell the product to our customers.

If a product's price changes in the future, 1) enter a new row for the product, 2) enter the date when new price becomes effective as Effective From Date and 3) enter the effective purchase and sales prices. Note: please enter both purchase and sales price even if only one has changed.

 

Step 6: Enter Partner information 

In the Partners sheet, we will enter the list of our suppliers and customers together. In case a partner is both supplier and partner, you will still enter that partner only once. Partner Name should be unique here. Do not leave it blank.


 

Step 7: Set up Invoice Sheet


Invoice sheet is the printable invoice that can be automatically created for any sales order. This sheet is very customizable to suit your needs.

First, let’s update the logo. Click on the three vertical dots on the existing logo and click on Replace image.


Then, choose your logo image from your computer and click on Insert. Now, your logo will appear on the invoice when printing.


The fields on the invoice are also customizable.



There are 4 key sections in the invoice: Customer Info (8 fields), Order Info (5 fields), Product Info (8 fields) and Order Total Info (6 fields).   If all the fields shown by default will meet our needs, we do not have to change anything. We can move to the next step.

All these four sections are customizable.

  • If you do not need a certain field, just click on a field name and press the Delete key.
  • If you need to choose another field instead, click on the field name. You will see a drop down menu to choose from a list of available fields. Just select the one you need.

 

Step 7: Set up Purchase Order Sheet


Purchase Order sheet is the printable purchase order that can be automatically created for any purchase order. This sheet is very customizable to suit your needs, just like we did with the Invoice sheet. 

You can change the logo in the same way as discussed in the previous step.


The sections in a purchase order is as shown below:



There are 5 key sections in the PO: Our Business Info, Supplier Info (5 fields), Order Info (5 fields), Product Info (8 fields) and Order Total Info (6 fields).  If all the fields shown by default will meet our needs, we do not have to change anything. We can move to the next step.



All the four sections (except Our Business info) are customizable.

  • If you do not need a certain field, just click on a field name and press the Delete key.
  • If you need to choose another field instead, click on the field name. You will see a drop down menu to choose from a list of available fields. Just select the one you need.

This is all the initial set up that is needed.