Old Reports -> Creditor -> Transactions

Parent Previous Next

This option is used to generate the detailed transactions in the creditors' ledger. This transaction report is a register of all transactions (purchases, supplier returns, payments, adjustments, etc.) for a specific creditor or all your creditors.

The Creditor Transactions Report Options allows you to view the detailed transactions of a selected creditor account, or a range of selected creditor accounts, in your Creditors Ledger. The detailed transaction report is a register of all the transactions with each of your creditors. The Creditor Transactions Report will include all transactions for which a creditor account was selected in batches (journals) which are posted to the ledger and documents which are updated to the ledger.

Any Unposted Batches and Documents will be excluded from the Creditor Transactions report.

The total outstanding balance of all your Creditors accounts will be reflected on the Creditors Control Account in the General Ledger. The transactions of the individual creditor accounts in the Creditors Ledger cannot be viewed in the General Ledger Transactions Report.

Print Creditor Transaction Reports

To Generate a Creditor Transaction Report:

1.Click on the Tools  → Old Reports → Creditor → Transactions menu.

The Creditor Transaction Report Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Sequence - You may select the selected accounts to be listed or displayed according to Account Number or Account Description.

b)Which Year - You may select This Year, or Last Year to generate the detail transaction report.

c)From Account ... To - You may select all your creditor accounts, a specific account or a specified range of accounts, to be included in this report.

d)From Reporting Date ... To - You may select any available range of periods for this year, or last year, depending on which year you have selected.

e)Reporting Group - All reporting groups is the default. Select an available creditor reporting group (if Reporting Group 1 or Reporting Group 2 was set up in the Setup → System parameters → Groups menu).

Creditor (supplier) accounts linked to a specific (selected) reporting group will not be included in this report, if the creditor (supplier) accounts is not included in the range of accounts selected in the From Account ... To fields.

f)Each Period Separately - If this field is selected, the transactions for each account will be printed for each period separately if more than one financial period is selected. The opening and closing balances for each period will be displayed.

g)Each Batch Separately - If this field is selected, the transactions for each batch will be grouped and totalled for each batch in each account. A total for each batch in each selected account will be displayed.

h)New page per account - If this field is selected, each account will be printed on a new page.

i)Include Zero Balances - If this field is selected, all selected creditors accounts will be generated on this report. If this field is not selected, only those creditor accounts with balances will be generated on this report.

j)Show Details - If this field is not selected, no transaction details will be displayed only the opening and closing balances. To view the details of the transactions, you need to select this field.

If the Each Batch separately option is selected, and the Show Details field is not selected, the totals for each batch will be displayed.

4.Click on the OK button to send the report to the medium selected in the Send Report to field.

View Creditor Transaction Reports

The following is an example of Creditor Transaction report generated with details for one accounting period (March 2009):


The details of the creditor ledger transaction report will display the account code and name, as well as any opening and closing balances for each selected account. The transactions are displayed in eight columns as follows:

1.Date - This is the transaction date as entered in the date field of a batch entry screen, or the date of a document.

2.Report Range - This is the accounting period for the transaction date.

3.Batch Type - Purchase Journal, Payments Journal, etc. or any other batch type in which transactions were entered and posted to the ledger. In the case of documents, the Batch Type or journal, which is set for each document type in the Setup → System parameters → Documents menu, (Purchase and Supplier Returns documents) will be displayed.

4.Reference No - The reference number you have allocated to transactions entered on batches, (e.g. cheque number in the payments journal, etc.). In most cases, it would refer to the source document or supporting document. In the case of documents (Purchase and Supplier Returns documents), the document number as generated by TurboCASH will be displayed.

5.Detail - The description of the transaction entered on batches, (e.g. Payment on Account, etc.) to describe the nature of the transaction (e.g. what was purchased, paid, etc.). In the case of documents (Purchase and Supplier Returns documents), the selected stock item description would be displayed.

6.Debit - If a debit (purchase returns or a payment transaction) was posted to the selected account.

7.Credit - If a credit transaction (purchase transaction) was posted to the selected account.

8.Cumulative Balance - If the opening balance is a credit balance, any amounts in the credit column will be added (increase) and any amounts in the debit column will be subtracted (decrease) the credit balance, and vice versa. Creditor accounts should reflect a credit balance.

View Creditor Transaction Reports - Each Batch Separately

If the Each Batch Separately option is selected, the transactions will be grouped according to the batch types / journals and a total for each batch will be displayed. An example is as follows:

TurboCASH reports the Creditor ledger accounts in the 3-column format. If you wish to view any of the Creditor ledger accounts in the traditional T-Account format, you may click on the Tools → T-Account Viewer menu.


Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle