Rule Testing Tool

What does this tool do?

This tool helps you check your transaction and rules files before running a compliance evaluation, then shows you which transactions were flagged and why. Follow the three steps below and you'll be done in minutes.

1

Check your rules file Upload your rules workbook (.xlsx) and we'll tell you if anything is wrong. Not sure of the format? Download a ready-made sample to get started.
2

Check your transactions file Upload your transactions CSV and we'll highlight any rows or fields that need fixing before you can run a check.
3

Run the check Upload both files and click Run. You'll see a summary of results straight away — how many transactions were reviewed, how many were flagged, and which rules matched.

Jump to a step

Click a card to go straight to that part of the tool.

📋

1. Validate Rules (.xlsx)

Check your rules workbook has the right columns, valid types, and numeric thresholds.

📄

2. Validate Transactions (.csv)

Verify your transaction CSV has all required fields in the correct format.

⚙️

3. Run Check

Upload your files and run the check to see which transactions were flagged.

📖

Rule Catalog

Browse all supported rule types and templates to help build your workbook.

Step 1 — Check your rules file. Upload your .xlsx rules workbook and we'll check every row for issues. Any errors will show the exact row and column so you know what to fix. Don't have a file yet? Click Download Sample to get a ready-made template.

What should my rules file look like?

Your .xlsx file needs a header row with these column names, followed by one rule per row:

Column Reference

Column	Required	Allowed values
`ruleName`	Required	Any unique name for this rule
`ruleType`	Required	`VALUE_THRESHOLD` `VELOCITY` `AGGREGATION` `PATTERN` `BEHAVIOURAL`
`priority`	Required	`HIGH` `MEDIUM` `LOW`
`active`	Required	`TRUE` or `FALSE`
`customerType`	Optional	`INDIVIDUAL` `CORPORATE` `ALL`
`currency`	Optional	3-letter ISO code e.g. `NGN`
`operator`	Optional	`>` `>=` `<` `<=` `==`
`threshold`	Required for VALUE_THRESHOLD	Numeric value e.g. `5000000`

Upload Your Rules Workbook

Drag and drop or click to browse. Results show the exact row and field to fix.

📋

Click to choose file or drag & drop here

Accepts .xlsx or .xlsm

Step 2 — Check your transactions file. Upload your transactions .csv and we'll check every row for missing fields, incorrect values, and formatting issues. Fix anything flagged before moving to Step 3. Don't have a file yet? Click Download Sample to see the expected format.

What should my transactions file look like?

Your .csv file must include at minimum these columns. Any additional columns you include will also be used in the check.

Required Columns

Column	Allowed values
`companyName`	Your company name
`rcNumber`	Your RC registration number
`customerID`	Unique customer identifier
`transactionReference`	Unique reference per transaction
`transactionAmount`	Numeric e.g. `6500000`
`currency`	3-letter ISO code e.g. `NGN`
`transactionStatus`	`SUCCESSFUL` `PENDING` `DECLINED` etc.
`transactionChannel`	`ONLINE` `CASH` `CARD` `ATM` etc.
`authenticated`	`YES` or `NO`
`customerType`	`INDIVIDUAL` or `CORPORATE`
`transactionType`	`INFLOW` or `OUTFLOW`
`environment`	`PRODUCTION` or `SANDBOX`

Upload Your Transactions CSV

Drag and drop or click to browse. Errors show the row number and field so you can find and fix them.

📄

Click to choose file or drag & drop here

Accepts .csv

Your Transactions File

Upload your transactions CSV. You can upload more than one file at a time. Make sure you've checked it in Step 2 first.

📄

Click to choose file(s) or drag & drop here

Accepts .csv — multiple files allowed

Your Rules

Choose how you want to provide your rules. Upload your workbook if you have one, or use the form below to build rules from scratch.

📋

Click to choose your rules workbook or drag & drop

Accepts .xlsx — check it in Step 1 first

Rule Type

Choose Rule

Applies To

Currency

Priority

Rule Name

Ready?

Upload your transactions file and rules above, then click Run to see your results.

Rule Catalog. These are all the rule types and templates available to you. The ruleType column in your rules workbook must match one of the types shown here exactly. Parameters like {A} and {B} are the numeric values you fill in for each rule.

Loading catalog…