Summarize clearing balances
-
Group
Groups clearing rows by source and order
-
Calculate
Computes debits, credits, and open balance
-
Classify
Labels each balance as closed, aged, or open
Artifacts by Prowork
Artifacts turn the output of any Flow into dashboards, reports, and exception queues your team can explore and share. Every number stays connected to the Flow that produced it.
10 of 17 invoice lines are ready to post and 7 are held for review.
Net invoice value is $75,817 across 15,092 units, including credits.
59%
Lines ready to post
7
Held for review
15,092
Across selected lines
$75,817
Includes credits
88%
Across all lines
Line amount by OCR confidence
Line amount by invoice date
59% of selected queue
41% of selected queue
The fastest-growing brands accelerate with Prowork.
From manual work to answers
Capture the process once, on your own data and without an IT ticket. Every run after that produces a current dashboard or exception queue, so the week goes to decisions, not to rebuilding the spreadsheet.
Group
Groups clearing rows by source and order
Calculate
Computes debits, credits, and open balance
Classify
Labels each balance as closed, aged, or open
Join
Combines results with clearing balances
Flag
Keeps exceptions and aged clearing activity
Prioritize
Assigns severity and next action
Join
Matches ecommerce rows to ERP by ID
Calculate
Compares net amounts and computes variance
Classify
Labels each as matched, missing, or mismatched
Filter
Keeps January rows still in transit
Map
Assigns debit and credit clearing accounts
Format
Produces ERP-ready journal lines
01. Build the Flow
Rules and calculations stay explicit, with AI kept to the steps that need judgment. The people closest to the work can validate the logic on live data and change it when the process changes.
Six transactions are flagged for review, five of them high priority. They carry $1,109 of absolute variance and $439 in open clearing balances, the oldest at 12 days.
Select a row to see the action and supporting detail
| Priority | Transaction | Reason | Variance | Open balance |
|---|---|---|---|---|
| High | ECOM-1003 | Payment still unsettled after month-end | $207.28 | $207.28 |
| High | ECOM-1004 | Ecommerce and ERP amounts do not agree | $1.00 | $48.24 |
| High | ECOM-1007 | Settlement is missing from ERP | $140.67 | $140.67 |
| High | ECOM-1008 | Settlement is missing from ERP | $543.05 | $43.05 |
| High | ECOM-1010 | ERP entry has no matching source | -$155.00 | — |
| Medium | ECOM-1009 | ERP entry has no matching source | -$62.10 | — |
5
Needs attention first
$1,109
Mostly settlements missing in ERP
$439
Oldest item still in clearing
02. Share the Artifact
The Flow’s output becomes a dashboard, report, or exception queue people can filter and drill into. It regenerates on every run, and every number traces back to the step behind it.
What you can build
The shape depends entirely on what you ask for. Most follow the same arc: headline numbers up top, charts that show their shape, and a table into the rows behind them.
Executive summary
KPI tiles up top, the supporting charts below. Current every Monday when the Flow runs on a schedule.
Exception queue
Late shipments ranked by the order value at risk, in a queue the team can filter and work through.
Partner scorecard
Reliability by partner and month, with filters and search so anyone can answer their own follow-up.
The Flow behind it
The sources, matching, and rules that produce the page stay visible on the canvas, so the owner can fix a rule and rerun.
How Artifacts compare
BI tools are governed but slow to change. General-purpose AI is fast but hard to check. Artifacts are built in minutes by the people closest to the work, on a Flow anyone can trace.
BI tools
Built for governed, company-wide metrics.
General-purpose AI
Fast for exploring data you have on hand.
Artifacts in Prowork
Fast to build, on logic you can check.
Bring the report you rebuild every week. We’ll show you it as an Artifact, on your data.
Filter, sort, and drill in
An Artifact isn’t a static image. Every control acts on the same data from the latest run, so whoever you send it to can answer their own follow-up question. Viewers can download a CSV of whatever they’ve filtered to.
Read about Artifact typesFilter bars
Narrow the page to a segment or date range
Search
Type to find matching rows
Tabs
Split content into sections
Toggles
Switch views, metrics, or states
Sliders
Set a threshold and watch it respond
Sortable columns
Click a header to reorder
Expand & collapse
Open grouped rows and sections
Drill-downs
Click a row for its detail panel
Prompt an Artifact
Describe what you want and Prowork builds the page: tiles, charts, controls, and tables. The richer the ask, the more complete the result. Follow-ups adjust what you already have, and you can edit just one section without disturbing the rest.
Describe the look
“Use our brand green for positive variance and grey for everything else.”
Upload a reference
A brand guide, a screenshot of an existing report, or the PDF this dashboard replaces.
Use your company logo
Set once by an admin. Swap it later and Artifacts pick it up on their next run.