# Profit and Loss PDF to Excel: Months as Columns

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Other financial documents
- Canonical: https://fastbankconvert.com/blog/profit-and-loss-pdf-to-excel

> Turn a profit and loss PDF to Excel: month columns that span pages, account groups, negative figures in brackets, and checking net income.
To turn a profit and loss PDF to Excel, extract the table with account names in the first column and one column per month, rejoining any months that continue on a later page. Mark subtotal rows so they are not summed twice, convert bracketed figures to negative numbers, and check that the net income line matches the PDF.

## Month columns that span pages in a profit and loss PDF

A profit and loss report with twelve months rarely fits one page across. Accounting software usually prints the first few months on one page and continues the rest on the next, repeating the account names down the left side. A converter then returns two tables. Rejoin them side by side on the account name, not by stacking them.

### Spotting a split report

Look at the column headings on each page. If page 1 ends at June and page 2 starts at July with the same account list, the report is split across, not down. If page 2 instead starts with new account names under the same months, the report is long rather than wide, and those pages do stack.

Some reports do both. A twelve-month P&L for a business with many expense accounts can run two pages wide and three pages long, giving six table pieces. Draw the grid on paper first: which pages hold which months, and which hold which accounts. Then assemble in that order.

### Rejoining with a lookup

Put the first piece on a sheet with account names in column A. On the second piece, the account names repeat. Use XLOOKUP, or INDEX with MATCH, on the account name to bring the July to December columns alongside. A lookup is safer than a copy and paste, because the second page may skip an account that had no activity in those months, which shifts every row below it by one.

After the join, scan for blanks. A blank in a month column can mean zero activity, or it can mean the account name was printed slightly differently on page 2, such as a trailing space or a shortened word, and the lookup missed it.

### Labelling the months

Copy the headings exactly. Reports print months in many forms: "Jan 2026", "January", "01/2026", or a fiscal label such as "Period 7". Above your data, add a row of real Excel dates set to the last day of each month. Charts, sorting and formulas work with dates. They do not work with text that only looks like a date.

## Account groups and subtotal rows in the P&L sheet

A P&L arranges accounts in groups: income, cost of sales, operating expenses and other income or expense. Each group ends with a subtotal, and lines such as gross profit sit between them. Keep the groups, but add a column that says whether a row is an account, a subtotal or a total. Then sum only the account rows.

### Why the type column matters

Without it, a SUM down any month column adds the accounts and their subtotals together, so the result is roughly double. Filters, pivot tables and charts make the same mistake. A "Row type" column with the values Account, Subtotal and Total lets SUMIFS add only the accounts.

Also add a "Group" column that repeats the group name on every account row, such as "Operating expenses". Indentation on the PDF shows the group visually, but indentation is lost or turned into leading spaces during extraction, and a column is something formulas can read.

### Nested accounts

Some reports nest accounts more than one level deep. "Payroll" may hold "Wages", "Payroll taxes" and "Benefits", each with its own line, and then a "Total Payroll" line. Treat the parent line as a subtotal if it has its own total row, and as a heading with no amount if it does not.

Employer retirement contributions often appear as one of those nested payroll lines. If you want to see them from the employee's side, [a 401k statement in Excel lists contributions and fund gains](/blog/401k-statement-to-excel) by pay period, which can be matched against the P&L month.

## Why do bracketed P&L figures arrive as text?

Accounting reports print negative amounts in brackets, such as (1,250.00), and many converters write that cell as text rather than as a number. The cell looks right but sits left-aligned, and SUM skips it. Converting brackets to minus signs fixes it.

### The fix

1. Select the amount columns.
2. Use Find and Replace to replace "(" with "-" and ")" with nothing.
3. Remove any currency symbol and stray spaces the same way.
4. In a spare cell, type 1, copy it, select the amounts, and use Paste Special, Multiply. Text numbers become real numbers.

Check the status bar afterwards. Select a month column: if it shows a sum, the conversion worked. If it shows only a count, some cells are still text.

### Other ways a report shows a negative

Not every report uses brackets. Some print a trailing minus, as in "1,250.00-", which needs the minus moved to the front. Some print negatives in red with no sign at all, and red color does not survive most extraction, so those figures arrive as positive numbers. If a report uses red, compare the converted sheet against the PDF on every line that looked red, or ask for the report again with brackets turned on.

Some lines are expected to be negative even in a profitable month: a sales returns line, a loss on an asset sale, or an unrealized loss on investments the business holds. A business holding crypto, for example, may show a loss line that comes from the exchange's records, and [a crypto exchange statement in Excel separates the trades and fees](/blog/crypto-exchange-statement-to-excel) behind that number.

## Checking net income in the converted P&L

The net income check proves the sheet matches the PDF. For each month, sum the income accounts and subtract the cost of sales accounts and the expense accounts, then add other income and subtract other expenses. The result must equal the printed net income for that month. Do the same for every subtotal on the way down.

### A worked example

The three-month report below is an example, made up for illustration. Figures in brackets are negative, as printed.

| Account | Row type | Jul | Aug | Sep |
| --- | --- | --- | --- | --- |
| Sales | Account | 18,400.00 | 21,150.00 | 19,800.00 |
| Cost of goods sold | Account | 7,360.00 | 8,460.00 | 7,920.00 |
| **Gross profit** | Subtotal | 11,040.00 | 12,690.00 | 11,880.00 |
| Rent | Account | 2,500.00 | 2,500.00 | 2,500.00 |
| Wages | Account | 6,200.00 | 6,450.00 | 6,300.00 |
| Software | Account | 310.00 | 310.00 | 345.00 |
| **Total expenses** | Subtotal | 9,010.00 | 9,260.00 | 9,145.00 |
| **Operating income** | Subtotal | 2,030.00 | 3,430.00 | 2,735.00 |
| Interest expense | Account | (180.00) | (175.00) | (170.00) |
| Loss on equipment sale | Account | | | (1,250.00) |
| **Net income** | Total | 1,850.00 | 3,255.00 | 1,315.00 |

Take September. Sales of 19,800.00 minus cost of goods of 7,920.00 gives 11,880.00, which matches the gross profit line. Expenses of 2,500.00, 6,300.00 and 345.00 add to 9,145.00, which matches total expenses. Operating income of 2,735.00, less 170.00 of interest and 1,250.00 of loss, gives 1,315.00, the printed net income.

Now suppose the bracket fix had missed the loss line, so it sat in the sheet as text. The net income formula would skip it and give 2,565.00. A gap of exactly 1,250.00 points straight at the line to fix.

### Formulas that do the checking

Add a check row under the table. In each month column, calculate net income from the account rows with SUMIFS on the Group column, then subtract the printed net income. Every cell in the check row should be zero. Repeat for gross profit and operating income if you want to find a gap faster.

Last, sum the months across and compare with the year-to-date or total column if the report prints one. A total column that does not tie usually means a month went missing during the page join.

## When is a profit and loss PDF the wrong starting point?

A profit and loss PDF is the wrong starting point when you can reach the accounting system that produced it. Most accounting software exports the same report to Excel or CSV directly, with real numbers, no brackets to fix and no page joins. Converting the PDF only makes sense when the PDF is all you were given.

That is common enough. A buyer looking at a small business, a lender, a landlord checking a commercial tenant, or a new bookkeeper taking over a client often receives the P&L as an attachment and nothing else. In those cases, ask once for the native export. If it does not come, convert the PDF and run the checks above.

A P&L is also the wrong source when you need to know what is behind a number. The report shows that rent was 2,500.00 a month. It does not show who was paid or when. For that, you need the transactions, which come from the general ledger or from the bank statements. A business without clean books can rebuild a rough P&L from its statements: convert each month to rows, give each row a category, and sum by category and month.

FastBankConvert is built for that first step, turning a checking, savings or card statement PDF into a spreadsheet and flagging a statement whose balances do not add up. It is getting ready to open, and [the homepage](/) shows a sample conversion. Whatever converter you use for a P&L, look at the output before you download and build on it; [what to check in a converted Excel preview](/blog/preview-converted-excel-before-download) lists the columns and totals worth a glance.