Quick Start

Creating invoices in Excel Invoice Manager is just a snap. Here is a step-by-step quick example demonstrating how to create a customer, a product and an invoice.

1. Click Start -> Programs -> Office-Kit.com -> Excel Invoice Manager -> INVOICE.xls to open the invoice workbook. This workbook connects to the default Sample.mdb database. As the name implies, this database contains sample data.
2. Click and activate the Invoice worksheet.

   
   (Click to enlarge)

3. Click the Customers button on the Invoice worksheet to open the Customers window.


(Click to enlarge)

4. Click the Add Customer button on the Customers window.
5. Fill in your customer information in the New Customer window. This window provides a number of fields, but only the Name field is required. The name can be either a person's name or a company name, such as ABC Company. Click Save Changes button to save this customer. The window caption is set to Customer Edit, and a customer ID is generated automatically if left blank.


(Click to enlarge)

6. Press the Esc key twice to close the Customer Edit window and Customers window.
7. Click the Products button on the Invoice worksheet to open the Products window.


(Click to enlarge)

8. Click the Add Product button to open the New Product window.


(Click to enlarge)

9. Fill in the description, price and stock information in this window. Click Save Changes button to save the new product.
10. Press the Esc key twice to close the Product Edit and Products window.
11. Now it's time to create your first invoice.On the Invoice worksheet, click the Select Customer icon button (the magnifier icon) near the Bill To label.
12. In the Customers selection dialog box, double click the customer name ABC Company to select this customer into the Invoice worksheet.

    
    (Click to enlarge)

    Note: If you know the ID value of the customer, you can also enter the ID value into the Customer ID cell to retrieve all the fields of the customer. This feature is called In-Cell Lookup.

13. On the invoice body area, click the Select Product icon button on the first row to display the Products selection dialog box. Double click to select a product.

    
    (Click to enlarge)

    Note: If you know the ID value of the product, you can also enter the ID value into the Product ID cell to retrieve all the fields of the product.

14. Fill in the Quantity (and Unit Price, if needed) field on the same row.
15. Click the Save To DB button on the Invoice worksheet to save the invoice. An invoice ID is generated automatically if left blank.


(Click to enlarge)

16. If you want to print the invoice, just click the Print button on the Invoice worksheet. Here is an example of the printed invoice.


(Click to enlarge)

That's it! You have successfully created a new invoice!