Debtors - Transaction list reports (Reports menu)
The following two (2) reports may be printed to list the transactions:
•Debtor transaction list - This report lists all the transactions in documents and batches which are posted (updated) to the ledger. All transactions will be listed irrespective of open item links.
•Debtor transaction list - Open item - This report lists only those outstanding transactions in documents and batches which are posted (updated) to the ledger. If a debtor (customer / client) account is set as Open item account (Debtors - Accounting information tab (Action ribbon)), it will list only those transactions with outstanding amounts. Any credit amounts, which are not linked to debit transactions, should be processed in Open item link (Action ribbon).
|
|
These reports does not include any opening balances. |
Report options
To print Debtor - Transactions list reports:
1.On the Reports ribbon, select Reports → Debtors → Transactions. The "Transactions" report options will be displayed.
2.Select the "Transaction list" or "Transaction list - Open item" report.
3.Select the following options:
a)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.
b)From ... To - Select a debtor (customer / client) account or a range of debtor (customer / client) accounts, to include in the report.
c)Sequence - Select "Debtor code" to print the report by account code or "Description" to print the report by account description (name).
d)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).
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.
4.Click on the OK button.
Printed example : Debtors Transaction list
An example of the "Debtors - Transaction list" report, is as follows:.
Printed example : Debtor transactions - Open item
An example of the "Debtors - Transaction list - Open item" report, is as follows:
|
|
The credit transactions which are linked to specific debit transactions of the same value, will not be displayed. If a transaction of a different amount is linked to a specific transaction, only the outstanding amount (difference) will be listed.
For example, an payment of 2000.00 is received from the debtor (customer / client) on 2021/03/16. The payment is linked as follows: •INV003 - 2021/03/10 - 1150.00 is fully settled (linked to the payment of 2000.00) - •The remaining balance of 850.00 is linked to INV003 as a partial settlement of IN000001. An outstanding amount of 300.00 will be printed on some reports. This amount is calculated as 1150.00 minus the partial settlement of 850.00 = 300.00 as the outstanding amount. As per this example - •Invoice INV003 will not be printed on some reports and in other reports it will print 0.00 as the outstanding amount. •IN000001 will print on some reports as 300.00 as the outstanding amount. |
|
|
Any credit amounts (e.g. CR000003) on this report implicates that the transaction(s) are not linked to a debit transaction. You may need to process the links on the Open item link option (Action ribbon). |
|
|
The credit transactions which are linked to specific debit transactions of the same value, will not be displayed. If a transaction of a different amount is linked to a specific transaction, only the outstanding amount (difference) will be listed. |
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). It also displays if the debtor (customer / client) account is an open item account.
4.Detail - List the transaction details for each account.
a)Date - The date of the transaction or document.
b)Period - This will display the accounting period's description (i.e. name of the month).
c)Batch no. - The Batch number as generated for posted batch transactions. If documents (i.e. invoices and credit notes are posted, the document number will be listed.
d)Alias - The Batch name (as entered in the "Change alias" field, or Auto-alias generated), for posted batch transactions. If documents (i.e. invoices and credit notes are posted, the document number will be listed.
e)Reference - The reference number of the document (i.e. Invoices and Credit notes) or the reference number entered in the reference column on the "Batch entry" screen.
f)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 and Credit notes) or the description entered in the description column on the "Batch entry" screen.
g)Debit - The debit transaction amount.
h)Credit - The credit transaction amount.
i)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.
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.