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 a sheet 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 sheet by Thursday.
The slow version:
- Go to FreeAgent, navigate to Reports, select P&L, set January's date range, screenshot or note the figures
- Open your Google Sheet, type January's income, expenses, and net profit into B2, C2, D2
- Go back to FreeAgent, change the date range to February, note the figures
- Type them into row 3
- Repeat for all twelve months
- Two hours later, you have 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 spreadsheet that can query FreeAgent's P&L endpoint for each month and write the figures directly into your reporting sheet.
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 P&L 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, so they match what your accountant sees. No risk of the transcription error that costs you twenty minutes of reconciliation the night before the bank call.
Run the same prompt next month and SheetXAI updates only the rows where column A has a new month value.
What If the Data Is Not Quite Ready
P&L reporting scenarios are rarely as clean as "twelve months, 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 figures for that specific 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 separately
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
Your sheet has current year in columns B through D and the 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 analysis: pull, compare, flag underperforming months, and summarize
The bank also wants a written commentary 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 commentary for any month where net profit dropped more than 15% month on month, explaining the likely driver based on the expense and income movement. Leave column F blank for months that held steady.
The pattern: instead of pulling the numbers and analyzing them in two separate steps, you describe the final state of the report in one prompt. SheetXAI handles the API calls and the derived columns together.
Try It
Get the 7-day free trial of SheetXAI and open your P&L reporting sheet, then ask it to pull the 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 Google Sheets overview.