I would like to have an income statement and balance sheet that show me the previous year and the current year totals side by side in Sage 300 CRE.
This method is a suggested workaround. There is no guarantee that the data will be reflected correctly. You must verify that the information displayed is correct.
If the information does not display correctly, a custom financial statement may be necessary. Please contact your Sage Consultant for help in creating a custom statement.
CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.
There is not a default statement that shows a side by side comparison of current and previous year.
Workaround:
Append the default Current balance column with an Balance 1 Year ago (Balance fields) column and a 1 Year Ago Activity column.
Income Statement:
- Launch Financial Statement Designer.
- Select File, Open
- In the Open Statement Design window, double click on IncSAccr.FSD.
- With the statement open, click File, Save As.
- Type a unique name for the design in the File Name area.
- Click Save.
- In the design, double-click the title Current Balance.
- In the Column Options -- Column 4 window, click the button Append.
- In the Insert Columns window, make sure the Field Type on the right is set to Balance Fields.
- In the list, scroll down to and highlight Balance 1 Year Ago and click the Add button, then the Done button.
- With the Column Options -- Column 5 window open, click Append.
- Verify the Field type is still Balance Fields, and then scroll to and highlight 1 Year Ago Activity then click the Add button, and then the Done button.
- Click OK.
- Click File, Save, then File, Close.
Balance Sheet:
- Launch Financial Statement Designer.
- Select File, Open.
- Select the BalSAccr.FSD.
- Repeat the steps above with the exception of Steps 10 and 11. This will append the balance sheet with only Balance 1 Year Ago column.
- For Retained Earnings, see Why is my retained earnings balance incorrect for the prior year on my comparative Balance Sheet statement?
- Solution ID
- 224924650064809
- Last Modified Date
- Mon May 02 23:33:04 UTC 2022
- Views
- 0