Connectors

/

Sage Intacct

/

Explain Intacct GL account activity
Report

Explain what moved a Sage Intacct GL account

For accountants who need to explain a surprising account balance, with the entries worth a second look, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Explain Intacct GL account activity
Why did GL account 6400 Professional fees jump in September 2026 in Intacct?
6400 Professional fees rose 22,300 USD in September, up 140 percent on August, mostly from Contoso Consulting. - Driver: Contoso Consulting bills, 15,800 USD - Manual: JE-3307, a 6,000 USD accrual that reverses on 2026-10-01, so it is temporary - Worth checking: two 2,450 USD entries on the same day from Fabrikam Legal Want the movement table for both periods?
Sage Intacct
Sample figures. Your results come from your own account.
sage-intacct-get-account
sage-intacct-get-general-ledger-detail
sage-intacct-get-journal-entry
sage-intacct-get-journal-entry-line
sage-intacct-get-bill
sage-intacct-get-invoice

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Sage Intacct

Sage Intacct
Run it on your own Sage Intacct data.

Connect Sage Intacct, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

A surprising account balance and no quick way to explain it

When a GL account moves more than expected, working out why means scrolling ledger detail in Sage Intacct, grouping it in a spreadsheet and comparing with last period. Manual entries, reversing accruals and duplicates are easy to miss.

Without PopdockAI

  • Scroll the ledger detail for the account
  • Group entries by vendor or journal in a spreadsheet
  • Compare with last period by hand
  • Miss the manual entry or reversing accrual

With PopdockAI

  • Ledger detail read for the period and the one before
  • Movement broken down by journal, counterparty, department and project
  • Manual entries traced to the other side, source documents pulled
  • Reversing accruals called out as temporary, nothing changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Explain what moved GL account `{account}` between {start-date} and {end-date} (defaults: the first day of the current month to today): what drove it, how it compares with the prior period, and which entries deserve a second look.

**Step 1: Identify the account**

If the account was given as a number, call `intacct-get-account` with `account-number`. Otherwise call it with `title.contains`. If several accounts match, list them and stop. Note `normal-balance`, `account-type`, `category` and `disallow-direct-posting`.

**Step 2: Pull the activity**

Call `intacct-get-general-ledger-detail` with `account-number`, `entry-date.from`, `entry-date.to` and `reporting-method` (accrual unless the user says otherwise; rows repeat per method, so never mix them). Then make the same call for the period of equal length immediately before.

Net movement = `debit-amount` minus `credit-amount`, with the sign flipped for credit-balance accounts.

**Step 3: Break it down**

* By `journal`, to separate subledger postings (AP, AR, cash) from manual entries.
* By `vendor-name` or `customer-name`, then by `department-name` and `project-name`.
* The ten largest rows by amount.
* Against the prior period: counterparties that are new, those that grew most, and those that disappeared.

**Step 4: Trace the notable entries**

* For a manual entry, call `intacct-get-journal-entry` with its `transaction-number` for `description`, `created-date`, `state`, `automatic-reversal-date` and `reversed-from`. Then call `intacct-get-journal-entry-line` with the same `transaction-number` to see the other side of the entry.
* An entry with an `automatic-reversal-date` is an accrual that reverses next period. Say that part of the movement is temporary.
* Where `document-number` looks like a bill or invoice number, call `intacct-get-bill` with `bill-number` or `intacct-get-invoice` with `invoice-number` for the source document.

**Step 5: Report**

1. A one-sentence headline: the net movement, the change against the prior period, and the main driver.
2. Movement table for this period and the prior one: debits, credits, net, row count.
3. Drivers, largest first, with amount and share of the movement.
4. Entries worth a second look, with transaction numbers and why: manual entries to an account where `disallow-direct-posting` is true, same-amount entries that look duplicated, large manual entries at period end with no reversal, and anything far out of line with the prior period.

**Rules & Guidelines:**

* This prompt is read-only. Do not call `intacct-create-journal-entry`, `intacct-update-journal-entry`, `intacct-update-account` or any other create or update tool.
* Call entries "worth checking", never "errors". The ledger does not record intent.
* Pass dates as YYYY-MM-DD. If the user names an Intacct company, pass it as `company` on every call.

**Validation:**

* If the account is not found, try `title.contains` once with a shorter part of the name, then stop.
* If there is no activity in the period, say so, give the prior period's net for context, and stop.
* If a GL call returns exactly `max-records` rows, say the totals are incomplete and suggest a shorter range.

Who it's for

One answer, three teams that use it

Controllers

Answer why an account moved

Get the drivers and the entries worth a second look without building a pivot table.

Why did travel expense in Intacct double in October compared with September?

FP&A analysts

Explain variances to budget owners

The movement is broken down by department and project, so you can explain it to the right owner.

Break down the movement in GL 6100 Software for Q3 by department and vendor.

Staff accountants

Find entries to review before close

Manual entries and possible duplicates are listed with their journal and source.

Show manual entries that hit accrued liabilities in Intacct in September and what they offset.

How it works

What PopdockAI does when you ask

You name the account and a date range and your AI assistant explains what moved it in Sage Intacct. Entries are presented as worth checking, never as errors, and nothing is changed.

01

Ask

You name the account and a date range.

Your AI tool

02

Read

It reads the ledger detail for the period and the one before it.

sage-intacct-get-account
sage-intacct-get-general-ledger-detail

03

Trace

It breaks the movement down and traces manual entries and source bills or invoices.

sage-intacct-get-journal-entry
sage-intacct-get-journal-entry-line
sage-intacct-get-bill
sage-intacct-get-invoice

04

Report

You get a headline, the drivers and the entries worth a second look, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Sage Intacct and one secure connection to your AI tool. No code, no exports.

get-data

sage-intacct-get-account

Returns accounts from Sage Intacct. One row per general ledger account.
get-data

sage-intacct-get-general-ledger-detail

Returns general ledger details from Sage Intacct. One row per posted GL entry. Rows repeat per reporting method (for example accrual and cash), so filter by reporting method before totalling.
get-data

sage-intacct-get-journal-entry

Returns journal entries from Sage Intacct. The transaction-number links to the Get journal entry lines tool.
get-data

sage-intacct-get-journal-entry-line

Returns journal entry lines from Sage Intacct. Filter by transaction number (from Get journal entries) to get one journal entry's lines.
get-data

sage-intacct-get-bill

Returns bills from Sage Intacct. The record-number links to the Get bill lines tool.
get-data

sage-intacct-get-invoice

Returns invoices from Sage Intacct. The record-number links to the Get invoice entries tool.
Read only.Nothing in Sage Intacct Changes

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.

How Popdock AI secures your data

The outcome

Explain any account movement in one read

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation