Ledger - Transactions - Standard / Extra details (Reports menu)
The General ledger transactions - Standard report lists all the transactions in documents and batches which are posted (updated) to the ledger.
The General ledger transactions - Extra details report is similar to the General ledger transactions - Standard report, but displays extra details of the Contra accounts (i.e. Account code, Account description, Contra account code and Description as well as the Tax account code and Description). For example;
" C2ABCOS ABC-Office Sup,T860020, Input VAT-Standard rate - 15% " , etc.
These reports does not include any opening balances for Income and Expense accounts reported on the Income statement. These reports will include opening balances for all other ledger accounts. |
Report options
To print General ledger transactions - Standard / Extra details reports:
1.On the Reports ribbon, select Reports → Ledger → Transactions.
2.Select the "General ledger transactions - Standard" or "General ledger transactions - Extra details".
3.Select the following options:
a)Report type - Select the "Debtor Transactions - Standard" or "Debtor Transactions -Extra details " report.
b)Period - Select a period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates to include transactions in the report.
c)From ... To - Select a general ledger account or a range of general ledger accounts, to include in the report.
d)Sequence - Select "Account" to print the report by account code or "Description" to print the report by account description (name). You may also select "Reporting group 1" or "Reporting group 2" to print the accounts according to the the Account group 1 or Account group 2 as added in Groups on the Setup ribbon and linked to the Accounts (Action ribbon).
e)Include zero balances - If this option is not selected (not ticked), it will list only the transactions for accounts which has transactions and / or balances. Tick this option to include opening balances (closing balances before the selected periods / dates).
Opening and Closing balances will not be displayed for Income and Expense account types. It will only be displayed for Balance sheet accounts. |
f)New page per account - If this option is selected (ticked), it will print the transactions for each account on a new page.
The Company details will not be printed as in the Page header. The company name is displayed in the Page footer. |
g)Cost centre 1 / 2 - If you have activated Cost centres, you may select the Cost centres.
3.Click on the OK button.
Printed example : General ledger transactions - Standard report
An example of the "General ledger transactions - Standard" report, is as follows:
Printed example : General ledger transactions - Extra details report
An example of the "General ledger transactions - Extra details" report, is as follows:
The details on the report, is as follows:
1.Page header 1 - Company details - This will only print on the fist page.
If the New page per account option on the report parameters is selected (ticked), the Company details will not be printed in the Page header of the first page. The company name is displayed in the Page footer of all pages. |
2.Page header 2 - Report name and parameters as selected on the report options will display below the Company details on the first page and at the top of each subsequent page.
3.Header group - The Account code and Name (description).
4.Detail - List the transaction details for each account.
a)Reference - The reference number of the document (i.e. Invoices, Credit notes, Purchases and Supplier returns) or the reference number entered in the reference column on the "Batch entry" screen.
b)Date - The date of the transaction or document.
c)Description - The stock item code or the account description (if the Financial entry stock item type was selected on a document) of the document (i.e. Invoices, Credit notes, Purchases and Supplier returns) or the description entered in the description column on the "Batch entry" screen.
d)Debit - The debit transaction amount.
e)Credit - The credit transaction amount.
f)Cum - The accumulative total of the transactions included in the account.
5.Footer - Groups - Total / Balance - Displays the total of the transactions and the closing balance for each account.
Closing balances will not be displayed for Income and Expense account types. It will only be displayed for Balance sheet accounts. |
6.Page Footer - List the following:
a)Data - Name of the Set of Books and the full path of the Set of Books (e.g. ...\books\BOOKSNAME\Books.fdb)
b)System user and TurboCASH user (Access control on the Setup ribbon).
c)Printed: The date and time of the system (computer) on which the report is printed.
d)Page: Page number and the last page number of the report.