Trial Balance – Source Code

This new report was developed in order to obtain analytical details for transactions involving G/L accounts posted in direct correspondence with partner cards (customer cards, vendor cards, fixed assets, or bank accounts).

The Trial Balance Customer/Vendor (G/L) helps the Accounting Department compare values registered in accountancy with values registered using partner cards.

Open Trial Balance Cust/Vend (G/L) by searching for it in the Tell me icon. The report can be run using the following filters:

  1. Date filter: the time interval for which the report is run; this filter is mandatory.
  2. No.: the G/L accounts for which the trial balance is run; this filter is not mandatory but it is required by the use of the trial balance.
  3. Other filters for G/L account transactions, like Global Dimension 1 Filter or Global Dimension 2 Filter.

Data available in the report is grouped on partners involved in the selected g/l account transactions. The partner account is obtained in the report from the Source No. column from G/L Entries. Values displayed include:

  • Initial Balance – the balance at the beginning of the year on debit or on credit and the previous amounts from the beginning of the year until the beginning of the date filter on debit and credit.
  • Current Movements – amounts posted in the period selected with the date filter, both on debit and credit side.
  • Total Amounts – both on debit and credit side.
  • Ending Balance – on debit or on credit side.
Important

At the end of the report, the system calculates two types of totals. The first one sums the amounts posted in correspondence with a partner account. The second total line sums all transactions posted on the selected account. The two totals must have the same values, otherwise it means the selected G/L account was used, in some transactions, without having a partner correspondence.

Note

All displayed amounts are calculated in the local currency.