Skip to content
← All guides

Build a monthly profit and loss summary

A free worksheet for revenue, sold-item costs, selling costs, and expenses.

By Resylr · Updated

Download profit and loss CSV ↓

Start with the worksheet

The CSV contains monthly columns and labeled rows. Open it in a spreadsheet app and add your formulas. It is a worksheet, not an automated accounting report.

Separate sales from payouts

Enter sales, shipping collected, and returns separately. A payout is the amount transferred after deductions; using it as gross revenue and subtracting fees again counts those fees twice.

Keep the categories consistent

Enter sold-item costs, marketplace fees, postage, packaging, and operating expenses in the appropriate rows. Reconcile totals to your supporting records.

Check before sharing

Review missing receipts, refunds, duplicate expenses, and unsold inventory with your bookkeeper. The worksheet helps organize the discussion; it does not establish tax treatment.