Skip to main content
What you’ll learn in this lesson:
  • Design comprehensive test datasets for your project
  • Calculate expected outputs before running tests
  • Test edge cases: missing data, extreme values, and boundary conditions
  • Use Analytics and Data Inputs views to validate results
Testing a production accounting project isn’t just about running the pipeline and seeing if it works. You need pre-calculated expected outputs, systematic edge case coverage, and a clear process for validating every result.

​
Designing test datasets

A good test dataset covers three scenarios: happy path, edge cases, and error cases.
Normal operations with typical values. This is your baseline: if this doesn’t work, nothing will.Example for Mangrove Biochar (January 2024):

​
Calculating expected outputs

Before running the pipeline, calculate the expected output for each test scenario by hand or in a spreadsheet. This is critical: without expected values, you can’t tell if the output is correct.
1

Set up a spreadsheet

Create a spreadsheet with columns for each input value and each intermediate/final calculation. Include all 5 steps from your Module 2 model plus the LCA calculations from Module 3.
2

Enter your test data

Fill in the test values for each event. Calculate each intermediate value step by step, exactly as your model should.
3

Calculate batch-level outputs

For each batch (delivery), compute: gross carbon, allocated emissions (proportional + direct), and net carbon.
4

Compute ledger totals

Sum all batch outputs per ledger. Verify that ledger balances reconcile (inputs = outputs + inventory changes).
Example spreadsheet layout:
The numbers above are illustrative. Your actual values will depend on your model structure and emission factors. The point is to have a reference table before you run the pipeline, so you can compare against the results.

​
Validating results in Mangrove

After running Generate Batches, use these views to validate:

​
Data Inputs view

Check that all events were created correctly:
  • Event count matches expected
  • Datapoint values are correct
  • Evidence is attached where required
  • Date ranges are within the accounting period

​
Batch outputs

For each batch, verify:
  • Gross carbon matches your spreadsheet
  • Allocated emissions are proportional to mass
  • Transport emissions are assigned to the correct batch
  • Net carbon = gross - total emissions

​
Ledger balances

Check that each ledger reconciles:
  • Credits (incoming batches) match expected values
  • Debits (allocations to downstream ledgers) are correct
  • Running balance makes physical sense

​
Systematic edge case testing

For each edge case, follow this pattern: Edge cases to test for Mangrove Biochar:
Document each edge case test and its result. This becomes your test suite: when you modify the model later, you can re-run these tests to catch regressions.

​
Check your understanding

Without pre-calculated expected values, you have no way to verify if the pipeline output is correct, only that it runs without errors. A pipeline can produce wrong numbers silently. Pre-calculated values give you a reference to compare against, catching formula errors, unit mismatches, and configuration problems.
Happy path (normal operations with typical values), edge cases (unusual but valid values that test boundaries), and error cases (invalid data that should be caught by validation). Together these cover the range of inputs your project might encounter in production.
Next, learn about common problems and how to fix them in Lesson 5.3: Common Integration Pitfalls.