/
/
Summarize a month of Geotab billing by plan and database
For finance teams who reconcile Geotab MyAdmin billing and want the monthly totals without exporting three reports.
On this page
Connector
Connect Geotab MyAdmin, pick your AI tool and paste the prompt.
The problem
Closing a month of Geotab billing takes three exports
Closing a month of Geotab billing means exporting charges, credits and termination fees, then pivoting by plan and database. Totals get mixed across currencies and a partial export is easy to mistake for the whole month.
Without PopdockAI
- Export charges, credits and fees separately
- Pivot them by rate plan and database
- Keep currencies apart by hand
- Miss that an export was partial
With PopdockAI
- Charges, credits and termination fees are read for the period
- Totals and net are reported per currency
- Breakdowns by rate plan and database come with the largest charges
- Partial totals are flagged, 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.
**Objective:** Summarize device billing for month {month} of year {year} (both default to the current period when blank), optionally limited to database {database}.
**Step 1: Charges**
Call `geotab-myadmin-get-device-contract-transaction` with month = {month}, year = {year} and, if given, database = {database}. Use a max-records high enough to cover the month (for example 1000); if the result hits that cap, say the totals are partial.
**Step 2: Credits and termination fees**
* Call `geotab-myadmin-get-device-contract-credit-transaction` with the same month and year.
* Call `geotab-myadmin-get-device-contract-early-termination-fee` with the same month and year.
**Step 3: Report**
* Totals: charges, credits, early termination fees and net, in local currency and USD where available.
* A table of charges by rate plan: device count, total value.
* If no database filter was given, a table of charges by database.
* The 10 largest single charges.
**Rules & Guidelines:**
* This is a read-only job. Do NOT call any write tool: no `geotab-myadmin-change-device-billing-plan`, `geotab-myadmin-terminate-device-billing`, `geotab-myadmin-share-device`, `geotab-myadmin-update-device-contracts`, `geotab-myadmin-enroll-device-from-add-in`, `geotab-myadmin-unenroll-device-from-add-in` or any other action tool.
* Do not mix currencies in one total; group by currency if there is more than one.
**Validation:**
* If all three reads return nothing, say there is no billing for the period and stop.Who it's for
One answer, three teams that use it
Finance managers
Close the month faster
Charges, credits, fees and net per currency in one summary, ready for review.
Summarise Geotab billing for October 2026 with the net per currency.
Billing analysts
See where the money went
Breakdowns by rate plan and database show which plans and customers drive the bill.
Break down this month's Geotab charges by database and list the ten largest.
Reseller operations
Review one customer's billing
Limit the summary to one database to review a single customer's month.
Summarise Geotab billing for the contoso_fleet database for September 2026.
How it works
What PopdockAI does when you ask
You name a month and optionally a database, and your AI assistant summarises the billing. Currencies are never added together.
01
Ask
You name the month, year and optionally a database.
02
Pull
It reads charges, credits and early termination fees for the period.
03
Total
It totals by currency, rate plan and database.
04
Report
You get the net, the breakdowns and the largest charges.
What PopdockAI provides
The tools behind the answer
Ready made tools for Geotab MyAdmin and one secure connection to your AI tool. No code, no exports.
geotab-myadmin-get-device-contract-transaction
geotab-myadmin-get-device-contract-credit-transaction
geotab-myadmin-get-device-contract-early-termination-fee
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
A month of billing summarised without spreadsheets
Related use cases
More ways to put this data to work
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.

.webp)
