Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook |
Financial Summaries - Percentage Variance Column |
Article Number: 80 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 7:07 PM
|
Datafile Software Financial Summaries - Percentage Variance Column Financial Summaries allow the print of variance values between items such as actual values against budgets, this year’s actual values against last year actual values etc.This new feature allows for the calculation of variance percentages within the ‘full mode’ financial summaries. Installation The percentage variance column needs to be configured
within the summary design, to update select the Financial Summaries option
within the Nominal Ledger menu and then press the <F7-Option> key to open
up the summary definitions and open up the required definition. Once the layout is displayed to add the column select
Parameters and open up the General Parameters – here you can set the print
position for a new balance column 101.When you set the balance item a pop-up asks for two columns between
which to work out the percentage variance. Calculate Column No (1-20) As Percent of Column No (1-20) These prompts ask for the two balance columns to work out the percentage values between. Note that the column numbers specified relate to the column entries and not the balance item values or the column print positions – in the above screen example column 1 is set as balance item 9 – Movement for the Period and column 2 is set as balance item 7 – Budget for the Period so to get a percentage of movement vs. Budget you would set to calculate column 1 as a percentage of column 2. To enable the print of the new column against an
existing financial summary entry line the simplest method would be to select
the ‘Line Spec’ option within the parameters so that you can set the columns to
print against each required line. Once set, from the design mask, choose the File
pull-down menu to Save and then Exit from the summary definition and then
<ESC> back to the nominal ledger menu. |
Attachments
![]() There are no attachments for this article.
|
Defining Financial Summaries - Nominal
Viewed 2568 times since Wed, Jun 27, 2012
Automatic Bank Reconciliation - View Bank Journal
Viewed 170 times since Wed, Oct 16, 2024
VAT Form 100 - Group VAT Registration
Viewed 4021 times since Tue, Oct 9, 2018
Cashbook - Global Transaction References
Viewed 1695 times since Fri, Jul 21, 2017
Maintain Receipt Templates, Maintain Payment Templates - Cashbook
Viewed 1672 times since Wed, Jun 27, 2012
PERIOD – Budget Input for Periods - Nominal
Viewed 1046 times since Wed, Jun 27, 2012
VAT Adjustments - Partial VAT Exemption Scheme
Viewed 3544 times since Thu, Oct 11, 2018
System Profiles Screen 1 - Nominal
Viewed 1797 times since Wed, Jun 27, 2012
FACTOR – Factor Period Budgets - Nominal
Viewed 980 times since Wed, Jun 27, 2012
ENTER – Enter Current Budget Year Totals - Nominal
Viewed 1017 times since Wed, Jun 27, 2012
|