Previous Topic

Next Topic

Book Contents

T&M Invoicing Explained

The T&M invoice type has two line items attached to it, and both of those line items support sub-totals.

Line Item

Formula

Time Charges

TIME_CHG

Expenses

EXPENSE_CHG

Let's assume that we're using this format to generate a new draft invoice. Let's also assume that the new invoice is going to have the following time and expenses attached to it.

Source

Code/Cat

Budget Item

Date

Hours/Q

Rate

Amount

Matyas, Jake

Field:Inspection

Phase 1

4/30/07

7.5

75

$562.50

Matyas, Jake

CAD:Drafting

Phase 1

5/1/07

7

75

$525.00

Bruska, Agnes

Meeting, Client

Phase 1

5/2/07

8

75

$600.00

Bruska, Agnes

Calculation:Design

Phase 2

5/3/07

10

75

$750.00

Bruska, Agnes

Architectural Design

Phase 2

5/4/07

10

75

$750.00

Bruska, Agnes

Auto, Other

--

5/4/07

--

--

$150.00

Bruska, Agnes

Auto, Mileage

--

5/4/07

75

0.485

$36.38

Time charges on this invoice total $3,187.50, so the value of TIME_CHG will be 3187.50. The value of EXPENSE_CHG will be 186.38 (because the invoice has 2 expenses attached to it that total $186.38).

When I generate an invoice using this set of line items, I'll get a final invoice that show two line items:

Bill To:

Client ABC, Project XYZ

123 Main Street

Chicago, IL 60602

Amount Due: $10,000.00

Item Description

Amount

Time Charges

$3187.50

Expenses

$186.38

Total Charges:

$3,373.88

The invoicing engine just replaces the variable TIME_CHG with the amount $3187.50 and the variable EXPENSE_CHG with the amount $186.38. For a complete listing of the variables used by the invoicing engine, take a look at the end of this chapter.

See Also

Invoice Templates

Who Should Read This Chapter

Editing Invoice Templates

Invoice Sub-Totalling

Additional Template Examples

Line Item Variables

Line Item Functions

Invoice Sub-Totalling

When you create invoices, you can manipulate the sub-totalling options on your invoice templates to achieve the results you need. Take a look at a couple of specific examples.

Let's assume, for example, that you'd like to create an invoice for fees and expenses on a fixed-fee job. You'd like that invoice to show something like the following line items:

Description

Amount

Phase 1

$25,000

Phase 2

$15,000

Phase 3, Task 1

$2,300

Phase 3, Task 2

$1,500

Expenses

$2,344.55

Here, we've sub-totalled the "time charge" line items, but we've left the "expense" line item alone. This can be accomplished on the invoice format that we've selected (T&M) because there are two separate line item "formula" for time charges and expense charges.

Settings...Invoice Types (Edit sub-total check box)

We can edit those line item "formula" from the Tools... System Settings... Invoice Types page. The sub-total option for each line item is at the bottom of the edit page. For the example shown above, we've turned ON sub-totalling for the time charge line item(s), and we've left it off for the expense charge line item.