web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

GP: What are some reconciliation tools/add-ins to reconcile external sources of data?

(3) ShareShare
ReportReport
Posted on by 22
Purpose:
I'm looking for reconciliation tools that can reconcile external datasets to what is in the GL. For example: we may have a list of transactions that come from another dataset or system such as Unitrax that ultimately needs to be reconciled back to what is in GP.
It might even be multiple systems including a loan system with transactions that ultimately needs some accounts to reconcile back to certain accounts in the Loan System.
 
What I'm Interested In Finding:
1) A facilitator of reconciliations - provides a foundation or place to complete reconciliations - I think a lot of the 3rd party tools I'm finding are facilitators, but it's #2 that is often hard to find.
2) An actual assistant or process improvement in reconciliation - going beyond the base and the tool actually matching transactions
 
My Search So Far:
Native GP Functionality:
I started off searching reconciliation tools that exist natively and it seems like GP has native functionality for modules such as AP/AR/Inventory and Bank Recs (GP2010 is limited to AP and AR).
 
External GP Functionality:
- CCH Tagetiks - seems smart and can handle external data loading
- Blackline - worked with this in the past with SAP
- FloQast
 
They seem to be great facilitators however, Tagetiks seems to do more heavy lifting on #2 in what I'm looking for (above) and Blackline behind that. Don't know much about FloQast yet.
Categories:
I have the same question (0)
  • Suggested answer
    Saif Ali Sabri Profile Picture
    2,351 Super User 2025 Season 2 on at
    1. Native GP Functionality
    Limited to AP, AR, Inventory, and Bank Reconciliations
    Lacks automated external dataset matching

    2. External Solutions
    Facilitators & Process Improvement
    CCH Tagetik – Strong in data loading and automation, offering advanced reconciliation beyond facilitation.
    BlackLine – Well-known for automating account reconciliations and handling external datasets efficiently.
    FloQast – More focused on close management but offers automation in reconciliations.

    Alternative Approaches
    SmartConnect (eOne Solutions) – Can integrate external data with GP but requires configuration.
    Microsoft Power Automate + Power BI – If custom reconciliation logic is required, this can automate and visualize reconciliation discrepancies.

    For automated transaction matching, CCH Tagetik and BlackLine are the best bets.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans