Entering Account Balances, Historical Data, and Quantities

Sage ERP Accpac General Ledger 6.0

Entering Account Balances, Historical Data, and Quantities

Entering multicurrency historical data

If you want to show source-currency balances for all past periods, you must enter transactions in each of the originating currencies, along with the exchange rate at the time, and the functional-currency equivalent amount.

Modifying historical data

If you need to change account data in the previous year after you have created your chart of accounts, you should enter the adjustments in a batch, then post the batch to the previous year.

Entering Current Year-To-Date Transactions

When you set up a General Ledger system partway through a fiscal year, you must enter the transaction data for the current year to date, in addition to the closing balances from the previous year.

For ways to add the data, click here.

  • Enter all the current-year transactions, one at a time, period by period.

This provides full detail (that is, a complete audit trail) for current-year transactions.

  • Enter all the transactions for the current period, and the net changes for the earlier periods in the current year.

This provides full detail for current-period transactions, and creates accurate balances for previous periods in the current year. You can print comparative financial statements for all the current-year periods to date, and detailed audit trail reports for the current period.

  • Enter the net change (net increase or decrease) for each account in each period to date, including the current period.

This produces accurate balances for each account in each period of the current year, allowing you to print comparative financial statements. However, it does not provide transaction detail (such as date, reference code, and description) for the audit trail reports.

  • Enter the net change between the opening and current balances for each account.

This is the quickest method, but it does not let you print financial statements for past periods in the current year and does not provide transaction detail for audit trail reports. Using this method, you would have to rely on your manually prepared financial statements for comparisons.

 

To add existing account balances and quantity data to a new general ledger, click here.

See also