Reports

For: Anyone who needs a ledger, aging buckets, or gross profit from posted books — not charts

This module is a catalog of ledgers, aging, and gross profit. You pick a report, set filters, then run it. The table is posted books data at that moment — not Analytics charts, and not an overnight batch.

Sidebar → Reports → click a report → set filters → Apply Filters → read or Export Report

What Reports is

1. Open the catalog

Title is Reports. Columns are Report Name, Type, Created By (always System Generated). Grey header rows are groups with a count.

1. 1

   Open Reports in the left sidebar.

2. 2

   Find the group, then click the Report Name to open that report.

3. 3

   Use the back arrow on any report to return to this catalog.

Path into each group:

2. Filters, Apply, and date presets

Changing a dropdown does not load the table. Set the filters, then run the report.

1. 1

   If the bar is hidden, click View Filters (toggles to Hide Filters).

2. 2

   Fill the required picker first where the report has one — Customer, Item, or Bank. Apply does not skip a required field.

3. 3

   Where both exist: Division → Branch. Branch stays disabled until Division is set, and only shows branches of those divisions.

4. 4

   Set the date range or Financial Year, then click Apply Filters.

5. 5

   Active filters show as tags under the bar. Clear one tag, or click Reset All to clear the report.

Date presets on a range picker:

Today → Last 7 Days → Last 15 Days → Last Month → Last 3 Months → Custom Range → Specific Date

3. Export Report

Export is not on every report. Where it exists, use this path:

Export Report → PDF or XLSX → filename in the modal → export

1. 1

   Open Export Report in the header. Only the formats that report supports appear (table below).

2. 2

   The modal asks for a filename. Default is the report name plus today's date. PDF uses the organisation profile.

3. 3

   Sales Ledger and Purchase Ledger month detail also offer XLSX through an export-data modal. Their monthly summary is PDF only.

The reports

1. Accountant — General Ledger

Party-wise debit / credit statement for one contact. Opening balance, period lines, closing balance. Extra pages show Brought Forward / Carried Over. You can also land here from a customer with customerId already set.

Reports → General Ledger → Customer → date / Division / Branch → Apply Filters

1. 1

   Pick Customer (required). The picker shows Customer ID, Customer Name, and Role.

2. 2

   Set date range, then Division → Branch. If a split session is on, a Split switch appears. If the party is linked as vendor and/or customer, a switch includes the linked data.

3. 3

   Click Apply Filters. Click a voucher row to open the source document. Export Report → PDF or XLSX.

2. Item — Item Ledger

Quantity in and out for one item over a date range, with opening and closing qty rows. This is the period movement report. View Inventory is on-hand qty and value with no date range.

Reports → Item Ledger → Item → date / Division / Branch → Apply Filters

Other way in:

View Inventory → View Ledger → this report for that item

1. 1

   Pick Item (required), then date range, Division, Branch. Split appears when a split session is on. Click Apply Filters.

2. 2

   Click Doc No to open the posting document (Quote, Sales Order, Delivery Challan, Invoice, Purchase Order, GRPO, Bill, Production, Credit Note, Debit Note, Transfer, and the others that actually posted that line).

3. 3

   Export Report → PDF or XLSX.

3. Bank — Bank Ledger

Statement for one bank account: opening balance, movements, available balance.

Reports → Bank Ledger → Bank → date / Division / Branch → Apply Filters

1. 1

   Pick Bank (required), then date range, Division, Branch. Click Apply Filters.

2. 2

   Export Report → PDF or XLSX.

4. Sales — Sales Ledger

Two screens. First is a financial-year monthly summary with a column chart. Click a month for that month's invoices. There is no GST column set and no invoice-status filter.

Reports → Sales Ledger → Financial Year / Division / Branch → Apply Filters → click a month → invoice lines

1. 1

   Set Financial Year (April–March, current FY by default), then Division → Branch. Click Apply Filters.

2. 2

   Read the monthly table and chart. Export this summary as PDF only.

3. 3

   Click a month. Detail uses that month's date range plus Division / Branch. Export detail as PDF or XLSX.

5. Purchase Ledger

Same shape as Sales Ledger, for bills: FY monthly summary, then bill lines for the month you click.

Reports → Purchase Ledger → Financial Year / Division / Branch → Apply Filters → click a month → bill lines

1. 1

   Set Financial Year, Division → Branch. Click Apply Filters.

2. 2

   Export the monthly summary as PDF only.

3. 3

   Click a month for bill lines. Export that detail as PDF or XLSX.

6. Creditors Ledger

Vendor-wise balances. Total / Brought Forward / Carried Over stay on the list. Click a vendor for that party's statement (same debit/credit layout as General Ledger).

Reports → Creditors Ledger → date / Type / Division / Branch → Apply Filters → click a vendor → party statement

1. 1

   Set date range, Type (CREDIT or DEBIT), Record With Zero Balance if you need zero rows, then Division → Branch. Click Apply Filters.

2. 2

   Click a vendor row for the statement. Export Report → PDF or XLSX on both the list and the party detail.

7. Debtors Ledger

Customer-wise balances. Same filter bar and click-through as Creditors, for customers.

Reports → Debtors Ledger → date / Type / Division / Branch → Apply Filters → click a customer → party statement

1. 1

   Set date range, Type (CREDIT or DEBIT), Record With Zero Balance if you need zero rows, then Division → Branch. Click Apply Filters.

2. 2

   Click a customer row for the statement. Export Report → PDF or XLSX on both the list and the party detail.

8. Gross Profit

Three tabs. Header stats: Total Revenue, Total Profit, Profit Margin. There is no Export Report on this screen.

Reports → Gross Profit → pick a tab → date / Division / Branch → Apply Filters → click a row to drill

1. 1

   Open a tab: Customer Wise Gross Profit, Item Wise Gross Profit, or Customer's Month Wise Gross Profit.

2. 2

   Set date range (month range on Customer's Month Wise), Division → Branch. On Item Wise also set Item Group and Item Type (RM, FG, SEMI RM, CONSUMABLE, TRADE, SCRAP). Click Apply Filters.

3. 3

   Click a row to drill. Customer path: customer → documents → batch / production order. Item path: item → item detail → batch.

Customer's Month Wise date presets:

Last 3 Months → Last 6 Months → Last 9 Months → Last 12 Months → Custom Range

9. Aging Reports

Three reports in this group. Buckets are not fixed 0–30 / 31–60. You set how buckets are built, then click an amount to see the documents. No export on these screens.

How buckets are built on every aging report:

Column Type (Days / Weeks / Months) → Number of Columns (1–8) → Duration → Apply Filters

Customer Aging Report

Reports → Customer Aging Report → date / Branch / Customer / buckets → Apply Filters → click a bucket → Customer Aging Bucket

1. 1

   Date range defaults to last month through today. Set Branch and Customer if you want a subset. Split appears when a split session is on.

2. 2

   Number of Columns defaults to 5. Duration defaults to 5. Click Apply Filters, then click a bucket amount.

Vendor Aging Report

Reports → Vendor Aging Report → date / Branch / Vendor / buckets → Apply Filters → click a bucket → bucket list

Same bucket controls as Customer Aging. Use Vendor instead of Customer.

Receivables / Payables

Reports → Receivables / Payables → date / Branch / buckets → Apply Filters → click Amount Receivable or Amount Payable

1. 1

   Date range defaults to today through 30 days ahead (a forward window, not last month). Set Branch, Number of Columns, Column Type, Duration. Click Apply Filters.

2. 2

   Click Amount Receivable for that bucket's receivables list, or Amount Payable for payables.

Business rules