Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

TCDrillDown Plugin - DrillDown (Transactions)

Article Index

Page 3 of 6

DrillDown (Transactions)

The columns (if all is selected), is as follows:

  1. Account Type – There are five (5) account types (i.e. Bank, Creditor, Debtor, General Ledger and Tax).

  2. Transaction No. – The number of the Transaction in the Transaction table of the database.

  3. Batch No. - This is the number of the batch (journal) as allocated by TurboCASH. The last column (i.e. “Journaal”) displays a more friendly version of the Batch No.

  4. Date – The date of the transaction.

  5. Period – The accounting period (e.g. Month) of the transaction.

  6. Account No. – The account code for Bank, Creditor, Debtor, General Ledger and Tax accounts.

  7. Account – The description or account name.

  8. Group 1 – Account group 1 for Bank, General Ledger and Tax accounts. Creditor Group 1 for Creditor accounts and Debtor Group 1 for Debtor accounts.

  9. Group 2 – Account group 1 for Bank, General Ledger and Tax accounts. Creditor Group 1 for Creditor accounts and Debtor Group 1 for Debtor accounts.

  10. Reference – The reference as entered in the Reference column of batches and in the case of sales documents (i.e. Invoices, Point-of-Sales Invoices and Credit Notes) and purchase documents (i.e. Purchases and Supplier Returns), the document number will be displayed.

  11. Description – The description as entered in the Description column of batches. In the case of documents, the description is as follows:

    1. Sales account – Stock Item's description.

    2. Cost of Sales and Stock Control account – COST OF SALES/Document Number.

    3. Creditor account – Document Type/Document Number.

    4. Debtor account – Document Type/Document Number.

    5. Tax (Input and Output Tax) – Document Type/Document Number.

  1. Debit – Amounts entered or generated as balancing entries in the Debit column of batches. In the case of documents, the description is as follows:

    • Debit Tax – Amounts entered or generated as balancing entries in the Debit column of batches. In the case of documents, the description is as follows:

    • Debit Outstanding – Outstanding amounts in the Debit column. This is usually the same, as the Debit amount, unless a credit transaction have been linked to the debit transaction to an Open Item account.

  2. Credit – Amounts entered or generated as balancing entries in the Credit column of batches. In the case of documents, the description is as follows:

    • Credit Tax – Amounts entered or generated as balancing entries in the Debit column of batches. In the case of documents, the description is as follows:

    • Credit Outstanding – Outstanding amounts in the Credit column. This is usually the same, as the Credit amount, unless a debit transaction have been linked to the credit transaction to an Open Item account.

  3. Journaal - This is the Alias (Batch name). If the Change the Alias option on batches were used before posting batches, the Alias will be displayed. Should the Aliases of batches not be used, more than one batch will be listed. You may then need to use the Batch No. to filter for a specific batch.