taken from the
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 or journals which is posted
to the ledger, and documents which is
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.
The Creditor Transactions Report is generated on the Creditor Transaction Report Options screen on which the following selections will determine the format and the information included in the Creditor Transactions Report:
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 8 columns and are as follows:
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.
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.
The Creditor Transactions Report is generated on the Creditor Transaction Report Options screen on which the following selections will determine the format and the information included in the Creditor Transactions Report:
-
Sequence - select to display the accounts according to the
Creditor Account (Code), Creditor Account Description (Name) or Creditor Groups 1 or 2.
If Creditor Reporting Groups 1 or 2 was selected, you may select to display all available reporting
groups or only a selected creditor reporting group.
-
Select to view the transactions for This Year or Last Year.
Depending on the selected Year, you may select the accounting periods for a
Financial Year using This Year or Last Year Search or lookup facility.
-
Select to view a specific creditor account or a range of
accounts on the Creditors search or lookup facility.
-
Select to print each period separately (Opening and Closing
Balances for each accounting period) or to display totals for each batch or to
display details or not.
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 8 columns and are as follows:
-
Date - This is the transaction date as entered in the date
field of a batch entry screen or the date of a document.
-
Report Range - This is the accounting period for the
transaction date.
-
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 option, (Purchase or Goods Received Notes and Stock or Goods
Returned documents) will be displayed.
-
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 or Goods Received Notes and Stock
or Goods Returned documents), the document number as generated by TurboCASH
will be displayed.
-
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 or Goods Received Notes and Stock or Goods Returned documents), the
selected stock item description would be displayed.
-
Debit - If a debit (purchase returns or a payment
transaction) was posted to the selected account.
-
Credit - If a credit transaction (purchase transaction) was
posted to the selected account.
- 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 visa versa. Creditor accounts should reflect a credit balance.
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.
