Tutorial Hub / Finance AI Assistant / Sample Tasks
O

Sample Finance Tasks — Day-to-Day Operations

Twelve copy-paste tasks for the finance team, ready to adapt. Each task follows the same pattern — Prepare the files, Prompt with the ready-made text, Check the output before you trust it.

Sample Finance Tasks — Day-to-Day Operations

Twelve copy-paste tasks for the finance team, ready to adapt. Each task follows the same pattern — Prepare the files, Prompt with the ready-made text, Check the output before you trust it.

The patternHow these tasks work

Each task below follows the same pattern: Prepare (get the files into your task folder) → Prompt (copy-paste, adjust file names) → Check (what to verify before you trust the output).

1 · PREPARE get the files into your task folder 2 · PROMPT copy-paste, adjust the file names 3 · CHECK verify before you trust the output copy files in, then start Claude Code here run the prompt, then check one task = one folder — repeat for the next task Every task follows the same three steps
The task pattern: Prepare → Prompt → Check, then repeat for the next task.
TIPClaude Code reads files inside the folder you launched it from. Copy files in, then start claude there.
WARNFor .xlsx files, ask Claude to write a Python script to read them (see setup guide, Part 3).

At a glanceThe 12 tasks — grouped into three lanes

The tasks fall into three groups: Analysis & Reporting, Reconciliation & Control, and Drafting & Review. The numbers are the task numbers used throughout this page.

Analysis & Reporting · 4 tasks Reconciliation & Control · 4 tasks Drafting & Review · 4 tasks 1 · Daily cash position opening, inflows, outflows, closing 4 · Expense variance vs budget top 5 variances, 15% flags 5 · AR aging & follow-ups buckets, top debtors, emails 7 · Payroll summary review totals, CPF, changes over 20% 2 · Bank reconciliation ledger vs statement differences 3 · Supplier invoice checks extract, verify GST at 9% 6 · GST return checks output tax vs input tax 8 · Inter-company balances due to vs due from, all pairs 9 · Mgmt commentary draft highlights, margins, questions 10 · Fixed asset register depreciation & disposal flags 11 · Audit schedule tracker areas, owners, status 12 · FX revaluation check balance × month-end rate
The 12 tasks at a glance, grouped into three lanes.

Quick reference — task number, what it does, and what you get back:

#TaskWhat you get
1Daily Cash Position Summarycash-summary-<date>.md with category breakdown and flags
2Bank Reconciliation — Exception ReviewException table, grouped into timing differences vs potential errors
3Supplier Invoice Data Extraction & VerificationPer-invoice tables plus one combined summary, with GST 9% flags
4Expense Categorisation & Variance Analysisvariance-analysis-<period>.md with top-5 variances and 15% flags
5AR Aging — Analysis & Collection Follow-up Listar-followups.md with aging buckets, top debtors and draft emails
6GST (9%) Return — Preparation Checksgst-check-<period>.md with output vs input tax and line-item checks
7Monthly Payroll Summary Reviewpayroll-summary-<month>.md with totals, departments and flags
8Inter-Company Balance ReconciliationReconciliation table per pair plus total unmatched summary
9Monthly Management Accounts — Draft Commentarymanagement-commentary-<month>.md (max 1.5 pages)
10Fixed Asset Register — Depreciation & Disposal CheckReview table listing only the flagged assets
11Audit Schedule — Supporting Document Trackeraudit-schedule.md pre-filled with status "Not started"
12Foreign Exchange & Currency Revaluation CheckRevaluation table with original, rate, revalued amount and gain/loss

Lane 1 · Tasks 1, 4, 5, 7Analysis & Reporting

Turn raw data into summaries and analyses you can act on.

1Daily Cash Position Summary

Prepare

Export today's bank statements (or cash movement sheet) as CSV into the folder.

PROMPT — copy & paste
Read bank.csv and produce a cash position summary for today:
- opening balance, total inflows, total outflows, closing balance
- a breakdown of inflows/outflows by category (sales, suppliers, payroll, tax, other)
- flag any single transaction above $10,000 or any unusual category
Save the result as cash-summary-<date>.md
CHECKClosing balance matches the bank statement exactly; categories make sense.

4Expense Categorisation & Variance Analysis (Budget vs Actual)

Prepare

Export actuals (CSV) and the budget (CSV) into the folder.

PROMPT — copy & paste
Compare actuals.csv with budget.csv for this month. Produce:
- a table: category | actual | budget | variance $ | variance %
- list the top 5 variances (largest absolute) with a likely reason for each
- flag any category more than 15% over budget
Save as variance-analysis-<period>.md
CHECKFigures match the source reports; explanations are plausible — rewrite any you disagree with before sharing.

5AR Aging — Analysis & Collection Follow-up List

Prepare

Export the AR aging report (CSV) into the folder.

PROMPT — copy & paste
Read ar-aging.csv. Summarise receivables by bucket (current, 1-30, 31-60, 61-90,
90+ days) and by customer. List the top 10 debtors by total outstanding, with the
oldest invoice date. Draft a short, professional follow-up email for each of the
top 5 overdue debtors (90+ days) — polite but firm, mentioning invoice numbers and
amounts. Save the emails to ar-followups.md
CHECKAmounts match the ERP aging report; emails are factual (only include amounts actually overdue).

7Monthly Payroll Summary Review

Prepare

Export the payroll register (CSV) into the folder.

PROMPT — copy & paste
Read payroll-<month>.csv. Produce:
- total gross pay, total CPF contributions, total net pay, headcount
- by department: headcount, gross pay total, average pay
- flag any employee whose pay changed by more than 20% vs the previous month
- list employees with no CPF contribution (flag for review)
Save as payroll-summary-<month>.md
CHECKHeadcount and totals match the HR system; follow up on flagged employees.

Lane 2 · Tasks 2, 3, 6, 8Reconciliation & Control

Compare two sources of truth and surface every difference before it becomes a problem.

2Bank Reconciliation — Exception Review

Prepare

Export the ledger extract (CSV) and the bank statement (CSV) into the folder.

PROMPT — copy & paste
Compare ledger.csv with bank-statement.csv and list all differences:
- amounts in ledger but not in the bank statement (and vice versa)
- date mismatches for the same amount
- duplicates (same amount twice in ledger)
Group them into: timing differences vs. potential errors. Show as a table.
CHECKEvery line in the exception list is real — follow up on anything you can't explain.

3Supplier Invoice Data Extraction & Verification

Prepare

Drop invoice PDFs / Excel extracts into the folder.

PROMPT — copy & paste
Extract from each invoice file: supplier, invoice number, date, amount (excl. GST),
GST amount (9%), total, and PO number if present. Output one table per invoice,
then one combined summary table. Flag any invoice where GST is not 9% of the
net amount, or where the total doesn't add up.
CHECKSpot-check 2–3 invoices against the raw files. GST = 9% since Jan 2024.

6GST (9%) Return — Preparation Checks

Prepare

Export the sales summary and purchase summary (CSV) for the period.

PROMPT — copy & paste
Using sales.csv and purchases.csv, compute for the period:
- output tax (9% of taxable sales), input tax (9% of taxable purchases)
- GST payable/receivable = output − input
- list all line items where the GST amount is not exactly 9% of the net amount
- flag any zero-rated/exempt items that appear in the taxable lists
Save as gst-check-<period>.md
CHECKTotals reconcile with your accounting system before the return is filed.

8Inter-Company Balance Reconciliation

Prepare

Export each entity's inter-company ledger (CSV) — e.g. entity A's "due to B" and entity B's "due from A" — into the folder.

PROMPT — copy & paste
Compare the inter-company ledgers of entities A, B, C and D. For each pair,
match "due to" against the counterparty's "due from" and report:
- matched amounts
- unmatched amounts with the difference
- any amount that appears on only one side (potential error or unrecorded entry)
Output a reconciliation table per pair, and a summary of total unmatched amounts.
CHECKUnmatched items get cleared before consolidation — this is the source of most consolidation adjustments.

Lane 3 · Tasks 9, 10, 11, 12Drafting & Review

Draft documents and reviews, with checks before you share them.

9Monthly Management Accounts — Draft Commentary

Prepare

P&L (current month + YTD), balance sheet, and last-year comparatives (CSV).

PROMPT — copy & paste
Based on the attached P&L, balance sheet and prior-year data, draft a management
commentary (max 1.5 pages) with:
- key highlights and lowlights vs last month and vs last year
- margin analysis (gross margin, operating margin) with drivers
- balance sheet commentary: cash, receivables, payables, borrowings
- 2-3 questions management should ask, and recommended focus for next month
Use plain language; cite the figure you are commenting on in brackets.
Save as management-commentary-<month>.md
CHECKEvery cited figure matches the reports; tone is factual, not promotional.

10Fixed Asset Register — Depreciation & Disposal Check

Prepare

Export the fixed asset register (CSV) with cost, date, depreciation rate.

PROMPT — copy & paste
Read fa-register.csv. For each asset, verify the monthly depreciation is consistent
with its cost and rate. Flag:
- assets with zero net book value still listed as active
- assets fully depreciated but still in use (list — these may need review)
- any asset missing a cost, date or rate
Output a clean review table with only the flagged assets.
CHECKFollow up flagged assets with the asset owners before the year-end close.

11Audit Schedule — Supporting Document Tracker

Prepare

Create an empty folder; copy the audit checklist (or list of areas) in.

PROMPT — copy & paste
Based on this audit checklist, build an audit schedule markdown table:
Area | Working paper name | Supporting docs needed | Owner | Status | Notes.
Pre-fill status "Not started" for every row and save as audit-schedule.md
CHECKAll audit areas from the checklist are covered; add owners before sharing.

12Foreign Exchange & Currency Revaluation Check

Prepare

Export foreign-currency balances (CSV) and the month-end exchange rates.

PROMPT — copy & paste
Using fx-balances.csv and the attached month-end rates, revalue all foreign currency
balances to SGD: balance × rate per account. Show original, rate, revalued amount,
and gain/loss vs the previous month's revaluation. Flag any revaluation gain/loss
above $5,000 for review.
CHECKUse the exact month-end rates from the bank / MAS reference; verify spot rates.

Small habits, big differenceGeneral Tips

Five habits that make every one of the tasks above faster and safer:

1 One task = one folder files, outputs and history stay clean 2 Output as a file …and save as report.md ready-to-edit document 3 Give the target format as a table, in thousands, with last-year comparison 4 Ask it to show its work calculation per row numbers you can verify 5 Ask for a checklist what should I check before filing — nothing missed
Five habits that make the tasks faster and safer.
  • One task = one folder. Keeps files, outputs and history clean.
  • Ask for the output as a file: "...and save as report.md" — you then have a ready-to-edit document instead of terminal text.
  • Give it the target format: "as a table", "in thousands", "with last-year comparison" — one line saves a round of back-and-forth.
  • Ask it to show its work: "show the calculation for each row" makes numbers verifiable.
  • When in doubt, ask for a checklist: "list the checks I should do before filing the GST return" is a good way to make sure nothing is missed.