Total Bills with Periods (JAN25-DEC25)

Written By Nomad FI

Total Bills with Periods (JAN25-DEC25)

Periods (Monthly and Quarterly)

Notes:

  • Created Total Bills with Periods from scratch with AI prompts only

  • Due to text cell size limitations in AI, I’ve truncated from monthly breakdown to quarterly breakdown

  • From testing with prompts, AI understands monthly periods in quarterly ranges

  • AI understands subtotals, but requires the formula for calculations

  • AI understands how to calculate grand total with subtotals

// Phase II //

  • Include FY25 total by category

  • Include a MTD column after OCT-DEC25 for each category

  • Include an alloc % for each category

Nomad FI
Previous

EFI Trades Analysis (With Prompts)(MAR-APR25)
Next

ING Offset (Cash Flow Analysis)(With Prompts)