Report Field Definitions - Clients

Alright — this one’s all about clients. If you’re trying to understand what your clients are buying, how much they’re worth, what they owe you, what pricing they’re on, or what’s still open — this is your playground.

These reports are mostly pivot-style reports. That just means you can slice and dice the data however you like — by client, by project, by month, by region, by supplier — you get the idea.

Below is what’s included in the Client reporting category:

• Client Activity Lines Pivot Report

• Client Specific Pricing Pivot Report

• Open Transactions by Client Pivot Report

• Open Transaction Lines by Client Pivot Report

• Client Details Pivot Report

Let’s break them down one by one.

Client Activity Lines Pivot Report

This is your big-picture activity report.

It pulls together everything that generated revenue or incurred cost in a selected period — Projects, Stock Sales, and Invoices — and lays it out in one pivot grid.

It uses:

• Invoice Date

• Supplier Invoice Date (or PO issue date if no invoice exists)

• Stock usage date

So what you get is a consolidated view of revenue and costs for whatever timeframe you care about.

If you want to know:

• “How profitable was Client X last quarter?”

• “Which region is driving revenue?”

• “Which supplier costs are hitting us the hardest?”

This is your report.

Fields

Client Specific Pricing Pivot Report

This one’s all about special pricing agreements.

If you’ve negotiated specific prices for certain clients (instead of using your default sell price), this report summarises all those pricing lines in one place.

Perfect for:

• Reviewing client margins

• Checking if negotiated pricing is still profitable

• Comparing standard pricing vs client-specific pricing

Think of it as your “are we still making money on this deal?” report.

Fields

Open Transactions by Client Pivot Report

Think of this as the summary version of open work.

Where the Open Transaction Lines report drills into individual lines, this one gives you a cleaner overview of all open projects and stock sales that started or were issued in your selected period.

It’s ideal when you want to quickly answer:

• “How much open work do we have per client?”

• “What’s still sitting out there not fully invoiced?”

• “Who owns the work and what’s the status?”

A couple of date notes to keep in mind:

• For Projects, the date fields relate to the Due Date

• For Stock Sales, the date fields relate to the Expected Date (or the Issued Date if none was saved)

So when you filter by month, quarter, or year, it’s applying to those relevant dates behind the scenes.

Fields

Open Transaction Lines by Client Pivot Report

This report focuses on what’s still open.

It brings together all lines for:

• Open projects

• Open stock sales

…that were started or issued within the selected period.

Important note:

• For Projects, date fields apply to the due date

• For Stock Sales, date fields apply to expected date (or issued date if none saved)

This is great for:

• Monitoring outstanding work

• Tracking uninvoiced value

• Managing pipeline by client

Basically — “what have we promised but not finished or invoiced yet?”

Fields

Client Details Pivot Report

This one is more account-focused.

It pulls in all client details along with their account balance before the selected date.

Important:
The account balance is calculated from data inside WorkGuru only — it does not include balances from external accounting platforms.

The date fields apply to:

• Invoices

• Credits

• Payments

This report is ideal for:

• Credit control

• Reviewing account limits

• Checking who owes what

• Auditing client data

Fields