Help Centre
›
ERP integrations
›
Finofo and Sage Intacct: How the Integration Works

Finofo and Sage Intacct: How the Integration Works

How Finofo integrates with Sage Intacct: what syncs, setup steps, multi-entity, dimensions, Smart Rules and approval decisions, and how to test before go-live.

At a glance

Finofo connects natively to Sage Intacct, which stays your system of record: Finofo syncs the vendors, accounts, entities and dimensions your coding needs, then sends approved, line-coded bills and payment records back.

Settle the Sage Intacct decisions during setup: which entities are in scope, which dimensions are required, how bill approvals run and how tax is handled.

How It Works

From Sage Intacct, Finofo uses vendors and the reference data your team codes with, brought in through the connection, a CSV import or manual upkeep: the chart of accounts, entities, and dimensions such as location, department, class and project, plus any user-defined dimensions your coding requires. Each invoice line in Finofo is coded with those values.

Invoices are captured, read, coded, matched and approved in Finofo. Approved invoices go to Sage Intacct as bills with their line coding. Posting follows approval, and how payment records go back is agreed with your Finofo team during setup.

Sage Intacct keeps the ledger, consolidation and financial reporting. The source document, approval history, comments and exceptions stay with each invoice in Finofo.

What Syncs Between Finofo and Sage Intacct

  • Sage Intacct to Finofo: Vendors, each mapped on its Finofo vendor profile.
  • Sage Intacct to Finofo: Chart of accounts, entities, and the standard and user-defined dimensions your coding requires.
  • Finofo to Sage Intacct: Approved invoices with line-level account, entity, location, department, project and other dimension detail.
  • Finofo to Sage Intacct: Payment records, in the form agreed with your Finofo team during setup.
  • Stays in Finofo: The source document, approval history, comments and exceptions.

Set Up the Connection

1. Confirm the setup and the entities in scope with your Finofo team.

2. Prepare Sage Intacct access with your administrator. A dedicated integration user, rather than a personal login, keeps access auditable and survives staff changes.

3. Your Finofo team sets up the Sage Intacct connection with you. The route depends on your Sage Intacct version and what data needs to flow in each direction.

4. Agree the coding dimensions with your Finofo team: which ones each line needs, which are required and which combinations are valid. Reference data comes from your ERP through the connection, a CSV import or manual upkeep.

5. Check that each vendor profile in Finofo holds its ERP mapping, and agree with your Finofo team how payment records are sent back.

6. Test with real invoices before go-live (see below).

Sage Intacct Decisions to Settle During Setup

Each area below shows the question to settle, followed by why it matters.

  • Entities: Is the company multi-entity, and do bills post at the top level or at each entity?
    Entity-level and top-level bills are paid and reported differently.
  • Dimensions: Which standard and user-defined dimensions are required on each bill line?
    Dimension-based reports depend on complete lines.
  • Dimension relationships: Are any dimension values restricted by entity or related to other dimensions?
    Coding must only offer combinations Sage Intacct accepts.
  • Approvals: Are AP bill approvals turned on in Sage Intacct?
    Avoids approving the same invoice in two places.
  • Smart Rules: Do any Smart Rules block or warn on bills, for example a required project?
    A rule that blocks a bill in Sage Intacct stops it posting from Finofo too.
  • Tax: How is tax set up: through the Taxes application with tax solutions, or as separate lines?
    GST, HST, PST and QST need the right treatment per line.
  • Currencies: Which vendor currencies are in scope?
    Foreign currency bills must post with the expected exchange rate treatment.

Test Before Go-Live

1. Post a single-line invoice from an existing vendor.

2. Post a multi-line invoice with different accounts, departments, locations and tax on different lines.

3. If you are multi-entity, post an invoice for each entity in scope.

4. Post a credit note against an earlier invoice.

5. Pay a small batch and check the payment entries in Sage Intacct.

Open each bill in Sage Intacct and confirm the dimensions, entity and tax are what your controller expects.

Fix Common Sage Intacct Sync Issues

  • A dimension value is missing from coding options: Check that the value is active in Sage Intacct and available to the entity you are coding.
  • A bill did not reach Sage Intacct: With Manual posting, open Post to ERP: the drawer shows whether the invoice is ready or blocked, and why. Check that the vendor profile holds its ERP mapping. Then check for a closed period, an inactive account or a Smart Rule that blocks the bill.
  • A bill posted to the wrong entity: Check the entity coded on the invoice in Finofo, and review the entity setup with your Finofo team.

Tips

  • Map your user-defined dimensions before go-live, and set them as required only where your reports need them.
  • Review Smart Rules on AP bills with your Sage Intacct administrator before the first test, so a hidden rule does not block posting.
  • If you consolidate across entities, test each entity rather than only the top level.
  • Sage Intacct remains the system of record for the ledger, consolidation and financial reporting.

Frequently Asked Questions

Does Finofo support Sage Intacct multi-entity companies?

Finofo codes invoice lines by company, GL account, operating unit and department, plus optional dimensions. How your entities map to those, and the entities in scope, and whether bills post at the top level or at each entity,, is settled with your Finofo team during setup.

Will user-defined dimensions carry through?

Finofo supports optional coding dimensions, such as project, alongside company, GL account, operating unit and department. List your user-defined dimensions during setup so your Finofo team can map them and set required fields and valid combinations.

Is Sage Intacct the same as Sage 300?

No. They are different Sage products with different integrations. Sage 300 has its own article.

Do approvers need Sage Intacct logins?

Approvals happen in Finofo, including on mobile, so approvers review and approve there rather than in Sage Intacct.

Can we pay bills that are already in Sage Intacct?

Talk to your Finofo team during setup. Whether open bills already in Sage Intacct come into Finofo for payment is part of the integration design, and approved bills can then be paid individually or in a batch.

Back to
ERP integrations