Modern Accounting The Workflow · Wednesday |
Accrual review, first draft in fifteen minutes
Month-end accrual review is one of those tasks that feels fast until it is not. You scan the list, the balances look familiar, and you initial it. Then audit pulls a sample and finds the Q3 bonus accrual that never reversed, the prepaid you expensed in full in October instead of spreading it, or the vendor invoice that landed on November 2 and belongs in October. None of those are hard to catch. They are just easy to skip when it is 6 p.m. on a Wednesday and the list has forty lines.
An AI is decent at this when you give it the right inputs: the accrual schedule with opening balance, additions, reversals, and closing balance for each line, plus the support column that explains the basis. It will draft a commentary line for every entry, flag the ones where the math does not close, and surface the lines that have no support note at all. It does not know your contracts or your close calendar, so the cutoff calls are still yours.
Here is the prompt to paste after you export the schedule.
What you need
- An export of the accrual schedule: account number, description, opening balance, additions this period, reversals this period, closing balance, and the support or basis column. A flat CSV or pasted table both work.
- Your materiality threshold for the month, so the prompt can flag lines that exceed it without commentary.
- The period-end date, so cutoff questions are framed correctly.
- The AI tool your company has licensed for internal use, not a personal account, since this export will contain ledger data.
The prompt
You are a first-draft reviewer helping an accountant prepare accrual commentary for the period ending [PERIOD END DATE]. Materiality threshold for this review: [DOLLAR THRESHOLD]. I will paste an accrual schedule below. Each row contains: account number, description, opening balance, additions, reversals, closing balance, support or basis note. Your instructions: 1. For each line, write one commentary sentence that states the closing balance, the basis for the accrual, and whether the movement this period is consistent with that basis. 2. Flag any line where opening balance plus additions minus reversals does not equal closing balance. Show the difference. 3. Flag any line where the support or basis note is blank or says only 'per prior month' with no further detail. 4. Flag any line where the closing balance exceeds [DOLLAR THRESHOLD]. 5. Do not infer contract terms, invoice dates, or accrual rates from context. If the basis note does not explain the amount, write 'Support missing: reviewer must obtain documentation' and do not guess. 6. Do not round any figure differently from how it appears in the schedule. Output format: - One numbered section per account. - Each section: account number and description as a header, your commentary sentence, then any flags on separate lines starting with FLAG: - After all accounts, a summary section listing every flagged item by account number only. Schedule: [PASTE SCHEDULE HERE]
What comes back
These numbers are made up to show what the output looks like. Imagine you paste two lines: Account 2210, Accrued bonuses, opening $120,000, additions $40,000, reversals $0, closing $160,000, basis note 'Q4 estimate per HR'; and Account 2340, Accrued professional fees, opening $15,000, additions $8,000, reversals $15,000, closing $9,500, basis note 'per prior month'.
For Account 2210, the AI writes: 'Closing balance of $160,000 reflects the Q4 bonus estimate per HR; the $40,000 addition is consistent with continued accrual through the period.' No flags. For Account 2340, it writes: 'Closing balance of $9,500.' Then: 'FLAG: math does not close. Opening $15,000 plus additions $8,000 minus reversals $15,000 equals $8,000, not $9,500. Difference of $1,500 unexplained.' And: 'FLAG: basis note says per prior month only. Support missing: reviewer must obtain documentation.'
Constructed example. Invented numbers, no real company.
That output is doing its job. The 2210 commentary is thin but accurate. The 2340 flags are the ones a tired reviewer would have missed at 6 p.m.
The review step
The math flag on Account 2340 is real and the AI caught it correctly, but the AI has no idea why the $1,500 difference exists. It could be a manual journal that was posted directly to the accrual account and is not reflected in the additions column. It could be a data export error. It could be someone correcting a prior period entry without documentation. The AI reported the gap; figuring out what filled it is your job.
Also worth checking: the 2210 bonus accrual shows zero reversals across the period. If this accrual has been building since Q1 without a reversal, that is a question for payroll, not a commentary sentence. The AI called the $40,000 addition 'consistent with continued accrual,' which is technically true and completely uninformative if the balance has been accumulating beyond the bonus payment date.
Look at every line where reversals are zero and the opening balance is not zero. Those are the ones most likely to represent a stale accrual that someone forgot to clear.
Zero reversals on an old accrual is not 'consistent with the basis.' It is a question.
Before you sign the commentary, run these three checks on every flagged line:
- Does the closing balance agree to a source document, a contract, an invoice, or an HR estimate, and is that document dated within this period?
- If reversals are zero, is there a payment or settlement in the period that should have cleared this line instead?
- Does the addition or reversal amount match the journal entry in the GL, or was something posted directly to the accrual account outside the normal entry?
The AI drafted the commentary. Your name is on the sign-off, and audit will ask for the support, not the draft.
Where it breaks
- Messy export columns. If your accrual schedule has merged cells, subtotals baked into the rows, or a 'basis' column that is actually three columns merged, the AI will misread the structure. Clean the export to one row per account with clearly labeled columns before pasting.
- Basis notes that are too terse. A basis column full of 'estimate,' 'per contract,' or blank cells gives the AI nothing to work with. You will get a commentary section full of 'Support missing' flags, which is accurate but not useful. The fix is upstream: whoever books the accrual should populate the note at entry time.
- Multi-currency schedules. If the schedule mixes currencies and your export shows only the local amount, the AI will flag math that is correct after conversion as a discrepancy. Translate to a single currency or add a column for the functional-currency amount before pasting.
- Stale line items the AI praises. The AI has no memory of last month's review. An accrual that has sat at the same balance for six periods will read as 'consistent with the basis' because the math closes. Only a reviewer who checks the aging catches that one.
You know the problem. Now build the fix.
You've spent years close to a broken industry or process. You know exactly what would fix it. But you’ve never had the time or resources to make it happen.
With Lovable, your expertise is all you need. Describe the solution to your problem — a website, a dashboard, an internal tool — and get professional-grade software back. You make every call on how it works, because you're the one who knows what it needs to do.
Start today and take $5 off your first month.
Discount of $5 applies to first month of any paid plan. You need to sign up via this webpage in order to claim the discount. The discount applies to new and returning users without an active paid plan. Terms apply.
Markets move. Headlines catastrophize. Inside the noise is the story that matters — the opportunity, not the fear. The Daily Upside: global business and finance, reported without the alarm.
If you want this one ready-made. The Missing accruals pack in our Library is $9. Catch the accruals you would otherwise find after close. See it in the Library
Thursday: Know on day one which expenses are missing a receipt or sit outside policy, without opening every report.
Amir
P.S. What does your accrual schedule actually look like at the moment you review it: a clean export, a printed PDF someone marked up, or something else? Hit reply, I am curious how much cleanup happens before anyone looks at the numbers.
We have not run these tools ourselves. Scores are from our published reviews, with the date we last checked. The worked example uses invented numbers.
Modern Accounting, from Audit Friendly.

