EIGENN.
docsguidesapichangelogpricingsign in
EIGENN.

Data integrations

The connectors in the Data sources catalog and the planning data that each connector brings into a model.

A data integration brings actuals into Eigenn from a system that you already use. Each connector gives one kind of planning dataset. A dataset is not part of a model until you link a variable to it.

To see the connectors, go to Scenario planning → Data → click New. The Data sources dialog shows one card for each connector. Use the tabs, such as Accounting and Spreadsheets, to filter the cards. You can select a card only when the connector has a planning dataset. Other cards show Coming soon or No planning datasets yet.

If you do not find a connector, click Request under Not finding what you need?.

Connectors and their data

ConnectorTabWhat it brings into a modelBefore you start
XeroAccountingMonthly P&L and balance-sheet accountsConnect Xero in Marketplace
QuickBooksAccountingIssued invoice amount and countConnect QuickBooks Online in Marketplace
FortnoxAccountingIssued invoice amount and count, with no source on the Data pageConnect Fortnox in Marketplace
Bank transactionsOtherMonthly net for each transaction categoryConnect a bank or add transactions
CSV importSpreadsheetsMonthly net for each transaction categoryImport a CSV on the Transactions page
StripeSubscription / BillingIssued invoice amount and countConnect Stripe in Marketplace

Three kinds of planning data

  1. Statements. A Xero source holds the P&L and the balance sheet. You create it on the Data page, and it refreshes from Xero.
  2. Transaction categories. A Bank transactions or CSV import source rolls up the team's transactions by category and month. You create it on the Data page.
  3. Invoice actuals. Imported invoices need no source. After Eigenn imports invoices from QuickBooks, Stripe, Fortnox, or Xero, a model can link to them.

Statement and category sources show as cards on the Data page. Invoice actuals do not.

The Data page with the All tab selected. One active source, Bank category actuals, appears under the Bank transactions heading. The New button is at the right of the toolbar.

Pages in this group

  • Xero: connect Xero and bring in the P&L and the balance sheet.
  • QuickBooks: use imported QuickBooks invoices as invoice actuals.
  • Fortnox: use imported Fortnox invoices as invoice actuals.
  • Bank transactions: use transaction categories as monthly actuals.
  • CSV import: the file format, the column mapping, and the limits.
  • Stripe: use imported Stripe invoices as revenue actuals.

Related

  • Data
  • Data
  • Connect a source
  • Link a variable to data
  • Refresh and check actuals

Data

Connect data sources, link variables to actuals, and check the actuals against the source.

Dimension examples

Three worked examples of dimensions in a planning model, with revenue by region, headcount by department, and a P&L by entity.

On this page

Connectors and their dataThree kinds of planning dataPages in this groupRelated

Eigenn docs

current product

Overview
Overview
OverviewAccount PreferencesApproval PoliciesAssistant AutomationAssistant Command CenterAssistant Workspace and Saved WorkBank ConnectionsBilling and UsageBudgets and ForecastCommand CenterCustomer FieldsCustomer LifecycleCustomer RecordsCustomersDeveloper PlatformDocument Processing and ExtractionFiles and Document VaultFinancial Analytics and ReportsFinancial OverviewInbox and ApprovalsInvoice InsightsInvoice ProductsInvoicesMarketplace IntegrationsNotifications and BrandingOnboarding and SupportOverviewPlanning Data and DimensionsPlanning Models and FormulasPlanning Time and ActualsPlanning UncertaintyPlanning Versions and CollaborationPlanning Views and ExportsPlans and AdjustmentsReceivablesReceivables AnalyticsReceivables ControlsRolling Budget CloseScenario PlanningSecurity and AccessSettings OverviewStress TestsTeams and OrganizationsTone Profiles and ExperimentsTransaction Categories and RulesTransaction CodingTransactionsWeekly Finance RitualWorkflow ExecutionsWorkflow OutcomesWorkflow PausesWorkflows
OverviewBudget vs. ActualsBuild a Driver-Based Planning ModelBuild and Review a ForecastBuild Your First WorkflowCollaborate on a Planning ModelCompare and Share Planning ScenariosConfigure Approval PoliciesConfigure Assistant OperationsConfigure Customer FieldsConfigure Notifications and BrandingConfigure Planning Time and ActualsConfigure Receivables ControlsConnect Planning Data and ActualsConnect Transaction RecordsConsolidationCreate and Manage CustomersCreate and Send InvoicesCreate Your First Planning ModelDeveloper API SetupFirst Cash ReviewHeadcount PlanningInvoice Collection WorkflowMaintain Transaction RulesManage Security and BillingManage Team AccessManage the Invoice LifecycleMCP WorkflowsMonitor and Recover WorkflowsOrganize and Share DocumentsProcess Inbox ItemsReconcile and Categorize TransactionsRevenue ForecastingReview a Customer Finance RecordReview, Restore, and Export a Planning ModelRun a Finance Operating ReviewRun a Receivables Tone ExperimentRun a Runway Stress TestRun Planning Uncertainty AnalysisRun Your First Command Center ReviewSave and Share Assistant WorkSet Up a WorkspaceTroubleshoot Account AccessWebhook DeliveryWeekly CFO Review
Overview

Concepts

DataDimensionsFormulasScenarios

Variables

VariablesChange an input over timeCreate a variableFormat a variableOrganize variablesTime totalsUse a variable from another modelVariable types

Time

TimeLast actual dateRoll the model forwardTime granularityTime settings

Formulas

FormulasBlanks and helpersCommon formulas: cash and balance sheetCommon formulas: cohortsCommon formulas: currency and multiple entitiesCommon formulas: headcount and payrollCommon formulas: SaaS metricsCommon formulas: seasonalityConditionalsDimension referencesFormula syntaxFunctionsTime referencesTroubleshoot formulasValues with uncertaintyWrite a formula

Charts and Dashboards

Charts and dashboardsCompare scenarios and versionsCreate a chartExport and shareTablesTime aggregation in charts

Dimensions

DimensionsApply a dimensionCreate a dimensionDimension examplesDimension totalsThe Dimensions page

Data

DataChoose cash or accrual for XeroConnect a data sourceLink a variable to dataRefresh and check actualsUse transaction categories as actuals

Data Integrations

Data integrationsBank transactionsCSV importFortnoxQuickBooksStripeXero

Views

ViewsCreate and edit a viewFilter a viewShare a view

Versions

VersionsCompare versionsRestore a versionSave a version

Scenarios

ScenariosCompare scenariosCreate a scenarioPlans and adjustmentsStress tests and shocks

Collaboration

CollaborationComment on a modelShare a model and set accessTeam roles and planning access

Managing Models

Managing modelsDuplicate a modelExport a modelModel limits and performanceStart from a templateThe models home and foldersTrash, restore, and delete a model
OverviewIntegrationsMCPSDKsWebhooks
OverviewAuthenticationBank Accounts APICustomers APIErrorsForecasts and Stress Tests APIInvoice Payments APIInvoices APIPaginationRate LimitsRemote Tracker API StatusTracker Categories APITracker Entries and Timers APITracker Projects APITransactions APIWebhooks API StatusWorkflows API
Overview
Overview