Maintain transparent financial operations for taxation and auditing bodies — AI Prompts for Microsoft Excel

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

I need the reconciliation workbook ready for the tax inspector by Wednesday. Send the trial…

I need the reconciliation workbook ready for the tax inspector by Wednesday. Send the trial balance, the adjustments worksheet and the cashbook to Maria in tax and to Jonathan in audit for e-signature, signers in that order, with a Wednesday deadline—confirm every ledger link recalculates and the supporting PDF extracts open from the summary sheet first.

Improve — make it easier to accept

Before I hand this to the tax team, make the audit trail obvious: show the net change per account…

Before I hand this to the tax team, make the audit trail obvious: show the net change per account at the top, highlight manual journal rows with a color and comment, list source file names beside each adjustment, and add a one‑line explanation for any balance over 10,000. Flag anything that would make Maria ask for backup.

Decide — diagnose the stuck moment

I reconciled period-end and emailed Maria in tax and Jonathan in audit; Maria says she cannot trace…

I sent the reconciliation but Maria replied she can't trace one adjustment.

I reconciled period-end and emailed Maria in tax and Jonathan in audit; Maria says she cannot trace a 14,732 adjustment. I am afraid it came from a copied sheet that lost its link and I cannot tell whether to reverse it or supply backup. Do I restore the original linked extract and notify both, or reverse now and rebook after I find evidence? Which keeps us safest for the inspector and audit timeline?

Become — change the pattern

Every quarter we lose two to three days to auditors chasing manual journals and source files. The…

We repeatedly spend days answering auditors' follow-ups about manual journals.

Every quarter we lose two to three days to auditors chasing manual journals and source files. The same teams—me, Maria in tax, and Jonathan in audit—ask for supported links, comment explanations and file exports. What single change to our month‑end practice will most reduce follow‑ups: a mandatory comment template for each manual journal, automated PDF exports attached to the reconciliation, or a fast restoreable linked source directory? Recommend the best habit and how to enforce it next quarter.

Next to this one

Other Microsoft Excel work people do in Microsoft Excel.

Maintain laboratory stock Maintain records of inventory, personnel, and supplies Maintain records of sales activities Maintain records of work hours and payroll Maintain student attendance and records Make investment recommendations Make staffing and procedural recommendations Manage budgets and control costs for events Manage corporate bank accounts Manage financial operations and budgets

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt