The Column balances creditor D/C report type list the debit and credit balances of the transactions totals for the for the individual creditor (supplier / vendor) accounts for each period. 

You may select to list all creditor (supplier / vendor) accounts, or only those accounts with balances. 

This report type cannot be printed but can be exported to a spreadsheet (e.g. OpenOfficeCalc / LibreOffice Calc or Microsoft Excel, etc.).

You may generate the transactions in a spreadsheet format in the Column balances creditors or the Column balances creditor D/C report types on the Ledger analyser. 

These transaction totals may  be exported to an "Export.txt" file or "Export.csv" and opened in a spreadsheet. 

To view the transactions for a specific creditor (supplier / vendor) account for a specific period, simply double-click on a period. The transactions will be displayed in the T-Account viewer to filter, print or export the transactions.

In addition to the transaction reports, you may also view and filter transactions on the Transactions tab of a selected creditor (supplier / vendor) account. 

Example : Column balances creditors - D / C


column-balances-creditors-debit-credit

The periods is as follows:

  1. Opening Balance Last Year - Period -1 
  2. Periods - This is last year periods - usually 1 to 12 (depending on the number of periods and descriptions specified and entered in Reporting dates on the Setup ribbon).  
  3. Period Total - The total of the period totals for last year.
  4. End Last Year -  Opening Balance Last Year total and the Period Total. 
  5. Opening This Year -  Period 0 - This should be the same as the End Last Year totals.   
  6. Periods - This is the current year (this year) periods - usually 14 to 25 (depending on the number of periods and descriptions specified and entered in Reporting dates on the Setup ribbon).  
  7. Period Total - The total of the period totals for this year. 
  8. End this year - Opening Balance This Year total and the Period Total (This Year). 

View transactions in T-Account viewer

You may double-click on a specific period of an account to list and view the transaction details in the T-Account viewer. You may be print the transactions. 

Print transactions in T-Account viewer

ledger-analyser-column-balance-creditor-print

Export transactions in T-Account viewer 

You may double-click on an account and / or in a specific period to list and view the transaction details in the T-Account viewer. You may be print the transactions. 

You may also click on the Export button of the T-Account viewer to export the transactions to a spreadsheet. 

You may select to save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type:

    • Text files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options.
    • CSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.).