How to Manage Monitoring When Data Comes From Multiple Systems

Learn how NGOs and development organizations can manage monitoring when data is spread across KoboToolbox, ODK, DHIS2, Excel, and other systems without replacing the tools they already use.

Multiple monitoring data systems connected through an operational workflow linking projects, sites, visits, findings, actions and verification.

Many organizations do not have a single system for monitoring.

A health program may use DHIS2 for routine health information, KoboToolbox for surveys and assessments, ODK for field data collection, Excel for operational tracking, and shared folders for photographs and supporting documents.

Each system may be doing its job well.

The difficulty begins when managers need to answer questions that cross those systems:

  • Which project does this information belong to?
  • Which site was monitored?
  • When was the site last visited?
  • What findings were identified?
  • Which corrective actions are still open?
  • Who is responsible for resolving them?
  • Was the problem verified during a subsequent visit?
  • Which sites require management attention?

This is not simply a data-collection problem.

It is an operational monitoring problem.

A practical solution is not necessarily to replace every existing system. Instead, organizations can establish a structured operational monitoring layer that connects data sources with projects, sites, field visits, findings, corrective actions, verification, and performance management.

Why Organizations End Up With Multiple Monitoring Systems

Different systems are often introduced for legitimate reasons.

One system may be selected because it is excellent for mobile data collection.

Another may already be the organization's national or sector information system.

A third may be used by a technical team for analysis.

Excel may remain useful for planning, budgeting, or simple operational tracking.

Over time, the organization develops an ecosystem such as:

  • KoboToolbox for surveys and assessments
  • ODK for structured field data collection
  • DHIS2 for health information and program data
  • Excel for operational trackers
  • Documents and photographs for supporting evidence

The existence of multiple systems is not automatically a problem.

The problem is when the organization cannot maintain the relationships between the information stored in those systems.

The Difference Between Data Collection and Operational Monitoring

A data-collection system answers questions such as:

What information did the field officer collect?

Operational monitoring asks additional questions:

What project does this relate to?

Which site does it concern?

What did the organization find?

What action was required?

Who owns that action?

When is it due?

Was the action completed?

Was completion verified?

These questions require workflow and context, not just data storage.

The Problem With Treating Every System as the Same Thing

KoboToolbox, ODK, DHIS2, Excel, and other platforms have different purposes.

Trying to force one system to perform every function can create unnecessary complexity.

A mobile data-collection platform may be excellent at collecting structured submissions.

A health information system may be excellent at managing health indicators.

A spreadsheet may be convenient for a small operational list.

A monitoring operations platform may be better suited to managing the lifecycle of field visits, findings, corrective actions, and follow-up.

The better question is therefore not:

Which system should replace all the others?

It is:

How should the systems work together?

Start With the Monitoring Workflow

Before integrating systems, define the operational workflow.

A typical project monitoring workflow might look like:

Project → Site → Monitoring Visit → Observations → Findings → Corrective Actions → Evidence → Verification → Resolution

This provides the operational structure into which information from different systems can be connected.

Establish a Common Operational Hierarchy

One of the most important steps is establishing consistent organizational context.

For example:

Organization → Program → Project → Site → Visit

This hierarchy provides a common reference point.

A Kobo submission, ODK submission, or DHIS2 record may contain useful data, but management still needs to know how that information relates to the organization's operational structure.

For example:

Project: Maternal Health Improvement Program

Site: Facility 017

Monitoring Visit: 14 August 2026

Finding: Stock records incomplete

Corrective Action: Update stock documentation

The operational hierarchy turns isolated information into monitoring context.

Use Stable Site Identifiers

Multiple systems become much easier to manage when sites have stable identifiers.

For example:

  • SITE-001
  • SITE-002
  • SITE-003

The same identifier can be mapped across systems.

A DHIS2 organization unit, Kobo submission, ODK record, and FieldOps site can then be related to the same operational location where appropriate.

Without stable identifiers, organizations often resort to matching names manually.

That creates problems when one system calls a site:

Kapsabet Health Centre

while another uses:

Kapsabet HC

and another uses:

Kapsabet Health Center Level 3

A stable identifier is more reliable than attempting to match names.

Do Not Start With Integration Technology

Organizations often begin by asking:

How do we integrate Kobo with DHIS2?

or:

How do we connect ODK to our dashboard?

Those may be useful technical questions.

But they should come after a more fundamental question:

What operational process are we trying to support?

For example, if the goal is to monitor project sites, the workflow might be:

Data Source → Project / Site → Monitoring Visit → Finding → Corrective Action → Verification

The integration should support that workflow.

Otherwise, an organization can successfully move data between systems without actually improving monitoring.

Separate Systems of Record From Operational Workflow

A useful architecture distinguishes between the systems that hold source data and the system that manages the operational workflow.

Data Sources

KoboToolbox

Collection and submission data.

ODK

Field data and structured submissions.

DHIS2

Health information and program data.

Excel

Operational datasets and supporting information.

Operational Monitoring Layer

Projects

Sites

Visits

Findings

Corrective Actions

Verification

This approach does not require every source system to become an operational case-management system.

What Should Be Centralized?

Not everything needs to be copied into one platform.

The information that should be centralized depends on the organization's workflow.

For field monitoring, useful shared context includes:

  • project
  • site
  • monitoring visit
  • monitoring status
  • findings
  • finding severity
  • corrective actions
  • action owner
  • due date
  • evidence
  • verification
  • resolution status

The objective is to create a reliable operational view.

What Should Remain in the Source System?

Organizations should avoid unnecessary duplication.

The source system may remain responsible for:

  • original survey submissions
  • detailed health information
  • raw data
  • specialized datasets
  • indicator calculations
  • or other information for which it is the authoritative system

The operational layer can reference or synchronize the information needed for monitoring workflows.

This creates a more sustainable architecture than attempting to duplicate every field from every system.

Example: KoboToolbox and Operational Monitoring

Consider an NGO conducting a quarterly facility assessment using KoboToolbox.

Kobo collects:

  • facility information
  • assessment responses
  • observations
  • photographs
  • other survey data

The collection process works well.

But after the assessment, the M&E Manager asks:

Which facilities failed the assessment?

What findings were identified?

Who needs to address them?

When are the actions due?

Which facilities have unresolved findings?

Were the corrective actions verified?

The answers require more than the original submission.

The operational workflow could therefore become:

KoboToolbox → Project / Site Mapping → Monitoring Visit → Findings → Corrective Actions → Verification

The collection system continues doing what it does well.

The monitoring workflow gains the operational layer it needs.

Example: ODK and Field Monitoring

An organization may use ODK to collect field inspection data.

The ODK form can capture detailed observations during the inspection.

After submission, however, the organization may need to manage:

  • review
  • approval
  • findings
  • action owners
  • deadlines
  • follow-up visits
  • resolution

The operational monitoring process therefore extends beyond the submission.

A useful model is:

ODK → Field Data → Operational Visit → Review → Finding → Action → Verification

This allows ODK to remain part of the collection workflow without requiring it to manage the entire operational lifecycle.

Example: DHIS2 and Field Monitoring

Health organizations often have DHIS2 data that provides important information about facilities and program performance.

But a performance indicator may raise a question rather than answer it.

For example:

Why did Facility 017 report a significant decline in a particular indicator?

Management may need a field visit to investigate.

The resulting workflow could be:

DHIS2 Indicator → Site Requires Attention → Monitoring Visit → Observation → Finding → Corrective Action → Follow-Up

The health information system provides the program information.

The field monitoring workflow provides a mechanism for investigating and acting on what that information reveals.

Example: Excel and Monitoring Operations

Excel remains useful for many organizations.

A spreadsheet may contain:

Site Finding Owner Due Date Status
Site 001 Missing records Site Manager 20 Aug Open
Site 002 Stock documentation gap Facility Lead 25 Aug Open
Site 003 Resolved documentation issue Project Officer 18 Aug Closed

For a small number of findings, this may work.

As the number of projects, sites, visits, findings, users, and actions increases, organizations often need stronger relationships and workflow controls.

For example:

  • Which visit produced this finding?
  • What evidence supports it?
  • Was it reviewed?
  • Was it verified?
  • Has the site had the same finding before?
  • Which other sites have the same issue?

Those questions are difficult to answer reliably when operational relationships are maintained manually across spreadsheets.

The Problem With Separate Corrective-Action Trackers

A common pattern is:

Monitoring system → Findings → Excel → Corrective-action tracker

The problem is that the corrective-action tracker can become detached from the monitoring record.

Someone may see:

Missing documentation — Open

But not immediately see:

  • which project
  • which site
  • which visit
  • who identified it
  • what evidence was collected
  • why it was classified as significant
  • what happened during follow-up

A better operational model maintains the relationship:

Visit → Finding → Corrective Action → Verification

The Same Finding Can Reappear

Multiple systems also make recurring problems difficult to identify.

Suppose three monitoring visits report:

January

Stock records incomplete.

April

Stock records incomplete.

July

Stock records incomplete.

If each visit is stored independently, the organization may treat these as three unrelated observations.

Operationally, they may represent one recurring problem.

A monitoring system should make it possible to ask:

Has this site had the same or similar finding before?

and:

Has the corrective action actually resolved the underlying problem?

This is where historical monitoring data becomes more valuable than isolated submissions.

Build Around Events, Not Just Records

Operational monitoring is often easier to understand as a sequence of events:

Visit occurred → Finding identified → Action assigned → Evidence submitted → Action verified → Finding resolved

Each event has context.

The organization can therefore reconstruct what happened rather than simply viewing a collection of disconnected records.

Maintain an Audit Trail

When multiple systems are involved, traceability becomes particularly important.

Organizations should be able to determine:

  • where information originated
  • when it entered the monitoring workflow
  • who reviewed it
  • what changed
  • who approved it
  • what action was assigned
  • what happened afterward

This becomes especially important for monitoring records used in:

  • donor reporting
  • compliance
  • quality assurance
  • program management
  • audits
  • organizational learning

Avoid Creating a Giant Duplicate Database

A multi-system monitoring strategy should not mean:

Copy everything from every system into one enormous database.

That creates unnecessary complexity.

Instead, identify the information required for the operational workflow.

Source systems remain authoritative for their specialized datasets.

The operational monitoring layer maintains the relationships required to manage:

Project → Site → Visit → Finding → Action → Verification

This keeps the architecture focused on what management actually needs.

Create Clear Data Ownership

Every important piece of information should have an accountable source.

For example:

Information Possible authoritative source
Health indicator DHIS2
Survey submission KoboToolbox
Field inspection submission ODK
Project structure Monitoring platform
Site monitoring visit Monitoring platform
Finding Monitoring platform
Corrective action Monitoring platform
Verification result Monitoring platform

The exact arrangement will differ by organization.

The principle is:

Know which system owns which information.

This reduces duplication and conflicting versions of the truth.

Create a Common Monitoring Vocabulary

Multiple systems can use different terminology.

One system may use:

Facility

Another:

Site

Another:

Organisation Unit

Another:

Location

The organization should establish a common operational vocabulary.

For example:

Site

is the operational location used by the monitoring workflow.

Individual source-system identifiers can then be mapped to that site.

The same principle applies to:

  • projects
  • programs
  • indicators
  • findings
  • actions
  • statuses
  • reporting periods

Use Integration to Support Decisions, Not Just Data Movement

A technically successful integration is not necessarily a successful monitoring system.

Moving 10,000 records from one database to another does not automatically improve program management.

The integration becomes valuable when it helps answer questions such as:

Which sites require attention?

Which findings are overdue?

Which problems are recurring?

Which corrective actions have been verified?

Which projects have the greatest concentration of unresolved issues?

What changed after follow-up?

The objective should therefore be decision support and operational control, not simply synchronization.

A Practical Architecture for Multi-System Monitoring

A useful architecture is:

DATA SOURCES

KoboToolbox | ODK | DHIS2 | Excel

↓

DATA MAPPING

↓

OPERATIONAL CONTEXT

Project → Site → Visit

↓

FINDINGS

↓

CORRECTIVE ACTIONS

↓

VERIFICATION

↓

PERFORMANCE

The source systems continue serving their respective purposes.

The operational monitoring layer provides the shared workflow.

How FieldOps Fits Into a Multi-System Environment

FieldOps is designed around the operational monitoring layer rather than requiring organizations to abandon every existing data system.

It provides a structure for managing:

Organization → Program → Project → Site → Visit

and connecting monitoring visits to:

Findings → Corrective Actions → Verification → Performance

FieldOps can also work with data originating from systems such as KoboToolbox and ODK Central, allowing organizations to retain their existing data-collection workflows while adding structured operational monitoring.

The objective is not to make every organization use one tool for everything.

The objective is to provide a reliable operational workflow around the information organizations already collect.

A Practical Example of the Complete Flow

Imagine a development organization operating 60 project sites.

Its technology environment includes:

  • KoboToolbox for beneficiary surveys
  • ODK for field inspections
  • DHIS2 for health indicators
  • Excel for selected operational trackers

A site begins showing poor performance in DHIS2.

The project team identifies the site for follow-up.

A monitoring visit is created.

The field officer conducts the visit and records observations.

The visit is submitted.

A reviewer checks the record.

A finding is identified:

Required documentation is incomplete.

A corrective action is assigned:

Complete the missing documentation and submit evidence.

The action has an owner and due date.

The site later submits evidence.

The M&E team verifies the evidence.

The finding is marked resolved.

The operational chain is now:

DHIS2 Signal → Site → Monitoring Visit → Finding → Corrective Action → Evidence → Verification

The original systems remain useful.

But management now has a connected operational workflow.

When Should an Organization Consider an Operational Monitoring Layer?

A dedicated operational monitoring layer becomes increasingly valuable when an organization experiences several of these conditions:

  • multiple data-collection platforms
  • many projects
  • many sites
  • multiple monitoring teams
  • repeated field visits
  • large numbers of findings
  • corrective actions tracked manually
  • difficulty identifying overdue actions
  • inconsistent monitoring workflows
  • limited visibility into historical visits
  • difficulty determining whether problems recur
  • difficulty tracing findings back to their original field evidence

The exact threshold differs between organizations.

The important signal is not simply the number of systems.

It is the complexity of the workflow between data collection and action.

A Checklist for Managing Multiple Monitoring Systems

Before implementing or redesigning a multi-system monitoring environment, ask:

1. What does each system do?

Document the primary purpose of every platform.

2. Which system owns each type of data?

Avoid ambiguous ownership.

3. Do all systems use consistent identifiers?

Especially for projects and sites.

4. What is the operational monitoring workflow?

Define it before designing integrations.

5. Where are monitoring visits managed?

Do not assume the data-collection system should automatically own the entire workflow.

6. Where are findings managed?

Ensure findings remain connected to their source visits.

7. Where are corrective actions managed?

Define ownership, due dates, evidence and status.

8. How are actions verified?

Completion should not automatically mean resolution.

9. Can historical monitoring records be reconstructed?

Preserve important versions and audit information.

10. Can management identify recurring problems?

Historical relationships should support analysis across visits and sites.

11. Can management identify sites requiring attention?

Operational information should support prioritization.

12. Are integrations supporting decisions?

Measure success by improved monitoring and follow-up, not merely by successful data transfers.

The Most Important Principle

Organizations do not necessarily need to consolidate every piece of data into one system.

They need to connect the information required to manage their operations.

A strong multi-system monitoring architecture separates three concerns:

Data Collection

Collect information using the tools appropriate for the task.

Operational Monitoring

Connect information to projects, sites, visits, findings and corrective actions.

Management

Use the resulting operational information to prioritize attention, follow up on problems and understand performance.

This allows organizations to preserve the value of their existing systems while addressing the operational gaps between data collection and action.

Conclusion

Using multiple data systems is not inherently a weakness.

KoboToolbox, ODK, DHIS2, Excel, and other platforms can each serve important purposes.

The challenge arises when the organization needs to manage a workflow that crosses those systems.

The critical questions are no longer simply:

Was the data collected?

They become:

What does the data mean operationally?

Which project and site does it relate to?

Does it require a monitoring visit?

What finding resulted?

Who must act?

Has the action been completed?

Has it been verified?

What happened afterward?

A practical approach is therefore to keep specialized systems for the work they already perform well while establishing a structured operational monitoring layer around:

Project → Site → Visit → Finding → Corrective Action → Verification → Performance

That is the difference between having multiple sources of data and having a connected monitoring operation.

For organizations using KoboToolbox, ODK, DHIS2, Excel, or combinations of these tools, the goal should not be to eliminate every existing system.

The goal should be to ensure that data collected in the field can ultimately lead to a traceable monitoring decision and, where necessary, verified corrective action.

Collect where appropriate. Connect the operational context. Act on what the monitoring reveals.

FieldOps Africa

Move beyond data collection

FieldOps helps NGOs manage field visits, monitoring templates, findings, corrective actions, dashboards and donor reporting in one operational intelligence platform.

Learn more about FieldOps