Finance Reports

JobNext provides 72 analytics reports across four sub-folders within the Finance Reports module. These reports cover the full spectrum of financial operations — from vendor payables and customer receivables to statutory filings, tax compliance, and general ledger analysis. Together they support both day-to-day financial management and period-end compliance requirements.

Complete Report Inventory

The table below lists all 72 finance reports with their purpose and key filter parameters.

Accounts Payable (27 reports)

Accounts Receivable (7 reports)

Business Reports (13 reports)

Statutory Reports (18 reports)

General Ledger (7 reports)

Accounts Payable

The 27 Accounts Payable reports cover vendor management, purchase tracking, GST compliance, TDS deductions, and payables analysis. They form the backbone of the procure-to-pay reporting cycle.

Creditor Ageing

The Creditor Ageing report summarizes vendor outstanding amounts into standard ageing buckets. It is the primary tool for managing cash outflow and identifying overdue payables. The report calls the omni_sp_reports_GetVendorAgeingSummary stored procedure and displays amounts in the company's native currency.

Variants: Two additional variants are available. Creditor Ageing Bill-wise breaks down the ageing to individual bill level, showing each vendor bill's outstanding amount and its age. Creditor Ageing Job Wise groups ageing data by job, allowing project managers to see vendor exposure per project.

GST and GSTR Reports

JobNext provides a comprehensive suite of GST reports for Indian tax compliance. These reports share a common GSTIN filter populated from omni_company_master and omni_job_billing_address, with an "All TINs" option.

GST Purchase Register is the most detailed GST report, calling omni_sp_reports_GSTPurchaseRegister_v2. It lists every purchase transaction with tax breakdowns and includes a separate credit note reconciliation dataset. The GSTIN filter uses omni_fn_Finance_GetVendorBillSourceGSTIN() to resolve the correct source GSTIN.

GST Sales Register provides the sales-side complement, showing IGST, CGST, and SGST amounts for each sales transaction with credit note reconciliation.

GSTR-1 Offline Utility reports (B2B Invoice, Credit Note, HSN Summary) format data for direct import into the government's GSTR-1 offline tool. The B2B Invoice variant resolves the Place of Supply through cascading lookups: billing address, then job address, then customer address, then company address, before mapping to the GST state code.

GSTR-3B generates complete return data using three stored procedures covering Section 3.1 (outward supplies), Section 3.2 (UIN holders), and Section 4 (eligible ITC).

PO and WO Tracking

The PO Tracking Report provides end-to-end visibility into purchase order lifecycles. Filters cascade as Business Unit, then Job, then Vendor, then Purchase Order. The report produces three datasets:

• Summary: Order Value, Advance Paid, Supplied Material Value, Billed, Paid, Outstanding
• MRNs: Material Receipt Notes against the PO
• Bills: Vendor bills against the PO with status and outstanding

The WO Tracking Report follows the same pattern for work orders, with cascading filters (Division, Job, Vendor, Work Order) and datasets for order summary, measurement sheets with approval details, and vendor bills.

The Capital PO Tracking Report mirrors the PO Tracking structure but uses capital purchase order and capital MRN tables for machinery and equipment purchases.

Vendor Statement and Liabilities

The Vendor Statement is the most comprehensive AP report, combining five stored procedures into a single statement of account for a vendor:

The Vendor Liabilities Summary aggregates liabilities across vendors with optional job and business unit breakdowns. The Vendor Remittance report shows bank-wise payment remittance data including bank name, branch, IFSC, account number, currency, and amount.

Other AP Reports

TDS Register tracks TDS deductions on vendor payments with fields for payment date, vendor details, PAN, TDS section, rate, payment amount, TDS amount, and voucher number. VAT Report provides VAT analysis for purchase and sales transactions using CTEs for bill and invoice tax aggregation. Working Capital provides project-level working capital analysis with cascading Accounting Centre, Business Unit, and Job filters.

Accounts Receivable

The 7 Accounts Receivable reports serve the finance and collections teams by providing visibility into outstanding receivables, ageing analysis, and collection performance.

Debtor Ageing

The Debtor Ageing report provides a customer-level ageing summary grouping outstanding receivables into standard buckets. It calls omni_sp_reports_GetDebtorAgeingSummary_v1 and displays amounts in the company's native currency (read from the NativeCurrency system configuration key).

The Debtor Ageing Detail report is a drill-down sub-report that shows invoice-level detail for a specific customer within a specific ageing day range. It is invoked when a user clicks into a particular ageing bucket on the summary report.

The Invoice Ageing and Status report computes ageing buckets (0-30, 31-60, 61-90, 91-180, 181-365, 366-720, 720+ days) and derives invoice status (Unpaid, Paid, Certified, Approved, Created) from workflow dates and balance amounts. It uses CTE-based inline SQL to calculate outstanding balances directly from voucher entries rather than relying on a view.

Statement of Account and Collections

The Debtors Statement of Account generates a formal statement for a specific customer, showing all transactions (invoices and payments) up to the as-on date. It supports filtering by business unit, region, job, and invoice number range, and includes customer address and contact details for statement formatting.

The Payment Collection Report tracks collections received within a date range, filterable by division, region, job, and party. The Salesmanwise Collection Report groups the same collection data by salesperson, joining invoices with payment receipts and voucher records. It supports filtering by invoice status (All, Unpaid, Paid, Certified, Approved, Created) and enforces job-level security through omni_fn_CanUserAccessJob.

Business Reports

The 13 Business reports are the primary management reporting tools used by finance teams and senior leadership. They cover profit and loss analysis, job costing, profitability analytics, and sales registers.

Profit & Loss

JobNext offers multiple P&L report variants to serve different management needs:

The standard Profit and Loss report calls omni_sp_reports_ProfitLoss and groups revenue and expense ledger accounts by their chart of accounts hierarchy. Output includes Income, Direct Expenses, Indirect Expenses, and Net Profit/Loss. The isDraft parameter controls whether draft (unposted) vouchers are included — essential for management reports where provisional figures are needed before month-end closing.

The Company Profit and Loss variant uses omni_sp_reports_ProfitLoss_v1 and adds Division and Region filters. The Ungrouped variant presents line items without group subtotals. The PL Ledger Summary provides a ledger-wise breakdown designed for CFO review, showing each ledger account's individual contribution to profit or loss.

The Projected Profit and Loss combines actuals with projected figures using three datasets: projected cost, projected sales/revenue, and contribution margin. The summary variant presents the same data in condensed format.

Sales Register

The Sales Register uses omni_sp_reports_SalesRegister_Optimised for performance on large datasets. It supports Business Unit, Zone, Customer, Job, and Job Type filters.

Two additional variants are available:

• Sales Register – Invoice Wise: Shows individual invoice entries with a GST filter for GSTIN-based reconciliation.
• Sales Register – Customer Wise: Aggregates sales data at the customer level.

Job Costing and Profitability

The Job Cost report provides detailed cost analysis at the individual job level. The allocByFTE parameter controls whether indirect costs (admin, HR, facilities) are allocated proportionally based on Full-Time Equivalent headcount. Output includes direct costs, allocated costs, revenue, and margin per job.

The Profitability Analysis report slices profitability across four dimensions — BU, Customer, Contract, and Job — each usable independently or in combination. It calculates revenue, direct costs, gross margin, indirect costs, and net margin.

Statutory Reports

The 18 Statutory reports cover balance sheet, trial balance, voucher tracking, cash flow, and compliance outputs required for financial audits and regulatory filings.

Trial Balance

The system provides seven trial balance variants to serve different reporting needs. All share a common foundation: they list ledger accounts with opening balance, period debits, period credits, and closing balance, verifying that total debits equal total credits.

Common Parameters: UserID, Company, Accounting Centre, From Date, To Date. Most variants also accept an isDraft toggle to include unposted vouchers.

Output Columns: Ledger Code, Ledger Name, Opening Debit/Credit, Period Debit/Credit, Closing Debit/Credit. The "Ungrouped With Dr Cr" variant explicitly separates debit and credit into distinct columns rather than using a net balance.

Balance Sheet

The Company Balance Sheet is the primary balance sheet report, using two stored procedures to build the full statement:

• omni_sp_reports_GetALLedgerTransactions_Assets — Returns Fixed Assets, Current Assets, Investments, and other asset categories.
• omni_sp_reports_GetALLedgerTransactions_Liabilities — Returns Capital, Reserves, Current Liabilities, and Long-term Liabilities.

The report layout presents both sides with group subtotals and a balancing total. A simpler Balance Sheet variant uses a single stored procedure (omni_sp_reports_GetALLedgerTransactions) with fewer filter options.

Cash Flow Statement

The Cash Flow Statement uses multiple inline SQL datasets to build the three standard sections:

• Operating Activities: Cash receipts from customers, purchases, salaries and wages, interest paid, other operating expenses, and taxes.
• Investing Activities: Sale/purchase of fixed assets and investments.
• Financing Activities: Borrowings, loan repayments, stock issuance, stock repurchase, and dividends.

Filters include Company, Accounting Centre, Job, and Date Range.

Cash and Bank Reports

The Cash and Bank Daybook shows all cash and bank transactions with DR/CR amounts and reconciliation status (Matched or Unmatched). The Cash and Bank Transaction Audit provides an audit view showing parent and counter (child) entries for each transaction. Both use omni_sp_reports_GetLedgerOpeningBalance for opening balance calculations. The Cash Balances report shows the cash position by accounting centre as of a specified date.

Voucher and Audit Reports

The Voucher List provides a comprehensive listing of all vouchers with type, reference type, created-by, and approved-by filters. The JV List focuses specifically on journal vouchers with creator and approver tracking for segregation-of-duties compliance. The Unbalanced Vouchers report flags vouchers where total debits do not equal total credits — a pre-audit check used during month-end and year-end closing.

The Work In Progress report identifies revenue recognition gaps by calculating three WIP categories per job: draft invoices (not finalized), measured but not invoiced (certified work with no invoice), and invoiced amounts.

General Ledger

The 7 General Ledger reports serve the core accounting function by providing access to the chart of accounts, transaction histories, party balances, and bank reconciliation.

Ledger Transactions

The Ledger Transactions report is the most detailed report in the GL folder. It uses two stored procedures: omni_sp_reports_GetLedgerOpeningBalance provides the carried-forward balance as of the start date, and omni_sp_reports_GetLedgerTransactions provides line-by-line transaction detail. Together, the report layout shows a running balance for the selected ledger account.

The Ledger Transaction By Month provides a complementary monthly summary view, pivoting transaction totals across months within a financial period. It uses fnLastDayOfMonth to determine month boundaries.

Party Reports

Party Balances shows net balances grouped by party (customer, vendor, employee, machine, bank, etc.) within a financial period. Party Wise Ledger Summary provides ledger-level detail per party, showing how each party's transactions are distributed across ledger accounts. Both support filtering by party type, specific party, ledger, and business unit.

Chart of Accounts and Bank Reconciliation

The Chart Of Accounts report uses a recursive CTE on omni_account_group to display the full hierarchical tree of account groups, then appends leaf-level ledger accounts from omni_account_ledger. It is primarily used for reference and auditing the account structure.

The Unmatched Bank Entries report lists payments and receipts not yet reconciled against bank statement lines. It filters on is_reconciled=0 and is a critical tool for the bank reconciliation workflow.

Common Filters

Most finance reports share a consistent set of filter parameters. The table below describes the filters you will encounter across the report suite.

Best Practices

• Run Trial Balance before P&L and Balance Sheet — Verify that debits equal credits before generating higher-level financial statements. Use the Unbalanced Vouchers report as a pre-check.
• Review ageing reports weekly — Both Creditor Ageing and Debtor Ageing should be reviewed at least weekly to maintain healthy cash flow and vendor/customer relationships.
• Reconcile bank accounts monthly — Use the Unmatched Bank Entries report and Cash and Bank Daybook together. Do not let bank reconciliation fall behind.
• Close the period before generating statutory reports — Ensure all transactions have been entered and approved. Pending vouchers and unapproved invoices will not appear in balances unless the "Include Drafts" toggle is enabled.
• Use the istabular toggle for exports — When you need to export report data to Excel for further analysis, enable the tabular toggle for a flat, export-friendly layout.
• Match GSTR reports against filed returns — Run the GST Purchase Register and GST Sales Register at the end of each filing period and reconcile against your GST return workings. Investigate discrepancies immediately.
• Archive period-end reports — Export and save financial statements at each period close for historical comparison and audit support.
• Use cascading filters efficiently — Start with the broadest filter (Company), then narrow down through Accounting Centre, Division, and Job. This ensures each subsequent dropdown is correctly scoped.

Frequently Asked Questions