/
/
Compare TickTick focus time with Business Central timesheets
For operations teams who want timesheet hours checked against TickTick focus time, just by asking their AI assistant.
On this page
Connector
Connect TickTick, pick your AI tool and paste the prompt.
The problem
Logged hours and real focus time rarely line up
Comparing timesheet hours with real focused work means exporting from Business Central and TickTick and lining up days by hand. Unlogged or over-logged time is easy to miss.
Without PopdockAI
- Export the resource's timesheet from Business Central
- Export focus sessions from TickTick
- Total both per day in a spreadsheet
- Miss days that appear on only one side
With PopdockAI
- Timesheet rows are read for the resource and dates
- Focus hours are totalled per day with the top tasks named
- Days with only one side are listed
- Differences are review prompts, and nothing is written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For resource `{resource-number}` in company `{company}`, compare focus time recorded in TickTick with timesheet time in Business Central between `{date-from}` and `{date-to}`.
**Step 1: Timesheet side (Business Central)**
Call `business-central-get-timesheet` with `company` set to `{company}`, `resource-number` set to `{resource-number}`, `date.from` set to `{date-from}` and `date.to` set to `{date-to}`. Keep the date, hours or quantity, status and job-number of each row. If nothing comes back, note that no timesheet exists for the period and continue.
**Step 2: Focus side (TickTick)**
Call `ticktick-get-focuses` with `start-time.from` set to `{date-from}` and `start-time.to` set to `{date-to}`. Sum duration-seconds per calendar day and convert to hours. Note the task titles that account for the most time.
**Step 3: Report**
A day-by-day table: date, TickTick focus hours, timesheet hours, difference. Then totals, the days with focus time but no timesheet entry, the days with timesheet hours but no focus time, and the timesheet status (open, submitted, approved, posted).
**Rules & Guidelines:**
* `business-central-get-timesheet` is on the business-central server. `ticktick-get-focuses` is on the TickTick server.
* This prompt is read-only. Never call `ticktick-add-focus-session`, `ticktick-delete-focus-session` or any Business Central create or update tool.
**Validation:**
* Focus sessions belong to the connected TickTick account; confirm with the user that it is the same person as the resource, and state the assumption in the report.
* Focus time and billable hours are not the same thing; say that differences are a prompt for review, not an error.Who it's for
One answer, three teams that use it
Consultants
Check your timesheet against your focus time
See which days you worked but did not log, before you submit your Business Central timesheet.
Compare my TickTick focus time with my Business Central timesheet for resource R-0010 this week.
Resource managers
Review a timesheet with evidence
Differences per day give you something specific to ask about, rather than questioning the whole timesheet.
Show focus hours against timesheet hours for resource R-0042 in CRONUS for October.
Operations analysts
Find days with time on one side only
Days with focus time but no timesheet, or the other way round, are listed for follow up.
Which days between 1 and 30 September have TickTick focus time but no Business Central timesheet hours for R-0007?
How it works
What PopdockAI does when you ask
You give the company, resource number and dates, and your AI assistant puts timesheet hours and focus time side by side. It asks you to confirm the TickTick account is the same person and writes nothing.
01
Ask
You give the company, resource number and date range.
02
Read timesheets
It reads the resource's Business Central timesheet rows.
03
Read focus
It totals TickTick focus hours per day and names the top tasks.
04
Report
You get a day by day table and the days with only one side.
What PopdockAI provides
The tools behind the answer
Ready made tools for TickTick and one secure connection to your AI tool. No code, no exports.
ticktick-get-focuses
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
Unlogged and over-logged days in one table
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)
