The Invoice List worksheet contains the following fields as summary information of each invoice.
| Invoice List Field | Description |
|---|---|
| Order_ID | The Invoice Number representing an order in the system. This number is assigned by the Invoice Tool sequentially as orders are added to the system, and is the invoice number that should be entered in the Order Form worksheet to load an existing invoice. |
| Order_Date | The Invoice Date from the Order Form worksheet. |
| Due_Date | The Due Date from the Order Form worksheet. |
| Client_Id | The unique Client Id assigned when a client is added to the system from the Client List worksheet. |
| Client_Name | The Customer name from the Order Form worksheet |
| Subtotal | The cumulative sum of all products and services included on the Order Form worksheet, before the application of any discounts. |
| Item_Discount | The cumulative sum of all Item Discounts included on the Order Form worksheet. This number is subtracted from the Subtotal to get the Grand Total. |
| Other_Discount | The value of Other Discounts included on the Order Form worksheet. This number is subtracted from the Subtotal to get the Grand Total. |
| Tax | The Tax amount added to the invoice on the Order Form worksheet, and defined as the Tax Rate (Admin -> User Settings) multiplied by the value of the Subtotal minus any Item and Other Discounts. E.g., if a 10% tax rate is used then 0.10 * (Subtotal – Item_Discount – Other_Discount) = Tax. |
| Grand_Total | The cumulative sum of the Subtotal minus any Item and Other Discounts, plus Tax. |
| Status | The Type of Invoice (i.e., Draft, Estimate, Invoice, Interim Invoice, Final Invoice, Overdue Invoice, Cancelled) from the Order Form worksheet. |
| Notes | The Notes from the Order Form worksheet. |
| Paid | The Paid status (i.e., draft/estimate, outstanding, paid) as determined by the Type of Invoice and whether the saved invoice was marked as paid. |
