Skip to content

D: Billing the Customer

Lakeview's contract is billed monthly with an AIA-style pay application: each month Cedar Ridge Training reports how much of each part of the work is done, and the customer pays that amount less 10% retainage. In this exercise you:

  1. set up the job's schedule of values, the list of billing lines that adds up to the contract;
  2. prepare pay application 1 for July, including materials stored on site;
  3. accept it, which posts the customer's invoice;
  4. record Lakeview's partial payment and deposit it in the bank.

Before You Begin

  • Exercise C is done.
  • J-101 has a Billing Retainage of 10% and the company has a Retainage Receivable account (Exercise A).
  • Approving a schedule of values and accepting a pay application need a Company Admin or Accountant (see Roles and Permissions).

Step 1: Set Up the Schedule of Values

  1. Go to Jobs & Costing → Progress Billing. J-101 shows No schedule of values. Click Set Up Schedule.
  2. In Details, enter Contract Date 07/01/2026, Architect Northline Architects and Architect Project Number NA-2611. They print on the pay application.
  3. Click Add Line for each billing line and enter the Item, Description, Scheduled Value, Revenue Account (4010 — Contract Revenue), Work Retainage and Stored Materials Retainage:
Item Description Scheduled Value Work Retainage Stored Materials Retainage
1 General Conditions 32,000.00 10.00 10.00
2 Concrete 80,000.00 10.00 10.00
3 Rough Carpentry 64,000.00 10.00 10.00
4 Drywall 128,000.00 10.00 10.00
5 Electrical 176,000.00 10.00 10.00
Total 480,000.00

The schedule shows the revenue side of the contract; it does not have to match the budget's cost codes. Its total must equal the revised contract, and the Contract card says Matches when it does.

The draft schedule of values for J-101 with five lines totaling 480,000.00, marked Matches
Figure 9-31 The draft schedule of values, ready to approve.
  1. Contract Date: the date of the contract with the customer.
  2. Scheduled Value: the contract amount allotted to the line.
  3. Work Retainage: the percentage withheld from work billed on the line (Stored Materials Retainage, beside it, applies to materials stored).
  4. Approve: makes the schedule the basis for billing.
  1. Click Approve. The schedule is Approved, and J-101 can now be billed through pay applications. From now on, an ordinary invoice to this job is refused unless its line is marked Extra (work outside the schedule).

See Schedules of Values.

Step 2: Prepare Pay Application 1

At the end of July the project manager agrees the progress with the architect:

Line Work Completed in July Materials Stored on Site
1 General Conditions 8,000.00
2 Concrete 60,000.00
3 Rough Carpentry 16,000.00
4 Drywall 8,000.00 (board delivered, not yet hung)
5 Electrical 44,000.00
Total 128,000.00 8,000.00
  1. On the schedule page, click New Application. Choose the Job, and enter Application Date 07/31/2026 and Due Date 08/30/2026. Click Start Application.
The New Application form with Job J-101, Application Date 07/31/2026 and Due Date 08/30/2026
Figure 9-32 Starting the first application.
  1. Job: the job being billed.
  2. Application Date: the end of the period the application covers.
  3. Due Date: when the customer's payment is due.
  1. In Lines, enter each line's Work This Period, and for drywall the Added to Storage amount. Installed from Storage is for materials stored earlier and installed this period (you use it in August).
  2. Click Save Draft.
Application 1 lines with Work This Period and Added to Storage entered
Figure 9-33 July's progress entered on application 1.
  1. Work This Period: work completed this month, line by line.
  2. Added to Storage: materials delivered and stored on site, billed before they are installed.

The figure was taken just before Save Draft, so the note above the lines still reflects the empty draft; it disappears once the figures are saved. The application then works out every total:

Summary of application 1: completed and stored 136,000.00, retainage 13,600.00, current payment due 122,400.00
Figure 9-34 The summary of application 1.
Summary Line Calculation Amount
Completed and Stored to Date 128,000.00 work + 8,000.00 stored 136,000.00
Percent of contract 136,000.00 ÷ 480,000.00 28.33%
Retainage Held 10% × 136,000.00 13,600.00
Earned Less Retainage 136,000.00 − 13,600.00 122,400.00
Previous Certificates first application 0.00
Current Payment Due 122,400.00 − 0.00 122,400.00
Balance to Finish, Including Retainage 480,000.00 − 122,400.00 357,600.00
  1. Click Print for Approval if the architect signs the application on paper, then Mark as Sent when it goes to the customer. Both are optional; Mark as Sent records the status Sent.

See Pay Applications for every column.

Step 3: Accept the Application

When the customer approves the application, click Accept…. Structally shows the invoice it is about to post, with its lines, retainage and journal entry:

The Accept Application 1 dialog listing the invoice lines, 13,600.00 retainage and the journal entry
Figure 9-35 The accept dialog previews the invoice and its entry.

Click Accept and Post Invoice. Application 1 becomes Accepted and is locked, and invoice INV-2026-000001 is posted to accounts receivable.

The Invoice Entry (JE-2026-000011)

Account Debit Credit
1100 Accounts Receivable 122,400.00
1110 Retainage Receivable 13,600.00
4010 Contract Revenue (J-101) 136,000.00

All $136,000.00 is revenue now, including the retainage and the stored materials. Only $122,400.00 is collectible now; the $13,600.00 sits in Retainage Receivable until it is released (Exercise H). Revenue on a contract job is adjusted to the percentage of completion at month-end by the WIP schedule (Exercise F).

Application 1 accepted, with invoice INV-2026-000001 and its journal entry
Figure 9-36 The accepted application with its invoice and entry.

Step 4: Receive the Customer's Payment

On August 25, Lakeview pays $100,000.00 by check 20417, part of the $122,400.00 due.

  1. Go to Customers & Invoices → Receipts and click Receive Payment.
  2. Choose Lakeview Medical Partners and click Load Open Items.
  3. Enter Date 08/25/2026, Funds Account 1050 - Undeposited Funds, Amount 100000.00, Method Check and Reference 20417.
  4. In Allocate, enter 100000.00 against INV-2026-000001.
  5. Click Receive Payment.
Receive Payment for Lakeview Medical Partners: 100,000.00 to Undeposited Funds, allocated to INV-2026-000001
Figure 9-37 A partial payment against the first invoice.
  1. Funds Account: Undeposited Funds holds checks until they are deposited.
  2. Amount received.
  3. Allocate: the part of the payment applied to this invoice.
  4. Receive Payment posts receipt RCPT-2026-000001.

INV-2026-000001 is now Partly Paid with $22,400.00 still open (paid in September). See Receiving Customer Payments.

Step 5: Deposit the Check

The next day the check goes to the bank.

  1. Go to Banking → Deposits and click Make Deposit.
  2. Leave From Account as 1050 - Undeposited Funds and click Load Receipts.
  3. Choose To Account 1010 - Operating Checking, Date 08/26/2026 and a Memo, and tick the receipt.
  4. Click Make Deposit.
Make Deposit moving RCPT-2026-000001 from Undeposited Funds to Operating Checking
Figure 9-38 Depositing the check into Operating Checking.
  1. To Account: the bank account that receives the deposit.
  2. Tick each receipt in the deposit.
  3. Make Deposit posts deposit DEP-2026-000001.

The Receipt and the Deposit

Date Account Debit Credit
08/25 1050 Undeposited Funds 100,000.00
08/25 1100 Accounts Receivable 100,000.00
08/26 1010 Operating Checking 100,000.00
08/26 1050 Undeposited Funds 100,000.00

Recording checks in Undeposited Funds first means the bank deposit, which may hold several checks, appears in the bank as one amount, the way the bank statement shows it. See Making Deposits.

The Rest of the Season

The same steps repeat each month. The later applications in this training project:

Application Date Billed This Period Retainage Current Payment Due Invoice
1 07/31/2026 136,000.00 13,600.00 122,400.00 INV-2026-000001
2 08/31/2026 144,000.00 14,400.00 129,600.00 INV-2026-000002
3 09/30/2026 146,000.00 14,600.00 131,400.00 INV-2026-000003
4 (final) 10/20/2026 90,000.00 9,000.00 81,000.00 INV-2026-000004
Total 516,000.00 51,600.00 464,400.00

Application 2 bills the change order of Exercise E and moves the stored drywall into place with Installed from Storage. Lakeview paid $152,000.00 on September 20 (the rest of invoice 1 and all of invoice 2) and $131,400.00 on October 15 (invoice 3).

Next: E: Managing Change Orders.