Drill Down Enquiry - Nominal


Datafile Software

Drill Down Enquiry - Nominal

Particularly useful when using a cost-centre structured nominal code this option gives you a view of the ledger at the highest level and you can then drill-down to the lower levels of the hierarchy all the way to the transactions.

Enquire Accounts ‘As At’ Period

Journal Date Range From / To

Firstly, you are asked for the period number and date range (for transaction display) to use for this enquiry. Enter as required.

Balance Items to be Reported

Next you can select up to three balance items to be reported. The balance items, displayed on the right of the screen, allow you to display values such as the movement for the period, budget for period and the variance.

Available balance items are:

1 Current Balance – The balance of the account as it would appear on the trial balance

2 Start of Year Balance – The opening balance at the start of the year

3 Start of Period Balance – The opening balance at the start of the current period

4 Comparative Year Balance – The balance of the account as at the end of last year

5 Comparative Period Balance – The movement on the account for the same period last year

6 Budget for Year Balance – The total budget set for the year

7 Budget for Period Balance – The budget set for this period

8 Movement for Year – This is the difference between the start of year balance on the account (item 2) and the current balance (item 1)

9 Movement for Period – This is the difference between the start of period balance (item 3) and the current balance (item 1)

10 Comparative Year Variance – This is the difference between the balance at the end of last year (item 4) and the movement for the year (item 8)

11 Comparative Period Variance – This is the difference between the movement on the account for this period last year (item 5) and this year (item 9)

12 Budget Year Variance – This is the difference between the budget total for the year (item 6) and the movement for the year so far (item 8)

13 Budget Period Variance – This is the difference between the budget for the period (item 7) and the movement for the period (item 9)

14 Budget for Year Accum – This is the budget year-to-date (i.e. up to the period you run the enquiry for) as opposed to item 6 for the full-year’s budget.

15 Budget for Year Accum Variance – This is the difference between the year-to-date budget (item 14) and the movement for the year (item 8)

16 Comparative Year Accum – This is the year-to-date balance for this period last year as opposed to the full year balance that is item 4.

17 Comparative Year Accum Variance – This is the difference between the balance at this point last year (item 16) with this year (item 8)

After setting the balance items (you don’t need to set all three) the system accumulates the balances up the hierarchy of the accounts (if transactions have been generated since last run) and displays the enquiry for level 1.

You can scroll up/down the list using the arrow keys, the <page-up> and <page-down> keys, or use the mouse on the right-hand scroll bar. <F7-Option> will display a screen detailing more information on the account.

To move to the next level press <Enter> or double-click with the mouse.

You can move up/down the hierarchy all the way to the transactions. To move back up a level use the <ESC> key. If there are further levels then selecting an entry takes you to the next level, if no further code levels then selecting an entry takes you to its transactions.

At the transaction level <F6-Journal> can be used to display the full detail of the journal and <F7-Option> can be used to view more detail on this transaction record.


Custom Fields

Article ID: 1021
Created On: Wed, Jun 27, 2012 at 1:57 PM
Last Updated On: Mon, Jun 19, 2023 at 7:21 PM

Online URL: https://kb.datafile.co.uk/article/drill-down-enquiry-nominal-1021.html