You are here: HOME >>> Excel Invoice Manager

Invoice Detail

Both the Invoice worksheet and the Invoice Edit form can be used to edit an invoice, although there are some significant differences between the two.

	Invoice worksheet	Invoice Edit form
Create new invoices	Yes	No
Add invoice items	Yes	No
Delete invoice items	Yes	Yes
Delete or void payment	No	Yes
Void invoices	No	Yes
Delete invoices	No	Yes
Payment History	No	Yes

The Invoice Worksheet

Here is a screen shot of the Invoice worksheet.

(Click to enlarge)

It's easy to get started with the Invoice worksheet because it is based on the What You See Is What You Get (or WYSIWYG) paradigm. However, to be effective, there are still some important points you need to know.

The Clear & New button clears the Invoice worksheet. After clearing, the Invoice Date and Ship Date field automatically revert to the current date. The Tax Rate, Sales Rep. Name, Ship Via, Terms are also set to their default values respectively. You can set these default values by clicking the Settings button on the Invoice worksheet.
To keep the command button area visible when scrolling the worksheet, it is frozen at the top-left cell of the invoice area.
The Invoice worksheet is protected by default to avoid accidentally corrupting formulas. If you want to alter the protected contents such as the company name, logo and certain text labels, you can unprotect it by clicking Excel Menu Tools -> Protection -> Unprotect Sheet in Excel 2000 - 2003, or by clicking Review tab -> Changes group -> Unprotect Sheet if you are running Excel 2007.
When you finish customizing the worksheet, it is strongly recommended that you return the worksheet to protected status to avoid accidental corruption of formulas.
By default, the maximum number of invoice line items is 12. These lines must be filled, one by one, with NO blank rows between them. For example, if you have three product line items, then they must be keyed or entered into rows 1, 2, and 3. If you filled them into rows 1, 2, and 4, then only row 1 and 2 will be saved to the database. Because line 3 was skipped or left blank, then Row 4 will be discarded without any warning.

An item is treated as blank if ANY of the following fields are empty or zero: Product ID, Product Description, and Line Total.

For an in-depth look at the invoice workbook, see the chapter titled Customizing Invoice Workbook.

The Invoice Edit Window

The Invoice Edit window allows you to edit most fields of an invoice, except the calculated fields, tax rate fields, shipping costs, and invoice items.

Here is a screen shot of the Invoice Edit Window.

(Click to enlarge)

Button	Action
Save Changes	Saves the modified data to the database.
Edit in Excel	Displays the current invoice in Excel.
Void Invoice	Deletes the invoice from the Sales Record but keeps a copy in the database for reference.
Print Invoice	Displays the invoice in the Invoice worksheet and prints it, using default print options.
Email Invoice	Displays the invoice in Excel, extracts the Invoice worksheet as a new workbook, and creates a new email message to send the workbook to selected e-mail addresses.
Delete Invoice	Deletes the invoice record from the database. This will delete all payments and place all products back into stock (where applicable).
Refresh	Reload data from the database. This command is basically used in a network environment where multiple users open the same database. You can use this button to update or refresh data modified by other uses.

Unlike the Invoice worksheet, the Invoice Edit window shows you all the payments on the Payments tab, where you can add new payments, remove or edit existing payments. To add a new payment, click the Add Payment button. To remove or edit an existing payment, double click the payment record to open the Payment Edit window.

Excel Invoice Manager Free Download and Try (4.17 MB)

Learn More Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Before Using Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Adding Extra Rows to Invoice Body Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement More Topics Registration and Services Reference

Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer How Do I Replace the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices

Home	Contact Us	Privacy	Link to Us
copyright © Office-Kit.com, all rights reserved