Updating Last Year's Balances

This is only possible if your Sage system allows it (system key NLUPDMAST = YES).

Sage's own functionality with regards to entry of reporting currency last year balances seems to be suspect, and you may wish to check this all works to your satisfaction before using this functionality.

If allowed you can download and update the base and reporting currency last year's balances held against (detail level) posting codes. Four sets of ranges are provided:

  • Base currency (download)
  • Reporting currency (download)
  • Base currency (upload)
  • Reporting currency (upload)

Upload ranges can be laid over download ranges.

When updating, you can choose not to include the reporting or base currency ranges.

If creating new records, the other value to the one included on the spreadsheet will always be calculated using the current exchange rate.

If updating existing records, you can choose whether the other value to the one included on the spreadsheet is recalculated or left unchanged. This is set in Options.