/
/
Flag the Rillet journal entries that deserve a second look
For controllers who want Rillet journal entries in a period checked for imbalances, inactive accounts, manual round amounts and weekend posting.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Risky journal entries hide among hundreds of lines
Reviewing journal entries means scanning for entries that do not balance, inactive accounts, manual postings with no source and reversals that never happened. Done by eye across hundreds of lines, the risky ones slip past before close.
Without PopdockAI
- Export journal entries and lines for the period
- Check each journal balances per currency
- Look up accounts for inactive ones
- Scan by eye for manual and unusual postings
With PopdockAI
- Journals, lines and the chart of accounts read together
- Each journal tested for imbalance and account problems
- Review signals like large round manual amounts flagged
- Errors first, worded as reasons to look, nothing fixed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Audit the journal entries dated between `{from-date}` and `{to-date}`, optionally only those touching the account `{account-code}` (default all accounts), and list the ones that break a rule or deserve review.
**Step 1: Pull the entries**
* `rillet-get-journal-entries` and `rillet-get-journal-entry-lines` take no filters. Keep rows whose `date` is in the period.
* If `{account-code}` is set, keep only journals that have at least one line on that account, but keep all of those journals' lines.
* Call `rillet-get-accounts` for the chart of accounts.
**Step 2: Check each journal**
* Unbalanced: debit lines and credit lines (by `side`) do not total the same per currency.
* Bad account: a line's `account-code` is not in the chart, or the account's `status` is not active.
* Manual: no `related-entity-type`, so it was not generated by a bill, invoice or other record. These are the entries to review first.
* Reversal overdue: `reversal-date` is before today but no reversing entry with the same name is visible.
* Round and large: a manual line that is a round number and among the ten largest in the period.
* Posted on a weekend.
**Step 3: Report**
* A counts table: journals checked, and how many failed each check.
* For each flagged journal: name, date, the checks it failed, its lines (account code and name, side, amount), and the `journal-id`.
* Unbalanced and bad-account findings first; they are errors. The rest are for review.
**Rules & Guidelines:**
* This is read-only. Do not call any tool whose name starts with rillet-add-, rillet-update-, rillet-apply-, rillet-unapply-, rillet-record-, rillet-set- or rillet-setup-. In particular do not call `rillet-update-journal-entry` or `rillet-add-journal-entry`, even to fix what you find.
* A flag is a reason to look, not proof of an error. Word it that way.
**Validation:**
* If no entries fall in the period, say so and stop.Who it's for
One answer, three teams that use it
Controllers
Focus the close review
Counts per check and each flagged journal with its lines, errors first.
Audit Rillet journal entries for October and list any that do not balance.
Internal auditors
Test journals against clear rules
Manual entries, weekend postings and overdue reversals are flagged for a second look.
Flag manual Rillet journals posted on weekends or with large round amounts this quarter.
Staff accountants
Check one account before close
Limit the audit to one account to clean it up before the books lock.
Check September journal entries hitting the accrued expenses account in Rillet.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant checks every Rillet journal against clear rules. Flags are reasons to look, not proof of error, and nothing is posted.
01
Ask
You give a date range, and optionally one account.
02
Read
It reads journal entries, lines and the chart of accounts.
03
Check
It tests each journal for imbalance, account problems and review signals.
04
Report
You get counts per check and each flagged journal, errors first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-journal-entries
rillet-get-journal-entry-lines
rillet-get-accounts
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
Review the entries that need it before close
Related use cases
More ways to put this data to work
Add missing Rillet customers to a Constant Contact list
Ask your AI to add missing Rillet customers to a Constant Contact list and it adds only addresses not already there, after you confirm consent.
Learn More
Add missing Rillet customers to a Mailchimp audience
Ask your AI to add missing Rillet customers to a Mailchimp audience and it adds only new addresses as pending after you confirm, checking each one.
Learn More
Add missing Rillet customers to Drip
Ask your AI to add missing Rillet customers to Drip and it creates tagged subscribers only for emails Drip has never seen, after you confirm.
Learn More
Add renewing Rillet customers to a Mailchimp segment
Ask your AI to add renewing Rillet customers to a Mailchimp segment and it adds only subscribed contacts not already in it, after you confirm.
Learn More
Attribute Rillet revenue to a Constant Contact campaign
Ask your AI what revenue followed a Constant Contact campaign and it matches clickers to Rillet customers and totals invoices and contracts in the window.
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.