ACCOUNTING

 

Top

Reports in DataCOM are an essential part of the program. As the forms in DataCOM all the reports have merely the same structure.  Most of the reports are periodical reports, which means can be selected from a start date to an end date.  DataCOM reports have 4 different kinds of output:

Direct output to a printer. The report is directly printed to the default printer connected to the computer system.

Preview output.  The report is directed to a preview form that can be printed to a printer, which can be selected from the preview form

Browse output.  The report is displayed in a tabular form on the screen

Excel output. The report is exported to Microsoft Excel in a form of an excel worksheet. 

NB: In all reports, From-To for all parameters (date, code, number...) is inclusive in the report.

General Ledger

Top

This report displays the chart of account or the ledger.

0. Range of accounts to be displayed, from –To.

1. New page for each class: when it is checked each class of accounts is printed on separate pages

     Print auxiliary accounts: when it is checked auxiliary accounts are displayed

     Color Ledger detail: when it is checked bands for detail are colored

2. Print balances: when it is checked the balances are displayed according to the specified currency.

3. Order by: The chart will be ordered by number or description.

Statement of Account

Top

This report displays all the accounting transactions and movements of an account within a certain period.  The total of movements prior to the start date is reported as previous balance.

0. From date to date: the ranges of the period. This period is considered either by the date of the transaction or the value or maturity date of the transaction and accordingly the statement is ordered by the date or value date.

 

1. The amounts can be in:

      - currency of the account

      - currency base 1 

      - currency base 2

 

- When the same account is used with more than one currency and one of currency base1 or base 2 is checked with the cumulative check then the statement combines all the movements of the account regardless of the currency and displays a consolidated statement.

E.g. an account number 53000001 is used with Lebanese pounds and US dollars, a consolidated statement in LL can be displayed by checking the LL and cumulative.

- Separate pages: Each statement of an account with a currency is displayed on a separate page.

 

2. Detailed per date: When not checked, the movements of an account in a single day are combined in one line; else they are displayed as they were entered.

 

3. Border: To disable or enable the borders of the report 

 

4. External report: To print an external statement report without showing the journal voucher reference and the folio reference of each transaction.

 

5. Print reference: if checked the journal voucher reference is displayed on the statement whether external report is checked or not.

 

6. From Ledger account to Ledger account if ledger is chosen.

From document to document if document is chosen (refer to ledger form for more details about documents).

 

7. To list all the transactions that contains regardless of the account or ledger number for a certain description.

 

NB: when more than currency option is selected at the same time (currency with base 1 or currency with base 2 or base 1 with base 2 the orientation of the paper should be landscape)

Transaction Journal Voucher

Top

This report displays all journal vouchers in two forms:

1 - Separate vouchers.

2 - Official journal voucher (list the official journal voucher (all journal vouchers) , with totals).

The journal voucher report can be ordered and selected by:

0. Journal Voucher Date (From –To).

 

1. Journal Voucher Reference (From –To).

 

2. Journal Voucher Folio (From –To).

 

3. The journal voucher can have the following options:

Type: if empty journal vouchers of all types, else specify the type (JV, PV, RV, DV, CV, PI, PR, SI, SR).

 

4. Force New Page: When checked each voucher is printed on a separate page.

 

5. Journal Listing: when checked the journal vouchers are displayed as the official journal vouchers. The vouchers are printed as a list.    The official journal voucher amounts can be either by:

           -  The currency of the transaction

           -  The counter value in currency base 1

           -  The counter value in currency base 2

Print Value date of each transaction.

NB: When journal listing is checked.

-  If the paper orientation is portrait the amounts of the transactions are displayed in currency base 1 and currency base 2.

- If the paper orientation is landscape the amounts of the transactions are displayed by the selected currencies (currency and base 1 or currency and  base 2 or base 1 and base 2).

List of receipts / payments / Debit Notes / Credit Notes

Top

This report lists and sums the following transactions in a certain period or within a range.

0. Type of transaction: Receipt, payment, debit note, credit note vouchers.

1. Period form date to date.

2. Range of transactions according to the reference from – to.

3. Range of account numbers that use the selected transactions from – to.

Income Statement / Balance Sheet / Difference Of Exchange

Top

This page contains 2 accounting reports (Income statement or profit and loss statement and the balance sheet (and one main accounting procedure that is done automatically which is the difference of exchange).

0. The period for which the two reports are displayed from – to.

1. To choose the report

             - Income statement or Profit & Loss statement

             -  Balance Sheet

2. To choose the currency of the reports in (1).

      Base 1

      Base 2

 

For the Income statement or the Profit & Loss statement to include the variation of stock in the statement, the opening and closing inventory amounts should be entered in the specified place in the currency chosen base 1 or base 2.

NB: Opening and closing inventory are figures according to the period chosen in (0). To get these figures refer to the inventory reports and use the same period chosen in this page. e.g. period in (0) is  from  Apr -01 - 2004 to Apr - 30- 2004.

To get the opening inventory is the total inventory up to Mar -31-2004 inventory report from... to Mar -31 –2004.

To get the closing inventory is the total up to Apr -30 -2004 inventory report from ......... to Apr -30 –2004.

Trial Balance

Top

This report can be used to produce a trial balance and other reports such as a list of debtors a list of creditors, a list of clients, a list of suppliers.

0. Period of the report selected.  The movements before this period are reported as previous balances.

1. The currency of the accounts:

             By currency of the account

             By the Counter value in base 1

             By the counter value in base 2

 

Print detail CV. If it is checked and the currency option is checked the counter value in base 1 and base 2 are displayed.

 

Group Only: If it is checked, only group accounts are displayed and the number of digits of these groups is specified.

 

Print Zero Quantities: If it is checked, accounts with 0 balances are displayed.

Trial balance: All accounts.

Debtors: Accounts of class 4 with debit balance.

Creditors: Accounts of class 4 with credit balance.

Clients: All Accounts from account number 41 to account number 42. 

Suppliers: All Accounts from account number 40 to account number 41.

Debitors / Creditors:  All Accounts of class 4.