Report Menu

In Report Menu user can view business reports as per branch, date range, account, party, item and transaction filters.

How to select the option required for “Report Menu”?

• From Main Menu
• Select Reports
• Select required report group and submenu

Detailed Menu Information

1) Ledgers

• Account Ledger: Account-wise transaction details with running balance.
• Party Ledger: Debtor/Creditor-wise ledger.
• Mainhead wise Ledger / Party Ledger: Grouped reporting by mainhead.
• General Ledger: Consolidated ledger entries.
• Service Item Ledger / Summary: Service item-wise transaction view.

2) Account Balances / Monthly Balances

• Account Balances: Closing balance of account heads.
• Party Balances: Closing balance of parties.
• Monthly Balances: Month-wise movement and balances.

3) Account Reports / Agewise Reports

• Account Reports: Master/summary analysis reports.
• Agewise Reports: Pending amount age analysis.

4) Manual Matching (Outstanding)

• Match Debit Credit Entries: Match transactions for settlement.
• Opening Bill Entries: Opening outstanding bill setup.
• Remove Matching / Remove Matching (All Parties): Undo matching.
• Manual Matching Reports: Matched/unmatched statement.
• Matched Entries Reports: Final matching status report.
• Receipts with Age: Outstanding bills with ageing.
• Collection Analysis Report: Collection follow-up summary.

5) Stock Reports

• Stock Ledger: Item-wise stock movement.
• Stock Balances: Available quantity by item.
• Stock Valuation: Value of current stock.
• Stock Balances with Valuation: Quantity + value together.
• Stock Valuation FIFO: FIFO method stock value.
• Reorder Level Report: Minimum stock alert list.

6) Excise Registers

• Excise/statutory stock and movement register.
• Used for compliance and audit reference.

7) Sales Reports

• Scheme Reports (Automatic/Defined): Scheme performance.
• Monthly Sales Comparison / Daywise Sales: Time-based sales trend.
• Brandwise Sizewise Sales: Brand-size split sales analysis.
• Partywise Brandwise Discounts: Discount tracking.
• Ratewise / Rate Difference / Rate Master Difference: Price and margin variation.
• Salesman Performance / Commission / Targets: Team KPI reports.
• Primary & Secondary Sales / Outlet Analysis: Market-level sales view.
• Vehiclewise / Partywise LiquorTypewise / Batchwise / Brandwise Sales: Specialized sales analysis.

8) Purchase Reports

• Monthly Purchase Comparison: Month-on-month purchase analysis.
• Daywise Purchase Report: Daily purchase movement.
• Brandwise Sizewise Purchase: Brand-size purchase details.
• Partywise LiquorTypewise Purchase: Supplier + liquor category analysis.

9) Other Reports

• Interest Calculation: Interest computation on pending balances.
• Collection Reports / Bank Reconciliation: Recovery and bank matching reports.
• TCS/Surcharge Reports: TCS statutory reporting set.
• Tax Reports: Summary and month-wise tax reporting.
• Trial Balance / TB To Entry / BS To Entry: Finalization support reports.
• Balance Sheet: Financial position statement.
• Graphical Reports: Trend and comparative visual charts.
• Projected Receipts / Daily Final Report / User Report: Monitoring and planning reports.

Pre requisites for Report Menu

• Account Head Master
• Party Master
• Item Master
• Service Item Master
• Transaction postings completed
• Option set and user rights configured

The modes available are

• VIEW mode

VIEW mode

• User can view report information using filters like date range, trade, account, party, item and transaction type.