How do I print financial statements for prior years?
Description

There are multiple methods to run financial statements for prior periods, depending on your scenario. Review these options and determine which fits your situation.

Use the Rollback option

If you need reports for periods in the current fiscal year or prior fiscal year, you can follow these steps print the statements or ledger.

Prefixes and Companies using 13 periods can rollback up to 25 periods when in the 13th period of the year. For Prefixes and Companies using 12 periods, the maximum rollback is 23 periods.

Modify existing financial statements

Most financial statement designs use balance fields that aren’t able to roll back. They can't calculate before the first period of the prior fiscal year. You can modify a financial statement to use prior fiscal year-end balances using the steps outlined below.

Restore a copy of your data for reporting

Restore the data and print the statements from an archive folder. You can restore data from a backup to a new data folder or create a copy of your data in a separate folder.

Use Office Connector

Sage Office Connector gives you the flexibility to run financials for prior years with the familiarity of Microsoft Excel. Breaking down the constraints of running these financials from backups. Contact our Sales team at 1-800-858-7095 or by email at [email protected] today for more information.

Cause
Resolution
[BCB:5:Third-party support:ECB]

 

Modify the default financial statements to print the fiscal year-end balances

Note: Don’t use the Rollback setting with these modified designs. When you select the End Balance [number] years ago fields, it builds in a rollback function.

Create a new accumulator

  1. In Financial Statement Designer, from the Tools menu, select Accumulators.
  2. Select Default Net Income - Accrual or Default Net Income - Cash and click Copy.
    Note: Choose the accumulator that matches your accounting method.
  3. Enter an accumulator name and click OK.
  4. In the Field column, select the first line and click List.
  5. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
  6. Repeat the previous two steps for each line in the accumulator.
  7. Click Save and then Close.

Modify the default balance sheet

  1. Open the default balance sheet (File, Open, BalSAccr.fsd or BalCash.fsd, Open).
  2. Save the balance sheet under a different name (File, Save As).
  3. Double-click the Current Balance column heading.
  4. Click GL Field.
  5. Select End balance [number] years ago or CEnd Balance [number] Years ago and click OK.
  6. Enter a description in the Heading box. This is optional.
  7. Click OK.
  8. Scroll down to the Equity section of the statement and double-click Net Income.
  9. Click Cell overrides.
  10. In the Current column list, select End balance [number] years ago or CEnd Balance [number] Years ago.
  11. Click Change field.
  12. Click Accumulators and select the accumulator created above.
  13. Click OK twice.
  14. Click Save and then Close.
  15. From the View menu, select Header.
  16. Select <Period ending date>.
  17. From the Edit menu, select Delete Instruction.
  18. Click Yes.
  19. From the View menu, select Body.
  20. From the File menu, select Save.
  21. From the File menu, select Close.

Modify the default income statement

  1. Open the default income statement (File, Open, IncSAccr.fsd or IncCash.fsd, Open).
  2. Save the income statement under a different name (File, Save As).
  3. Double-click the Current Activity column heading.
  4. Click Delete and click Yes twice.
  5. Click GL Field.
  6. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
  7. Enter a description in the Heading box. This is optional.
  8. Click OK.
  9. From the View menu, select Header.
  10. Select For the Period Ended <date>.
  11. From the Edit menu, select Delete Instruction.
  12. Click Yes.
  13. From the View menu, select Body.
  14. From the File menu, select Save.
  15. From the File menu, select Close.

Modify the default trial balance statement

  1. Open the default trial balance statement (File, Open, TBalAccr.fsd or TBalCash.fsd, Open).
  2. Save the trial balance statement under a different name (File, Save As).
  3. Double-click the Beginning Balance column heading.
  4. Click Delete and click Yes twice to remove the Beginning Balance column.
  5. Click Delete and click Yes twice again to remove the Current Period Activity column.
  6. Click GL Field.
  7. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
  8. Enter a description in the Heading box. This is optional.
  9. Click OK.
  10. From the View menu, select Header.
  11. Select <Period ending date>.
  12. From the Edit menu, select Delete Instruction.
  13. Click Yes.
  14. From the View menu, select Body.
  15. From the File menu, select Save.
  16. From the File menu, select Close.

Tip: To make reporting easier, you can create a Statement group to run all prior year statements at once. See detailed directions on creating Statement Groups.

Steps to duplicate
Related Solutions

How do I print a YTD ledger for prior periods before the first period of the prior fiscal year?

Asterisks appear in financial statement columns

How do I use ODBC to fill in the Activity Balances and Debit Activity fields on General Ledger Accounts?

How do I copy my files to another data folder for testing or historical reporting in versions 16.1 and later?

How do I print a trial balance for a prior period or Year?