I am closing the year 2011 in my company, for that i follow the document from internet and while making the “closing sheet” when i click on the “load balances” i am not getting the figure in “balance” column rather i found on “Difference” column. My question is this do we have to manually have to enter the figure in "balance " column as what we have in the “difference” . And after that click on post.
Please take a look at your leder account setup as this setup has an influence on the column in which you can identify the amounts posted in the closing sheet.
I close the year but in some of the ledger account the amount is not been transfer when i generate the trail balance if the “include Opening” and “closing transaction” check mark is uncheck, i also check the “account type” in “chart of account” as it is of “Assets” type.
“Close” feild we use in the chart of account, so that when we prepare the closing sheet the balances move automatically in the result, balance or in capital column. And also i got how can i reverse the closing.
But the question still here “why the opening balance is not showing for some of the accounts”
Actually there is some misunderstanding in generation of the Trail Balance report, actually i was selection the transaction in the criteria, rather we have to select the closing balance. And one more thing, if the transaction during the year is not their it will not show the opening balance also if you selected the transaction in the criteria.
In Chart of Account/General/ Close feild, we use when we create the closing sheet for the year closing, the amount come in the respective column in closing sheet.e.g. if you select “balance” in Chart of accounts then in closing sheet it will come under balance column.
Here i got the solution, actually if we generating the trail balance report and during the year transaction is not there then it will not show that account whether it have opening balance or not.
For that it is better to put the closing balance in the criteria and generate the trail balance.