how to prepare p&l - Apna Tax Consultant

How to Prepare Profit & Loss (P&L) Statement from Bank Statement

This standardized process ensures accurate, consistent, and audit-ready monthly P&L statements directly from bank transactions.

Step 1: Classify Transactions as Income or Expense

Credit (Cr) → Money received into the account → Treat as Income
Debit (Dr) → Money paid out from the account → Treat as Expense

Step 2: Apply These Standard Categories

Income Categories

Sales / Business Income
UPI Received (General Income)
IMPS Received
Refunds
Interest Received

Expense Categories

Travel/Transport (IRCTC, Railway, Taxi, etc.)
Office Purchases (Tools, Supplies, Parts)
Personal/General Expenses (Food, Hotel, Cosmetics)
Vendor Payments (Textile, Electrical, Kirana, etc.)
Small Cash Expenses
Other Miscellaneous Expenses

Step 3: Sample Categorized Transactions

Date	Description	Amount	Type	Category
01-10-2025	Tourist Hotel	1,500	Credit	Refund / Reversal
01-10-2025	NAVI TECHNOLOGI	600	Debit	Personal Expense
01-10-2025	REFINED POLYMERS	1,500	Credit	Business Income
01-10-2025	Aditya Raj	3,000	Credit	General Income
02-10-2025	Hemant Kumar	2,995	Debit	Vendor Payment

Step 4: Instructions for Team Members

            Task 1 — Enter all transactions in Excel with these columns:

                    Date | Description | Amount | Credit/Debit | Category
                
Task 2 — Calculate:

                    • Total Income (Sum of all Credits)

                    • Total Expenses (Sum of all Debits)

                    • Net Profit = Total Income − Total Expenses
                
Task 3 — Prepare a clean monthly Profit & Loss statement (final format will be shared separately)

Following this method ensures 100% consistency, eliminates errors, and enables faster monthly financial closing.

[smartslider3 slider="2"]