Draft a monthly management profit and loss from the ledger export

A draft management profit and loss mapped from ledger accounts, with prior-month comparison and unmapped accounts.

Choose one of three approaches. The steps for that option appear below.

Choose an option above. On a phone, swipe the tabs left or right to see all options →

Gemini: maps accounts and totals the P&L, you check

The preparer imports the tables. Gemini adds the management lines and totals. The accountant checks the draft.

  1. You

    Preparer imports tables

  2. Gemini

    Map and draft P&L

  3. You

    Preparer spot-checks draft

  4. The accountant

    Accountant checks, decides

  1. Preparer imports the three tables

    Use: You

    Have ready: trial balance export, mapping and approved prior-month figures. Import the first two into one workbook as tables; add the prior-month figures as a third.

    Check

    Check the imported trial balance total equals the export total.

  2. Map accounts, then draft the P&L

    Use: Gemini

    Ask Gemini to look up each account's management line and list unmatched ones, then build the P&L with prior-month comparison and totals check.

    Details

    What to paste into the tool

    Draft a formula for the trial balance table that looks up the management report line from the mapping table by account code. Leave it empty when there is no match; do not guess. Summarise the mapped trial balance by management line, add the prior-month figure from the prior-month table by line, and show the total difference to the trial balance total. List new or unmapped accounts.

  3. Preparer spot-checks before handover

    Use: You

    Spot-check mapped lines and the reconciliation figure against the tables before the draft goes to the accountant.

    Check

    Gemini reads a sample of rows and the header, so full results need checking.

  4. Accountant checks the draft and decides

    Use: The accountant

    Check the P&L, the prior-month comparison and the reconciliation against the trial balance and approved figures, then approve the draft.

    Check

    Check the mapping version and flag accounts needing reclassification. Unmapped accounts stay listed, never force-mapped. Reclassifications and final adjustments happen in the ledger. Do not distribute as final accounts.

Before you paste into any AI tool, remove any confidential information. Put it back at the end.

Tools in this workflow

Deciding between ChatGPT and Claude for this? See the comparison.

Final check

Never paste credentials or full payment details.

P&L lines reconcile to the trial balance total with no unexplained plugs. Prior-month comparison ties to the approved figures. Every account is mapped or listed; none force-mapped. Draft is not distributed as final accounts.

Check the result against your original inputs. Approve it before sharing or acting.

What still needs checking
  • Pricing and plan limits beyond the quoted plan statements for the tools listed were not read for this proposal.

Share this page