Reports Overview

Versoll Books provides a comprehensive set of reports to help you analyze business performance, track outstanding balances, manage inventory, and stay compliant with tax regulations. This guide covers all available reports and when to use each one.

Accessing Reports

All reports are available from the Reports section in the main navigation. Each report can be filtered, sorted, and exported as needed.

Financial Reports

These reports provide a view of overall business health and are essential for management decisions and compliance.

Balance Sheet

Shows assets, liabilities, and equity at a specific point in time. Use it to understand what the business owns and owes.

• When to use: Month-end review, loan applications, investor reporting.
• Key insight: Total Assets must equal Total Liabilities plus Equity.

Profit and Loss

Displays income and expenses over a period, calculating net profit or loss.

• When to use: Monthly performance review, budgeting, tax planning.
• Key insight: Track gross margin and operating expenses separately.

Trial Balance

Lists all accounts with opening balances, period transactions, and closing balances.

• When to use: Before closing books, audit preparation, error detection.
• Key insight: Total debits must equal total credits.

General Ledger

Complete transaction history for all accounts with source document references.

• When to use: Investigating specific transactions, audit evidence, reconciliation.
• Key insight: Group by account or party for focused analysis.

Ageing Reports

Track outstanding balances by age to manage cash flow and collections.

The report shows outstanding amounts in these categories:

• 0-30 days: Current, within standard payment terms.
• 31-60 days: Slightly overdue, follow up recommended.
• 61-90 days: Significantly overdue, escalate collection.
• 90+ days: Severely overdue, consider write-off or legal action.

Use Payables Ageing to:

• Prioritize payments based on age and supplier relationships.
• Identify invoices approaching due dates.
• Plan cash outflows for the coming weeks.
• Negotiate better terms with vendors for early payments.

Inventory Reports

Monitor stock levels and movement across locations.

The Stock Balance report shows for each item:

• Opening Quantity/Value: Stock at the start of the period.
• Incoming Quantity/Value: Stock received during the period.
• Outgoing Quantity/Value: Stock sold or transferred.
• Balance Quantity/Value: Current stock on hand.
• Valuation Rate: Average cost per unit.

Filter the Stock Ledger by:

• Item: View transactions for a specific product.
• Location: Filter by warehouse or store.
• Batch: Track specific batch movements (if enabled).
• Date Range: Analyze a specific period.

GST Reports

Generate filing-ready reports for GST compliance.

GSTR-1 includes:

• B2B sales with GSTIN details.
• B2C sales summary by rate.
• HSN-wise summary of items sold.
• Exports and zero-rated supplies.

GSTR-2 shows purchase invoices organized by:

• Supplier GSTIN and invoice details.
• Tax amounts split by CGST, SGST, IGST.
• Eligible input tax credit.

GSTR-3B provides:

• Output tax liability by rate.
• Input tax credit available.
• Net GST payable after set-off.

TDS Reports

Track tax deducted at source for compliance and payment.

TDS Summary helps with:

• Tracking total TDS deducted by category.
• Identifying amounts due for deposit.
• Preparing quarterly TDS returns.

TDS Payable shows:

• Section-wise TDS amounts.
• Due dates for government deposit.
• Deductee details for certificate generation.

E-Way Bill Register

Track all E-Way Bills created for goods movement.

The register displays:

• E-Way Bill Number: Unique identifier.
• Status: Active, Cancelled, or Expired.
• Validity Date: When the bill expires.
• Linked Invoice: Reference to the source document.
• Transport Details: Vehicle and transporter information.

Common Report Actions

All reports support these standard actions:

Filtering

Use the filter panel at the top of each report to narrow down data. Common filters include date range, account, party, and document type.

Sorting

Click column headers to sort data ascending or descending. Some reports offer an Ascending Order checkbox in filters.

Exporting

Click the Export button to download the report. Choose PDF for printing or Excel for further analysis.

Pagination

Large reports use pagination. Navigate between pages using the controls at the bottom of the report.

Report Schedule Recommendations

Establish a regular reporting routine:

• Daily: Review dashboard for quick insights.
• Weekly: Run Receivables Ageing and Payables Ageing.
• Monthly: Generate Balance Sheet, P&L, and GST reports.
• Quarterly: Prepare TDS summary and compare to previous quarters.
• Annually: Run full Trial Balance and archive all reports.