Customer Success Story

From 22 Disconnected Databases to a Single Source of Truth

Consolidated 22 disparate entity databases and automated complex inter-company transactions across land management, hospitality, and agricultural farming. Roxburghe Estates was able to save 80 hours in its month-end close.

floor castle

Company

Sunlaws Development Company (Roxburghe Estates)

Partner

Folio3

Company Size

51-200

Industry

Real Estate

Region

UK

key outcomes

Unified Systems, Simplified Operations, Measurable Impact

After implementing NetSuite with Folio3, Roxburghe Estates simplified the complexities of its multi-entity operations. The consolidation of disconnected databases into a single, unified platform and the automation of critical processes resulted in significant time savings.

10,000
Minutes Saved

Saved time to process 2,500 invoices by automating complex transactions

960
Hours/Year Saved

Accelerated the month-end close process and saved hundreds of hours

35%
Transactions Automated

Automated 35% of total transaction volume and removed manual entry

22
Entities Consolidated

Consolidated 22 disparate entity databases into a single NetSuite platform

3,600
Minutes/Year Saved

Saved time by automating revenue recognition for rental properties

2,400
Minutes/Year Saved

Removed manual paper filing through ZoneCapture OCR

ABOUT ROXBURGHE ESTATES

One of the UK’s Leading Estates, Operating Diverse Businesses Across 52,000 Acres

Roxburghe Estates manages a diverse portfolio of businesses, spanning land and estate management, hospitality, agriculture, renewable energy, property letting, forestry, and sporting activities across the UK. The Estate attracts thousands of visitors every year and is home to Floors Castle, which is at the heart of Roxburghe Estates.

multi vertica
The Challenge

Fragmented Operations, Disconnected Systems, and Process Delays

The growth of Roxburghe Estates had outpaced the legacy systems it used to keep track of data and report it to the Duke and the Trustees. The fragmentation created operational risks and delayed strategic decisions.

Fragmented Inter-company Transactions

Complex pass-through transactions between related estate entities were processed manually. This consumed significant capacity of the finance team every single month.

Disconnected Entity Databases

Financial data lived across separate entity databases with no unified view. Producing an estate-wide report required manual data mining that took hours and caused reporting delays.

Manual Revenue Recognition

Rental property revenue recognition was managed through manipulated spreadsheets. This consumed the time of senior finance resources each month that could otherwise go to strategic analysis.

Paper-based Approvals

Invoice filing relied on manual paper processing with no systematic duplicate checking, while departmental budgeting depended on fragile, manually linked Excel templates prone to breaking and errors.

The Solution

A Unified System for Faster Financial Reporting Across Multiple Entities

Folio3 implemented NetSuite SuiteSuccess Financials First, ARM, OneWorld, Advanced Financials, and Fixed Asset Management as the financial foundation for Roxburghe Estates. The Folio3 team replaced fragmented databases and manual spreadsheet processes with one unified, cloud-based platform. The solution was architected to handle the estate’s unique complexity of multiple entities, interlocking transactions, and strict regulatory reporting requirements.

NetSuite Implementation

Deployed as the Roxburghe Estates’ core financial system to replace disconnected entity-level databases and spreadsheets with a single unified platform.

Multi-entity Consolidation

Consolidated 22 disparate entity databases into NetSuite and enabled estate-wide reporting across all business lines from the one source of truth.

Inter-company Automation Scripting

Automated complex pass-through transactions between related entities, cut invoice processing time, and freed up the finance team from repetitive manual work.

NetSuite ARM Module

Automated revenue recognition for rental properties, eliminated manual spreadsheet manipulation, and gave senior finance staff time back for strategic work.

OCR and Approval Workflows

Implemented ZoneCapture OCR with digital approval workflows and systematic duplicate checking. This removed paper filing and reduced the risk of payment errors.

DataRails Integration

Integrated NetSuite with DataRails to replace fragile, manually linked Excel budget templates with a robust, automated budgeting process.

financial operations
Business Outcomes

All 22 Entities Consolidated and Financial Reporting Made More Accurate

Roxburghe Estates replaced manual, paper-based, and spreadsheet-driven financial processes with a unified platform. What once required hours of spreadsheet manipulation now delivers estate-wide reports in seconds.

Operational Efficiency

  • Automating complex inter-company pass-through transactions reduced time to process 2,500 invoices by 66%, from around 15,000 minutes to 5,000 minutes. This enabled the finance team to save another 960 hours per year in month-end close.
  • Consolidating 22 disparate entity databases into a single NetSuite platform enabled the generation of estate-wide reports, such as donations or P&Ls, in seconds rather than hours.

Cost Reduction

  • Automating the revenue recognition process for rental properties saved 3,600 minutes per year of senior finance team previously spent manipulating spreadsheets. This enabled a shift in focus from manual data entry to strategic analysis.
  • Implementing ZoneCapture OCR and digital approval workflows eliminated approximately 2,400 minutes of manual paper filing annually and introduced strict duplicate checking to prevent payment errors.

Budgeting and Reporting

  • Integrating NetSuite with DataRails eliminated fragile, manually linked Excel budget templates and enabled a robust budgeting processes where 70+ departmental files can be generated and consolidated in under one minute.
  • A single source of financial data across all entities improved reporting consistency, reduced reconciliation effort, and minimized the risk of manual data errors.

Data Integrity and Compliance

  • Migrating to a unified cloud platform delivered granular visibility of profitability by activity and enabled Roxburghe Estate to navigate Scottish Land Reform risks by strategically bringing farm operations in-house via contract farming.
  • Custom integration enhancements ensured accurate lease revenue recognition in NetSuite and eliminated a key accounting and compliance risk within the standard setup.

We'd love to help you with all your NetSuite needs

Folio3 Your Top Choice:

Folio3 awarded NetSuite Partner of the Year 2025
Folio3 awarded NetSuite Alliance Partner Spotlight for Education in 2025
Winner Award
Software and IT Services 2024

Let's discuss your NetSuite needs

Hello, How can we help you?

Get a 45-Minute
NetSuite Consulting Session

Worth $2,000 for Free

Grab the opportunity to speak with one of our top-rated consultants to get expert guidance on your NetSuite needs.