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.

Account Listing

Business Unit
The business unit to be reported.
Ledger Code
The ledger to be reported.
Accounting Period Opening Balance
The period from which transactions are included in the report. The opening balance printed for balance sheet accounts is from this period.
Account Code From/To
The range of accounts to be included in the listing. If you want to include all account codes, click the All option.
Accounting Period
The period up to which transactions are included in the report. Leave this blank for all periods up to and including the current accounting period.
Provisional Posting Status
The type of transactions to include on the report. This is only required if provisional postings are mandatory or optional and it allows you to print either provisional or permanent transactions. Select Yes to print only provisional transactions, No to print only permanent postings or N/A to print all transactions.