Profit and Loss Statement Template

Fill in
Profit and Loss Statement Template โ€” page 1

Fill in

PROFIT AND LOSS STATEMENT
Monthly and year-to-date ยท management template
AccountJanFebMarAprMayJunJulAugSepOctNovDecYTD
REVENUE
Product / service revenue$9,375.00$10,000.00$10,625.00$11,250.00$11,875.00$12,500.00$13,125.00$9,375.00$10,000.00$10,625.00$11,250.00$11,875.00$131,875.00
Other operating revenue$375.00$400.00$425.00$450.00$475.00$500.00$525.00$375.00$400.00$425.00$450.00$475.00$5,275.00
Total revenue$9,750.00$10,400.00$11,050.00$11,700.00$12,350.00$13,000.00$13,650.00$9,750.00$10,400.00$11,050.00$11,700.00$12,350.00$137,150.00
COST OF GOODS SOLD
Materials / inventory$2,062.50$2,200.00$2,337.50$2,475.00$2,612.50$2,750.00$2,887.50$2,062.50$2,200.00$2,337.50$2,475.00$2,612.50$29,012.50
Direct labor / fulfillment$1,218.75$1,300.00$1,381.25$1,462.50$1,543.75$1,625.00$1,706.25$1,218.75$1,300.00$1,381.25$1,462.50$1,543.75$17,143.75
Payment / marketplace fees$281.25$300.00$318.75$337.50$356.25$375.00$393.75$281.25$300.00$318.75$337.50$356.25$3,956.25
Total COGS$3,562.50$3,800.00$4,037.50$4,275.00$4,512.50$4,750.00$4,987.50$3,562.50$3,800.00$4,037.50$4,275.00$4,512.50$50,112.50
Gross profit$6,187.50$6,600.00$7,012.50$7,425.00$7,837.50$8,250.00$8,662.50$6,187.50$6,600.00$7,012.50$7,425.00$7,837.50$87,037.50
Gross margin63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%63.5%
OPERATING EXPENSES
Payroll and contractors$1,687.50$1,800.00$1,912.50$2,025.00$2,137.50$2,250.00$2,362.50$1,687.50$1,800.00$1,912.50$2,025.00$2,137.50$23,737.50
Rent / occupancy$562.50$600.00$637.50$675.00$712.50$750.00$787.50$562.50$600.00$637.50$675.00$712.50$7,912.50
Marketing$468.75$500.00$531.25$562.50$593.75$625.00$656.25$468.75$500.00$531.25$562.50$593.75$6,593.75
Software / communications$234.38$250.00$265.62$281.25$296.88$312.50$328.12$234.38$250.00$265.62$281.25$296.88$3,296.88
Insurance / professional fees$187.50$200.00$212.50$225.00$237.50$250.00$262.50$187.50$200.00$212.50$225.00$237.50$2,637.50
Travel / meals$93.75$100.00$106.25$112.50$118.75$125.00$131.25$93.75$100.00$106.25$112.50$118.75$1,318.75
Other operating expense$140.62$150.00$159.38$168.75$178.12$187.50$196.88$140.62$150.00$159.38$168.75$178.12$1,978.12
Total operating expenses$3,375.00$3,600.00$3,825.00$4,050.00$4,275.00$4,500.00$4,725.00$3,375.00$3,600.00$3,825.00$4,050.00$4,275.00$47,475.00
Operating profit$2,812.50$3,000.00$3,187.50$3,375.00$3,562.50$3,750.00$3,937.50$2,812.50$3,000.00$3,187.50$3,375.00$3,562.50$39,562.50
Interest / other non-operating$46.88$50.00$53.12$56.25$59.38$62.50$65.62$46.88$50.00$53.12$56.25$59.38$659.38
Income before tax$2,765.62$2,950.00$3,134.38$3,318.75$3,503.12$3,687.50$3,871.88$2,765.62$2,950.00$3,134.38$3,318.75$3,503.12$38,903.12
Estimated income tax$281.25$300.00$318.75$337.50$356.25$375.00$393.75$281.25$300.00$318.75$337.50$356.25$3,956.25
Net profit$2,484.37$2,650.00$2,815.63$2,981.25$3,146.87$3,312.50$3,478.13$2,484.37$2,650.00$2,815.63$2,981.25$3,146.87$34,946.87
Net margin25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%25.5%