Rebalance Ledger Period Totals

Use this utility to create period total records that contain the sum of the transactions for a particular period.

Creating period totals improves the speed with which reports can run, because the system calculates account balances at the time the report is printed. It does not store totals. To get a total, it must sum up ledger transactions for an account up through the required date.

This utility processes all ledger transactions and creates balance totals per period, for each account. This information is then used for General Ledger reporting.

Run this utility if you suspect that the period totals are not correct, because it takes some time if there are a lot of ledger transactions. You might also want to run this utility when you have sort methods that need to be maintained only for a short period of time.

For example, suppose you have defined a sort method for a financial report that is needed for year end closing. Maintaining this report throughout the year would be an unwanted performance hit for eleven months. You would leave the index inactive for eleven months and when the time came to run your report, you would run this utility for this one sort method and select the Active Only check box. Once you are done with your year end reporting, you would go to the Period Sorting Methods form and deactivate the sort method until next year.