Skip to content

External Transactions

External Transactions are tickets from outside the terminal measurement system — producer statements, LoadCall dispatch, PakEnergy, LACT imports, Google Sheets, or manual entry. You match them to facility transactions so Coyote can reconcile volumes and support settlement.

Open Daily Ops → External Transactions in the app (/external-transactions).

External Transactions list — tabs, filters, and sync actions

External vs facility transactions

External TransactionFacility Transaction
RepresentsProducer / dispatch / statement sideTerminal measurement side
Typical sourceLoadCall (external ticket), PakEnergy, Sheets, LACT, manualImport, LoadCall (transaction), manual
Primary goalMatch to a facility loadReconcile and report

One external ticket can link to one or more facility transactions through matching.

List page

KPI banner

When unmatched tickets exist, a warning banner shows the unmatched count and a Start Matching button (filters to unmatched tab).

Tabs

TabShows
All TransactionsEvery external ticket in the date range
UnmatchedTickets not yet linked to a facility transaction
MatchedTickets with an active match

Unmatched tab — filter to tickets that still need matching

Columns

ColumnDescription
Ticket #External ticket number (source badge, Split badge if LoadCall split)
DateTicket date
ProducerAssigned partner; inline assign if missing; LoadCall name hint if different
FacilityAssigned facility; inline assign if missing
VolumeStated volume (BBL)
VarianceLoadCall loaded vs delivered delta when available
StatusMatched or Unmatched

Filters

FilterDescription
SearchTicket number
FacilityAll, one facility, or No Facility Assigned
ProducerFilter by producer partner
Date RangePresets or custom range

Page totals (KPI row)

For the current page: ticket count, unmatched count, total volume, settlement total (LoadCall when present).

Actions

ActionDescription
Sync with LoadCallWhen LoadCall uses External Ticket sync target
Sync with PakEnergyWhen PakEnergy integration is enabled
Add TransactionManual external ticket entry

Sync with LoadCall from the External Transactions page

Add external transaction manually

For tickets from spreadsheets or systems without an integration (for example Acord Tracker exports):

  1. Click Add Transaction.
  2. Enter ticket number, ticket date, producer, and volume (required).
  3. Optionally add product, well, destination, source, notes.
  4. Save.

Add External Transaction — ticket information form

The ticket appears as Unmatched until you link it to a facility transaction.

External transaction detail

Open a ticket from the list.

External transaction detail — ticket info, producer, and Find Match

Details tab

  • Ticket number, date, volume, producer, facility, product, well, destination
  • Driver, truck, trailer when provided
  • Quality data — API, temperature, BS&W from normalized payload
  • LoadCall financial breakdown — linehaul, fuel surcharge, invoice/settlement totals, miles
  • Indicators: matched status, snapshot available, split ticket, facility assigned

Matching

  • View existing matches to facility transactions
  • Find Match — search facility transactions by ticket, date range, and volume tolerance
  • Reject or remove a match when incorrect

Find Match dialog

  1. Click Find Match on an unmatched ticket.
  2. Set search, date range (defaults ±3 days from ticket date), and volume tolerance (BBL).
  3. Select a candidate facility transaction from results.
  4. Confirm Create Match.

Find Match dialog — search, date range, and volume tolerance

Coyote filters candidates by search and optional volume proximity.

Snapshots tab

Integration imports store snapshots of raw and normalized payload over time. Use snapshots to audit what LoadCall or another source sent on each sync.

Assign producer or facility inline

On the list page, unmatched tickets without a producer or facility show dropdowns to assign values without opening detail.

  1. Sync or import external tickets (LoadCall, PakEnergy, LACT, Sheets) or add manually.
  2. Open External TransactionsUnmatched tab (or Start Matching).
  3. Assign producer and facility where missing.
  4. Open each ticket → Find Match → link to the correct facility transaction.
  5. Proceed to Reconciliation to resolve volume or status differences.

Data sources

SourceConfiguration
LoadCallIntegration sync target = External Ticket
PakEnergyAdmin → Integrations → PakEnergy
Producer LACTLACT import batch on import session
Google SheetsTarget entity = External Ticket
ManualAdd Transaction

LoadCall-specific fields

When the ticket came from LoadCall, detail may include:

  • Loaded / delivered BBLs and variance
  • Split ticket grouping
  • Settlement and invoice amounts
  • Miles and rate fields

Volume on the external ticket for matching typically uses loaded or delivered barrels per normalization rules — compare to facility net volume in Find Match.

Permissions

ActionPermission
List external ticketsfacility:external-transactions:list
View / update ticketfacility:external-transactions:view
Create ticketfacility:external-transactions:create
Create / reject / delete matchfacility:external-transactions:match

Troubleshooting

IssueFix
No tickets after syncConfirm integration sync target (External Ticket vs Transaction); check run history
Cannot find matchWiden date range; increase volume tolerance; verify facility transaction exists and is approved
Producer name differs from partnerAssign correct producer partner; LoadCall name shown as “from:” hint
Ticket stuck unmatchedOpen detail → Find Match manually; verify ticket number and date align
Wrong matchReject or delete match on detail page; re-match