Tabular Data to OnePlan Financial Planner Integration

This integration is designed to streamline the process of importing financial data into the OnePlan Financial Planner using a CSV UTF-8 file. It enables users to efficiently populate cost categories or detail rows within the planner, reducing manual data entry and minimizing errors. It can be used on demand or on a schedule.

Use Cases

The tabular data integrations have the following popular use cases:

Update Global Cost Categories

Use Case: Import financial data into standardized cost categories shared across all plans.
Value: Ensures consistency and simplifies reporting across the organization.

Create Plan-Specific Cost Categories

Use Case: Import data into custom cost categories unique to individual plans.
Value: Enables tailored financial tracking for projects with specialized budgeting needs.

Populate Custom Financial Fields

Use Case: Import data into custom fields defined in the Financial Planner.
Value: Supports advanced analytics and aligns with unique business metrics.

Import Actuals from External Systems

Use Case: Bring in actual financials from systems like SAP or spreadsheets.
Value: Keeps financial plans aligned with real-world expenditures for accurate forecasting.

Time-Phased Financial Data Import

Use Case: Import financial data broken down by time periods (e.g., monthly).
Value: Enhances visibility into budget trends and supports variance analysis.

Revenue and Cost Type Integration

Use Case: Import revenue data and categorize costs (e.g., CapEx, OpEx).
Value: Aligns financial planning with accounting structures and improves financial clarity.

Import Detailed Rows into Financial Planner

Use Case: Import and update detailed financial records using unique identifiers that roll up to a cost category.
Value: Enables granular tracking and ongoing updates to financial plans.

Synchronize Financial Data Across Platforms

Use Case: Use automation tools to sync financial data between OnePlan and other systems.
Value: Reduces manual effort and ensures data consistency across platforms.

Key Features

The tabular data integrations support the following:

• Secure connection options (e.g., IP whitelisting)
• Time phased data (monthly or weekly)
• Global or custom cost categories
• Detail rows
• On demand, manual data imports
• Scheduled automatic data imports

Setup Requirements

Before setting up the integration, make sure you have:

• The necessary file with the data.
• The file is accessible (e.g., firewall rules, credentials, etc.) by the integration. 

Source Data

The source data must be in a comma separated file (CSV UTF-8).

Microsoft Excel and many other tools, including reporting solutions, support creating, updating, or exporting data to comma separated files. 

Source File Location

Files can be loaded from these sources:

• SharePoint Online (document library)
• OneDrive (folder)
• SFTP

SharePoint Online

If you are planning to use SharePoint Online, please review the authentication options. 

SFTP

The SFTP site must be hosted by the party that owns the source data. OnePlan can provide source IPs for firewall rules to connect to the source file. 

Next Steps

Once the integration is installed:

1. Setup the integration.
2. Adjust your financial plan configuration as required.
3. Start importing data.