Reports Management
Reports in simpleBillBook provide valuable insights into your business performance, helping you make data-driven decisions. This guide covers all available reports, how to generate them, and how to interpret the data for better business management.
Overview of Reports
Reports help you:
- Track Performance: Monitor sales, purchases, and profitability
- Comply with Regulations: Generate GST-compliant tax reports
- Manage Inventory: Track stock levels and movements
- Control Costs: Analyze expenses and identify savings opportunities
- Make Decisions: Base business decisions on accurate data
Reports Dashboard
To access reports:
- Navigate to Reports from the main sidebar
- You'll see the main reports menu categorized by business function
Figure 1: Reports dashboard showing all available report categories
Reports Categories:
Sales & Tax Reports
- GST Sales (With HSN)
- HSN Wise Sales Summary
- Sales Summary
- GST Purchase (With HSN)
- Expense Summary
- Profit and Loss
- GSTR1
- GSTR2
Inventory Reports
- Stock Summary
- Stock Detail Report
- Sales And Purchase Summary
- Rate List Of Products
- Products Wise Sale Report
Sales & Tax Reports
1. GST Sales Report (With HSN)
Figure 2: GST Sales report with HSN code details
Purpose: Generate GST-compliant sales reports with HSN code classification for tax filing.
Report Columns:
| Column | Description |
|---|---|
| Date | Invoice date |
| Invoice No | Unique sales invoice number |
| Party GSTIN | Customer's GST Identification Number |
| Party Name | Customer name |
| Item Name | Product or service sold |
| HSN Code | Harmonized System of Nomenclature code |
| QTY | Quantity sold |
| Price/Unit | Selling price per unit |
| SGST | State Goods and Services Tax amount |
| CGST | Central Goods and Services Tax amount |
| IGST | Integrated Goods and Services Tax amount |
| Amount | Total invoice amount |
Features:
- Select A Date Range: Filter by custom date period
- Search: Find specific transactions
- Export PDF: Generate printable PDF report
2. HSN Wise Sales Summary
Figure 3: Sales summary grouped by HSN code
Purpose: Summarize sales by HSN code for tax classification and reporting.
Report Columns:
| Column | Description |
|---|---|
| HSN Code | Harmonized System of Nomenclature code |
| Item Name | Product name |
| QTY | Total quantity sold |
| Price Value | Total sales value before tax |
| Taxable Value | Value on which tax is calculated |
| SGST | Total State GST collected |
| CGST | Total Central GST collected |
| IGST | Total Integrated GST collected |
| Total Tax Amount | Sum of all taxes |
Use Cases:
- GST return filing
- Tax liability calculation
- Product category performance analysis
3. Sales Summary Report
Figure 4: Sales summary report by customer and date range
Purpose: Track and analyze sales transactions with customer-wise details, due dates, and payment status.
Report Columns:
| Column | Description |
|---|---|
| Date | Invoice date |
| Invoice Number | Unique sales invoice identifier |
| Customer Name | Customer name |
| Due Date | Payment due date |
| Amount | Total invoice amount |
| Balance Amount | Outstanding balance to be paid |
| Status | Payment status (Paid, Unpaid, Partial) |
Features:
- Choose A Customer: Filter sales by specific customer
- Select A Date Range: Filter by custom date period
- Search: Find specific invoices or customers
- Export PDF: Generate printable sales summary report
Use Cases:
- Track customer-wise sales performance
- Monitor outstanding receivables
- Identify overdue payments
- Analyze sales trends over time
- Prepare customer statements
Business Insights:
- Which customers generate the most revenue
- Payment patterns and delays by customer
- Seasonal sales variations
- Average collection period
4. Margin Summary Report
Figure 5: Margin Summary report showing sales, purchase price, profit, discount, and payment status
Purpose: Track sales margins and profitability by comparing selling prices with purchase prices for each invoice.
Report Columns:
| Column | Description |
|---|---|
| Date | Invoice or sales transaction date |
| Invoice Number | Unique invoice number |
| Customer Name | Name of the customer |
| Due Date | Payment due date for the invoice |
| Selling Price | Total selling price of the invoice |
| Purchase Price | Total purchase cost of the products |
| Profit | Profit earned from the sale |
| Discount | Discount provided on the invoice |
| Balance Amount | Outstanding amount to be collected |
| Status | Payment status of the invoice |
Features:
- Customer Filter: Select a specific customer to view their margin details
- Date Range Filtering: Select a custom period to analyze sales margins
- Search: Generate the report based on the selected filters
- Export PDF: Download the margin summary as a PDF for records
- Export Excel: Export the report to Excel for further analysis
Importance:
- Monitor overall sales profitability
- Compare selling price with purchase cost
- Identify profitable and low-margin sales
- Track discounts and their impact on profit
- Monitor outstanding customer balances
- Maintain detailed financial records
5. Payment Mode Report
Figure 6: Payment Mode Report showing invoice-wise payment details and payment status
Purpose: Track customer payments based on different payment methods and monitor the amount paid against each invoice.
Report Columns:
| Column | Description |
|---|---|
| Date | Date of the payment transaction |
| Invoice Number | Unique invoice number associated with the payment |
| Customer Name | Name of the customer |
| Payment Method | Method used for making the payment, such as Cash, UPI, Card, or Bank Transfer |
| Reference No | Reference or transaction number associated with the payment |
| Amount | Total invoice amount |
| Paid Amount | Amount paid by the customer |
| Status | Payment status, such as Paid or Partial |
Features:
- Date Range Filtering: Select a specific date range to view payment transactions
- Payment Method Filter: Filter transactions based on the selected payment method
- Search: Generate the report using the selected filters
- Reset: Clear the selected filters and restore the default report view
- Export PDF: Download the payment mode report in PDF format
- Export Excel: Export payment details to Excel for further analysis
Importance:
- Track payments received from customers
- Monitor payments by different payment methods
- Identify partially paid invoices
- Reconcile payment transactions with records
- Maintain accurate payment and collection records
11. GSTR2 Report
Figure 12: GSTR2 report covering Purchase and Purchase Return details with GST information
Purpose: Generate a detailed GST report for purchase transactions and purchase returns, including supplier details, invoice information, taxable values, and applicable GST amounts.
Report Sections:
1. Purchase
Displays GST and invoice details for purchase transactions from suppliers.
| Column | Description |
|---|---|
| GSTIN | GST Identification Number of the supplier |
| Supplier Name | Name of the supplier or vendor |
| State Code | State code of the supplier's state |
| State Name | Name of the supplier's state |
| Invoice No. | Unique purchase invoice number |
| Original Invoice No. | Original invoice number related to the transaction, when applicable |
| Invoice Date | Date of the purchase invoice |
| Invoice Value | Total value of the purchase invoice |
| Total Tax % | GST rate applicable to the purchase |
| Taxable Value | Value of the purchase before GST |
| Central Tax (CGST) | Central Goods and Services Tax amount |
| State/UT Tax (SGST) | State GST or Union Territory GST amount |
| Integrated Tax (IGST)* | Integrated Goods and Services Tax amount |
2. Purchase Return
Displays GST details for purchase returns and debit notes issued against suppliers.
| Column | Description |
|---|---|
| GSTIN | GST Identification Number of the supplier |
| Supplier Name | Name of the supplier or vendor |
| State Code | State code of the supplier's state |
| State Name | Name of the supplier's state |
| Invoice No. | Purchase return or debit note invoice number |
| Invoice Date | Date of the purchase return transaction |
| Invoice Value | Total value of the purchase return or debit note |
| Invoice Type | Type of transaction, such as Debit Note |
| Total Tax % | GST rate applicable to the purchase return |
| Taxable Value | Taxable value of the returned goods |
| Central Tax (CGST) | Central GST amount associated with the return |
| State/UT Tax (SGST) | State GST or Union Territory GST amount |
| Integrated Tax (IGST) | Integrated GST amount |
Features:
- Date Range Filtering: Select a specific period to generate the GSTR2 report
- Purchase Tab: View GST and invoice details for purchase transactions
- Purchase Return Tab: View details of purchase returns and debit notes
- Search: Generate report data based on the selected date range
- Reset: Clear the selected date range and restore the report
- Export PDF: Download the selected GSTR2 report in PDF format
- Export Excel: Export GSTR2 data to Excel for further analysis and record keeping
Importance:
- Maintain organized purchase GST records
- Track GST paid on business purchases
- Review supplier and invoice details
- Monitor purchase returns and debit notes
- Analyze taxable purchase values and GST amounts
- Support GST reconciliation and compliance
- Maintain accurate records for input tax credit analysis
6. GST Purchase Report (With HSN)
Figure 5: GST Purchase report with HSN code details
Purpose: Track purchases with GST details for input tax credit claims.
Report Columns:
| Column | Description |
|---|---|
| Date | Purchase date |
| Purchase No | Unique purchase entry number |
| Vendor GSTIN | Vendor's GST Identification Number |
| Vendor Name | Vendor/supplier name |
| Item Name | Product purchased |
| HSN Code | HSN classification code |
| QTY | Quantity purchased |
| Price/Unit | Purchase price per unit |
| SGST | State GST paid |
| CGST | Central GST paid |
| IGST | Integrated GST paid |
| Amount | Total purchase amount |
Features:
- Date Range Filtering: Select custom period
- Search: Find specific purchases
- Export PDF: Download for records or tax filing
Importance:
- Claim input tax credit
- Reconcile with vendor statements
- Track GST paid on purchases
7. Expense Summary
Figure 6: Expense summary report by category
Purpose: Track and analyze business expenses by category.
Report Columns:
| Column | Description |
|---|---|
| Expense Number | Unique expense entry identifier |
| Expense Date | Date expense was incurred |
| Category | Expense category (e.g., digital, home appliance) |
| Quantity | Number of items or units |
| Total Amount | Total expense value |
Features:
- Choose A Category: Filter by specific expense category
- Date Range: Select reporting period
- Search: Find specific expense entries
- Export PDF: Generate expense report
Analysis:
- Identify major expense categories
- Track spending patterns over time
- Budget vs. actual comparison
- Tax deduction preparation
6. Profit & Loss Report
Figure 7: Profit & Loss Report showing sales, purchases, taxes, expenses, stock value, and net profit
Purpose: Analyze the business's financial performance by summarizing income, expenses, taxes, inventory value, and net profit for a selected period.
Report Columns:
| Column | Description |
|---|---|
| Particulars | Financial categories included in the profit and loss calculation |
| Sales (+) | Total sales generated during the selected period |
| Credit Notes (-) | Amount deducted for credit notes issued to customers |
| Purchases (-) | Total purchase cost incurred during the selected period |
| Debit Notes (+) | Amount added through debit notes |
| Tax Payable (-) | Tax collected on sales and payable to the government |
| Tax Receivable (+) | Tax paid on purchases that can be received or claimed as input tax credit |
| Stock Value (+) | Value of the ending inventory for the selected period |
| Expenses (-) | Operating expenses incurred by the business |
| Net Profit | Final profit calculated after considering applicable income, costs, taxes, stock value, and expenses |
Features:
- Date Range Filtering: Select a specific period to generate the profit and loss report
- Search: Generate the report based on the selected date range
- Export PDF: Download the Profit & Loss report in PDF format
- Export Excel: Export the report to Excel for further analysis and record keeping
Importance:
- Monitor overall business profitability
- Analyze income and operating expenses
- Track purchases and sales performance
- Review tax payable and tax receivable amounts
- Monitor the value of ending inventory
- Understand the business's net profit for a selected period
10. GSTR1 Report
Figure 11: GSTR1 report covering Sales, Sales Return/Credit Note, and Purchase Return/Debit Note details
Purpose: Generate a comprehensive GST report containing sales invoices, sales returns/credit notes, and purchase returns/debit notes with detailed GST and invoice information for the selected date range.
Report Sections:
1. Sales
Displays GST and invoice details for sales transactions.
| Column | Description |
|---|---|
| GSTIN | GST Identification Number of the customer |
| Customer Name | Name of the customer |
| State Code | State code of the customer's state |
| Place of Supply | State or location where the goods/services are supplied |
| Invoice Number | Unique sales invoice number |
| Invoice Date | Date of the sales invoice |
| Invoice Value | Total value of the invoice |
| Total Tax (%) | GST rate applicable to the invoice |
| Taxable Value | Value of goods/services before GST |
| CGST | Central Goods and Services Tax amount |
| SGST/UTGST | State GST or Union Territory GST amount |
| IGST | Integrated Goods and Services Tax amount |
| Total Tax | Total GST amount charged on the invoice |
2. Sales Return / Credit Note
Displays GST details for sales returns and credit notes issued to customers.
| Column | Description |
|---|---|
| GSTIN | GST Identification Number of the customer |
| Customer Name | Name of the customer |
| State Code | State code of the customer's state |
| Place of Supply | State or location where the original supply was made |
| Invoice Number | Invoice or credit note reference number |
| Invoice Date | Date of the transaction |
| Invoice Value | Total value of the credit note or return |
| Invoice Type | Type of transaction, such as Credit Note |
| Total Tax (%) | GST rate applicable to the transaction |
| Taxable Value | Taxable value after considering the return |
| CGST | Central GST amount |
| SGST/UTGST | State GST or Union Territory GST amount |
| IGST | Integrated GST amount |
| Total Tax | Total GST amount associated with the return or credit note |
3. Purchase Return / Debit Note
Displays GST details for purchase returns and debit notes related to vendors.
| Column | Description |
|---|---|
| GSTIN | GST Identification Number of the vendor |
| Vendor Company Name | Name of the vendor or supplier |
| State Code | State code of the vendor's state |
| Place of Supply | State or location where the purchase was made |
| Invoice Number | Invoice or debit note reference number |
| Invoice Date | Date of the transaction |
| Invoice Value | Total value of the debit note or purchase return |
| Invoice Type | Type of transaction, such as Debit Note |
| Total Tax (%) | GST rate applicable to the transaction |
| Taxable Value | Taxable value of the returned purchase |
| CGST | Central GST amount |
| SGST/UTGST | State GST or Union Territory GST amount |
| IGST | Integrated GST amount |
| Total Tax | Total GST amount associated with the purchase return or debit note |
Features:
- Date Range Filtering: Select a specific period to generate the GSTR1 report
- Sales Tab: View GST details for sales invoices
- Sales Return/Credit Note Tab: View details of sales returns and credit notes
- Purchase Return/Debit Note Tab: View details of purchase returns and debit notes
- Search: Generate report data based on the selected date range
- Reset: Clear the selected date range and restore the report
- Export PDF: Download the selected GSTR1 report in PDF format
- Export Excel: Export GSTR1 data to Excel for further analysis and record keeping
Importance:
- Maintain organized GST transaction records
- Track GST collected on sales
- Monitor sales returns and credit notes
- Track purchase returns and debit notes
- Review taxable values and GST amounts
- Simplify GST reconciliation and reporting
- Prepare transaction data for GST compliance and filing
Inventory Reports
1. Stock Summary Report
Figure 7: Current stock position with quantities and values
Purpose: Get a snapshot of current inventory levels and stock value.
Report Columns:
| Column | Description |
|---|---|
| Item Name | Product name |
| Item Code | Unique product identifier |
| Purchase Price | Cost price per unit |
| Selling Price | Retail price per unit |
| Stock Quantity | Current available quantity |
| Stock Value | Total value of current stock (Qty × Purchase Price) |
Sample Data:
| Item Name | Item Code | Purchase Price | Selling Price | Stock Qty | Stock Value |
|---|---|---|---|---|---|
| micro oven | 01 | ₹8,000.00 | ₹9,000.00 | 5 | ₹40,000.00 |
| dishwasher | 2 | ₹13,000.00 | ₹14,000.00 | 10 | ₹1,30,000.00 |
| home theatre | 112 | ₹5,000.00 | ₹8,000.00 | 5 | ₹25,000.00 |
| tablet | 23 | ₹25,000.00 | ₹30,000.00 | 2 | ₹50,000.00 |
| ac | 111 | ₹50,000.00 | ₹60,000.00 | 6 | ₹3,00,000.00 |
| ref | 33 | ₹50,000.00 | ₹60,000.00 | 5 | ₹2,50,000.00 |
Use Cases:
- Inventory valuation
- Reorder planning
- Capital tied up in inventory
- Profit margin analysis
2. Stock Detail Report
Figure 8: Detailed stock movement history for specific products
Purpose: Track stock movements and transaction history for individual products.
Report Columns:
| Column | Description |
|---|---|
| Date | Transaction date |
| Transaction Type | Purchase, Sale, Return, Adjustment |
| QTY | Quantity added or removed |
| Closing Stock | Balance after transaction |
| Reference No. | Invoice, purchase, or order number |
Features:
- Choose A Product: Select specific item to analyze
- Search: Find specific transactions
- Export PDF: Download movement history
Analysis:
- Identify fast-moving vs. slow-moving items
- Track stock receipt and issue patterns
- Audit inventory transactions
- Investigate stock discrepancies
3. Sales And Purchase Summary
Figure 9: Comparison of sales and purchase quantities by product
Purpose: Compare sales volume against purchase volume for each product.
Report Columns:
| Column | Description |
|---|---|
| Item Name | Product name |
| Item Code | Unique product identifier |
| Sale Quantity | Total units sold in period |
| Purchase Quantity | Total units purchased in period |
| Difference | Sale Qty - Purchase Qty (net position) |
Features:
- Date Range Selection: Filter by custom period
- Search: Find specific products
- Export PDF: Generate comparative report
Business Insights:
- Identify best-selling products
- Detect stock shortages or excess
- Plan purchasing based on sales velocity
- Calculate stock turnover rate
4. Rate List of Products
Figure 10: Complete price list of all products
Purpose: Generate a comprehensive price list for all products with selling prices.
Report Columns:
| Column | Description |
|---|---|
| Item Name | Product name |
| Item Code | Unique product identifier |
| Selling Price | Current retail price |
Sample Data:
| Item Name | Item Code | Selling Price |
|---|---|---|
| ac | 111 | ₹60,000.00 |
| dishwasher | 2 | ₹14,000.00 |
| home theatre | 112 | ₹8,000.00 |
| laptop | 04 | ₹25,000.00 |
| macbook | 60 | ₹70,000.00 |
| micro oven | 01 | ₹9,000.00 |
| mobile | 22 | ₹40,000.00 |
| ps5 | 44 | ₹45,000.00 |
| ref | 33 | ₹60,000.00 |
| tablet | 23 | ₹30,000.00 |
| tv | 11 | ₹25,000.00 |
| washing machine | 55 | ₹60,000.00 |
Use Cases:
- Share price list with customers
- Train sales staff on pricing
- Audit price consistency
- Prepare catalogs and quotations
Common Report Features
Date Range Selection
Most reports include date range filters allowing you to:
- Select predefined periods (Today, This Week, This Month, This Quarter, This Year)
- Set custom start and end dates
- Compare periods (Month-over-Month, Year-over-Year)
Search Functionality
- Search across all columns
- Find specific transactions, customers, vendors, or products
- Filter by keywords or exact matches
Customer Filtering
Reports like Sales Summary allow filtering by:
- Specific customer to view their transaction history
- All customers for complete overview
- Customer groups or categories
Export Options
- Export PDF: Generate formatted PDF reports for printing or sharing
- Format may include company logo, headers, and footers
- Professional presentation for clients or tax authorities
Best Practices for Report Generation
1. Regular Reporting Schedule
- Daily: Quick sales and cash position
- Weekly: Sales trends, stock movement
- Monthly: Complete financial and GST reports
- Quarterly: Business performance review
- Annually: Annual summary for tax filing
2. Data Accuracy
- Ensure all transactions are entered correctly
- Reconcile reports with bank statements
- Investigate and correct discrepancies promptly
- Maintain clean master data (HSN codes, product details)
3. Report Interpretation
- Understand what each metric represents
- Compare against historical data for trends
- Look for anomalies or unusual patterns
- Share insights with relevant team members
4. Documentation
- Save critical reports for audit trail
- Maintain organized report archive
- Document report definitions and calculations
- Note any adjustments or corrections
5. Compliance
- Ensure GST reports match filed returns
- Retain reports as required by tax laws
- Generate reports before tax due dates
- Verify HSN code accuracy
Integration with Other Modules
Sales Module:
- GST Sales Report: Pulls data from sales invoices
- Sales Summary: Aggregates customer-wise sales data
- HSN Summary: Aggregates by product classification
- Rate List: Uses current selling prices
Customer Management:
- Sales Summary: Links to customer profiles
- Customer Filtering: View sales by specific customer
- Outstanding Tracking: Monitor customer balances
Purchase Module:
- GST Purchase Report: Uses purchase entry data
- Input Tax Credit: Tracks GST paid on purchases
Inventory Module:
- Stock Summary: Real-time inventory position
- Stock Detail: Transaction history by product
- Sale vs. Purchase: Comparative analysis
Expense Module:
- Expense Summary: Categorized expenditure tracking
Common Scenarios and Solutions
Scenario 1: Preparing for GST Return Filing
Solution:
- Generate GST Sales (With HSN) report for the tax period
- Generate HSN Wise Sales Summary for classification
- Generate GST Purchase (With HSN) report for input tax credit
- Verify totals against GSTR-1 and GSTR-3B requirements
- Export PDF for records and audit trail
Scenario 2: Monthly Business Review Meeting
Solution:
- Run Sales Summary for month-over-month comparison
- Filter by customer to identify top clients
- Generate Expense Summary by category
- Check Stock Summary for inventory health
- Prepare Rate List for pricing review
- Export all reports to PDF for presentation
Scenario 3: Customer Account Statement
Solution:
- Navigate to Sales Summary report
- Select specific customer from "Choose A Customer" dropdown
- Set appropriate date range
- View all invoices with due dates and balances
- Export PDF to share with customer
Scenario 4: Stock Audit and Reorder Planning
Solution:
- Run Stock Summary to identify low-stock items
- Generate Sales And Purchase Summary for movement analysis
- Check Stock Detail Report for fast-moving items
- Create purchase orders based on data
Scenario 5: Overdue Payment Tracking
Solution:
- Generate Sales Summary report
- Filter by date range
- Sort by due date and balance amount
- Identify customers with overdue invoices
- Initiate collection follow-up
Scenario 6: Expense Control Review
Solution:
- Generate Expense Summary by date range
- Filter by category to identify high-cost areas
- Compare with previous periods
- Investigate significant increases
- Implement cost control measures