Bookkeeping

Can I do my own profit and loss statement?

Yes. A profit and loss statement shows a business's income and expenses for a period, and you can make a simple one from your bank and card statements: mark what each line was, total the income and the expenses, and check the totals against the statements. The hard part is knowing what each line was, and your own AI assistant can do that sorting while CollieTax builds the report from your books.

By CollieTaxUpdated

What a profit and loss statement is.

It is also called an income statement. In the IRS's words: “An income statement shows the income and expenses of the business for a given period of time.” The period can be a month, a quarter, a year, or the year to date.

A simple one has five lines:

The lines of a simple profit and loss statement
LineWhat goes there
RevenueWhat you earned in the period: sales, fees and services
Cost of goods soldWhat the goods you sold cost you, if you sell goods
Gross profitRevenue minus the cost of goods sold
Operating expensesRent, software, contractors, supplies, interest and the other costs of running the business
Net profit or lossGross profit minus operating expenses

Make a simple one in four steps.

You need no accountant and no software for a simple one. You need your statements, and an answer for each line on them:

  • Pick the period. Get every statement for it, for each business bank account and each business card.
  • Mark what each line was. Most are clear from the payee: the rent, the card sales, a supplier. For the rest, ask yourself: was this a sale or a loan? Business or personal?
  • Total the income and the expenses, each by category.
  • Check it. For each account, the opening balance plus the deposits minus the withdrawals must equal the closing balance on the statement. If your marked lines do not add up to the statement's totals, a line is missing or counted twice.

What does not go on it.

Bank deposits minus withdrawals is not your profit. These lines move money, but they are neither income nor expense:

  • Money you put into the business yourself.
  • A transfer between two of your own accounts.
  • The principal of a loan payment. The interest part is an expense; the lender's statement shows the split.
  • Money you take out for yourself, as a sole proprietor or partner.
  • A payment to your business card. The card's purchases are the expenses, not the payment that clears them.

A worked month.

An invented example for a small service business, not a customer result or a tax calculation. Assume the customer receipts are revenue earned this month, and the costs belong to this month.

Scroll horizontally to see all columns.

One month on the bank statement
Bank activityMoney inMoney outWhat it was
Customer receipts$12,400—Revenue
Owner contribution$2,000—Money the owner put in, not revenue
Transfer to savings—$1,500A move between the business's own accounts
Rent—$1,800Operating expense
Software—$240Operating expense
Contractor invoice—$3,600Operating expense
Loan payment—$650$600 principal and $50 interest, from the lender's statement

The report it makes.

Revenue is $12,400. The expenses are $5,690: $1,800 rent, $240 software, $3,600 contractors and $50 interest. The profit is $6,710.

The bank shows something else: $14,400 in and $7,790 out, an increase of $6,610. The account got the owner's $2,000, and lost the $1,500 moved to savings and the $600 of loan principal. None of the three is on the profit and loss, so the account rose $100 less than the profit. Both numbers are right. Forcing the profit to match the bank would make the report wrong.

The month's profit and loss statement
LineAmount
Revenue$12,400
Operating expenses and interest$5,690
Net profit, before any other adjustments or taxes$6,710

A template gives you the layout, not the answers.

Microsoft's page of Excel templates says you can “Build profit and loss reports with customizable templates, built-in formulas, and Copilot in Microsoft Excel.” A spreadsheet adds up what you put in it. It cannot tell you which deposit was a loan, and it does not check its totals against your statements. That part is yours, and it is the part that goes wrong.

Books go one step further: they keep every entry with its source, so next month's report and the year's come from the same checked records.

Can ChatGPT create a profit and loss statement?

Yes, from transactions it has sorted, and it lays the report out well. Check it the same way you would check your own: the totals must agree with each statement. Anthropic's own page for Claude's Personal Finance feature says: “Check important figures against your bank's own app or statements.”

A report made once in a chat stays in that chat. Next month, the assistant starts again from the statements, unless it keeps the entries in a set of books.

Does the IRS require a profit and loss statement?

Not by that name, for most small businesses. A sole proprietor reports the business's income and expenses on Schedule C (Form 1040), “Profit or Loss from Business (Sole Proprietorship)”. A partnership or an S corporation reports its income and deductions on its own return, Form 1065 or Form 1120-S.

The return's numbers are not always the books' numbers. Equipment you will use for years is often deducted over time, goods you have not sold yet are not an expense until they sell, only part of a business meal is usually deductible, and the personal share of a car or a home is left out. A simple profit and loss does not settle these; a licensed CPA or EA does, when the return is prepared.

What the IRS does require is records behind every number: “These records must support the income, expenses, and credits you report.” It adds that these are generally the same records you use to prepare your financial statements, which “can help you in dealing with your bank or creditors.” So when a lender or a landlord asks for a profit and loss statement, give them one that agrees with your bank statements.

Or have your assistant build it from your books.

Your own assistant, ChatGPT, Claude, Muse or Grok Bot, reads the statements for the period, books what is clear and asks you about the rest. CollieTax checks the rows against the totals each statement prints, then builds the profit and loss for any period you ask for: a month, a quarter or the year to date, with the balance sheet beside it.

Your assistant tells you what is still open, such as a question you have not answered, and gets you a link to every entry behind each line, beside its statement. The link opens when you sign in to CollieTax.

The price: In your own assistant, free under 15 transactions a month, then from $29 a month for each set of books. With a CollieTax bookkeeper, from $199 a month.

Sources and further reading

General information and product guidance. Examples are illustrative; your records and filing situation determine the work required. Sources and product descriptions were checked for this update.

Put the workflow to work.

Give this to your assistant. It reads the page, then does the work with you.

Read https://collietax.com/blog/bank-statements-to-profit-and-loss.md, then make a profit and loss statement for my business from my bank and card statements with CollieTax.

See how your assistant keeps the books

Keep reading.