Connectors

/

Shopify

/

Match Shopify payments to Intacct deposits
Report
Cross-Connector

Line up Shopify takings with Sage Intacct deposits

For finance teams who want daily Shopify payments matched to bank deposits in Sage Intacct, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Shopify payments to Intacct deposits
Match Shopify payments from September to our deposits in Sage Intacct.
This is a date and amount match to check, not proof. - Matched: 26 of 30 days, small gaps labelled as likely fees - Mismatch: 14 September, 4,210.00 collected, 3,480.00 deposited - No deposit: 28 and 29 September - Unpaired deposit: DEP-0912 for 1,150.00 Want the day by day table?
Shopify
Sample figures. Your results come from your own account.
shopify-get-transaction
sage-intacct-get-deposit
sage-intacct-get-deposit-line
sage-intacct-get-other-receipt

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

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

Try PopdockAI free

The problem

Missing payouts hide among normal fee gaps

Money collected in Shopify reaches the bank days later, net of fees, so lining up takings with Sage Intacct deposits is guesswork in a spreadsheet. A payout that never arrived, or arrived short, can hide among normal fee gaps.

Without PopdockAI

  • Export Shopify transactions and total them by day
  • Export Sage Intacct deposits for the following week
  • Match by date and amount in a spreadsheet
  • Miss a short payout that looks like fees

With PopdockAI

  • Successful sales, captures and refunds are totalled by day
  • Each day is paired with deposits up to five days later
  • Small gaps are labelled likely fees and larger ones mismatches
  • It says this is a match to check, not proof, and changes nothing

The prompt

Use this prompt

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

Prompt
**Objective:** For `{from-date}` to `{to-date}` (default today), total Shopify's collected payments by day, optionally for gateway `{gateway}`, and line them up with Intacct deposits to find money that was collected but never deposited, or deposited with a different amount.

**Step 1: Read the Shopify transactions**

Call `shopify-get-transaction` with `processed-at.from` = `{from-date}`, `processed-at.to` = `{to-date}` and, if set, `gateway` = `{gateway}`. Use the `kind` and `status` values the tool's schema lists; keep successful sale and capture transactions as money in, and successful refund transactions as money out. Ignore authorizations, voids and failed transactions.

Group by `processed-at` date (and by `gateway` if no gateway was given) and compute gross in, refunds, and net.

**Step 2: Read the Intacct deposits**

Call `intacct-get-deposit` with `deposit-date.from` = `{from-date}` and `deposit-date.to` = 5 days after `{to-date}` (payouts land days after the sale). Keep `deposit-id`, `deposit-date`, `bank-account`, `description` and `total-base-amount`. For a deposit whose description does not identify its source, call `intacct-get-deposit-line` with `deposit-record-number` = its `record-number` and read the line descriptions and customer names.

**Step 3: Match**

Match each Shopify day (or group of consecutive days) to a deposit whose amount is within 5 percent of the net, within 5 days after the sale date. Payment processors deduct fees before paying out, so the deposit is normally slightly below the net; report the gap as "likely fees" when it is under 5 percent, and as a mismatch above that.

**Step 4: Report**

A table by Shopify day: date, gateway, gross, refunds, net, matched deposit id and date, deposit amount, gap. Then list unmatched Shopify days and unmatched deposits that look like payment processor payouts. End with period totals for both sides.

**Rules & Guidelines:**

* `shopify-get-transaction` is on the shopify server. `intacct-get-deposit` and `intacct-get-deposit-line` are on the intacct server.
* This prompt is read-only. Do NOT call `intacct-create-journal-entry` or any other create or update tool on either server.
* This is a heuristic match on dates and amounts. Say so at the top of the report, and never describe a match as confirmed.

**Validation:**

* If Shopify returns no successful transactions, report the range and gateway and stop.
* If Intacct has no deposits in the range, say that deposits may be recorded in a different bank account, entity or as other receipts, and suggest checking `intacct-get-other-receipt` for the same dates.
* If the Shopify `currency` differs from the deposit currency, report those days separately without matching them.

Who it's for

One answer, three teams that use it

Cash accountants

Match takings to deposits quickly

Daily totals are lined up with deposits for you, so the bank reconciliation starts from a short exception list.

Match Shopify payments from 1 to 31 October to deposits in Sage Intacct.

Controllers

Find payouts that never arrived

Days with no matching deposit stand out, so you can chase the processor before the month closes.

Which Shopify collection days in September have no matching Sage Intacct deposit?

Finance managers

Separate fees from real shortfalls

Gaps are labelled as likely fees or mismatches, so you know which differences need a closer look.

Match last week's Shopify Payments takings to Intacct deposits and show anything that is more than fees.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant lines up daily Shopify takings with Sage Intacct deposits. It only reads and lists days and deposits with no partner.

01

Ask

You give a date range and optionally a payment gateway.

Your AI tool

02

Total

It totals successful Shopify sales, captures and refunds by day.

shopify-get-transaction

03

Match

It pairs each day with Sage Intacct deposits up to five days later.

sage-intacct-get-deposit
sage-intacct-get-deposit-line
sage-intacct-get-other-receipt

04

Report

You get matches, likely fees, mismatches and unpaired days and deposits.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

shopify-get-transaction

Returns the payment transactions on Shopify orders, such as authorizations, sales, captures and refunds, with gateway and status. Filter by order, customer, kind, status, gateway, amount and processed date.
get-data

sage-intacct-get-deposit

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

sage-intacct-get-deposit-line

Returns deposit lines from Sage Intacct. Filter by deposit record number (the record-number from Get deposits) to get one deposit's lines.
get-data

sage-intacct-get-other-receipt

Returns other receipts from Sage Intacct. The record-number links to the Get other receipt lines tool.
Read only.Nothing in Shopify 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

Missing payouts chased while they are recent

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