Profit and loss builder

Build a month's profit and loss for a product business, then switch between accrual and cash basis to see why the two tell different stories.

Free, no sign-up. Everything is worked out in your browser — nothing you type is sent anywhere.

Sales

Stock

Expenses

Accrual basis, for the month

Sales invoiced, less refunds
$48,000.00
Cost of goods sold
−$20,000.00
Gross profit (58.3%)
$28,000.00
Expenses incurred
−$15,000.00
Net profit (27.1%)
$13,000.00

On cash basis, the same month's net profit is −$2,000.00 — $15,000.00 apart.

How it's worked out

On accrual basis:

net = (sales invoiced − refunds) − cost of goods sold − expenses incurred

On cash basis:

net = (payments received − refunds) − stock paid for − (expenses − unpaid at month end)

Margins are each profit as a share of that basis's revenue.

Questions

What's the difference between accrual and cash basis?
Accrual counts a sale when you invoice it and a cost when you incur it — stock counts as a cost when it sells, not when you pay for it. Cash counts money when it moves through the bank. Accrual shows whether the business makes money; cash shows whether it has money.
Why can a profitable month leave me short of cash?
Buying stock is the usual reason. Stock you pay for this month but sell next month is a cost on a cash basis now and on accrual only later — so a growing product business often shows a profit on accrual and a loss in cash.
Which basis should I use?
Your accountant and tax office decide what you report. For running a product business, look at both: accrual for margins, cash for whether you can pay the next purchase order.

A P&L that posts itself

Every receipt, sale, invoice, payment and refund in Manifold becomes a balanced entry in your general ledger as it happens, with cost of goods from the batches the stock really came from — on cash or accrual basis, and into Xero, MYOB or QuickBooks.

More free tools