Closing the year accounts means : Making sure the transaction data consist only the transactions for the year - remove data irrelevant to the accounting period and make sure all data related to accounting period is taken in.
Once the data in sheet DATA conform to the above, automatically the Trial Balance, Balance Sheet, Profit Loss and other sheets are updated.
How to remove the data with date outside the accounting period?
Identify rows in column DATE which contain the irrelevant date.
You can identify one by one.
You can use filtering method.
No comments:
Post a Comment