/
/
Keep one project list across Asana and Sage Intacct
For finance and delivery teams who want their AI assistant to find projects that differ between Asana and Sage Intacct.
On this page
Connector
Connect Asana, pick your AI tool and paste the prompt.
The problem
Two project lists that drift apart
Projects are tracked in Asana for delivery and in Sage Intacct for finance, and the lists drift. Projects finished on one side stay open on the other, dates and owners disagree and some never reach one system.
Without PopdockAI
- Export projects from Asana
- Export projects from Sage Intacct
- Compare status, dates and owners by hand
- Miss projects missing from one side
With PopdockAI
- Projects read from both systems and paired by exact name
- Completion, dates and owner compared side by side
- One sided and ambiguous names listed
- Unset dates not counted as mismatches, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare the projects in Asana with the projects in Sage Intacct and report where they disagree. Limit Asana to projects whose name contains `{project-name}` (default: all non-archived projects) and to the team containing `{team}` (default: all teams).
**Step 1: Read the Asana projects**
Call `asana-get-project` with `archived` = false, `name.contains` = `{project-name}` if given, and `team.contains` = `{team}` if given. Keep `name`, `project-id`, `completed`, `current-status`, `start-on`, `due-on` and `owner` for each.
**Step 2: Read the Intacct projects**
Call `intacct-get-project`, using `project-name.contains` = `{project-name}` if given. Keep `project-name`, `project-id`, `project-status`, `status`, `begin-date`, `end-date`, `percent-complete` and `project-manager-name`.
**Step 3: Match them**
Match an Asana project to an Intacct project when Asana `name` equals Intacct `project-name`, ignoring case and leading or trailing spaces. If one name matches more than one project on either side, list those as ambiguous and do not compare them. Do not match on partial names.
**Step 4: Report**
Four sections:
1. **Mismatched** - matched projects that disagree. One row each: project name, the field, the Asana value, the Intacct value. Compare completion (Asana `completed` against Intacct `project-status` and `percent-complete`), start date (`start-on` against `begin-date`), end date (`due-on` against `end-date`) and owner (`owner` against `project-manager-name`).
2. **In Asana only** - Asana name and owner.
3. **In Intacct only** - Intacct `project-id` and `project-name`.
4. **Ambiguous** - names that matched more than once.
Finish with counts: matched, mismatched, Asana only, Intacct only.
**Rules & Guidelines:**
* `asana-get-project` is on the asana server. `intacct-get-project` is on the intacct server.
* This prompt is read-only. Do NOT call `asana-update-project`, `asana-create-project`, `asana-create-status-for-project`, `intacct-create-project` or `intacct-update-project`.
* Asana dates are ISO (2026-03-01); Intacct dates may be MM/DD/YYYY. Compare the dates, not the strings.
**Validation:**
* If either side returns no projects, say which side was empty and stop. Do not report every project on the other side as missing.
* An Asana project with no `due-on`, or an Intacct project with no `end-date`, is not a date mismatch. Say the date is unset.Who it's for
One answer, three teams that use it
Project accountants
Close finished projects in finance
Projects complete in Asana but open in Intacct are listed.
Which projects are complete in Asana but still open in Sage Intacct?
PMO leads
Find projects missing on one side
Projects only in Asana or only in Intacct are listed with counts.
Reconcile the Professional Services team's Asana projects with Sage Intacct.
Finance managers
Fix dates and owners that disagree
Both values are shown side by side for each mismatch.
Where do Asana and Sage Intacct disagree on project end dates or owners?
How it works
What PopdockAI does when you ask
You narrow by name or team, or check everything, and your AI assistant reconciles the two project lists. Both systems are only read.
01
Ask
You narrow by project name or Asana team, or check everything.
02
Match
It reads projects from Asana and Sage Intacct and pairs them by exact name.
03
Compare
It checks completion, start and end dates and owner.
04
Report
You get four lists with counts, and nothing is changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Asana and one secure connection to your AI tool. No code, no exports.
asana-get-project
sage-intacct-get-project
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
One project list for delivery and finance
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
