Running management reports for a previous financial year
Description
Cause
Resolution

Use a previous year's archive data

To produce a balance sheet, profit and loss or trial balance report for a previous financial year, run the reports from your archived data. This is the only option for a profit and loss report.

Use Transactional management reports

If you didn't archive your data and haven't cleared the audit trail for the reporting period, run these reports within your current data. You can exclude your year-end journals to show your prior year figures.
  • Transactional Balance Sheet
  • Transactional Trial Balance

 NOTE: Sage 50 Accounts Essentials doesn't include these reports. Use your archived data instead.

If you'd like to upgrade, leave your details and we'll be in touch.


Locate your ledger year-end journals
  1. On the navigation pane, click Transactions.
  2. In the search window, type Ledger Year End, then press Enter.
  3. Check the Date column to confirm that you see the financial year-end journals for the required year.
  4. Note the transaction numbers in the No column of the first and last ledger year-end journals. 

Run the transactional management reports

 CAUTION: We're aware of issues running some reports using criteria filters. See our Transaction number criteria article for more information. 

  1. In Nominal codes, click Reports.
  2. Select the relevant report to run, for example, Profit and loss.
  3. Select the Transactional Profit & Loss report, then click Preview.
  4. In the Criteria window, set the criteria as follows:
    Criteria Operator From To
    Transaction Date Between (inclusive) The required start date, for example, the start of the previous financial year. The relevant year-end date.
    Transaction No Outside (exclusive) The transaction number of the first ledger year-end journal for the relevant year. The transaction number of the last ledger year-end journal for the relevant year.
  5. Click OK.

Remove the search in Transactions
  1. Close your report and open the Transactions window.
  2. Click the bin icon next to the Search bar to discard your search and see all transactions. 

Steps to duplicate
Related Solutions