BoostExcel main content
There are three ways to add new customers: A) Using the Customers window; B) Using the Invoice worksheet; and C) Copying from an existing customer.
A) Add a new customer using the Customers window
- Click and select the Invoice ribbon tab if it has not already been selected.
- Click the Customers button on the Invoice ribbon tab to display the Customers window. This window displays all customers in the database.
- Click the Add button.
- In the New Customer window fill in your customer's information. The only required field for a customer is the Name field. All other fields are optional and a customer ID is automatically generated if one is not filled in.
- Click Save Changes button to save this customer. If succeeded, the New Customer window becomes the Customer Edit window.
B) Add a new customer using the Invoice worksheet
- Click and select the Invoice worksheet if it isn't already selected.
- Fill in your customer's information in the appropriate field near the Bill To label. Again, the only required field for a customer is the Name field. All other fields are optional and a customer ID is automatically generated if one is not filled in.
- Click the Save As New Customer button on the task pane to create the customer.
C) Add a new customer by copying an existing one
- Click and select the Invoice worksheet if it isn't already selected.
- Click any cell in the BILL TO section. The "On-Sheet Picker" button appears.
- Click the "On-sheet Picker" button to display the Customers selection dialog box, and then double click to select the customer. All customer information will be written to the Invoice worksheet, including the customer ID.
- On the Invoice worksheet, clear the customer ID field, and modify other fields as needed.
- Click the Save As New Customer button to create a new customer.
Please move to the Customer Detail section for a detailed explanation of the Customer Edit window.
PDF Book
Documents
- 1Quick Start Tutorial
- 2How Invoice Manager for Excel Works
- 3Before Using a Template
- 4Template File Format
- 5Install and Upgrade
- 6Settings: Template
- 7Settings: Taxes
- 8Settings: Misc. Data
- 9Settings: Database
- 10Settings: In-cell Lookup
- 11Settings: Print
- 12Settings: Extract / Email
- 13.Customers
- 13.1Add New Customers
- 13.2Edit Existing Customers
- 13.3Customer Detail
- 14.Products
- 14.1Add New Products
- 14.2Edit Existing Products
- 14.3Product Detail
- 15.Invoices
- 15.1Create New Invoices
- 15.2Edit Existing Invoices
- 15.3Invoice Detail
- 16.Payments
- 16.1Add New Payments
- 16.2Edit Existing Payments
- 16.3Payment Detail
- 16.4Batch Payment
- 17Reports
- 18.Common Tasks
- 18.1Search Bar
- 18.2Data List Window
- 18.3Share Database
- 18.4Migrate Access Database to SQL Server
- 18.5Email Reports
- 18.6Share Files Using OneDrive
- 18.7Add-ins Appear in Excel
- 18.8Customize Invoice Template
- 18.9Custom Fields
- 18.10Advanced Database Customization
- 18.11Import External Data
- 18.12Share Database
- 18.13Install and Upgrade
- 18.14Migrate Access Database to SQL Server
- 18.15Share Files Using OneDrive
- 18.16Backup Scheduler
- 18.17Set Number of Lines
- 18.18Frequently Asked Questions
- 19License Key
- 20Cell Name Reference
- 21License Agreement