Drill down, export and print
Change the period of any report, drill down to the voucher behind a figure, and export or print what you see.
Every report in Hisaab works the same way. You set the period, move with the arrow keys, press Enter to see what is behind a figure, and export or print the report as it stands on screen.
Change the period#
- Press F2, or click the date button at the top of the report. A panel opens with From and To.
- Type the dates, for example
1-4-2025or1-Apr-25. Press Enter in From to move to To. - Press Enter in To, or click Apply.
To skip the typing, click a ready period: This month, Last month, This quarter, This year, Last year or All data. Quarters and years follow the April to March financial year.
Press Esc to close the panel without a change. The period stays the same as you move from report to report.
Note: Position reports such as Bills Receivable, the ageing reports, Bank Reconciliation and Reorder Status are drawn "as at" a date. That date is the end of the period, or today when today falls inside the period.
Detailed or Summary#
Trial Balance, Profit & Loss and Balance Sheet have two buttons, Detailed and Summary. Detailed shows ledgers under their groups. Summary shows groups only. Alt+F1 or Alt+T switches between the two. The status bar and the period panel call the Summary view Condensed.
Drill down#
| Key | What it does |
|---|---|
| ↑ ↓ | Move one row |
| PageUp PageDown | Move 20 rows |
| Home End | First or last row |
| Enter | Open what is behind the selected row |
| Ctrl+Enter | Alter the ledger, item or voucher on the selected row |
| Esc | Go back one step |
What Enter opens depends on the row:
- A group row opens the Group Summary of that group.
- A ledger row opens the Ledger statement.
- A stock item row opens Item Movement.
- A voucher row opens the voucher.
So from the Balance Sheet you can go group, ledger, voucher with three presses of Enter. Esc takes you back the same way, to the row you left. Clicking a row does the same as Enter.
Search#
The Day Book and the registers have a search box above the table. Type a voucher number, party, narration, ledger or amount, and the list narrows as you type. The lists of ledgers, groups and stock items have the same box. Every other report has a filter box that narrows its lines in the same way. Ctrl+F takes you to the box.
To search across everything, press Ctrl+K and type a ledger, voucher number, amount or report name.
Export to CSV or Excel#
- Open the report and set the period.
- Click CSV, or press Ctrl+E. For an Excel workbook (
.xlsx), click Excel, or press Alt+E and choose Excel. - The status bar shows where the file was saved.
Files go to the exports folder inside the Hisaab data folder. The file name is the report name and the period. A CSV file opens in Excel or any other spreadsheet.
The Excel file has one sheet. Headings, group lines and totals are bold. Amounts are plain numbers, not text, so you can sum and sort them. A Dr or Cr balance is a positive number for Dr and a negative number for Cr, shown with "Dr" or "Cr".
Print#
- Click Print, or press Ctrl+P.
- The report opens in your web browser with the company name and period at the top.
- Print from the browser, or choose to save as PDF there.
On an open voucher, Ctrl+P prints the voucher.
Limits#
- Ctrl+E always makes the CSV file. Excel has no key of its own: press Alt+E and choose it from the list.
- The Excel file carries no formulas, colours or column totals of its own, and amounts use Excel's digit grouping, not the Indian one.
- Printing goes through the browser. There is no print preview or layout editor inside Hisaab.
- Export and print give the report as shown, with the period and the Detailed or Summary choice you have on screen.
- Long reports are shown 200 rows at a time. A line under the table says which rows you are on. PageDown and PageUp move through the list. A CSV or Excel export always holds every row.
Next#
Something here wrong or missing? Open a ticket and mention this page.
