Producing an Account Listing

The Account Listing report identifies the transactions that have been posted to the ledger, by chart of accounts code. You can include transactions for a range of accounts and accounting periods. You can select a single account code or range of account codes and a range of accounting periods for which transactions are to be listed.

SunSystems Financials includes the following example account listings, some of which are tailored to the chart of accounts and analysis codes used in the PK1 demonstration business unit:

• Account Listing with Analysis for any Business Unit (ALAU) - this report prints the main transaction details and includes any analysis codes entered on the transactions.
• Account Listing with Analysis for PK1 (ALA) - this report prints the main transaction details and includes any analysis codes entered on the transactions for the PK1 demonstration database only.
• Account Listing for PK1 (ALPT) - this report prints all of the transaction details for each transaction, excluding any analysis codes and standard text, for the PK1 demonstration database only.

The account listing reports print the base currency, transaction currency and second base/reporting currency details for each transaction. Fourth and fifth currency fields are also available to be defined.

Within each account, the transactions are grouped by accounting period and the total postings to each period are shown in the base and second base currencies. Once all of the transactions have been listed for the account, for the accounting periods selected, the total of the account transactions is printed, analyzed by currency. Finally, the report prints the total of all transactions, for all the accounts and periods included on the report.

You can define account listing reports using the SunSystems Reporting functionality. You can design as many reports as you want, with each showing the information required.