Connectors

/

Stripe

/

Reconcile Stripe refunds and disputes with Intacct
Report
Cross-Connector

Make sure Stripe refunds reduce Sage Intacct receivables

For finance teams who want Stripe credit notes, refunds and lost disputes matched to Sage Intacct AR adjustments by their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Stripe refunds and disputes with Intacct
Have all of September's Stripe refunds and lost disputes been recorded in Sage Intacct?
5 Stripe items from September have no adjustment in Sage Intacct. - Refunds: 3 missing, including 720.00 on INV-1042 for Contoso - Credit notes: 1 missing, 300.00 for Fabrikam - Lost disputes: 1 missing, 950.00 - Inferred: 2 matched on customer, amount and date Want the missing items listed with invoice numbers?
Stripe
Sample figures. Your results come from your own account.
stripe-get-credit-note
stripe-get-refund
stripe-get-dispute
stripe-get-invoice
stripe-get-charge
sage-intacct-get-ar-adjustment
sage-intacct-get-general-ledger-detail

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Refunds that never reduced receivables

Refunds, credit notes and lost disputes in Stripe all reduce what customers owe, but each has to be recorded in Sage Intacct by hand. The ones that slip through leave receivables overstated, and tracing them back to invoices takes ages.

Without PopdockAI

  • List refunds, credit notes and lost disputes
  • Find the invoice behind each one
  • Search Intacct AR adjustments and the ledger
  • Count a refund twice when it sits behind a credit note

With PopdockAI

  • Credit notes, refunds and lost disputes are read, each counted once
  • The invoice behind each is found
  • AR adjustments are matched by invoice and amount, then customer and date
  • Missing items are reported by type, and nothing is 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:** Check that money Stripe returned to customers between {date-from} and {date-to} (if blank, today), through credit notes, refunds and lost disputes, has a matching AR adjustment or ledger entry in Sage Intacct, and report what is missing.

**Step 1: Read what Stripe gave back**

* `stripe-get-credit-note` with `created.from`, `created.to` and `status` issued
* `stripe-get-refund` with `created-date.from` and `created-date.to`; keep those whose `status` is succeeded
* `stripe-get-dispute` with `created-date.from` and `created-date.to`; keep those whose `status` is lost

A credit note that refunded money carries a `refund-id`. Count that refund once, under the credit note.

**Step 2: Find the invoice number behind each item**

* a credit note: call `stripe-get-invoice` with its `invoice-id` and take the `number`
* a refund or a dispute: call `stripe-get-charge` with its `charge-id`; if the charge has an `invoice-id`, call `stripe-get-invoice` with it and take the `number`

If this needs more than 50 lookups, do the 50 largest items by amount, and say that the rest were matched without an invoice number.

**Step 3: Read the Intacct adjustments**

Call `intacct-get-ar-adjustment` with `adjustment-date.from` set to the start date and `adjustment-date.to` 7 days after the end date.

**Step 4: Match**

1. The Intacct `reference-invoice-number` equals the Stripe invoice `number`, and the Intacct `total-amount` equals the Stripe amount, ignoring sign.
2. Otherwise, the same customer name, the same amount ignoring sign, and an `adjustment-date` within 7 days. Label these **inferred**.
3. For anything still unmatched, call `intacct-get-general-ledger-detail` with `entry-date.from` and `entry-date.to` 7 days either side of the Stripe date, and `amount.min` and `amount.max` both set to the amount, in case it was booked as a journal entry. Rows repeat per reporting method, so count each `transaction-number` once.

**Step 5: Report**

* **Missing from Intacct:** type (credit note, refund or lost dispute), Stripe ID, customer, amount, currency, date, invoice number
* **Matched:** Stripe ID, Intacct `adjustment-number` or `transaction-number`, and how it matched

End with the count and total for each type, matched against missing.

**Rules & Guidelines:**

* Tools named stripe-... are on the stripe server; tools named intacct-... are on the intacct server. Both servers must be connected. If a tool from one of them is unavailable, say which server is not connected and stop.
* Read only. Do not call `intacct-create-journal-entry`, `intacct-update-customer` or any other Intacct create or update tool.
* An open dispute is not money lost yet. Include only disputes whose `status` is lost.
* Pass `company` to Intacct tools only when the user names an Intacct company.

**Validation:**

* If Stripe has no credit notes, refunds or lost disputes in the window, say so and stop.
* Never match amounts in different currencies. Compare currency codes ignoring case.
* If the Stripe amounts are consistently 100 times the Intacct amounts, divide the Stripe amounts by 100, say that you did, and continue.

Who it's for

One answer, three teams that use it

Accounts receivable

Record what was refunded

Missing adjustments are listed by type, ready to enter in Intacct.

Have all of October's Stripe refunds and lost disputes been recorded in Sage Intacct?

Controllers

Close with accurate receivables

Refunds that never reduced receivables are found before the books close.

Which Stripe credit notes from last quarter have no AR adjustment in Sage Intacct?

Revenue accountants

Trust inferred matches less

Matches by customer, amount and date are labelled inferred, so you know which to check.

Show inferred matches between Stripe refunds and Sage Intacct adjustments this month.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant checks every Stripe refund and lost dispute against Sage Intacct. It only reads and leaves open disputes out because no money is lost yet.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads credit notes, successful refunds and lost disputes and finds the invoice behind each.

stripe-get-credit-note
stripe-get-refund
stripe-get-dispute
stripe-get-invoice
stripe-get-charge

03

Match

It matches Intacct AR adjustments by invoice and amount, then by customer and date.

sage-intacct-get-ar-adjustment
sage-intacct-get-general-ledger-detail

04

Report

You get what is missing by type, read-only.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

stripe-get-credit-note

Returns credit notes (number, customer, invoice, reason, amount, status) from Stripe.
get-data

stripe-get-refund

Returns refunds (charge, customer, amount, reason, status) from Stripe.
get-data

stripe-get-dispute

Returns disputes (charge, amount, reason, status, evidence due date) from Stripe.
get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
get-data

sage-intacct-get-ar-adjustment

Returns AR adjustments from Sage Intacct. The record-number links to the Get AR adjustment lines tool.
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.
Read only.Nothing in Stripe 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

An AR balance that matches money returned

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