# Accounting

See what every job costs and earns, bill time and materials, and send invoices to QuickBooks.

When hours sit on paper dailies and receipts sit in a truck, nobody knows what a job made until the month is closed. At Acme Precision, each crew lead's daily posts the hours and materials to the job as it is submitted, priced at the right rates. The office adds the receipts and bills, sees each project's profit, and turns the work into invoices for QuickBooks Online.

[Add it from the Marketplace](/tenant/?open=settings/marketplace)

## What it does

Accounting is job costing. Every labor, material, equipment and cost line is charged to a project, or to an internal account for overhead, under a cost code. Labor is priced as it posts, from the rate sheet in effect on the work date. Crews post their hours on forms and never see a dollar.

The module adds these pages under **Accounting** in the sidebar:

- **Dashboard**: **This week** and **This month** tiles for **Labor hours**, **Cost**, **Billable** and **Margin on billed work**, each compared with the period before. **Needs the office** appears when there is **Labor not priced**, **Materials & equipment to cost** or **Hours posted twice?**. Below are the **Trends** charts, **Projects this month**, **Go to** links and a **Set up** line.
- **Projects**: every project's customer, hours, cost, billable, revenue, gross profit and margin. Click one for its profit and loss. The **Internal accounts** tab shows overhead by department.
- **Transactions**: every line, with **Add cost**, the line's details and receipt, and **Export CSV**.
- **T&M Billing**: the **T&M Billing Summary** of what a project's time-and-materials work bills for a period, ready to print.
- **Invoices**: the **Invoiced** tab (every invoice by status) and the **Unbilled** tab (work not on an invoice yet), with **Bill service contracts**, **New progress invoice** and **Export to QuickBooks…**.
- **Bill rates**: what each labor role bills at, for crew leads. It never shows wages or cost.
- **Reports**: the ready-made **Job cost by project** report.

Projects, customers and crews come from the module your workspace uses for them. Employees and labor roles can come from HR, and products and vendors from the Price Book.

## Set it up

A Workspace Admin does this first.

1. Give each role the Accounting permissions it needs (see **Who can do what** below). Only Admin gets the dollar permissions out of the box. See [Users and roles: create and edit roles](article:88d4e232-d5b8-4909-b452-cfe96d3d550f).
2. Open **Module Settings** from the ⋮ on the **Accounting** sidebar row. On **Configuration → Labor rates**, check the **Company multipliers** and click **Edit defaults** to change them. They start at overtime ×1.35, double time ×1.7 and burden ×1. See [Module settings and versions](article:fb7c92e4-6dcc-4ef4-80bc-1b6e7482e540).
3. Click **Add labor role** for each role your crews work as, such as Foreman or Laborer. If your workspace uses HR, roles are added there instead.
4. Click **New standard rate sheet**, then type each role's **Bill (T&M)**, **Work-in-scope premium** and **Burdened cost**, and click **Save rates**. Until a standard sheet exists, labor posts its hours but is not priced.
5. On **Cost codes**, check the starting codes and type each one's **QuickBooks name** so exports match QuickBooks.
6. On **Internal accounts**, click **Add internal account** for each overhead account, such as Shop / Yard, Training or Drive time.
7. On **Preferences**, type the T&M markups, profit and overhead, bond and sales tax percents, the invoice prefix and next number, days until due and retainage, then click **Save Settings**.
8. Set your logo and letterhead in **System Settings → Branding**, so summaries and invoices print on it.
9. In Inspections & Forms, add the **Labor**, **Materials** and **Equipment** sections to the forms crews use.

The Dashboard's **Set up** line counts your cost codes, labor roles, rate sheets and surcharges, and warns when labor can't be priced yet.

## Check what the crews' forms posted

1. Open **Accounting → Dashboard**.
2. Look under **Needs the office** for **Labor not priced**, **Materials & equipment to cost** and **Hours posted twice?**.
3. Click a tile to open just those lines on **Transactions**.
4. Fix each one, then click **Show everything** to see every line again.

## Add a receipt, card purchase or rental

1. Click **Add cost** (on the Dashboard, Transactions or a project's P&L) and leave it on **One amount**.
2. In **Charged to**, pick a project or **Internal account (overhead)**, then choose it in **Which one**.
3. Set the **Date**, **Paid by** (Card, On account, Cash or Other) and **Vendor**. Leave **Bills as** on **As the project bills** unless this cost bills differently.
4. Type **What**, pick the **Cost code** and type **Amount (cost)**. Add **Qty** and **Unit** if they help. Leave **Bill to customer** empty to bill at the usual markup.
5. Choose the file under **Receipt or bill (photo or PDF)** and click **Save cost**.

## Enter a vendor or subcontractor invoice

1. Click **Add cost**, then **Vendor invoice (lines)**.
2. Pick the project in **Charged to** and **Which one**, and set the **Invoice date**, **Vendor**, **Paid by** and **Invoice #**.
3. For a subcontractor, set **Cost code for lines without an item** to your Subcontractors code.
4. On each row, pick a Price Book item or type what it is, with quantity, unit and unit cost. Type **Bill** only for a set bill amount. Click **Add line** for another row.
5. Attach the file under **The invoice (photo or PDF)** and click **Save cost**. Each line is costed and billed on its own.

## Cost a material or rental a crew posted

When a daily posts a typed material or rental as a quantity only, the office enters what it cost.

1. Click the **Materials & equipment to cost** tile on the Dashboard, or find the line on **Transactions**.
2. Click **Cost it** (the $ button) on the line. The **Cost this material** (or **Cost this equipment**) form opens filled in.
3. Type **Amount (cost)**, and pick **Paid by** and **Vendor**. Leave **Bill to customer** empty to bill at the markup.
4. Attach the **Receipt or bill (photo or PDF)** and click **Save cost**.

## Find and check lines

1. Open **Accounting → Transactions**. It shows the last 30 days.
2. Type in the search box to find a project, employee, material, vendor or code, and set the dates.
3. Click **Labor**, **Material**, **Equipment**, **Cost** or **Surcharge** to show one kind, or **All**.
4. Click the eye (**View line**) to see who, hours, role, rate sheet, cost and billable. Click **Open the form** to read the form it came from, or **Receipt** to see the receipt.
5. Click **Export CSV** to download the list, or tick rows and pick **Actions → Export selected to CSV**.

## Fix a wrong line

Nothing is edited or deleted. A wrong line is reversed, and the right one entered again.

1. Find the line and check it with the eye (**View line**).
2. Click **Reverse** (the undo arrow) and confirm. For several lines, tick them and pick **Actions → Reverse…**. A reversing line is added, so the total nets to zero.
3. Click **Add cost** to enter it again correctly.

Lines that came from a form are fixed by reopening the form and submitting it again.

To bill one day's labor at a different role (someone ran a machine or led the crew), click **Labor**, find the line, click **Change labor role**, pick the role in **Bill and cost this time as**, type **Why** and click **Change role**. The line must not be on an invoice yet.

## See each project's profit and overhead

1. Open **Accounting → Projects** and set the From and To dates.
2. Search, or click a column such as **Margin** to sort.
3. Click a project to read its **Revenue**, **Cost**, **Gross profit**, **Labor hours**, **Invoiced to date** and **Unbilled**, the **Cost by code** table and every line.
4. Use **Add cost** on the project's page to enter something it is missing.
5. Click the **Internal accounts** tab to see overhead by department. Click an account to see its lines. Overhead is cost only and is never billed.

## Build the T&M Billing Summary

1. Open **Accounting → T&M Billing** and pick the project.
2. Set the From and To dates.
3. Check each section and the totals: materials, rentals, equipment, labor, premium labor, subcontractors, profit and overhead, bond and sales tax. Cost anything the notice says is not costed yet.
4. Click **Print / PDF** to print it on your letterhead for the customer, or **CSV** to download it.

## Turn T&M work into an invoice

1. On **T&M Billing**, pick the project and dates and check **This period, not yet invoiced**.
2. Click **Create invoice** and confirm. A draft invoice opens in the side panel. Every line it bills is linked to it, so nothing is billed twice.
3. Click **Edit** to set the invoice date, due date, **Customer PO** and notes, then click **Save**.
4. Click **Issue** and confirm.

## Bill progress on a contract project

1. On **Invoices**, click **New progress invoice** and pick the contract project (or click **Create progress invoice** on T&M Billing).
2. Type **Bill this period**, or a percent in **or % of contract**. Check **Retainage %**.
3. Set the **Invoice date**, **Period from** and **to**, and **Notes**.
4. Click **Create draft**, then **Issue** in the side panel.

## Bill monthly maintenance contracts

1. On **Invoices**, click **Bill service contracts** and pick the **Month of service**.
2. Contracts that are due are ticked. Untick any to hold back; the others say why they aren't due.
3. Click **Create drafts**, then review and issue the drafts.

To make them each month automatically, tick **Service contracts: make each month's draft invoices automatically** in **Preferences** and set the day.

## Review, issue or void invoices

1. Open **Accounting → Invoices**. Click the **Drafts** tile to see drafts.
2. Click an invoice, or its eye (**Open invoice**), to open it in the side panel.
3. Click **Issue** and confirm. For several drafts, tick them and pick **Actions → Issue…**.
4. An issued invoice is locked. To correct one, click **Void** and confirm, then create it again. Its lines are freed to bill again.
5. Open the **Unbilled** tab to see work not on an invoice yet, project by project.

## Export invoices to QuickBooks Online

1. On **Invoices**, click **Export to QuickBooks…**.
2. Set **Invoice date from** and **to**. Every issued invoice in that range that isn't exported yet goes in the file.
3. Leave **File** on **CSV — QuickBooks Online import** (or pick **JSON — for an API connector**) and click **Export**. The invoices are marked **Exported**.
4. In QuickBooks Online, go to **Settings → Import data → Invoices**, upload the file, check the column mapping and import.
5. If QuickBooks numbered an invoice differently, type it in **QuickBooks invoice #** on the invoice and click **Save**. **QuickBooks CSV again** on an invoice downloads it again without changing anything.

Payments are recorded in QuickBooks. Accounting does not know when an invoice is paid; past due means past its due date.

## See hours by person, crew or project

1. In the module that lists crews, people or projects, click **◷ Hours**. The hours page opens in the side panel, with no dollars unless you may see them.
2. Pick **By project**, **By employee** or **By day**.
3. Pick **This week**, **This month**, **Last month** or **Custom**.
4. Click a row to drill down from project to person to day to the form. **Back** returns.

Crew leads look up what time bills at on **Accounting → Bill rates**. Type in **Search labor role or trade…** to find a role.

## Set up rates, codes, surcharges and overhead accounts

All of these are in **Module Settings → Accounting → Configuration**.

1. **Labor rates**: click **New rate sheet**. In **For**, pick **Everyone (standard rates)**, **One customer (negotiated)** or **One project (negotiated)**, and set **Effective from**. Use **Copy the rates of** another sheet **Adjusted by %** to start from existing rates. Type the rates and click **Save rates**. **Adjust %** moves a whole sheet.
2. A line is priced from the project's own sheet, else its customer's, else the standard sheet, in effect on the work date. Changing a rate never changes lines already posted.
3. **Cost codes**: click **Add cost code**, type the **Code** and **Name**, pick the **Category**, type the **QuickBooks name** and click **Save**.
4. **Surcharges**: Fuel and Card fee rules come with the module, turned off. Click **Add surcharge** (or the pencil on a rule), type the **Name** and **Percent**, pick **Posted under** and **Treated as**, tick the kinds of lines it applies to, set **Status** to **On** and click **Save**.
5. **Internal accounts**: click **Add internal account**, type the **Name**, **Code** and **Department**, pick the **Type**, type the **QuickBooks account** and click **Save**.

## Build the Office and Management dashboards

1. On the Dashboard, click **Build dashboards** (confirm **Rebuild dashboards** if they exist already).
2. Open **Dashboards** in the sidebar and pick **Office** or **Management**. Each person sees only the charts their permissions allow. See [Dashboard](article:1d8a33a4-3a13-4874-b8e5-5ef9da22df95).

For a printable report, open **Reports** under **Accounting** and click **Job cost by project**: each project's cost, labor, billable and not-yet-invoiced against its contract, with gross profit.

## Who can do what

Each action in the module needs a permission. A Workspace Admin gives permissions to roles; see [Users and roles: create and edit roles](article:88d4e232-d5b8-4909-b452-cfe96d3d550f). **Out of the box** shows the module's starting roles that have it.

| Permission | What it lets someone do | Out of the box |
|---|---|---|
| **View hours and quantities** | Open the Dashboard, Transactions and hours pages and see everyone's hours and quantities, with no dollar amounts. | Admin, Operator |
| **View their crews' hours** | See hours (no dollars) only for the people they lead, by project. Needs the Team service preference set. | Admin |
| **View costs, rates and profit** | See all dollars: labor cost and wages, rates, receipts, project profit and margins, T&M billing and invoices, and build dashboards. **Give with care.** | Admin |
| **View billing rates only** | See what each role's time bills at (standard, overtime, in-scope premium), never wages, cost or margins. | Admin |
| **Enter receipts and bills** | Add receipts, rentals and vendor or subcontractor invoices against jobs, cost posted materials, and attach receipts. | Admin |
| **Create and send invoices** | Create, edit, issue, void and export invoices to QuickBooks, including progress and service-contract invoices. **Give with care.** | Admin |
| **Set up accounting** | Maintain cost codes, labor roles, rate sheets, multipliers, surcharges, internal accounts and preferences, and reverse or re-role ledger lines. **Give with care.** | Admin |
| **See the job cost report** | Run the Job cost by project report (dollars), normally given together with View costs, rates and profit. | Admin |

- **Projects**, **T&M Billing** and **Invoices** open only with **View costs, rates and profit**. Without it, people see the Dashboard and Transactions with hours and quantities only.
- **Reverse** and **Change labor role** need **Set up accounting**, not **Enter receipts and bills**.
- Give **View their crews' hours** and **View billing rates only** to your crew-lead role yourself; out of the box only Admin has them.

## Ask its agent

The **Accounting Assistant** answers how-to questions from the module's help and works with your ledger, billing and invoices, with your own permissions. Try:

- "What's unbilled right now, by project?"
- "Which invoices are past due?"
- "Show this month's P&L for our biggest project."

It can also add a cost, enter a vendor invoice or create a draft invoice. It tells you what it is about to do and waits for your yes; reversing a line or voiding an invoice also asks for approval in the app. It can't attach a receipt file, so use **Add cost** for that. See [Agent chat](article:073c6465-d85c-4364-8768-acf42a3a6a48).

## Good to know

- Nothing is ever edited or deleted. A reversal, or a form that is reopened and submitted again, adds offsetting lines.
- Changing a rate or a preference applies from then on. Lines and invoices already made keep their amounts.
- Internal accounts are cost only: never billable and never invoiced.
- Every line an invoice bills is linked to it, so the same work can't be billed twice.
- Accounting has no live link to QuickBooks. It exports a file, and payments are recorded in QuickBooks.
- Leave the **Sales tax** preference at 0 if QuickBooks works out the tax, or it is counted twice.
- Each cost code's **QuickBooks name** must match a product or service in QuickBooks exactly, or the import stops.

## More help

Open **Help** at the top of any Accounting page for the full reference, including how labor gets its dollars and what each preference does. Its **Runbooks** walk through each job step by step, from checking what the dailies posted to the month-end review. See [Find and follow a runbook](article:4b62ad1f-577a-4998-8bce-f00226376522). Accounting works with Inspections & Forms and the DV Field app for crews' forms, with your project module for projects and customers, and with HR and the Price Book & Vendors module when you use them.


Source: https://datavisions.ai/docs/module-guides/accounting
