What you'll do: learn the controls every report shares, so you can use any report in Hala: where to find it, how to filter it, and how to print or export it.
Before you start:
- Each report has its own permission in the role, for example View profit/loss report or View stock report. See Create a role.
- Some reports appear only when a feature is on (see the table at the end).
Open a report
Section titled “Open a report”In the sidebar, open Reports & Analytics → Reports. The list shows every report your role may see, for example Profit & Loss, Tax Report or Stock Report.
Click the report. It opens for All Locations and a default date range.
Filter it
Section titled “Filter it”Most reports have a Filter button above the table. Press it to open the filter panel (for example Filter Contacts or Filter Stock). On Profit & Loss, Expense Report and Trending Products the filters are always shown at the top.
Choose the branch in All Locations, and other filters the report offers (customer, supplier, category, brand, user…).
Click the date box (Select date range) and pick a range: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, This Year, Current financial year, Last financial year… or Custom Range with a Start Date and End Date, then Apply.
1 Location · 2 Date range · 3 Print The report refreshes by itself. Clear Filters goes back to the defaults. A dot on the Filter button reminds you that filters are on.
Read the figures
Section titled “Read the figures”- Reports with cards (such as Profit & Loss) show the headline figures at the top and the details in tabs below.
- Table reports end with a Totals row. It adds up the rows of the current page.
- Click a name, invoice or product where it is underlined to open it.
Print or export
Section titled “Print or export”Table reports have the same buttons above the table:
Show: how many rows per page.
Export CSV or Export Excel (XLSX): choose Current Page Only or All Records. The file follows your filters.
Print: Print Options asks for Current Page Only or All Records.
Toggle Columns: hide the columns you don't need, on screen and in the print.
1 Export CSV · 2 Export Excel (XLSX) · 3 Print · 4 Toggle Columns
Profit & Loss, Purchase & Sell, Expense Report and Trending Products have only a Print button: it prints the page as you see it (use your browser's Save as PDF to get a file).
Why is a report missing?
Section titled “Why is a report missing?”The owner chooses which reports show in the menu: Administration & Settings → Settings → Modules & Reports, tab Reports. Profit & Loss and Register Report are locked on. Some reports also need a feature:
| Report | Needs |
|---|---|
| Purchase & Sell Report | the Purchases, Add sale or POS sale module |
| Stock Expiry Report | Product Expiry switched on in Business Settings → Products & Stock |
| Lot Report | Lot Number switched on in Business Settings → Purchases |
| Stock Adjustment Report | the Stock adjustment module |
| Expense Report | the Expenses module |
| Activity Log | a business admin |