This guide covers bookkeeping reporting in Netvisor. Open bookkeeping reporting by selecting Financials > Bookkeeping reports.

CONTENTS

Access rights to see reports

Make sure that in the function specific rights the user has at least viewing rights to the following:

  • "Perusraportointi"
  • "Kirjanpidon perustoiminnot"
  • "Kirjanpidon raporttihakuehdot"

Use the "Yrityskäyttäjä" or "Kaikki oikeudet" profile if you want bookkeeping reports to be visible directly.

Open bookkeeping reports by selecting Financials > Bookkeeping reports.

  • Select the desired report format.
  • Fill in the restrictions and search criteria for the information you want in the report.
  • Use drill‑down: in all reports you can drill down all the way to the transaction level.

Reports

  • Voucher browsing (the report also has a selection that allows you to narrow the report to only distinguishing vouchers).
  • General ledger (list of bookkeeping transactions in order of subject).
  • Journal (list of bookkeeping transactions in chronological order).
  • Profit and loss statement.
  • Profit and loss statement with variable costs (requires creating accounts in the range 4500–4999, see below). This report is only visible with the basic specification of accounts. Works with company forms: limited company, limited partnership, general partnership, sole proprietorship, cooperative and real estate company.
  • Profit and loss statement, monthly.
  • Profit and loss statement, comparison to budget (NOTE! This report is not available with a budget created in the new Controller, more information on this reporting: Uusi Controller - Raportit).
  • Profit and loss statement, comparison to group (requires the Group and chain reporting additional service. The report must be taken from the elimination company. Requires KP rights and rights to all companies in the group.)
  • Balance sheet.
  • Balance sheet, comparison to group (requires the Group and chain reporting additional service. The report must be taken from the elimination company. Requires KP rights and rights to all companies in the group.)
  • Account balance.
  • Attachment data report. Shows financial statements attachment data documents.
  • Transaction statistics.
  • The user also sees shortcuts created for them in the listing.


Report search criteria


Reports and shortcuts: Select the desired report or shortcut.

Financial period/Date range: Select the desired financial period or enter the date range manually for the desired period.

Voucher type: Select whether you search only vouchers of a specific voucher type or all vouchers (default).

Account number range: Enter the desired account number range or, for example, only a single account range from which information is retrieved.

Voucher numbers: Select from which voucher number range the information is retrieved.

Account:  Use the account search field as follows:

  • Search by account number or account name.
  • If the search result is only one account, select it by moving out of the field with the Tab key.
  • If there are several search results, select the account separately from the dropdown menu.
  • If necessary, set several accounts as search criteria in the same Account field.

Account number range:  Use the account number range also when the account used in the restriction is not in use in the company.

  • Note if both 5‑ and 6‑digit accounts are in use.
  • The account number restriction does not consider a 5‑ or 6‑digit account numerically larger than a 4‑digit account in the corresponding account group.
  • The search results come from the specification of accounts based on the first four digits of the account number.
  • If you restrict the account number range 4000–4490, the search criteria will also include the account 42001 appearing in the group.
  • As a result, you cannot restrict 5‑ and 6‑digit accounts, for example, outside the profit and loss statement report with the account number range.

Specification: Search for vouchers with the desired specification.

Sum: Search with the desired sum or sum range.

VAT rate: Search for transactions with the desired vat percentage or code.

Report language: Select Finnish, English or Swedish as the report language.

  • The report language selection is shown if a foreign language has been added to the company’s basic information.
  • The report is generated in the selected language.

Show only vouchers where the posting date differs from the invoice date: Select this if you want to search for vouchers where the posting date differs from the invoice date.

Generate the report as follows:

  1. Enter the desired search criteria.
  2. Press the Search button.

Use the selection "Show report in the form of the 2016 accounting law" as follows:

  • Select the setting if you want to leave extraordinary items out of the report and show the balances of those accounts in the section where extraordinary items are linked in the 2016 settings.
  • Uncheck the selection if you want to view reports from previous years that include extraordinary items. In this case, no links are made and extraordinary items are displayed normally.



Note the following when using the balance sheet and profit and loss statement:

  • The balance sheet and profit and loss statement taken from bookkeeping reports are not always suitable in content or appearance, for example, for external reading.
  • When preparing, for example, an interim financial statement, view the financial statements for the desired period.
  • Obtain the official financial statements, profit and loss statement and balance sheet via Financial statements by selecting Financials > Financial statements.
  • Set the desired period as the Active period.
  • Open the documents by clicking the document.
  • Save or print the opened document as needed.
  • Note that the official financial statements, profit and loss statement and balance sheet cannot be obtained directly in Excel format.


Variable costs reporting

Create separate accounts for variable costs in the specification of accounts as follows:

  • Use the same account groups as for fixed costs.
  • Set the account number for variable costs in the range 4500–4999.
  • Use the Profit and loss statement with variable costs report, which separates the transactions of these accounts.

Adjust the visibility of the report search criteria with the arrow button on the right‑hand side:

  • Expand the search criteria when you want to see all restriction options.
  • Indent the search criteria when you want a more compact view.


Show hidden cost objects: Select this if you also want to bring hidden cost objects into view.

Bring unallocated: Select this if you want to bring into view transactions that have not been recorded for the selected cost object.

You can use the above selections in the following reports:

  • Account balance
  • Profit and loss statement monthly
  • Attachment data documents
  • Group reports (profit and loss statements and balance sheet)

Use exporting from the search criteria as follows:

  • Press Export from search options if you want to print the report directly from the search criteria without opening it first on the screen.
  • Select whether you want the report in pdf format or csv format.

Use report‑specific functions at the top of the report:

  • Save, for example, the general ledger and voucher browsing as csv or pdf files.
  • Print the report directly from the report functions.
  • Save the report as a shortcut from the report functions.

Clear the selections made in the report search as follows:

  1. Go to the bottom of the search criteria.
  2. Press the Clear button.
  3. Let the search criteria return to the default selections.

General and journal ledger

Save the general and journal ledger in csv format as follows:

  • Select report format csv if you want a report that includes, for example, opening balances in the general ledger.
  • Select machine‑readable csv if you want a format suitable for further processing of data, where one piece of information is in one column and summary rows are omitted.
  • Use the report format csv option if there are so many transactions on the report that it cannot be obtained in pdf format.

Shortcut

Create a shortcut from a report as follows:

  1. Open the desired report from bookkeeping reports.
  2. Set the desired search criteria for the report.
  3. Save the report as a shortcut from the report functions.

Note the visibility of shortcuts:

  • The shortcut is visible on the Netvisor homepage.
  • You can also make the shortcut visible to other users if you have one of the following roles in the company:
    • accounting office administrator (TPK)
    • user administrator (KH)
    • accountant (KP)
  • You can find shortcuts in the same dropdown menu as the reports.

Manage shortcuts in the Shortcut management view:

  • You can see all shortcuts created for you.
  • If you have the accounting office administrator role or user administrator role, you can see all created shortcuts.
  • With the KP role, you can see the shortcuts you have created for others.

Restrict a user’s visibility only to the shortcut as follows:

  1. Open the user’s function specific rights.
  2. Set no rights for all other sections.
  3. Give reading rights to basic bookkeeping reporting.

Build a shortcut to a report restricted by a cost object as follows:

  • Build the shortcut via Bookkeeping reports if you want the user to see only the shortcut and the selected cost object.
  • Avoid building the shortcut via Cost object reporting if you do not want to open other cost object headings to the user.
  • Note that cost object reporting is built differently from bookkeeping reports and opens other cost object headings to view.

Understand what the user sees with the above rights:

  • The user can drill down from the values to see the voucher number.
  • The user cannot open the voucher without additional rights.
  • Opening a voucher requires reading rights in basic bookkeeping functions.
  • When you give reading rights in basic bookkeeping functions, the user sees:
    • open receivables and open accounts payable
    • some bookkeeping settings (cannot change them)
    • cost objects
    • possible construction industry notifications
  • The user cannot make or see other bookkeeping reports.

 


Fix Excel date issues with csv reports as follows if dates are not displayed correctly (for example, general or journal ledger in .csv format):

  1. Open Control Panel (Ohjauspaneeli).
  2. Select Clock and Region and then Change date, time or number formats.
  3. Select Finnish (Finland) from the Format dropdown and save the view.
  4. Close and reopen Excel.


Frequently asked questions

How can I print an account-specific profit and loss statement by cost centers?

Proceed as follows:

  • Go to Bookkeeping reports > Profit and loss statement.
  • At the bottom of the report, select which cost centers you want to include in the report.
  • Select "Show change comparison" if you want to include comparison data.
  • On the right‑hand side, press the "Print report" button and print the report in PDF format.
  • Adjust the report font size in the print settings.

How can I make sure I see bookkeeping reports?

  • Make sure you have at least viewing rights to "Perusraportointi", "Kirjanpidon perustoiminnot" and "Kirjanpidon raporttihakuehdot".
  • You can also use the "Yrityskäyttäjä" or "Kaikki oikeudet" profile, in which case the reports are visible directly.

How do I generate a report from bookkeeping reports?

  • Open Financials > Bookkeeping reports.
  • Select the desired report or shortcut.
  • Set the financial period or date range and other search criteria.
  • Press the Search button.

How do I get the official financial statements, profit and loss statement and balance sheet?

  • Open Financials > Financial statements.
  • Set the desired period as the Active period.
  • Open the desired document by clicking it.
  • Save or print the document from the opened view.

How do I create a shortcut from a report and share it with others?

  • Open the desired report from bookkeeping reports and set the search criteria.
  • Save the report as a shortcut from the report functions.
  • Share the shortcut with other users if you have the TPK, KH or KP role.

Why does Excel not display dates correctly in a csv report?

  • The Windows regional settings may be in a different format than the report date format.
  • Fix the issue by changing the Control Panel Format setting to Finnish (Finland) and reopening Excel.


Keywords: Bookkeeping reporting, shortcut, bookkeeping reports, profit and loss statement


This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.