# Job Card Wise Profit

<p class="doc-lead">Job Card Wise Profit compares estimated and actual cost, sale, and profit for Approved and Closed job cards. Choose job date or transaction date. Parent jobs with children can be expanded. Click a job number to open <a href="#/job/reports/job-card-summary">Job Card Summary</a>.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/job/reports/job-card-wise-profit?id=overview">Overview</a>
<a href="#/job/reports/job-card-wise-profit?id=use-cases">Use Cases</a>
<a href="#/job/reports/job-card-wise-profit?id=filters">Filters</a>
<a href="#/job/reports/job-card-wise-profit?id=columns">Columns</a>
<a href="#/job/reports/job-card-wise-profit?id=actions">Actions</a>
<a href="#/job/reports/job-card-wise-profit?id=faq">FAQ</a>
<a href="#/job/reports/job-card-wise-profit?id=related">Related</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Job → Job Card Wise Profit</b>.

<p><b>What it shows.</b> One row per job with estimated cost, sales, and profit from the Job Card lines, and actual cost, net sales, and profit from allocations. Amounts sit under two group headers: <b>Estimated</b> (light blue-gray) and <b>Actual</b> (light warm gray). Rows with negative estimated or actual profit are highlighted.</p>

<p><b>Date basis</b> is the dropdown next to the date range.</p>

<ul>
<li><b>Job date</b> (default) — job cards whose date is in the range. Actual amounts are the full life of the job.</li>
<li><b>Transaction date</b> — job cards that have a sale invoice, credit note, purchase invoice, debit note, or expense dated in the range. Actual amounts include only those documents. Estimates stay the full job card. A sub job card with nothing in the period is hidden.</li>
</ul>

<p><b>Detailed</b> sits after the filter button. It adds <b>Sales</b> and <b>Returns</b> under Actual, before <b>Net sales</b>. Sales is the sale-invoice total. Returns is the credit-note total, shown as a positive amount. Net sales is sales minus returns. A parent row includes its sub job cards. Turning Detailed off hides those two columns. Sub job cards also show when Detailed is on.</p>

Default range is the current month. Maximum range is 12 months. Footer totals are for the <b>current page</b> (500 rows per page).

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Monthly job P&amp;L</b> — See which jobs made or lost money after allocations.</li>
<li><b>Estimate vs actual</b> — Spot jobs where actual cost overran the Job Card estimate.</li>
<li><b>Parent with house BLs</b> — Expand a parent row to see each child job's profit.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

| **Filter** | **Description** |
|------------|-----------------|
| Date range | Required. Maximum 12 months. Which date it uses depends on Date basis. |
| Date basis | <b>Job date</b> or <b>Transaction date</b>. Default is Job date. |
| Employee | Optional. |
| Booking Party | Booking customer. |
| Consignee | Consignee customer. |
| Shipper (Customer) / Shipper (Supplier) | Advanced filter fields kept for older records. |
| Shipping Line | Supplier shipping line. |
| Job Type | One Job Type. |
| Bill of Lading No | Contains or equals. |
| Job Number | Contains or equals. |
| Customer Group | Booking party's customer group, including child groups. |
| Port of Loading / Port of Discharge | Location (State or District). |

Use the filter icon for advanced filters. <b>Clear</b> removes them.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| (expand) | Chevron on parent jobs. Click to show child rows. |
| # | Row number on this page. |
| Date | Job Card date. |
| Number | Job number. Click to open Job Card Summary. |
| Job Type | Type name. |
| Employee | Employee in charge. |
| Booking Party | Booking customer. |
| Consignee | Consignee customer. |
| Estimated → Cost / Sales / Profit | From Job Card lines. Profit = sales − cost. |
| Actual → Cost | From purchase, expense, and debit-note allocations. |
| Actual → Sales / Returns | Shown only while <b>Detailed</b> is on. Sales is sale invoices. Returns is credit notes. A parent includes its children. |
| Actual → Net sales / Profit | Net sales = sales − returns. Profit = net sales − actual cost. Same formulas as <a href="#/job/reports/job-card-summary?id=calculations">Job Card Summary</a>. |

The footer labels totals as <b>Total (this page)</b> and shows the row count for that page.

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Detailed</b> — show or hide Sales and Returns under Actual.</li>
<li><b>Generate</b> — run the report.</li>
<li><b>Export</b> — download to Excel.</li>
<li><b>Print</b> — print the report.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<b>Why don't footer totals match a full-period export?</b><br>
On-screen totals sum the current page only. Export or add pages if the result spans more than 500 rows.

<b>Why is actual profit blank or zero?</b><br>
Allocations are missing or the source documents are still draft. See <a href="#/job/job-card?id=allocation">Job Card Allocation</a>.

<b>Are draft jobs included?</b><br>
No. Only Approved and Closed.

<b>Date range too long?</b><br>
The report rejects ranges longer than 12 months.

<b>Does Transaction date change the estimates?</b><br>
No. Estimates stay the full job card. Only actual cost, sales, returns, net sales, and profit are limited to documents dated in the range.

<b>A revised credit note is missing from Returns.</b><br>
It is included when the allocation is still on the cancelled copy and the approved revision has no allocation of its own on that job. If the approved copy is allocated, only that copy counts.

<hr class="doc-section-divider">

<h2 id="related">Related</h2>

<ul>
<li><a href="#/job/job-card">Job Card</a></li>
<li><a href="#/job/reports/job-card-summary">Job Card Summary</a></li>
<li><a href="#/job/reports/job-card-wise-report">Job Card Wise Report</a></li>
</ul>
