/
/
Explain a customer's Salesforce balance with every document tied out
For finance teams answering a customer balance question who want invoices, payments, credits and refunds tied out, by asking their AI assistant.
On this page
Connector
Connect Salesforce, pick your AI tool and paste the prompt.
The problem
A disputed balance means hours of tying out documents
When a customer questions their balance, the invoices, payments, credit memos and refunds in Salesforce have to be tied out by hand. Unapplied amounts, oversized refunds and overdue invoices on auto-pay accounts hide in long lists.
Without PopdockAI
- Export invoices, payments, credits and refunds separately
- Total each in a spreadsheet
- Hunt for unapplied payments and credits
- Miss the overdue invoice on an auto-pay account
With PopdockAI
- Every billing document for the period is gathered for you
- Invoiced, paid, credited and refunded amounts are totalled
- Unapplied amounts and other mismatches are flagged
- Read only, with amounts used exactly as returned
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile billing for account `{account-name}` over the last `{lookback-days}` days (default 365).
**Step 1: Resolve the account**
Call `salesforce-get-account` with `name` set to `{account-name}`. If nothing matches, retry with `name.contains`. If more than one account matches, list them (name, billing city, owner, account ID) and stop. Use the returned account-id for every later call.
**Step 2: Gather, by account-id, dated within the window**
* `salesforce-get-invoice` with `invoice-date.from`.
* `salesforce-get-payment` with `date.from`.
* `salesforce-get-credit-memo` with `credit-date.from`.
* `salesforce-get-refund` with `date.from`.
* `salesforce-get-payment-method`: the payment methods on file and whether auto-pay is on.
**Step 3: Tie out**
* Invoiced total, paid total, credited total, refunded total.
* Open invoice balance against the sum of unapplied payments and unapplied credits.
* Flags: payments with unapplied amounts, credit memos with unapplied balance, refunds larger than the matching payment, overdue invoices on an account with auto-pay on, no active payment method.
**Step 4: Report**
A totals table, then a table of every flagged document (type, number, date, amount, balance, flag), then a one-paragraph conclusion.
**Rules & Guidelines:**
* This prompt is read-only. Do not call any write tool: `salesforce-add-account`, `salesforce-add-contact`, `salesforce-add-lead`, `salesforce-add-opportunity`, `salesforce-add-case`, `salesforce-add-task`, `salesforce-add-asset`, `salesforce-add-campaign`, `salesforce-update-account`, `salesforce-update-contact`, `salesforce-update-lead`, `salesforce-update-opportunity`, `salesforce-update-case`, `salesforce-update-task` or `salesforce-update-asset`.
* Use the amounts as returned; do not recompute tax.
**Validation:**
* If no billing documents exist in the window, say so and stop.Who it's for
One answer, three teams that use it
Accounts receivable
Answer balance questions with confidence
Tie out a customer's invoices, payments and credits in one pass when they question what they owe.
Why does Fabrikam's balance in Salesforce look wrong? Reconcile their billing for the last 6 months.
Billing specialists
Find unapplied payments and credits
See payments and credits that were never applied, and refunds bigger than the payment behind them.
Reconcile Northwind Traders billing in Salesforce since January and list anything unapplied.
Account managers
Prepare for a billing conversation
Know exactly where the customer's balance comes from before you get on the phone.
Give me a billing tie out for Contoso Ltd over the last 90 days, including payment methods on file.
How it works
What PopdockAI does when you ask
You name the account and a period, and your AI assistant ties out its billing documents in Salesforce. It reports the mismatches and changes nothing.
01
Ask
You name the account, and optionally a lookback window.
02
Gather
It reads invoices, payments, credit memos, refunds and payment methods for the period.
03
Tie out
It totals each and sets the open balance against unapplied payments and credits.
04
Report
You get totals, flagged documents and a conclusion, with nothing changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.
salesforce-get-account
salesforce-get-invoice
salesforce-get-payment
salesforce-get-credit-memo
salesforce-get-refund
salesforce-get-payment-method
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
Explain any balance with every document accounted for
Related use cases
More ways to put this data to work
Salesforce overdue invoices report
Ask your AI for a Salesforce overdue invoices report and it ages past-due balances, checks top accounts for unapplied credit, payments and open cases, and builds a chase list.
Learn More
Salesforce account 360 review
Ask your AI for a Salesforce account 360 review and it gathers contacts, pipeline, cases, unpaid invoices, contracts, orders and activity onto one page with watch-outs.
Learn More
Add Salesforce campaign members to a Constant Contact list
Ask your AI to add Salesforce campaign members to a Constant Contact list and it adds only the new people after you confirm, excludes unsubscribes and leaves consent unset unless you say otherwise.
Learn More
Add Salesforce campaign members to a Drip campaign
Ask your AI to add Salesforce campaign members to a Drip campaign and it skips existing and unsubscribed people, flags a paused campaign or double opt-in, and adds people only after you confirm.
Learn More
Add Salesforce campaign members to a Mailchimp audience
Ask your AI to add Salesforce campaign members to a Mailchimp audience and it adds new people as pending for double opt-in, skips anyone already there, and writes only after you confirm.
Learn More
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.