The Scenario
You are a small business owner. You present monthly P&L figures to your bank as part of an ongoing loan covenant.
The bank wants an Excel workbook showing twelve months of P&L data — total income, total expenses, and net profit — for the current financial year. Your data is all in FreeAgent. Your bank wants the workbook by Thursday.
The slow version:
- Go to FreeAgent, navigate to Reports, select P&L, set January's date range, note the figures
- Open your Excel workbook, type January's income, expenses, and net profit into B2, C2, D2
- Go back to FreeAgent, change to February, note the figures
- Type them into row 3
- Repeat for all twelve months
- Two hours later, there is a fifty-fifty chance of a typo somewhere.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can query FreeAgent's P&L endpoint for each month and write the figures directly into your reporting workbook.
Open the SheetXAI sidebar and type:
Pull the FreeAgent P&L for each month listed in column A and write total income, total expenses, and net profit into columns B, C, and D.
SheetXAI reads column A, calls FreeAgent once per month, pulls the correct figures, and writes them row by row. Your twelve-month summary is done without a single manual data entry.
What You Get
A completed P&L summary with:
- Column A — months you already have listed
- Column B — total income per month from FreeAgent
- Column C — total expenses per month
- Column D — net profit (income minus expenses)
The figures come from FreeAgent's actual P&L calculation, not a manual tally. No transcription error the night before the bank call.
What If the Data Is Not Quite Ready
P&L reporting scenarios are rarely as clean as twelve rows and three columns.
When the date range is in cells rather than column A
You have a single date range in A1 and B1 and need the P&L for that period written to C1, D1, E1.
Fetch the FreeAgent P&L summary for the date range in cells A1 and B1 and write income, expenses, and net profit to cells C1, D1, and E1.
When you want gross profit and operating expenses broken out
Your bank wants a more detailed breakdown than income and expenses as single figures.
Pull the FreeAgent P&L for each month in column A. Write total income to column B, cost of sales to column C, gross profit to column D, operating expenses to column E, and net profit to column F.
When you need prior-year figures alongside current-year for comparison
Prior year is already in columns F through H. You want a variance column.
Pull the FreeAgent P&L for each month in column A for the current financial year and write income, expenses, and net profit to columns B, C, and D. Then in column I, calculate the variance between current-year net profit (column D) and prior-year net profit (column H) for each row.
When you want the full report: pull figures, flag underperforming months, and add commentary
The bank wants a written note on any month where net profit dropped more than 15% compared to the prior month.
Pull the FreeAgent P&L for all twelve months in column A and write income, expenses, and net profit to columns B, C, and D. Calculate month-over-month net profit change and write it to column E. In column F, write a one-sentence note for any month where net profit dropped more than 15% month on month, describing the likely driver based on the expense and income movement.
The pattern: instead of pulling figures and analyzing them separately, you describe the final state of the report in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your P&L reporting workbook, then ask it to pull FreeAgent figures for each month in column A. The FreeAgent integration is included in every SheetXAI plan. See also how to export the FreeAgent balance sheet for year-end reporting or the FreeAgent in Excel overview.