Case Study • Construction • Automation

Automating Expense Integration Across Emburse, Microsoft Fabric, and Viewpoint Vista

AccelOne helped Chandos automate expense data between Emburse and Viewpoint Vista, improving accuracy, traceability, and scalability.

Data Integration Automation Embruse Microsoft Fabric Viewpoint Vista
client: Chandos Construction Aug 2026
Chandos_overview
03
Core systems
integrated
100%
Automated expense
data movement
Line-level
Receipt & ticket
traceability
01
Scalable foundation
for future automation
Overview
Chandos_Client

About the client

Chandos Construction is one of Canada’s largest employee-owned builders, recognized for its collaborative approach, technical expertise, and commitment to sustainability.

As the company grew, its manual expense reconciliation process created additional work and increased the risk of data inconsistencies.

Chandos needed a more reliable, scalable way to move and validate expense data between Emburse and Viewpoint Vista.

The challenge

Modernizing a Manual, CSV-Driven Expense Workflow

The flow of expense data between Emburse and Viewpoint Vista relied on manual CSV reconciliation, line-by-line validation, and matching supporting documents to individual transactions.

This slowed processing and increased the risk of errors in cost allocation, phase codes, report IDs, vendor mappings, and tax calculations.

The Challenge

The Hard Problems

01

Problem title

Problem description.

02

Problem title

Problem description.

03

Problem title

Problem description.

Our Solution

Connecting Expense Systems Through Intelligent Automation

AccelOne designed and implemented a comprehensive automated data integration between Emburse and Viewpoint Vista, using Microsoft Fabric as the orchestration and data processing platform. The solution was built to:

Automate Expense Movement

RESULT 01

Replace manual CSV reconciliation with a scheduled, automated flow of coded expenses and attachments between Emburse and Viewpoint Vista.

Automation Automation

Validate Before It Counts

RESULT 02

Apply transformation and business-rule validation, including tax logic and vendor mapping, before data reaches downstream financial processing.

Validation CheckCircle

Preserve Critical Formatting

RESULT 03

Protect values like leading zeroes in phase codes and report IDs that are easy to lose and costly to get wrong.

Formatting Devices-1

Connect Documentation to the Transaction

RESULT 04

Attach receipts and supporting tickets at the expense-line level, not just as generic supporting files.

Documentation Code

Orchestration & Pipelines

RESULT 05

Data Factory pipelines and OneLake handle the scheduled movement and synchronization of expense and reference data.

Data Container-Aug-13-2026-07-32-35-8540-PM

Processing & Validation

RESULT 06

Synapse and Spark Notebooks apply transformation logic, tax validation, and coding rules before data loads downstream.

Validation CheckCircle

Connectivity & Security

RESULT 07

An On-Premises Data Gateway provides secure connectivity, Azure Key Vault manages credentials, and Git integration handles deployment artifacts, with Power BI available as an optional reporting layer.

Security Shield
This architecture replaced manual reconciliation with automated processing and validation, giving Chandos a more reliable expense workflow and less operational overhead.
Highlights

Engineering Highlights

A Structured Implementation

The integration followed a clear plan, from requirements and environment setup through development, testing, user acceptance, and production deployment.

Building and Validating the Integration

The teams defined business rules, data structures, security needs, and system access before configuring Microsoft Fabric and developing the pipelines and transformation logic.

Testing and Production Support

Testing and Production SupportTesting verified data quality, coding, taxes, vendor information, and attachments. After launch, AccelOne supported stabilization and provided documentation to help Chandos monitor and troubleshoot the integration.

The Outcome

Results & Impact

01
Automated the manual CSV reconciliation steps that previously drove operational overhead for the finance team.
02
Made supporting tickets and receipts available at the expense-line level, so individual charges are easier to validate and trace.
03
Established a structured, repeatable flow of expense data between Emburse and Viewpoint Vista in place of disconnected manual steps.
04
Applied tax validation, vendor mapping, and formatting rules automatically, ahead of financial processing.
05
Added monitoring, validation checkpoints, and exception handling that give the team real visibility into whether the process completed successfully.
06
Delivered a production-ready, scalable foundation Chandos can extend as its business rules, reporting needs, and system integrations evolve.
OUTPUT

Strategic Value

The new integration gives Chandos more than a faster reconciliation process, it gives the company a production-ready foundation to build on.

The Fabric-based architecture is designed to extend as business rules, reporting needs, and system integrations evolve, so it can grow with Chandos rather than becoming another manual workaround.

This engagement reflects the kind of focused, outcome-driven collaboration that lets a company modernize a critical financial process without disrupting the teams that depend on it, and lays the groundwork for further automation as Chandos’s operations scale.

Impact

Business Impact

What had been a manual, CSV-driven reconciliation process spread across disconnected systems is now a structured, automated integration. That shift changes how Chandos’s finance and project teams work day to day.

Teams spend less time reconciling files by hand and more time reviewing and validating the expense data itself, now that receipts and tickets are tied to the correct line.

Tax logic, vendor mapping, and formatting rules run automatically instead of depending on manual review, and monitoring gives the team clear visibility into whether the process completed successfully or needs attention.

Chandos transformed a manual, CSV-driven process into an automated integration, reducing reconciliation work, improving data validation, and giving teams greater visibility into every expense.

Frequently asked questions

Why did Chandos need to modernize its expense integration?
As Chandos grew, manual CSV reconciliation and line-by-line validation became increasingly time-consuming and difficult to scale. The company needed a more reliable way to maintain accurate financial data across Emburse and Viewpoint Vista.
Why was Microsoft Fabric selected for the solution?
Microsoft Fabric provided a centralized platform for orchestrating data movement, applying transformation rules, validating information, and monitoring the integration. Its cloud-based architecture also gives Chandos a flexible foundation for future growth.
How does the integration improve financial accuracy?
The solution automatically applies tax logic, vendor mappings, coding rules, and formatting protections before expenses reach downstream financial processes. Receipts and supporting documents are also connected to the correct expense lines.
What business value does the automation deliver?
Finance and project teams spend less time reconciling files and correcting inconsistencies. They can focus on reviewing expense data while gaining clearer visibility into processing results and exceptions.
How can the solution support Chandos’s future needs?
The integration was designed as a scalable foundation that can evolve alongside Chandos’s business rules, reporting requirements, transaction volumes, and system landscape.
RELATED CASE STUDIES.

Real outcomes, measurable impact

From FinTech to Government and Enterprise, we help organizations achieve faster delivery, higher quality, and sustainable innovation.

Automating Expense Integration Across Emburse, Microsoft Fabric, and Viewpoint Vista

Discover how AccelOne helped Chandos automate expense integration across Emburse, Microsoft Fabric, and Viewpoint Vista.

Designing an AI-Powered Leadership Development Platform for Think Together

See how AccelOne helped Think Together build a secure, AI-powered leadership development platform that delivers personalized superintendent training...

A Real-Time Reporting Platform Built for Construction Project Management

AccelOne helped XL Construction replace manual project reporting with a real-time web platform that improved data accuracy, streamlined workflows,...

Building a Scalable AI Platform for Real-Time Sports Analytics

Discover how AccelOne built a mobile AI platform that uses a single smartphone to analyze live baseball games and deliver real-time insights to fans.

Developing a Modern Credit Improvement Platform

Explore how AccelOne accelerated the launch of a credit empowerment platform through product strategy, agile delivery, secure integrations, and...

From Audio Hardware to a Connected Digital Platform

AccelOne helped MJP Audio Designs build a unified software platform connecting hardware, cloud, desktop, mobile, and web in approximately five months.

Building an AI-Native Insurance Platform for Med Spas

Discover how AccelOne built a HIPAA-compliant AI insurance platform for Olivarch, streamlining med spa onboarding, claims, and policy management.

How AccelOne Built a Blockchain Digital Wallet for Argentina's Government in 5 Months

AccelOne built Billetera Activa, a private blockchain platform for the Government of San Luis, Argentina, replacing paper graduation awards with...

Cryptocurrency Transaction Platform Solution: Building the Core Reconciliation Engine for Xapo

AccelOne architected and delivered the core reconciliation engine for Xapo, a leading South American Bitcoin wallet and debit card company, beating...

How AccelOne Built Vivian: An AI Assistant That Turns Institutional Knowledge into Instant Answers

AccelOne built Vivian, an internal AI assistant connected to all company data sources, Slack, Google Drive, email, and more, that answers questions...

Building a Community Event Discovery App for iOS and Android

AccelOne architected and built native iOS and Android apps that connect users with local events based on proximity and shared interests. Built in two...

Enhancing Legal Accessibility: Rebuilding a Multi-Channel Checkout for a Legal Services Provider

AccelOne rebuilt a broken checkout and cart system for a legal services company, integrating multiple sales channels, enabling cart persistence,...

Custom Sales Tax Software: State-Certified, Built to Scale to Millions of Transactions

AccelOne built a custom sales tax platform that validates, reconciles, and files returns in minutes, with real-time jurisdictional error alerts down...

Explore more perspectives from AccelOne