Table of Contents
Overview
The Poland Subledger Report provides a comprehensive and customizable tool for financial professionals to analyze and understand the detailed transactions occurring within different subledger modules. Its flexibility, advanced filtering options, and visualization features make it a robust financial reporting and decision-making tool.
Benefits
Granular Financial Analysis: This enables a detailed breakdown of financial transactions, allowing organizations to analyze specific activities within subledger categories such as Accounts Payable and Accounts Receivable.
Enhanced Visibility: Offers a clear and comprehensive view of financial activities at a granular level, improving visibility into transaction details and aiding decision-making processes.
Flexible Reporting Periods: Permits users to select custom date ranges, enabling flexibility in reporting periods and facilitating trend analysis over specific timeframes.
Compliance and Reporting: It ensures compliance with Polish accounting principles and aids in preparing accurate financial reports.
Configuring the Subledger Report
To configure the report:
Navigate to Setup > Staria Poland Localization > Poland Localization Settings.
If you are creating a new Localization Setting, refer to 3) Setting Up Poland Localization.
Click Edit beside the localization setting record you wish to modify.
Under the Subledger Report tab, provide the following details:
Folder ID: Enter the internal ID of a File Cabinet folder where the generated reports are stored and saved.
A/R Subledger Saved Search: Select the saved search to be used as the data source of the report. By default, the value of this field should be [STA] PL Default A/R Subledger Search.
A/P Subledger Saved Search: Select the saved search to be used as the data source of the report. By default, the value of this field should be [STA] PL Default A/R Subledger Search.
It is possible to customize the default saved search by replacing the source fields of each column. However, it is currently impossible to add or remove new columns. It is important to note that the Custom Label must remain the same for any customized search to work with the current report.
Optionally, you may also configure the following fields:
Report by Period: Check this box to report by period. If left unchecked, the report is run based on the transaction date.
Default Email Sender: Select the default employee to be used as the sender of email notifications. If left blank, no email notifications are sent. Please ensure that an email address is set for the selected employee. Otherwise, an email error will occur.
Generating the Subledger Report
To generate a subledger report:
Navigate to Reports > Poland Reports > Generate Subledger Report.
Under Primary Information,
Select a Subsidiary.
Enter a Start Date and End Date.
If Report by Period is enabled, select a Start Period and End Period.
Select a Report Type. Current options available are:
A/R Subledger: An Accounts Receivable (A/R) Subledger is a detailed and specialized accounting record that provides a comprehensive view of an organization's receivables transactions. The A/R subledger is a general ledger component, focusing specifically on tracking and managing accounts receivable activities.
A/P Subledger: An Accounts Payable (A/P) Subledger is a detailed accounting record that tracks and manages an organization's payable transactions. The A/P subledger is a general ledger component dedicated explicitly to recording and organizing information related to amounts owed by the company to its suppliers, vendors, and creditors for goods and services received.
Select your preferred report Language. If your preference is set to English (International), then the report language is defaulted to English. Otherwise, it is defaulted to Polish.
Optionally:
You may mark the Include Opening Balances check box to add an opening balance line in the report.
You may select one or more Accounts to filter the accounts to be included in the report. If none are selected, all accounts are included.
You may select one or more Entities to filter the entities to be included in the report. If none are selected, all entities are included.
You may add a Memo to describe or comment on the report run.
Click Save.
Review the details of the saved record. The Status is saved as Not Started. Only proceed with the following steps if all details are finalized.
Click Generate Report.
Clicking the Generate Report button triggers the generation of your report in the background.
After clicking, you can only change the Memo field from now on.
Prompt and alert notifications are timely and provided for all successful or unsuccessful report runs.
If a Default Email Sender is specified, an email notification is sent to the user who clicked the Generate Report button.
If you wish to wait, you may click the Refresh button until the process finishes. A prompt, whether it's successful or failed, will be shown.
If successful, the Status is set to Done, and the file can be downloaded under the PDF field.
If unsuccessful, the Status is set to Failed, and an error message is displayed under the Error field.
Additionally, the following fields are updated for each run:
Generated By: This is the user that clicked the Generate Report button. The same user is printed on the report under the Generated By section.
Generated Date: This is the date the report generation finished. The exact date is printed on the report under the Generation Date section.
It's important to note that discrepancies can occur between the Generated Date in the record and the Generated Date in the file when the server's time zone and the current user's time zone under user preferences are different. The Generated Date in the file will always follow the server's time zone, while the Date and Time shown in NetSuite will always follow the user preference. However, if the user preference is switched to the server's timezone, both values should be the same.
Viewing the Subledger Report
Once a file is generated, you may download the file under the PDF field or click on the link to see a preview of the file. The report is divided between a report header and a report line section. The contents of each section are explained below.
Report Header Information
Report Name: This details the type of subledger report generated, whether it's an Accounts Receivable Subledger or an Accounts Payable Subledger.
Subsidiary Legal Name: This displays the legal name of the selected subsidiary during report generation.
Report Period: This displays the date range of the transactions included in the report.
Total Report Pagination: This displays the pagination of the overall file.
Date Generated: This displays the date the system generated the report.
Generated By: This displays the NetSuite employee who generated the report.
Entity: This displays the relevant entity for the section of the report. All report lines are associated with the entity.
Entity Pagination: This displays the pagination of the report respective to the entity.
Report Line Information
The generated subledger report contains the following report line information:
Type: This displays the transaction type of the line.
Date: This displays the date of the transaction. The format of this date depends on the user preference of the employee who generated the report.
Period: This displays the transaction's posting period. This column has a maximum width of ten (10) characters.
Document Number: This displays the document number in the NetSuite system. This column has a maximum width of twenty-five (25) characters.
Name: This displays the relevant entity for the transaction.
Memo: This displays the memo associated with the transaction.
Department: This displays the Department set on the transaction's header.
Class: This displays the Class set on the transaction's header.
Location: This displays the Location set on the transaction's header.
Created By: This displays the NetSuite employee who made the transaction.
Debit: This displays the debit balance of the transaction.
Credit: This displays the credit balance of the transaction.
Balance: This displays the running balance of the report on a per-entity basis.
Example
Send an email to support@staria.com for questions or concerns regarding this topic.