You turn bank transactions into a profit and loss statement in six steps. Connect every bank and card account. Categorize every row. Take out the money that was never income or expense. Book payroll from the register. Reconcile each account. Then run the P&L by month. Skip one and you get a number that looks like profit but is closer to how much your checking balance moved.

Many owners first paste a bank statement into ChatGPT and ask for a P&L. That gets you part of the way. Below is why it stops short, each step done right, how Switch, the AI bookkeeper inside Switchbooks, does it, and a ten-row example with the math worked out. To learn what the lines on a finished P&L mean, read how to read a profit and loss statement instead.

Why a pasted bank statement gives you a rough P&L at best

A bank statement lists money that moved. A P&L lists money the business earned and spent. Many rows are neither, and a chat with one pasted statement cannot always tell which ones.

ChatGPT and Claude are good at the easy part: Shell is fuel, Adobe is software. The trouble is everything around it:

• No ledger. The chat writes a summary, not books, so nothing can be checked later.
• Transfers and owner draws become income and costs. Money in from savings looks like a sale. Money out to your personal account looks like an expense. Neither is.
• Card payments get counted twice. The card charges are the expenses, and the payment from checking only pays them off. Paste both statements and the same spending can count twice. Paste only checking and it sees the payment instead of what you bought.
• Nothing is reconciled. A missing week or a doubled import goes unnoticed.
• Nothing is saved for next month. Next month you paste again and explain again, and the categories drift.

The total can be off in either direction, and even when it lands close, the lines under it can still be wrong. More on where the pasted approach breaks. The fix is not a better prompt. It is putting the rows into real books first.

Step 1: Connect every bank and card account

Connect every account the business uses, because a P&L built from one account misses whatever went through the others. That means checking, savings and every credit card. The card matters most: without it, the supplies, fuel and software show up only as one lump card payment.

In Switchbooks, connect from the Banking page, or ask Switch for the link. You sign in to your bank on Plaid's own screen, never in Switchbooks, and the connection only reads bank data. It cannot move money. A new connection starts on the first of last month unless you pick another start date, as far as two years back, though banks differ in how much history they send. If your bank does not connect, create a non-connected account and import statements as CSV, Excel, PDF, or OFX, QFX or QBO files. Older months for a connected account import the same way, into that same account. Loan accounts cannot be connected, so keep the lender's schedule handy for Step 3.

Step 2: Categorize every row

Every row needs a category before it counts toward profit, and the categories have to stay the same month to month or the months cannot be compared. For a plain list of categories and where the tricky items go, see how to categorize business expenses.

In Switchbooks, new rows land in To Review with a suggested category and payee, and nothing reaches the P&L until it is posted. Tell Switch about the business once: what you sell, how customers pay, your main costs. Ask him to remember it and it is saved with the company for next month. Then ask:

Go through To Review. Post what you are sure about and list the rest with your best guess.

He posts the clear rows and asks about the ones only you can answer, like a check with no payee. When a vendor repeats, ask him to make a rule so it files itself next time. The full set of prompts is in how to have AI do your bookkeeping.

Step 3: Take out what is not income or expense

Transfers, credit card payments, owner draws and contributions, and loan principal move money without earning or spending it, so they belong on the balance sheet, not the P&L.

Row	Where it goes
Transfer between your own accounts	Linked as one transfer, off the P&L
Credit card payment from checking	A transfer to the card. The card charges are the expenses
Money you take out for yourself	Owner's draw, an Equity account
Money you put in	Owner contributions, an Equity account
Loan money coming in	The loan, a Liability
Loan payment	Principal to the loan, interest to Interest Expense
Sales tax you collected	Sales Tax Payable, a Liability, until you pay it

In Switchbooks, a transfer between two of your own accounts, a card payment included, is linked and posted on its own once both sides arrive and can only match each other. When a row could match more than one, or the sides land far apart, Switch matches them. He books draws and contributions to Equity, creating those accounts if your chart has none, and splits each loan payment to the cent from the lender's schedule. What he cannot know on his own is who a Zelle to a person was for, so that comes back to you as a question. Whether the interest is deductible is your CPA's call.

Step 4: Book payroll from the register

Payroll goes on the P&L from your payroll register, because the bank only shows net pay and tax debits, not the wages and taxes the business owes.

If the team earned $4,600 and $650 was withheld, the bank shows $3,950 leaving, but the P&L shows $4,600 in wages plus the employer's payroll taxes. The withheld taxes and the employer's share sit in Payroll Liabilities until the tax debit clears.

Switchbooks does not run payroll. Drop your provider's register into the chat, and Switch books it as one journal entry on the check date, matches the net pay row to it, and posts the tax debits to Payroll Liabilities. Without the register, he tells you wages are understated until you send it.

Step 5: Reconcile each account

Reconcile every bank and card account to its statement each month, because it is the only step that proves no row is missing or counted twice. A pasted statement cannot be reconciled: it is the only thing in the chat, so there is nothing to check it against.

In Switchbooks, tell Switch the account, the statement end date and the ending balance:

Reconcile the business checking account to the September 30 statement. The ending balance is 14,382.06.

He finishes it only if the books tie to the statement. If they do not, nothing is finished: he shows the difference and the rows that explain it, usually a missing fee or a duplicate, so you can fix them first. A finished reconciliation can be undone if you need to reopen the month.

Step 6: Run the P&L by month

Run the P&L once every row is posted and every account reconciled, with one column per month to show the trend.

In Switchbooks it is on the Reports page under P&L, with monthly, quarterly or yearly columns and a comparison to the prior period or prior year. Click any number to see the transactions behind it. You can also ask Switch:

Is September done? What is left?

Show me the profit and loss for July through September, by month.

He answers the first with what is still open: rows in To Review, accounts not reconciled through month end, and monthly entries not booked. The P&L exports to Excel or Google Sheets, and he can hand you a PDF in the chat.

A worked example: ten bank rows to a P&L

September for a two-person cleaning company with one checking account and one credit card, and where each row goes:

#	Account	Description	Amount	Where it goes
1	Checking	Deposit, Harbor Dental	+5,200.00	Cleaning revenue
2	Checking	Transfer from savings	+2,000.00	Transfer, off the P&L
3	Checking	Deposit, Oak Street HOA	+3,800.00	Cleaning revenue
4	Checking	Payroll, net pay	-3,950.00	Matched to the payroll entry
5	Checking	Card payment	-1,240.00	Transfer to the card
6	Checking	Auto loan payment	-620.00	535.00 principal to the loan, 85.00 interest
7	Checking	Transfer to owner's personal account	-3,000.00	Owner's draw
8	Card	Home Depot	-412.00	Supplies
9	Card	Shell	-96.00	Fuel
10	Card	Progressive	-310.00	Insurance

The payroll register for row 4 shows gross wages of 4,600.00, 650.00 withheld, and 360.00 of employer payroll taxes. The 1,240.00 card payment paid off August's card charges, which were on August's P&L.

Profit and Loss, September 2026

Revenue
  Cleaning revenue            9,000.00

Expenses
  Wages                       4,600.00
  Payroll taxes                 360.00
  Supplies                      412.00
  Insurance                     310.00
  Fuel                           96.00
Total expenses                5,778.00

Operating profit              3,222.00

Other expense
  Interest expense               85.00

Net income                    3,137.00

Now the pasted version. Paste only the checking statement and count every deposit as income and every withdrawal as a cost: 11,000.00 in, 8,810.00 out, and a "profit" of 2,190.00. That is simply how much the checking balance went up. It is 947.00 too low, and almost every line under it is wrong:

• Revenue is 2,000.00 too high, because the savings transfer counted as a sale.
• The 3,000.00 owner's draw counted as a cost. It is Equity.
• The full 620.00 loan payment counted as a cost. Only the 85.00 of interest is.
• The 1,240.00 card payment stood in for the 818.00 of September card charges, which a checking statement never shows.
• Payroll shows 3,950.00 instead of 4,960.00 in wages and employer taxes.

None of those rows disappeared. The card payment lowered the card balance, the principal lowered the loan, the draw lowered your equity, and the 1,010.00 of payroll taxes sits in Payroll Liabilities until the tax debit clears. That is the balance sheet's job.

What Switchbooks does not do

Switchbooks keeps the books and runs the reports. A few related jobs stay elsewhere.

• It does not run payroll, send invoices, pay bills, track inventory, file sales tax or 1099s, handle other currencies, or track time.
• A P&L built from bank rows is mostly cash basis: income counts when it lands, and costs count when you pay them or charge them to a card. Adjustments such as spreading a year of insurance over twelve months go in as journal entries, which Switch books when you give him the numbers.
• Which costs are deductible, and how the business files, are your CPA's calls.

What it costs

Switchbooks is $25 per month per company, with every feature included and a free ten-day trial with no card. If you already work in ChatGPT or Claude, the same books connect there too: see bookkeeping in ChatGPT and Claude. For how this compares with hiring someone, see AI bookkeeping vs a bookkeeper. Then start a free trial, connect every account, and ask Switch for September.