|
Go to the Trial Balance on Pastel
accounting.
|
|
Copy the Trial Balance to Excel.
|
|
Insert 5 lines, so that the first account
number starts on line no. 6.
|
|
Clear all prior year columns.
|
|
Clear column’s C & D.
|
|
Insert formula in column G (+E6-F6)
|
|
Copy formula in column G6 through to the end.
|
|
Copy the value in column G to column D
|
|
Copy column’s A – D to
Management Report on Excel.
|
|
Print Budget.
|
|
Transfer Budget onto Management Report.
|
|
Go through Management report and do
corrections if necessary.
|
|
Print Management report and discuss
statement with the the Directors and Managers in the Financial Meeting.
|
|
After the financial meeting prepare the
statement for reporting to Nashua Midrand (Head Office).
|