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

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
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Audit Pointers - Cashbook
Viewed 1192 times since Thu, Jun 28, 2012
Reports and Analysis - Nominal
Viewed 1211 times since Wed, Jun 27, 2012
Reports – Today’s Receipts and Payments
Viewed 970 times since Wed, Jun 13, 2012
Transaction Control Numbers - Cashbook
Viewed 1173 times since Thu, Jun 28, 2012
MASTER – Maintain Header Accounts - Nominal
Viewed 1295 times since Wed, Jun 27, 2012
System Profiles - Cashbook
Viewed 1158 times since Thu, Jun 28, 2012
Multiple Updating - Update From Any Datafile Database File - Nominal
Viewed 1376 times since Thu, Jun 28, 2012
Account Cash Book - Nominal - Database Profiles
Viewed 1311 times since Thu, Jun 28, 2012
Warn if Sales/Purchase Account On-Stop
Viewed 1240 times since Tue, Jun 12, 2012
BUDGETS – Budgets Proposed - Nominal
Viewed 862 times since Wed, Jun 27, 2012