Finance, GST & Accounting · Reports
Report Builder
Build your own reports in Sayl from any module - filter, group, total, chart in 20 styles, export to Excel or PDF, schedule, and put them on your dashboard.
What it is for
Report Builder answers the questions no fixed report does: which lead sources bring the most business, who owes you money for more than 30 days, which products sell best this quarter. Pick the data, choose the fields, filter, group and total, and see it as a table or a chart - then save it, export it, schedule it or put it on your dashboard.
It reads 30 data sources across the whole CRM - leads, quotes, sales orders, invoices, payments, purchases, expenses, the general ledger, stock and HR - plus cross-module summaries such as Customer 360 and Salesperson performance.
How it works
- A saved report is a definition, not a copy of the numbers. It keeps what you chose - the data source, fields, filters, grouping, totals, period, formulas and chart - and always runs on today's data, showing each person only the records their permissions allow.
- A report with no grouping lists one row per record. Group by up to three fields (for example Customer, then Month) and add totals - a count, or the sum, average, lowest or highest of a number field - to get one summary row per group and a Total row.
- A period limits the report to records dated in a range (This month, This quarter, This FY…), and Compare with adds the previous period or the same period last year with the % change. Ready-made formulas add calculations such as margin %, collection % or growth % without typing anything.
- Results show as a table or one of 20 visualizations: bar, line, trend, pie, stacked bars, bar + line, donut, treemap, funnel, pipeline, KPI cards, gauge, progress bars and more. Any saved report can be added to the Main or Finance dashboard in exactly that design, and it follows the dashboard's date filter.
Step by step
Every screenshot is from the live demo. The highlighted button is the one to click - nothing here is saved in the demo, so you can follow along freely.
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
Key fields
- Data source
- 30 sources: Sales & CRM, Invoices & Billing, Payments, Purchases & Vendors, Accounting, Inventory, HR, and cross-module summaries.
- Columns / Group by / Values
- List rows, or group by up to 3 fields with Count, Sum, Average, Lowest, Highest or Distinct count.
- Period / Compare with
- A date range with quick picks; compare with the previous period or the same period last year.
- Formulas
- Ready-made business calculations or your own, up to 6 per report.
- Show up to
- Rows shown, 1 to 1,000.
- Visualization
- Table and 19 chart styles, with palette, value labels and target.
- Save options
- Private or shared with the workspace; Save as new, Duplicate, Schedule & Distribution, Delete.
Tips
- Start from the nearest ready-made report and adjust it - it is faster than building from scratch.
- Group by a month field (Issue month, Created month) for a trend, and by Customer, Product or Salesperson to see who and what drives the numbers.
- A report saved without a period follows the dashboard's date filter; one saved with its own period keeps it unless you change the widget's date option.
- A data source you have no permission to view is not offered, and saved reports built on it are hidden from you.











