Proposals & Line Items
Line items are the foundation of your proposal. They detail the specific services, materials, and costs that make up your quote. This guide walks you through building professional, accurate proposals.
Quick Start: Build a Proposal in 5 Steps
- Open or create a project
- Go to the Proposal tab
- Click Add Line Item
- Enter item details and pricing
- Repeat for all items
The Proposal tab saves for you. About 2 seconds after your last change, the header shows All changes saved. Save is there if you want to save sooner.
Understanding Line Items
What Each Line Item Contains
| Field | Description | Example |
|---|---|---|
| Item Name | Service or material description | Drilling per foot |
| Quantity | Number of units | 150 |
| Unit | Measurement type | Feet |
| Unit Cost | Your internal cost per unit | $45.00 |
| Retail | The price the customer sees | $60.00 |
| Taxable | Whether tax applies to this line | Yes |
| Total | Auto-calculated | $9,000.00 |
| Description | Optional details, on its own row | 6" diameter borehole |
Unit Cost and Retail are different numbers, and Retail is the one that bills. When a line has a retail price, the total uses it. The total falls back to unit cost only when retail is blank or zero. Leaving retail at an old value is the usual reason a proposal total does not match what you expected.
Step-by-Step: Adding Line Items
Method 1: Manual Entry
- Open the project
- Go to the Proposal tab
- Click Add Line Item
- Enter item name
- Set quantity and unit cost
- Add description (optional)
- Repeat for each item
The button reads Add Line Item in the sections view, which is the view the Proposal tab opens in. In the flat list view the same button reads Add Custom Row.
Method 2: Pull an item from inventory
The Item Name box on each row searches your inventory as you type.
- Add a row.
- Start typing in the Item Name box. It reads Search inventory or type item name.
- Pick an item from the list that drops down.
- The unit cost, unit, taxable setting, and description fill in from that item.
- Set the quantity.
You bind one item per row this way. To enter something that is not in inventory, type the name and keep going.
Method 3: Using Templates
- Open the Select Template... dropdown.
- Choose a template.
- Review the line items it brings in, then adjust them.
- Edits save on their own, as they do for any other change.
The dropdown appears only after your company saves at least one template. If you have never made one, the Proposal tab shows no template dropdown at all. If the proposal already has content, DrillerDB asks Replace this estimate with the template? first. Click Replace estimate to go on, or close the box to keep what you have.
Create templates for common job types to speed up proposal creation. Templates can include standard line items with default pricing. To build one, go to Settings > Proposal Templates, or build the proposal first and click Save as Template on the Proposal tab.
Applying a template does not silently wipe an estimate you have already written. Before 18 August 2026, picking a template replaced the whole estimate, and a template that had no priced items could blank the proposal outright. DrillerDB now checks the proposal for existing content first and asks before it replaces anything. The message names what goes: line items, sections and options, and any titles or notes written on them. It also says how many line items the template brings. Replacing cannot be undone. Written scope counts as content, so section titles, descriptions, and an add-on's pros and cons all trigger the question, not just priced rows. A template with nothing saved in it is refused, and your estimate stays as it was.
Managing Line Items
Editing Items
- Click on any line item field
- Edit the value inline
- Total recalculates automatically
- The change saves on its own a moment later
Reordering Items
- Click and hold anywhere on the row, next to the grip mark (⋮⋮).
- Drag the row to its new position.
- Release to drop it.
- The customer proposal follows the same order.
The flat list view also gives each row a Move up and a Move down arrow. Use those when a drag is awkward, such as on a touch screen.
Deleting Items
Click the trash icon at the end of the row.
- Sections view: the row goes straight away, with no confirmation step. Check that you have the right row before you click.
- Flat list view: DrillerDB asks Remove this line item? Click Remove to confirm. The box warns that typed values are not recovered.
Either way, the removal saves with the rest of your changes. To bring a line back, add it again. Deleting a whole section also asks first, with Delete section.
There is no per-item Duplicate action. To repeat a line, add a row and pick the same inventory item.
Grouping Line Items
A line item row has no category box. To keep a long proposal readable, use the Sections view, which groups related line items under section titles. The table shows common groupings and the items that go in them:
| Group | Common Items |
|---|---|
| Drilling | Per-foot drilling, casing advancement |
| Casing | PVC casing, steel casing, drive shoe |
| Materials | Grout, bentonite, filter pack, sand |
| Permits | State permit fee, county fee |
| Pump Equipment | Submersible pump, pressure tank, pitless adapter |
| Labor | Pump installation, well development, testing |
| Mobilization | Setup fee, travel, equipment transport |
| Testing | Water quality test, bacteria test, yield test |
Keeping Default Prices Current
The prices that fill in when you pick an item (Method 2) come from your inventory, so inventory is where the defaults live. There is no separate default-line-item list in Settings.
- Open the inventory item.
- Update its price, unit, or description.
- Save the item.
Picking an item copies its values onto the row. Changing the item later affects rows you add afterward. Rows already on a proposal keep the price they had.
Creating Templates
Step-by-Step: Create a Template
- Go to Settings > Proposal Templates
- Click New template
- Under Template Name, name your template (e.g., "Standard Residential Well")
- Add a Description if you want one (optional)
- Under Line Items, add the items typical for this job type
- Set default quantities and pricing
- Optionally add Template terms and conditions. Proposals built from the template use them instead of your company default
- Click Save Template
To make a template from a proposal you already built, click Save as Template on the Proposal tab and give it a name. If you started from a template, an update button on the same row replaces the saved version with the current line items.
Template Best Practices
Good templates include:
- All common line items for that job type
- Realistic default quantities
- Current pricing
- Clear item descriptions
Template naming conventions:
- Residential - Standard
- Commercial - Small
- Hi-Cap - Agricultural
- Geo-Vertical - 4 Ton
Calculating Totals
Automatic Calculations
DrillerDB automatically calculates:
| Calculation | How It Works |
|---|---|
| Line Total | Quantity × Retail. When Retail is blank or zero, Quantity × Unit Cost |
| Subtotal | Sum of all line totals |
| Tax | Subtotal × Tax Rate, on taxable lines only |
| Grand Total | Subtotal + Tax |
| Deposit | Percentage or fixed amount |
Configuring Tax
- Go to Settings > Invoicing & Tax
- Choose Fixed Rate and enter the rate, or Automatic (Location-Based) to have DrillerDB work out the rate from the job location
- On the proposal, tick or clear Taxable on each line
- Tax is figured from the taxable lines automatically
Setting Deposit Requirements
Deposits are set when you send, not in Settings.
- On the Proposal tab, click Create Proposal
- In the Send Proposal dialog, find Down payment
- Choose None, Optional, or Required
- Choose Fixed (a dollar amount) or Percentage (e.g., 50%) and enter the figure
Item Descriptions
Adding Detailed Descriptions
- Click the description toggle on the row to open its description box
- Type in the box that reads Add a description...
- The description appears below the item name in the proposal
What to Include
Good descriptions include:
- Materials specifications
- Work methodology
- Warranty information
- Exclusions or conditions
Example:
"6" diameter Schedule 40 PVC casing, includes threaded couplings, installed per manufacturer specifications. 10-year manufacturer warranty on materials."
Reviewing Before Sending
Proposal Checklist
Before sending, verify:
- All line items are complete
- Quantities are accurate
- Pricing is current
- Descriptions are clear
- Tax is correct
- Deposit amount is set
- Customer email is correct
Preview Feature
- Click Create Proposal to open the Send Proposal dialog
- Click Preview PDF
- Check formatting and totals the way the customer will see them
- Close the preview when satisfied
Troubleshooting
Line items not saving?
- Look at the header. Unsaved changes turns into All changes saved within a few seconds
- Save failed with a Retry button means the save did not go through. Click Retry
- "DrillerDB was updated. Reload the page to restore your changes." means a new version went live while the tab was open. Reload, and your edits come back
- Ensure quantity and price are numbers
Template not loading?
- Check the template exists under Settings > Proposal Templates
- A template with no line items saved is refused with a message, and your estimate is unchanged. Open it in Settings and add items
- If a box asks Replace this estimate with the template?, nothing has loaded yet. Click Replace estimate to load it
Totals calculating incorrectly?
- Check quantity and unit cost values
- Verify tax rate in Settings
- Look for hidden line items
Can't add more items?
- In the Sections view the button reads Add Line Item, inside each section. In the Flat list view it reads Add Custom Row
- Try refreshing the page
Related Topics
- Creating Projects - Start new projects
- Sending Proposals - Send to customers
- Billing Settings - Sales tax and payment terms