Improving the Speed of Reporting

SunSystems Financials contains an optional Ledger Balance file which contains a summary of the ledger transactions posted to each account. This file can be used to speed up the processing of some reports.

Financial Analysis or Financial Statements use the Ledger Balances file, if it is available, wherever it is appropriate to a report setup. The ledger file is used in preference to the balance file under the following circumstances:

  • balances have not been created for this ledger/budget. If the report uses actuals and budgets, then the balances are used wherever they exist.
  • a report includes items such as transaction reference, description and journal number, which are not held as ledger balances data.
  • selection codes or sort levels are entered which are not held as ledger balances data.
  • the Provisional Postings option is set to optional or mandatory and the Select Transactions field is set to Exclude Provisional. The balances do not differentiate between provisional and permanent postings, so when you exclude provisional transactions, the report cannot use the Ledger Balances file.

If your report uses the balances, you are offered the option to update them when you print the report or save it to disk.