Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Financial Summaries - Percentage Variance Column

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.


Custom Fields
  • Release ID: 6.4
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Set Auto Expand Data Files - Cashbook
Viewed 1331 times since Thu, Jun 28, 2012
Compact & Audit Database - Cashbook
Viewed 1259 times since Thu, Jun 28, 2012
DELETE - Delete an Account - Nominal
Viewed 2426 times since Wed, Jun 27, 2012
Payments with Remittance Advice - Cashbook
Viewed 7050 times since Wed, Jun 27, 2012
Database Audit - Cashbook
Viewed 1304 times since Thu, Jun 28, 2012
VAT Form 100 - Cashbook
Viewed 1925 times since Wed, Jun 27, 2012
Period/Year End Facilities - Nominal
Viewed 1416 times since Thu, Jun 28, 2012
Expand Data Files - Nominal
Viewed 1326 times since Thu, Jun 28, 2012
Ledger Enquiry Manager - Nominal
Viewed 1357 times since Wed, Jun 27, 2012
VAT Adjustments - VAT on Imported Goods
Viewed 4152 times since Fri, Oct 12, 2018