Skip to main content

The report builder

The standard reports — the trial balance, the account card, the financial statements — cover the classic accounting needs. But specific questions come up too: "which products brought the biggest margin this quarter?", "what do sales look like by month and by channel?", "what was recorded on account 713.1, month by month?". The report builder answers them without you exporting anything into Excel.

The pivot builder works on the commercial data — sales and stock movements. For questions about the accounting entries — turnovers per account, amounts per account and month — the answer is in the trial balance and in the account card.

The pivot builder​

Where to find it: Sidebar → Reports → the Reports tab → the Report Builder card

The card does not open a tab in the catalogue: it takes you out of the Reports screen, into the builder's own screen.

Here you put fields on Rows, Columns and Values and get a cross table, with subtotals and a grand total.

The data sources​

The field names come from the server and appear in Romanian in every language; the English meaning is in brackets.

SourceDimensions (Rows / Columns)Values
Vânzări (sales)Data (date), Luna (month), An (year), Canal (channel), Cod produs (product code), Produs (product), U.M. (unit), Cod TVA (VAT code)Cantitate (quantity), Venit (revenue), Cost, Marjă (margin), TVA (VAT)
Mișcări de stoc (stock movements)Data (date), Luna (month), An (year), Cod produs (product code), Produs (product), Categorie (category), Depozit (warehouse), Tip mișcare (movement type)Cantitate (quantity), Valoare (value)

How you build a pivot​

  1. Pick the Data Source in the left-hand panel
  2. Pick the Period
  3. In the Fields list, every dimension has an R (Rows) and a C (Columns) button, and every measure has a Σ (Values) button. You press them to add the field to that zone
  4. For each value you pick the calculation: Σ Sumă (sum), x̄ Medie (average), # Număr (count), # Distincte (distinct count), ↓ Min or ↑ Max
  5. Press Run

The fields you add appear as labels in the Rows / Columns / Values zones. You remove them by pressing the X on the label.

You need at least one value. The Run button stays disabled until you put at least one field in the Values zone. Rows and columns are optional — without them you get a single total.

Changing the data source clears everything. Pick another source and you lose the zones, the measures, the calculated fields, the sort, the Top-N and the result on screen. Save the configuration first if you want to use it again.

The Hide settings button at the top of the screen collapses the left-hand panel, so a wide table fits the full width. You bring it back with Show settings.

Calculated fields​

On top of the base values you can define one of your own: give it a Field name, pick the Left operand, the operator (÷, −, +, ×) and the Right operand, then press Add. The As percent (×100) checkbox multiplies the result by 100.

The box appears only after you have put at least one measure in Values — the operands are chosen from among them.

Example: margin divided by revenue, as a percentage, gives you the margin rate on every row of the pivot.

Sorting the result​

Press the head of a value column and the table reorders descending by it, with ▼ on the active column. The second click switches to ascending (▲), the third removes the sort altogether. The hierarchy stays intact — the rows on each level are reordered among themselves — and "Others" and the Grand Total stay at the end throughout.

Top rows​

The row of 10, 25, 50 buttons trims the report to that many rows, and the rest are added up into an "Others" row. All brings back the full list.

It only appears on a flat pivot — a single dimension on Rows and nothing on Columns. If you have added columns, the buttons are not on the screen; remove the columns to see them.

Chart and heatmap​

After the run, two visualisation buttons appear:

  • Chart — the graphical representation of the values
  • Heatmap — colours the cells by size, so you see at a glance where the big figures are

Export​

The Export Excel button downloads the table in XLSX format, with formatting, exactly as you see it on screen.

Saved reports​

You type a name in the left-hand panel and press Save — the button only becomes active once you have both a name and at least one measure. The configuration is kept and you reload it from the Load a report list. The X button next to the list deletes the selected report.

The list shows only the reports saved on the current data source. If a report seems to have disappeared, check first which source you have selected.

Pivot reports are saved in your browser

They do not reach the server. No other user sees them, you will not find them from another computer or another browser, and clearing your browsing data loses them. If a report matters to you, export it to Excel.

Which one to use when​

Your questionThe right screen
Sales, margin, quantities, by product / channel / monthThe pivot builder, source Vânzări
Stock receipts and issues, by warehouse or movement typeThe pivot builder, source Mișcări de stoc
Turnovers per account, journal entries, amounts per account and monthTrial balance and account card
Opening and closing balances per accountTrial balance
The detailed movements of a single accountAccount card

Common mistakes​

  1. Not setting a period — the report goes through the whole history, takes its time and gives you more rows than you can read. In the accounting builder you set Year and, if needed, Month.

  2. Grouping without aggregating (the accounting builder) — you choose grouping by month but leave the numeric columns on "—", so you do not get the totals you expected. Set SUM.

  3. Putting only dimensions, no values (pivot) — the Run button stays disabled. Add at least one measure with Σ.

  4. Looking for documents, not aggregated data — the accounting builder holds the entries, not the original documents. For invoices and bank operations, go to their own screens.

  5. Treating saved pivot reports as an archive — they live in the browser. Export to Excel whatever needs keeping.

  6. Forgetting to press Run after changing the settings — the table does not refresh on its own.

  7. Changing the data source "just to see the other one" (pivot) — you lose everything you configured. Save the current report first.

Troubleshooting​

The Run button is disabled

  • In the pivot: you have no measure in the Values zone
  • In the accounting builder: you have not chosen the data source, or you have unticked every column

The data source list is empty (pivot)

The sources come from different modules — sales from the commercial area, stock movements from inventory management. A source is missing from the list when the module is not active for your account or when you do not have read permission on its reports. The screen does not lock up: the sources you do have access to stay available.

The report shows no rows

  1. Check the period — most often it is too narrow
  2. In the accounting builder, check the account filter: it wants the exact analytical code (713.1), not the group code (713)
  3. Check that you have data in the chosen period

The figures do not match the trial balance

  1. Check that you are using the same period
  2. Remember that the trial balance starts from the opening balances, while the builder shows only the movements in the range

The report runs slowly

Narrow the period, then the number of fields in the zones.

Frequently asked questions​

Can I make a cross table (pivot)?​

Yes: you put dimensions on Rows and on Columns, measures on Values.

Are saved reports visible to my colleagues?​

No. The pivot ones stay in your browser. The ones from the accounting builder do reach the server, but they are not shared — the Shared column in the list stays empty precisely because it has nothing to show.

Can I modify a saved report?​

In the pivot, yes: you load it from Load a report, change the configuration and press Save again. In the accounting builder, no — the configuration does not reach the server, so the report comes back empty when reopened.

Can I schedule a report to run automatically?​

No. Reports run on demand.

Can I check the VAT return with the builder?​

No. The VAT return is not filled in from the account turnovers but from the VAT ledger, which keeps the rate and the tax treatment on every invoice. The builder shows you the movements, which helps you check the entries, but it does not reproduce the boxes of the return.

Is the data current?​

Yes. The builder queries the database at the moment of the run.

Can I send a report to a colleague who has no account on the platform?​

Export to Excel (pivot) or to CSV (accounting builder) and send the file.

Why do I see no source in the pivot builder?​

The Vânzări source needs read permission on the sales reports, and Mișcări de stoc needs the inventory management module. Ask your account administrator for the permission you are missing.