Description
In this video, we build the Profit and Loss Report for our inventory management system in Laravel 13. For every product, it shows how many units were sold, how much revenue came in, how much it cost us, and how much profit we have made.
You can filter the report by category and date range, then export the exact filtered results to Excel and PDF, with a Grand Total row at the bottom of the PDF. This is a Laravel Filament 5 tutorial, and it uses the same custom Filament page pattern as our Stock, Purchase, and Sale reports. The data is different this time, because we group sale items by product and let the database calculate the totals.
This series is a free Laravel project with source code, built step by step from installation to a working inventory management software. If you are looking for Laravel project ideas, or want to learn FilamentPHP 5 properly, this Laravel project tutorial is for you.
🎯 QUIZ TIME: stick around till the end. I ask 3 interview-style multiple choice questions based on this video. Answer with just A, B, C, or D in the comments.
━━━━━━━━━━━━━━━━━━━━━━━━━━━
📌 WHAT YOU WILL LEARN IN THIS VIDEO
━━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ How profit is calculated: revenue minus cost
✅ Building a shared query class used by the table, Excel, and PDF
✅ Grouping sale items by product with selectRaw and groupBy
✅ Sorting and searching calculated columns in a Filament table
✅ Adding a margin column with colour-coded badges
✅ Exporting the filtered report to Excel and PDF with a Grand Total row
✅ 3 quick interview-style quiz questions (A, B, C, or D)
━━━━━━━━━━━━━━━━━━━━━━━━━━━
📂 FILES COVERED IN THIS VIDEO
━━━━━━━━━━━━━━━━━━━━━━━━━━━
📄 app/Reports/ProfitLossQuery.php
📄 app/Filament/Pages/ProfitLossReport.php
📄 app/Exports/ProfitLossReportExport.php
📄 resources/views/filament/pages/profit-loss-report.blade.php
📄 resources/views/pdf/profit-loss-report.blade.php
━━━━━━━━━━━━━━━━━━━━━━━━━━━
📖 BLOG POST + FULL SOURCE CODE
━━━━━━━━━━━━━━━━━━━━━━━━━━━
🌐 Blog Post with Source Code: https://www.webslesson.info/2026/08/laravel-13-filament-5-inventory-management-system.html
━━━━━━━━━━━━━━━━━━━━━━━━━━━
📺 COMPLETE PLAYLIST — Inventory Management System in Laravel (Laravel 13 + Filament 5)
━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎬 Part 1 — Installation & Setup: https://youtu.be/796FXMF6joY
🎬 Part 2 — Database Design: https://youtu.be/5dPfGUTR9kE
🎬 Part 3 — Panel Branding & Navigation: https://youtu.be/o7jgfRGvi9s
🎬 Part 4 — Category Module: https://www.youtube.com/watch?v=UsLIgCeDshk
🎬 Part 5 — Unit Module: https://youtu.be/m8EkbuEMG-I
🎬 Part 6 — Supplier Module: https://www.youtube.com/watch?v=q7FE9loMmtM
🎬 Part 7 — Customer Module: https://youtu.be/Iy5M0yht8Fc
🎬 Part 8 — Product Module + File Upload: https://youtu.be/uZFQ2myF7nY
🎬 Part 9 — Warehouse Management: https://youtu.be/1H26vKdQFh8
🎬 Part 10 — Purchase Order Module: https://youtu.be/9novegIuDrg
🎬 Part 11 — Auto Stock Increase (Observers): https://youtu.be/rp4DGFo8blU
🎬 Part 12 — Purchase Detail View Page: https://youtu.be/HBVZ353faDk
🎬 Part 13 — Sale Management Module: https://youtu.be/VZclyNjYeX8
🎬 Part 14 — Auto Stock Decrease (Observers): https://youtu.be/7598X-LzFQc
🎬 Part 15 — Sale Detail View Page: https://youtu.be/0LCcCiau-7c
🎬 Part 16 — Stock Overview: https://youtu.be/VdpXPZHY9wk
🎬 Part 17 — Stock Adjustment: https://youtu.be/r10qOpEBJYI
🎬 Part 18 — Dashboard Widgets: https://youtu.be/tRDCtApGfH0
🎬 Part 19 — Dashboard Charts: https://youtu.be/go5mN5b57Yc
🎬 Part 20 — Stock Report: https://youtu.be/jSQILW3nd3M
🎬 Part 21 — Purchase Report: https://youtu.be/IPWet0mWko4
🎬 Part 22 — Sale Report: https://youtu.be/e22n8zT3ml8
🎬 Part 23 — Profit & Loss Report: (You are here)
🎬 Part 24 — Payment Tracking: Coming Soon
━━━━━━━━━━━━━━━━━━━━━━━━━━━
#Laravel #Laravel13 #Filament5 #FilamentPHP #LaravelTutorial #LaravelProject #LaravelProjectWithSourceCode #InventoryManagementSystem #InventoryManagementSoftware #InventoryManagementLaravel #LaravelProjectIdeas #ProfitAndLossReport #PHP #WebDevelopment #Laravel2026