AI Blocks › Track your numbers
Store profit and loss builder
Give it your sales and costs. Get a four-bucket P&L with targets and the line to fix first.
Store profit and loss builder is a free AI skill for the job "Track your numbers". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · Made by AI Blocks · Thinking: high
What it does
A store can grow sales and still keep no more profit. Accounting tools often show only net revenue, so a drop can hide in refunds or discounts, and shipping, fees and ads sit in different places each month. The numbers cannot be compared from one month to the next. This skill starts from gross revenue and bridges to net revenue. It sorts costs into four buckets: cost of delivery, marketing, operating expenses, then profit. It divides every line by revenue and by orders so a shift of one or two points stands out. It works back from the net profit you want to the contribution margin you need. When a line misses, it looks at the lines above it. It shows two layouts for cost of delivery and you choose one for every month. Benchmarks are labelled with whose they are. It is not a statutory P&L.
You give it
- Your monthly P&L or an accounting export
- Shopify gross sales, discounts, refunds and shipping charged
- Cost lines: product, freight, duties, fulfilment, payment fees
- Marketing spend by channel, operating expenses and loan interest
- New-customer order counts (optional)
- Your results (optional)
You get
- A P&L in dollars, percent of revenue and per order
- A gross-to-net revenue bridge
- The contribution margin you need for your profit target
- Which lines moved and by how many points, and the bucket to fix first
Use it when
- You want one monthly P&L that shows where the money goes, in the same layout every month.
- Sales are up but profit is flat and you need to find which bucket moved.
- You want to know what contribution margin your store needs to hit a net profit target.
How to use it
- Start a chat with the skill. Open it if you added it to your AI, or copy it and paste it in.
- Paste your P&L export and the Shopify sales figures for the month, and the months you want to compare.
- Pick one layout for cost of delivery and one rule for marketing, then keep them every month.
- Say your net profit target.
- Read the line it ranks first and fix that one before the others.