Note that the period or time ranges the reports allow you to specify by default starts with the first month of the year and ends with the last month of the year. For example, the period from starts with Jan-2018 while the period to ends with Dec-2018.
- Audit Trail
- Balance Sheet
- Budget Details
- Budget Periodic Comparison
- General Ledger Account Activity
- Intrastat Details
- Journal Listing
- OSS Sales VAT Report
- Profit & Loss
- Profit & Loss - Periodic
- Return of Trading Details
- Trial Balance
- Trial Balance - Formatted
- Trial Balance - Periodic
- VAT Returns
- VIES Details
- Yearly Budget Comparison
Audit Trail
This report shows the modifications on different documents performed by different users.
1. On the Reports page, under the GENERAL LEDGER heading, click Audit Trail Report.
2. The Audit Trail Report page appears. Enter the required criteria and click [Run].
3. The report is shown below.
Audit Trail Report shows the details of the time and user that run the Year End routine. To view, run the year end routine. On the Audit Trail Report page, from the TYPE list, select TB Journal and run the report. |
Balance Sheet
To generate the balance sheet report, complete the following steps.
1. The Reports page appears. Under the GENERAL LEDGER heading, click Balance Sheet Report
2. The Balance Sheet Report page appears. Enter the required details and click Run.
3. The report is generated.
Budget Details
This report generates the budget details based on nominal codes. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Budget Details.
2. The Budget Details page appears. Enter the required criteria and click [Run].
3. The report is generated, as shown below.
Budget Periodic Comparison
The report does a comparison of the differences between actual and budgetary figures based on nominal codes specified. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Periodic Budget Comparison.
2. The Budget Periodic Comparison page appears. Enter the required criteria and click [Run].
FIELD | STEP |
---|---|
Click and select a pre-configured date range. | |
PERIOD FROM | Specify the period from which you want to generate the report. |
PERIOD TO | Specify the period till which you want to generate the report. |
ACCOUNT CODE FROM | Specify the nominal code from which you want to generate the report. |
ACCOUNT CODE TO | Specify the nominal code till which you want to generate the report. |
3. The report is generated, as shown below.
General Ledger Account Activity
This report generates the general ledger account details of a business based on your choice of nominal codes and a time period. For example, you could choose to view the report between March and April between a range of nominal codes.
1. On the Reports page, under the GENERAL LEDGER heading, click General Ledger Account Activity.
2. The General Ledger Account Activity page appears. Enter the required criteria and click [Run].
FIELD | STEP |
---|---|
BASED ON | Select the basis on which the report will be generated. |
PERIOD FROM | You can set the starting range date up to 5 years beyond the current accounting period. |
PERIOD TO | You can set the ending range date up to 5 years beyond the current accounting period. |
ACCT. CODE FROM | Select the nominal code to set the range of report coverage. If you rather want to view the report for a specific nominal code, select the value and leave the ACCOUNT CODE TO field blank. |
ACCT. CODE TO | Select the nominal code to set the range of report coverage. If you rather want to view the report for a specific nominal code, select the value and leave the ACCOUNT CODE FROM field blank. |
3. Advanced Settings a takes into account Future Opening Balances and displays it as Balance Forward in the General Ledger Report that is being published.
4. Under Advanced Settings, a new feature Page Break has been added. This feature provides a page break in the list of the generated report. The page break introduced becomes visible every time a generated report is printed or imported.
5. The report is generated, as shown below.
The report generates clickable document numbers, shown in the image above. To move to the original document, click the document number. |
Intrastat Details
The report generates the Intrastat details for a period you specify. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Intrastat Details.
2. The Intrastat page appears. Select the period for which you want to generate the Intrastat details and click Run. A Warning message is also displayed. It states that “Warning: If a Product Does Not have a Country of Origin it will assume the Country of the Supplier/Customer, these are highlighted on the report with a *”
3. The user can chose the Intrastat time frame from the drop down. The 'Run' option enables user to generate the report for the time specified. The 'Print' option allows you to see a print preview of the report. The 'Save' option saves the report generated. The 'Email' option sends the report via email.
The choice of period will appear only if you have already generated at least one Intrastat for a period. |
4. The report is generated, as shown below. A new column has been added for Country of Origin which comes from the Product record. If the Product does not have a Country of Origin then the Country is to be selected from the Customer/Supplier.
Downloading the Reports
To download the report, complete the following steps.
1. Generate the detailed report.
2. On the Intrastat Details page, click Exports CSV to download the export details or the Imports CSV to download the import details.
3. Submit the CSV files to Revenue. You may update the details such as commodity or nature of transport code prior submission.
4. The Exports CSV option if clicked displays a confirmation message. The message is “Warning: If a Product Does Not have a Country of Origin it will assume the Country of the Customer. Nature of Transaction code, Mode of Transport code, Commodity Code, Net Mass may contain default values, which need to be edited either in the CSV prior to import, or in ROS Offline after import. The CSV contains exports only.“. The message is displayed below. A new column called Identification Number and Country of Origin has been added in the CSV File.
5. The outcome of generating of exporting the CSV Format for Intrastat is reflected in the downloaded CSV File. The file downloaded shows columns reflected as selected by the user. The file pulls the information either from the Customer/Suppliers information that are provided by the user or from the Intrastat Settings page as set by the user. The file also fetches the details as and when required from the Products setup confirmed by the user.
6. The Imports CSV option if clicked displays a confirmation message. The message is “Warning: If a Product Does Not have a Country of Origin it will assume the Country of the Supplier. Nature of Transaction code, Mode of Transport code, Commodity Code, Net Mass may contain default values, which need to be edited either in the CSV prior to import, or in ROS Offline after import. The CSV contains imports only.". The message is displayed below. A new column called Identification Number and Country of Origin has been added in the CSV File..
7. The outcome of generating of importing the CSV Format for Intrastat is reflected in the downloaded CSV File. The file downloaded shows columns reflected as selected by the user. The file pulls the information either from the Customer/Suppliers information that are provided by the user or from the Intrastat Settings page as set by the user. The file also fetches the details as and when required from the Products setup confirmed by the user. .
Journal Listing
This report lists journals during a period you specify. To generate a report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Journal Listing.
2. The Journal Listing page appears. Enter the required criteria and click [Run].
FIELD | STEP |
---|---|
Click and select a pre-configured date range. | |
DATE FROM | Specify the date from which you want to view the report. You can set the date up to 5 years beyond the current set accounting period. |
DATE TO | Specify the date till which you want to view the report. You can set the date up to 5 years beyond the current set accounting period. |
ACCOUNT CODE FROM | Specify the nominal code from which you want to view the report. |
ACCOUNT CODE TO | Specify the nominal code till which you want to view the report. |
Optional Step
1. You can sort the report by the fields Doc No. and Ref No. fields. To sort, click Advanced Settings.
2. The Advanced Settings window appears. Move the fields Doc No. and Ref No. under the Include heading and under the SORTING heading, select Doc No. and Ref No..
3. Click Update.
4. The report is generated and is sorted under the Doc No. and Ref No. fields.
OSS Sales VAT Report
This report displays the sales transaction done using OSS VAT code.
To generate the report, do the following steps:
1. Click Reports.
2. Under the GENERAL LEDGER, click OSS Sales VAT Report.
The OSS Sales VAT Report page appears.
3. Enter the required details and click Run
|
You can view the reports based by selecting a specific type from the TYPE drop-down menu. |
Profit & Loss
This report displays the profit or loss in the form of variance from the budget against various nominal codes. You can also view the sales figures against divisions or subdivisions, if you have set any. To generate the report, complete the following reports.
1. The Reports page appears. Under the GENERAL LEDGER heading, click Profit & Loss Report
2. The Profit & Loss Report page appears. Enter the required details and click Run.
3. The report is generated.
|
You can select the period up to 5 years beyond the current accounting period. |
Profit & Loss - Periodic
The report generates the periodic or month-wise profit and loss. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Profit & Loss - Periodic.
2. The Profit & Loss - Periodic page appears. To generate the report, specify the criteria, as given below.
3. The report is generated.
Return of Trading Details
The VAT Return of Trading Details Report (RTD) allows you to submit the return of trading details to the Revenue annually. The report format is compliant with that Revenue requires your business to follow. To generate the report, complete the following steps.
|
1. The VAT Return of Trading Details Report page appears. Specify the criteria according to which the report will be generated and click Run.
2. The report is generated. Both formats are shown below.
FIELD | STEP |
---|---|
Supplies of Goods and/or Services | |
€ Values Excluding VAT | Displays total values of goods and services' supplies excluding VAT. |
Exempt | Displays total values of goods and services' supplies excluding VAT. |
0% Exp | Displays the following:
|
0% Home | Sales within Ireland where the VAT is zero rated. |
Total | Total of the above columns |
Acquisitions from EU countries Net of VAT, Postponed Accounting & Vat free imported parcels | |
€ Values Excluding VAT | |
Exempt | Displays purchase of goods intra-EU, where the VAT rate is zero-rated. |
0% Home | All non-EU purchases, where the VAT rate is zero rated. |
23.00% | All non-EU purchases, where the VAT rate is 23%. |
Total | Total of the above columns |
Value of Stock for Resale (purchases, intra-EU acquisitions, Postponed Accounting & imports) | |
€ Values Excluding VAT | |
Exempt | The total of values of stock for resale that is VAT exempt. |
0% Home | All purchases within home country where the nominal code is set to Purchases and the option Goods for Resale is ticked in Chart of Accounts. |
23.00% | The total of values of stock for resale that is charged at 23%. |
Total | Total of the above columns |
Value of other deductible goods & services (purchases, intra-EU acquisitions, Postponed Accounting & imports) | |
€ Values Excluding VAT | |
Exempt | Total values of goods that will not be resold and is VAT exempt. |
0% Home | All purchases within home country where the nominal code is set to Purchases and the option Goods for Resale is not ticked in Chart of Accounts. |
23.00% | The total of values of stock not for resale that is charged at 23%. |
Total | Total of the above columns |
Totals of all figures relating to Postponed Accounting included in the sections above | |
€ Values Excluding VAT | |
PA2 | Total value for acquisitions from EU countries Net of VAT, Postponed Accounting & VAT free imported parcels. |
PA3 | Total value of Stock for Resale charged at zero VAT (purchases, intra-EU acquisitions, Postponed Accounting & imports) |
PA4 | Total value of other goods not for resale and charged at zero VAT (purchases, intra-EU acquisitions, Postponed Accounting & imports) |
Total | Total of the above columns |
Trial Balance
The report generates the trial balance for the specified financial year. You can generate the report for the current, past and comparative periods. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Trial Balance.
2. The Trial Balance Report page appears. Enter the required criteria and click [Run].
3. You can add more columns to the report by clicking [Advanced Settings] and then from the Advanced Settings window, selecting columns such as Division and Subdivision.
If, at the time of setting up the business, you select options Primary School or Secondary Schools, then in the Advanced Settings window, the column name IE/Balance Sheet will be displayed instead of PL/Balance Sheet. |
4. The report data is shown below.
Trial Balance - Formatted
The report generates the profit or loss or balance sheet, depending on your choice. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Trial Balance - Formatted.
2. The Trial Balance - Formatted page appears. Enter the required criteria. The report is generated based on the criteria you have specified.
FIELD | STEP |
---|---|
Click and select a pre-configured date range. | |
PERIOD FROM | Select the period from which you want to view the report. You can set the date up to 5 years beyond the current set accounting period. |
PERIOD TO | Select the period till which you want to view the report. You can set the date up to 5 years beyond the current set accounting period. |
TYPE | Based on whether you want to view profit and loss or balance sheet, select the appropriate option. To view both, select Both. |
3. Click Run.
4. The report is shown below. The profit and loss figures are shown against respective nominal codes while the balance sheet is against respective banks.
Profit and Loss
Balance Sheet
If, at the time of setting up the business, you select Primary School or Secondary School as the business type, then the following changes occur in the report.
Additionally, to see the above changes, you need to select the Suppress Zero and deselect the Show Future Opening Balances check boxes in the Advanced Settings window. |
Trial Balance - Periodic
This report shows two different outputs based on your selection of the Business Type at the time of setting up the business. If you select Primary School or Secondary School as the business type, the heading of the report is shown as Periodic Balance Sheet Report by default. Else, it shows Periodic Trial Balance Report in the heading. The report outputs are also different for the selections. For Primary School or Secondary School business types, it shows the income and expenditure and the balance sheet in various banks across different periods while, for the remaining business types, it shows the profit and loss and the balance sheet summary. The steps to generate the report are shown for both approaches.
Non-School Business Type
1. On the Reports page, under the GENERAL LEDGER heading, click Trial Balance - Periodic.
2. The Periodic Trial Balance page appears. On the Periodic Trial Balance page, enter the required criteria, as given below and click [Run].
FIELD | STEP |
---|---|
YEAR | Your options are:
|
TYPE | Your options are:
|
3. The report is generated.
School Business
1. On the Reports page, under the GENERAL LEDGER heading, click Periodic Trial Balance.
2. The Periodic I&E Report page appears.
3. On the Periodic I&E Report page, enter the following details and click Run.
FIELD | STEP |
---|---|
YEAR | Your options are:
|
TYPE | Your options are:
|
VAT Returns
This report generates the VAT returns during a specified period for IE Business.
1. On the Reports page, under the GENERAL LEDGER heading, click VAT Return.
2. The VAT Return page appears. On the VAT Return page, enter the required criteria and click [Run].
3. The report is generated below.
VIES Details
This report generates the VIES details for a period. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click VIES Details.
2. The VIES page appears. On the VIES page, enter the required criteria and click [Run].
3. The report is generated, as shown below.
Yearly Budget Comparison
This report compares the actual figures with that of the budget during a specified period based on nominal codes specified. To generate the report, complete the following steps.
1. On the Reports page, under the GENERAL LEDGER heading, click Yearly Budget Comparison.
2. The Yearly Budget Comparison page appears. Enter the required criteria and click [Run].
FIELD | STEP |
---|---|
Click and select a pre-configured date range. | |
PERIOD TO | Specify the period till which you want to generate the report. |
ACCOUNT CODE FROM | Specify the nominal code from which you want to generate the report. |
ACCOUNT CODE TO | Specify the nominal code till which you want to generate the report. |
3. The report is generated, as shown below.