Skip to main content

Report on Service Revenue

Report on billed, collected and outstanding service revenue with your existing Dockwa accounting reports and GL mapping.

Dockwa has no separate Service report. Service invoices, payments and refunds flow into your existing accounting reports, so you report on service revenue with the Line Items Ledger (accrual), the Cash Revenue Report (cash), and the Accounts Receivable report for unpaid work orders. Map your labor and parts items to GL codes so service revenue lands in the right accounts.

  • Who can do this: Finance, Admin

  • Where: Reports; Settings → Accounting (GL mapping); Service → Work Orders → Billing & Payments

  • Before you start: Service and service billing enabled. Labor and parts items set up in Sales → Items.

Which report shows what?

Question

Report

What to look for

How much service work did we bill this month?

Line Items Ledger (accrual)

Posted labor and parts line items from service invoices, by service or posted date.

How much service revenue did we collect?

Cash Revenue Report

Payments on service invoices by date received or transaction date, with revenue by category and payment method.

Which work orders still owe money?

Accounts Receivable report

Rows with Origin = Work Order. The Origin ID links to the work order.

What did the parts we used cost us?

Inventory Report, Cost of Goods Sold Report

Parts sold through jobs, margins, and inventory value.

Where does one work order stand?

The work order itself

Invoiced, Refunded, Net and Outstanding in Billing & Payments.

The Z-Out Report covers Point of Sale only. Service invoice payments are not included.

How do I separate service revenue from slips and fuel?

Reports group revenue by category. Each line has a Dockwa Category and, if you map GL codes, a Mapped Category.

  1. Go to Account (upper right) → Settings → Accounting. If you use QuickBooks Online or NetSuite, map items in Marketplace instead.

  2. Map each labor item (for example, Yard labor, Mechanical labor) to your service labor income account.

  3. Map parts to your parts sales account. Standard items assigned to the Services category show as Service by default; Supplies show as Supplies.

  4. Run the Line Items Ledger or Cash Revenue Report. The summary sheets group lines under your GL names.

By default, labor items show as Service in the Dockwa Category column.

How do I run a monthly service revenue report?

  1. Go to Reports.

  2. Choose the Line Items Ledger for billed revenue, or the Cash Revenue Report for collected revenue.

  3. Set the date type and the start and end dates for the month.

  4. Click Export. The file appears in Recent Exports when it is ready.

  5. In the spreadsheet, filter the detail sheet by your service categories or labor item names.

How do refunds and changes show up?

  • Removing a line item from a settled job creates a separate refund invoice for that item. Each appears as its own refund line.

  • Reopening an invoiced job before payment posts a return for each of its lines, netting the original invoice to zero. The original lines and their returns both appear in reports, and the replacement invoice posts when you generate it.

  • Reverse re-charges an invoice with a different payment method. Using it to refund money distorts reporting.

Why don't my service numbers match the work order totals?

Reports usually reflect the previous business day, so same-day activity may not appear yet. Check also that you're comparing accrual (billed) with accrual, and cash (collected) with cash. Unpaid invoices on a closed work order still show in Accounts Receivable.

Can I get a custom service report?

During the Service beta, ask your Dockwa contact for a specific cut of service revenue. Insights doesn't include service data yet: AI Search answers questions about reservations, and the liveboards cover Leads, Transient and Contracts.

Related articles

Did this answer your question?