Now that you have created one scenario, you are ready to use it in any report.
But first let's create a reversing journal.
Gateway of Tally->Voucher Entry->F10:Memo
Select Reversing Journals from the list
For 31-12-98 make the following entry:
Dr Depreciation (under Group Indirect Expenses) 15000
Cr Prov. For Depreciation (under Group Fixed Assets) 15000
Narration: depreciation for the month for HO reporting purposes. Actual depreciation to be provided for the whole year at year end.
Accept the Voucher.
Display/Alter a Reversing Journal
You can view or alter the reversing journal through the Reversing Journals Book found under Exceptional Reports.
Gateway of Tally->Display->Exceptional Reports->Reversing Journals
Select a month to list all the reversing journals for that month. Drill down to view or alter the entry.
Using Scenarios in Statements and Reports
You can use scenarios in most statements (not registers) that have the Column buttons active.
Display the Balance Sheet
Select New Column
In the column details, tab down to Types of Values to Show
Select Provisional. You will note that it is described as Scenario.
You now have two columns in the Balance Sheet for the same date; in the figure below for 31-12-98.
Note the Provision for Depreciation figures in both the columns. The actual column shows –18250 while the Provisional column shows –33250. This is because the Provisional Scenario contains a reversing journal for the difference. If you try to drill down the Provisional figure, you will not be able to see the actual transaction as it is not actually in the books. To view it, you must go through the Exceptional Reports Display Menu.
Note that Unadjusted Forex Gain/Loss figure is not included in the Provisional column confirming the Scenario set-up.
You can use the same procedure to create another scenario for Sales Forecasts.
Create a new Scenario and call it Sales Forecasts.
Include Sales Vouchers Optional Only.
Now create 12 Sales Vouchers one in each month in the future. Remember to mark them Optional.
View the Sales Accounts by drilling down the Profit & Loss A/c.
Bring up New Columns and limiting each column date range to the following month.
You will have the sales forecast figures.
For this purpose, you could even used Memorandum Vouchers.
But first let's create a reversing journal.
Gateway of Tally->Voucher Entry->F10:Memo
Select Reversing Journals from the list
For 31-12-98 make the following entry:
Dr Depreciation (under Group Indirect Expenses) 15000
Cr Prov. For Depreciation (under Group Fixed Assets) 15000
Narration: depreciation for the month for HO reporting purposes. Actual depreciation to be provided for the whole year at year end.
Accept the Voucher.
Display/Alter a Reversing Journal
You can view or alter the reversing journal through the Reversing Journals Book found under Exceptional Reports.
Gateway of Tally->Display->Exceptional Reports->Reversing Journals
Select a month to list all the reversing journals for that month. Drill down to view or alter the entry.
Using Scenarios in Statements and Reports
You can use scenarios in most statements (not registers) that have the Column buttons active.
Display the Balance Sheet
Select New Column
In the column details, tab down to Types of Values to Show
Select Provisional. You will note that it is described as Scenario.
You now have two columns in the Balance Sheet for the same date; in the figure below for 31-12-98.
Note the Provision for Depreciation figures in both the columns. The actual column shows –18250 while the Provisional column shows –33250. This is because the Provisional Scenario contains a reversing journal for the difference. If you try to drill down the Provisional figure, you will not be able to see the actual transaction as it is not actually in the books. To view it, you must go through the Exceptional Reports Display Menu.
Note that Unadjusted Forex Gain/Loss figure is not included in the Provisional column confirming the Scenario set-up.
You can use the same procedure to create another scenario for Sales Forecasts.
Create a new Scenario and call it Sales Forecasts.
Include Sales Vouchers Optional Only.
Now create 12 Sales Vouchers one in each month in the future. Remember to mark them Optional.
View the Sales Accounts by drilling down the Profit & Loss A/c.
Bring up New Columns and limiting each column date range to the following month.
You will have the sales forecast figures.
For this purpose, you could even used Memorandum Vouchers.
Comments