Get your data out
Export the whole company, masters, vouchers or any report as XML, JSON, CSV, Excel or a printable page.
You can take out the whole company, the masters and vouchers as sheets, or any single report. Viewers can export too.
Where exported files go#
Every export is written to the exports folder inside your data folder:
| System | Folder |
|---|---|
| Windows | %APPDATA%\Hisaab\exports |
| macOS and Linux | ~/.config/hisaab/exports |
The status bar shows the file name after each export. Hisaab does not ask where to save. An export with the same name replaces the earlier file.
Export the company or its masters#
- Click Import & Export in the sidebar.
- Under Export, click the button you need.
| Button | What you get | File name |
|---|---|---|
| Legacy XML (this period) | All groups you created, all ledgers and stock items, and the vouchers of the current period, in the legacy XML layout | <company>-<from>-<to>.xml |
| Everything as JSON | The whole company in one file: settings, masters and every voucher | <company>.json |
| GSTR-1 JSON (this period) | GSTR-1 data for the current period | <company>-gstr1-<from>-<to>.json |
| Ledgers (CSV) | Every ledger, in the columns of the ledgers import sheet | <company>-ledgers.csv |
| Stock items (CSV) | Every item, in the columns of the stock items import sheet | <company>-stock-items.csv |
| Vouchers (CSV, this period) | Vouchers of the current period, one row per ledger line | <company>-vouchers.csv |
"This period" is the period shown in the top bar. To export all vouchers, open any report, press F2 and click All data first.
Export a report#
- Open the report or list.
- Click CSV on the toolbar, or press Ctrl+E. For an Excel workbook, click Excel.
The file is named after the report and the period, for example trial-balance-20250401-20260331.csv or .xlsx. It holds what is on screen, including any search filter and the detailed or summary setting.
In the Excel file, amounts are numbers without digit grouping, so they add up in a formula. A balance shown as Dr or Cr is a positive number for Dr and a negative number for Cr, displayed with "Dr" or "Cr". Text and dates are text.
Print or save as PDF#
- Open the report.
- Press Ctrl+P, or click Print.
- Your web browser opens the report as a page. Use the browser's print command to print, or choose "Save as PDF" there.
Hisaab does not print directly and does not make PDF files itself. A voucher prints the same way: open it and press Ctrl+P.
What each format is good for#
- Legacy XML can be imported back into your previous software and into Hisaab. Cancelled vouchers are left out.
- CSV opens in any spreadsheet and can be imported back into Hisaab unchanged. The vouchers file leaves out cancelled and optional (draft) vouchers.
- Excel (
.xlsx) is for a report you want to work on in Excel or LibreOffice. It has one sheet, with the headings, group lines and totals in bold. - JSON is the complete copy for other programs to read. User names and passwords are never included.
Limits#
- Excel export is for reports and lists. The ledgers, stock items and vouchers sheets under Import & Export are CSV only.
- The Excel file has no formulas and no Indian digit grouping. Excel shows amounts with its own grouping.
- Legacy XML does not carry ledger addresses, credit days or item GST rates. Use the CSV or JSON export if you need those.
- Masters other than ledgers and stock items (employees, budgets, price lists and similar) are only in the JSON export.
- The GSTR-1 JSON has not been validated against the GST portal's tools. Check it in the offline tool before you rely on it.
For a full safety copy you can restore, use a backup rather than an export. See Back up and restore.
Next#
Something here wrong or missing? Open a ticket and mention this page.
