TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







VIEW CREDITOR LEDGER REPORTS
VIEW CREDITOR TRANSACTION REPORT
  
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:
  1. 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.

     

    LI> 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.

  2. Select to view a specific creditor account or a range of accounts on the Creditors search or lookup facility.

  3. 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 following is an example of Creditor Transaction report generated with details for 1 accounting period (March 2005):

Name of the business. Name of the report. Selected accounting period or periods. System date and time. Page number. Transaction date. Transaction date. The Creditor account number and description or name. The Opening balance for the selected period. The Closing balance for the selected period. The balance as accumulated (increased or decreased) by each transaction. The total of all the closing balances of selected accounts in this report. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Debit amounts of transactions. Credit amounts of transactions. Debit amounts of transactions. Credit amounts of transactions. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. The Creditor account number and description or name. The Opening balance for the selected period. The Closing balance for the selected period. Transaction date. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Debit amounts of transactions. Credit amounts of transactions.

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:
  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 option, (Purchase or Goods Received Notes and Stock or Goods Returned 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 or Goods Received Notes and Stock or Goods Returned 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 or Goods Received Notes and Stock or Goods Returned 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 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.

Name of the business. Name of the report. Selected accounting period or periods. System date and time. Page number. Transaction date. Transaction date. The Creditor account number and description or name. The Opening balance for the selected period. The Closing balance for the selected period. The balance as accumulated (increased or decreased) by each transaction. The total of all the closing balances of selected accounts in this report. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Debit amounts of transactions. Credit amounts of transactions. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Total of the transactions entered in a specific batch. The Creditor account number and description or name. The Opening balance for the selected period. The Closing balance for the selected period. Transaction date. Accounting periods. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Total of the transactions entered in a specific batch. Debit amounts of transactions. Credit amounts of transactions. The batch type or the name of the journal in which the transactions is posted or updated to the ledger. Reference number for the transaction. 8 Asterisks (********) indicates that it is a balancing entry. If a document is updated to the ledger, the document number will be displayed. The description or detail of the transactions. If a document is updated to the ledger, the document type will be displayed. Total of the transactions entered in a specific batch. Total of the transactions entered in a specific batch. The headings for the columns of this report.

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.

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 option.

The amounts which are displayed in <> indicates a credit or negative figure. You may change this negative amount indicator to a minus sign (-) to prefix your amounts or set it to display a D (for Debit) or a C (for Credit) in the Setup - Preferences - Data Parameters menu option.