user image

John Newman

Real Estate Executive, Trainer and Consultant. Over $750 Million Lifetime Sales

Claude Profit & Loss

Claude Profit & Loss

Stop dreading your books.

If your commissions, expenses and receipts are scattered across bank accounts, cards and Amazon orders, this system gives you a repeatable way to turn them into a clean, running Profit & Loss statement your accountant can review.

What’s inside

  • Step-by-step guide (PDF and editable Word): copy-paste prompts for every step, from setup to monthly upkeep.

  • Sample chart of accounts (Excel): 79 accounts built for real estate agents, covering income, brokerage splits and fees, and expenses. It lists typical Schedule C lines and has a tab of items that usually stay off your P&L, such as K-1 income and owner draws.

  • Sample P&L (Excel): a finished example with live formulas, a transaction detail tab, an income reconciliation, and an open-items list for your accountant. All data is fictional.

  • A monthly routine: the same short process every month, plus a standing-rules list so Claude asks fewer questions each time.

How it works

  1. Start with your last 90 days. Upload only the accounts that touched your business. Business-only accounts need no filtering. Mixed-use accounts are filtered to business items only.

  2. Train Claude with the chart and the sample. Claude categorizes your transactions to your chart, asks you about anything unclear in one table, and builds your running P&L.

  3. Review and repeat monthly. Add each new month as a column. Most agents should expect roughly 20 to 30 minutes a month once set up.

Built for real estate agents who run a single-member LLC or file Schedule C and want organized, review-ready books.

What you’ll need

  • A Claude account. Check that your plan supports Projects and file uploads.

  • Your statements as PDFs, for the accounts used for business.

  • Excel or a compatible spreadsheet app.

  • Optional: your Amazon order history CSV if you buy business items there.

Please note
This product is an organizing tool, not tax, legal or accounting advice. Everything it produces must be verified by a licensed accountant, CPA or bookkeeper before you rely on it or file. It does not promise deductions, refunds or tax savings, and results depend on your own records. All sample data is fictional. This product is independent and is not affiliated with or endorsed by Anthropic.

Get Started

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.