Excel Add-in: explanation of the SUB_CLASS_BAL_DATE function

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case 'SUB_CLASS_BAL_DATE'.

Sub-classifications
Select the sub-classification (category 2) for which you want to retrieve the balance amount. Select multiple sub-classifications as follows: 001:005. In this case the balance for sub-classifications 001 through 005 will be displayed.

From date
Select a date as of which you want the balance to be retrieved. Transactions that occurred before this date will not be included.

To date
Select a date up to which you want the balance to be retrieved. Transactions that occurred after this date will not be included.

Unprocessed
You can retrieve information after entry. This means that information from unprocessed entries will also be displayed (unprocessed= 1; processed=0).

Value
Select which value you want to have displayed in the worksheet. You have the following options:

• Debit (1): the total of the amounts debited
• Credit (2): the total of the amounts credited
• Balance (3): the balance of the debit total and the credit total
• Positive (4): same as the balance, but only positive values are displayed
• Negative (5): same as the balance, but only negative values are displayed (as positive values)
• Quantity (6): The quantity (as entered) is included

Range
If you select 'Date' here, entries for which the entry date falls within the range will be included in the result. If you select 'Reporting date' here, entries for which the reporting date falls within the range will be included in the result.

Include closing entries
Here you can indicate if you also want to include closing entries in the function.

Example

SUB_CLASS_BAL_DATE("001:005";17;"21/6/2001";"21/6/2002";1;3;1;1)
The balance after entry for the sub-classifications 001 through 005 in the entry date range 21 June 2001 through 21 June 2002, including closing entries, will be displayed on the worksheet.