Background

Requirement of the Balance Sheet Specifications is the part of financial statement annual reporting, and the requirement is based on Finnish Accounting law (KPL 3:13 §). The balance sheet Specification report lists in detail the open transactions and contents of each balance sheet account, except for equity accounts (equity is specified in the notes to the balance sheet). On the balance sheet specification report is reported account’s opening balance, open unsettled transactions and closing balance of account.

However all balance sheet accounts are not always wanted to specify on the balance sheet specification report, so those balance sheet accounts can be reported through separate reports. This kind of accounts are for example accounts payable accounts, account receivable accounts, bank accounts, warehouse accounts etc. These kind of account’s open transactions and details are reported via separate ledger reports e.g. open invoices list per end of month.

Suggesting idea

Now in Dynamics 365 Finance and Operations is not included balance sheet specification regional report for Finnish features, but there exist one possible report which is found in French country specific features. This report is found in: General ledger/Inquiries and reports/Transaction list by account.

The Transaction list by account - report is using ledger settlements data (General ledger/periodic tasks/ledger settlements) on the report. With this report, the user can choose the account interval from which they want to print transactions, as well as whether to print only unsettled (open transactions) or all account transactions. Also, the report supports the functionality if the ledger settlements are not done in the ledger settlement functionality (e.g., accounts payable and accounts receivable accounts), so user can determine on the account’s basic information if the account is reported only total by period -level. This functionality is found on: General ledger/Chart of accounts/accounts/main accounts and legal entity overrides/financial statement.

One functionality should be added on this report due to Finnish law (KPL 2:10 §), because the balance sheet specification report needs to archive 10 years and the report should be able to print out in afterward also so that the report is not changing. For this requirement in Dynamics 365 Finance and operations the ledger settlement date (wish is added when the functionality settle marked transactions done) should be added on the ledger settlement transactions (LedgerTransSettled - form). This date should be the Transactions list by account -report’s To date for the settled transactions. At the moment all settled transactions are removed from the report regardless of the settlement date.

So suggestion is that Transaction list by account -report is taken in use as Finnish regional feature with the minor changes.