The income statement, one of available Accounting reports, is used to search all the income account transactions. Search criteria can be modified to choose what kind of information is included on the statement.
Income statement is found in Reporting > Accounting reports (or, alternatively, in Accounting > Accounting reports) by selecting Income statement in the Accounting report type drop-down menu.
Search criteria
- Select Income statement from the Accounting report type drop-down menu.
- Receipt date is used to select the beginning and end date for the income statement.
- Presentation type menu gives several options for how the information is presented on the report.
- By default, the income statement presentation type is Total sum of selected period, where the income statement values are presented in a single column from the time period selected in Receipt date.
- The Opening balance and Closing balance time periods can be seen in Income statement report when the report type is Opening balance, change and closing balance OR Opening balance, debit, credit and closing balance and you have selected "Hide search options in exports". When "Hide search options in exports" is chosen, report type name is added to the export.
- Report length has the options default, brief, detailed, or all accounts.
- Receipt status can be used to select from the drop-down menu the status of receipts to be included on the report. By default, only completed transactions are included, but more specific search terms can be added in this menu.
- Presentation options section includes selections:
- Show rows with zero values option: when selected, includes the rows with zero values to the report.
- Hide creator in exports: option hides the creator from the Excel, HTML, and PDF printouts of the report.
- Hide company ID in exports
- Hide search options in exports
- Comparison data to be shown gives the option to choose the comparison data. The options are budget (only an option, if the budget has been imported to Procountor) and comparison period. You can select either one or both of these.
- When budget is chosen as comparison data, you need to choose whether the difference is shown as a percentage from the turnover, as currency, or as difference in percentage (of which the latter option is selected by default).
- If the report is not searched according to the dimension items, the basic budget is used for comparison. If the budget data has been imported to Procountor on dimension-level, and these dimension budget values are to be used as comparison data, select the same dimension items as search terms that are used on the budget.
- If several different versions of the budget have been imported to Procountor, the correct one can be chosen using the search term Budget version.
- If comparison period is selected as comparison data, the comparison period must be specified.
- The default comparison period is the previous year, but this can be adjusted as needed.
- If the selected report presentation type is Every month and total sum, Every quarter and total sum, or 12 month cumulative sums ending in different sums, the comparison period must match the report period.
- When budget is chosen as comparison data, you need to choose whether the difference is shown as a percentage from the turnover, as currency, or as difference in percentage (of which the latter option is selected by default).
More Options menu gives a list of additional search criteria. For income statement, the available search criteria are:
- Receipt type
- This search criterion defines the type(s) of receipt(s) to be included on the report.
- Receipt currency
- This search criterion narrows the search results to invoices in the specified currency.
- Receipt Name
- This criterion narrows the search only to receipts that are named with the content given in the Name field. The search can be done with the entire name or only with a part of it.
- Customer's Company ID
- This option narrows the search to a specific company ID. The company ID can be filled out in its entirety or only partly, either with the country code and hyphen or without them.
- Entry period (yyyy-mm)
- This search criterion narrows down the entry period of receipts according to the month. If both the date and the entry period have been given, the report searches for receipts according to the shorter time period: for example, if the Receipt date field has the dates 01.10.2019-30.11.2019 and the Entry period is set as 2019-11 – 2019-12, the search results will include receipts from Nov 1 to Nov 30 2019 on the report.
- Transaction value
- This narrows down the search according to the accounting value. The search is conducted in the accounting value column. Multiple values can be searched using <and> between them.
- Report language
- This defines the report language. The language selected by default is the language chosen in Management > Company info > Basic info as Company’s language.
- If English or Swedish is chosen as a report's language, Procountor retrieves the translated version of the default account chart.
- The selected report language defines the reports language.
- Report currency
- This selection defines the currency on the report.
- Number format
- This defines the rounding of the numbers on the report.
- By default, the values are rounded to two decimal places.
- Dimensions
- Adding this search criterion brings only entries allocated to a certain item or items of a specific dimension to the Income statement.
- Dimensions drop-down has a list of all the dimensions. Only one dimension can be selected for the report, meaning that several different dimensions cannot be selected on the same report.
- Items field shows all the items belonging to the selected dimension. One or more of these can be selected on the report. To select multiple items, hold down the Ctrl button when clicking the item names. If there are a lot of items, click the magnifying glass icon next to the search field to open a new window for selecting the items.
- If several items have been selected for the report and you want a more detailed list of the values of each item, choose Every dimension code and total sum in the Presentation type menu.
- Allocated part: (dimension name)
- All dimensions that are in use can be selected as their separate Allocated part search criterion.
- Enables several different items under different dimensions to be selected on the same report and shows the percentage values of each item.
- When choosing Allocated part search criterion or criteria for a report, a section Allocated part (dimension name) is shown in the search criteria listing all the items under that dimension. Items to be included on the report are selected either by holding down the Ctrl button or by clicking the magnifying glass icon and selecting the items to be included.
- Allocated part search criterion means the report is computational only, and the report will not allow drilling down to the transactions.
- More on this search criterion and how to use it is found here.
Search result buttons
- Use the Excel, HTML, and PDF buttons to export the report to different file types.
- By clicking on the number of the account or account group, you will get a report of the transactions of the selected row (account or account group). From the listing, it is possible to drill down to the receipt-specific information.