How to customise reports (definitions, columns and adjustments)

What is it for?

Three screens change what a report shows: Report definitions (the lines, columns and filters of each report), Side-by-side column groups (columns with only some journals, partners or accounts) and Manual report adjustments (figures that do not come from journal entries).

They are for whoever configures the program: the administrator or the consultant who installs it. The accountant can only view the manual adjustments.

When to use it?

• To create the company's own report, in the definitions.
• To compare, side by side, columns from different parts of the accounting.
• Do not use them to correct an amount in the periodic VAT return (DP IVA): correct the source document.

Where to find it?

Accounting › Record › What is there to do?, in the Customise and schedule reports group. It is also the page that opens when you enter Accounting. The group also has Scheduled report e-mails, which this article does not cover.

Before you start

• The group shows different links to each profile (tested with all four):
  • the program administrator sees all three screens, with New on all of them;
  • Fiscal officer and Fiscal administration see Side-by-side column groups and Manual report adjustments, with New, and do not see Report definitions;
  • Accountant only sees Manual report adjustments, without New: view only.

How to use it

1. View a definition. Open Report definitions and choose a report. The demo has 63. Each one has Name, Country, Root Report, Active, Sequence, Load More Limit and Search Bar, and the Lines, Columns and Filters tabs.
2. Create a column group. Open Side-by-side column groups and click New.
3. Fill in Name and, under What the group includes, Journals, Third parties or Accounts. Only what you fill in is used and, if you fill in more than one, a journal entry must meet all of them. In the example, the group “Vendas por diário” (sales by journal) only has the Sales journal.
4. Create a manual adjustment. Open Manual report adjustments and click New.
5. In Target Expression, choose the line: the Target Line fills in automatically. Fill in Date, Name and Numeric Value or Text Value. In the example, the expression is Ativos fixos tangíveis [notes], from the balance sheet, with the text value N5.
6. Check in the report. Open the report for a period that includes the adjustment's Date and check that the line changed. In the example, the Balance Sheet (SNC) from 01/01/2026 to 31/12/2026 shows N5 in the Notes column of Ativos fixos tangíveis.

Expected result

• The group and the adjustment are in their lists.
• On lines that accept adjustments, the value can also be typed in the report cell itself: click the cell, type the value and press Enter. It goes into the adjustments list with the name Edited in the report.
• The group can only be chosen in four generic reports (the balance sheet and income statement by account type and the two cash flow reports), in More filters › Show side by side. The group adds a column next to Total. In the example, in 2026, the ATIVO (assets) line of the Balance sheet by account type shows €45,698.09 in Vendas por diário and €255,821.53 in Total. The Balance Sheet (SNC) and the DP IVA do not have this filter.
• Today, these four reports are not in the menus. None of the profiles tested (administrator, Fiscal administration, Certified Accountant, Accountant and Auditor) can find them: they only open with a direct link. Creating a group does not put it in any report that opens from the menus.

Important notes

• Updates. The screen warns: “The reports that come with the product are restored when the module is updated, so changes made to them here can be replaced. A report you create here is never touched by an update.”
• Adjustments only change the lines that read external values. The Target Expression list also offers the others and saves without warning. In the DP IVA, an adjustment of €1,250.50 on [3] Taxa normal (standard rate), dated 30/09/2026, was saved and the line stayed at €6,433.15 from 01/09/2026 to 30/09/2026. The only DP IVA line that reads these values is [95] Pedido de reembolso (total ou parcial do campo 94) (refund request, total or part of field 94). Saving does not prove that the report uses the value: always check.
• Line [95] accepts an amount above the credit. When you type 150.00 in this cell, with the credit to recover at 0.00, the screen shows “O reembolso pedido (campo 95: 150,00) não pode ser superior ao crédito a recuperar no período (campo 94: 0,00).” (the refund requested cannot exceed the credit to recover in the period), but the amount is saved and the line becomes €150.00. If you see this message, check in Manual report adjustments whether the amount was kept.
• Pending validation by a certified accountant: changing the definition of a legal report or adding external values to it may take it away from the official format.

Common problems

• “Some required fields are empty. Fill in the fields marked in red to be able to save.” It appears when you save a group or an adjustment without the marked fields. On an adjustment, the Date is also required.
• I do not see the New button. Your profile can only view. Ask whoever administers the program to make the change.