Capital and property
Equipment, vehicles, fit-out, property and other investments can produce material transactions with suppliers used only once.
Rare high-value counterparty testing
Find unusual high-value counterparties in Xero and QuickBooks—and verify the relationship behind them
Datplan combines transaction value with counterparty frequency to highlight large items involving names that occur only rarely in the selected population. Audit Evidence reveals the underlying records for identity, approval, commercial and payment review.
How do I review rare high-value suppliers or customers?
Select a comparable Xero or QuickBooks population and period, set a value threshold and rarity expectation that fit the business, review the flagged counterparties, then inspect every underlying record. Confirm who the counterparty is, why the transaction occurred, who approved it and whether the documents, accounting treatment and settlement support the explanation.
Two characteristics together
High value and low frequency can be useful even when neither is unusual alone
The procedure is most informative when the population and thresholds reflect how the organisation normally buys, sells and posts one-off transactions.
| Design factor | Why it matters | Possible distortion |
|---|---|---|
| Population | Separates suppliers, customers, journals or other transaction classes with different business meaning. | A mixed population can make internal transfers, tax authorities or clearing entries look like external counterparties. |
| Value threshold | Focuses the review on financially significant items for the selected purpose. | One threshold may be too high for a small entity and too low for a high-volume group. |
| Frequency rule | Identifies counterparties used only a small number of times in the period. | A short test period can make an established annual supplier appear new or rare. |
| Counterparty identity | Allows related transactions to be considered together. | Duplicate contacts, spelling variants, blank names and generic accounts can split or merge identities incorrectly. |
| Period and seasonality | Provides enough history to distinguish a one-off item from a normal annual event. | Capital expenditure, insurance, rates and professional services may legitimately occur once a year. |
Counterparty review
Verify the relationship as well as the accounting entry
- Understand expected one-off activityIdentify projects, acquisitions, legal work, property, capital purchases and annual payments that can create rare names.
- Choose the population and periodUse enough comparable history to interpret frequency meaningfully.
- Set the high-value thresholdRelate it to the entity, account, procedure and reporting objective.
- Review the flagged namesLook for new, unfamiliar, blank, duplicated or slightly varied counterparty records.
- Open Audit EvidenceInspect every transaction contributing to the counterparty's frequency and value.
- Verify onboarding and approvalCheck identity, bank-detail controls, authorisation, conflicts and related parties where relevant.
- Trace the commercial evidenceReview contracts, orders, invoices, delivery, correspondence, payment and subsequent credits or reversals.
- Record the conclusionExplain why the relationship and transaction are valid, erroneous, a control exception or unresolved.
Evidence to consider
- Counterparty master-data creation and changes
- Independent identity and bank-detail verification
- Purchase order, engagement letter or contract
- Invoice and proof of goods or services
- Approver and delegated-authority evidence
- Payment beneficiary and bank settlement
- Related-party or conflict declarations where applicable
- Subsequent credit, refund, reversal or dispute
Legitimate rare relationships
One-off counterparties are part of normal business
Professional and emergency work
Legal advice, corporate transactions, specialist consulting and urgent repairs may involve uncommon providers and large values.
Annual or irregular payments
Insurance, licences, tax, rates and renewals can occur once in the selected period and still be entirely expected.
Refunds and settlements
A large receipt from an unusual name may be a refund, compensation, financing, asset sale or settlement rather than operating revenue.
Data quality first
Normalise identity problems before interpreting rarity
A counterparty can appear infrequent because the same supplier exists under several spellings, branches or legacy contacts. Conversely, a generic account such as “miscellaneous supplier” can combine unrelated parties and hide rarity.
Use the Audit Evidence records to compare identifiers, names, references and source documents. Correcting or explaining master-data quality may be the most important outcome of the test even when every transaction is valid.
Rare does not mean unauthorised
The test does not know whether onboarding, procurement, conflict checks, delegated authority or delivery occurred. It highlights where those controls may be worth verifying.
Xero, QuickBooks and related tests
Use source-specific evidence and combine indicators carefully
Xero review
Trace the flagged Xero records to contacts, invoices, bills, payments, bank transactions, supporting documents and available source history.
Xero audit workflow →QuickBooks review
Trace the QuickBooks records to vendors or customers, bills or invoices, payments, attachments, bank activity and the separate QuickBooks Audit Log.
QuickBooks audit workflow →Period-end activity
A large transaction with a rare counterparty may deserve more attention when it is also posted close to a reporting cut-off.
Review period-end activity →Round amounts
Check whether the high-value item is also an unusual clean or near-threshold amount and whether the commercial support explains it.
Review round amounts →Counterparty-test questions
Interpret rarity in the context of the organisation
What is a rare high-value counterparty?
In this analysis it is a counterparty that appears only infrequently in the selected population while being associated with transactions above the chosen value threshold. The reviewer controls the population, period and relevant settings.
Does a new or infrequent supplier indicate fraud?
No. New projects, one-off professional services, capital purchases, property transactions, refunds and emergency work can all involve legitimate rare counterparties. The test identifies items for corroboration.
Can inconsistent contact names affect the result?
Yes. Duplicate contacts, spelling variants, blank names, merged suppliers and payments posted through generic accounts can make one real counterparty appear rare or several counterparties appear to be one.
Is the analysis available for Xero and QuickBooks?
Yes. Datplan applies the same rare high-value counterparty concept to supported Xero and QuickBooks populations and provides Audit Evidence drill-down to the included records.
What should I verify for a flagged counterparty?
Confirm identity, onboarding and approval, business purpose, source contract or invoice, bank details, related transactions, ownership or conflicts where relevant, accounting treatment, settlement and platform history.
Investigate high-value transactions with uncommon counterparties
Run the analysis on supported Xero or QuickBooks data, then use identity, approval, source-document and payment evidence to explain each result.