Year end journal report
The Year End Journal report shows the totals transferred to the year end account for each profit and loss account. To run it, first check your financial year dates:
Click System, then click Options.
Click System Control Options, then click the Ledger Defaults tab.
Note the financial year start date and when the last period ended.
Then run the report:
Click Financials, then click ACR.
Select the Year End Journal report.
Enter the Year End Journal Ref.
Leave the currency blank.
Click OK.
Profit and loss account to update year end account
To ensure that profit and loss accounts update the required year end account:
Click Financials, then click Accounts.
Click Edit, then click Info.
Enter your designated year end account.
Click Save.
Profit and loss accounts have a major heading of one to six. Filter the major heading column to include values less than or equal to six to return only appropriate nominal accounts.
You can’t filter the balance sheet account column since any balance sheet account could be a year end account. You can order it to check that there’s no unexpected values appearing.
Use the profit and loss summary to compare the turnover year to date (YTD) for the accounts at the end of last year to ensure that the values match.
To find the summary:
Click Financials, then click Profit and Loss.
Select P&L 12 Month Summary.
To export all profit and loss transactions for the year to Excel and compare against the year end journal report, use the nominal transaction enquiry view:
Click Financials, then click Profit and Loss.
Select All Periods, then click the Excel icon.
Other information
Access Office Integration (AOI) is a useful tool for extracting and pivoting data more quickly than through the Financials front end.