Wiki Detay | wiki workcube

Allows you to check the accuracy of records made during the period before official financial statements are received. All records assigned to account codes defined in accounting charts in Workcube can be monitored in the trial balance.

Path: ERP > Finance Accounting > Accounting Tables > Trial Balance

Account Filters: Accounts between two accounting accounts, including the accounting code selected in the first field and the accounting code selected in the second field.
Transaction Currency: There are two additional options: Transaction Currency and 2nd Currency. If Transaction Currency is selected, in addition to the Standard Transaction Currency, Transaction Currency columns are opened in the trial balance and transactions made with transaction currencies registered in the system are listed by separating them into currencies. If 2nd Foreign Currency is selected, columns are opened in the table only for the 2nd Foreign Currency determined when creating "Accounting Periods". If no option is selected, it will be listed with the amounts equivalent to the Standard Transaction Currency determined in the Accounting Periods.
Report Type: There are four options: Department, Branch, Project and Parent Project. The working logic of this filter is that it can list discarded records depending on the relevant filter options. For example; When the trial balance is taken by selecting the project filter, the project column opens in the list. Posted records related to the project are shown to the relevant accounts. The amounts in the lines with the Project column filled in the trial balance lines mean that they have been recorded in connection with the project. "Detailed Expenditure Analysis Report" can be used to confirm. A report can be obtained and the amounts can be examined by selecting the project that appears on the trial balance line. The same logic applies to Department and branch filters. Department and branch related records are created if the accounting code is selected in the branch and department detail.
Parent Accounts:1. There are four options: Subaccounts, 2nd Subaccounts, 3rd Subaccounts and All Subaccounts. If no option is selected, trial balance is created only with parent accounts. In parent accounts, the total amount of sub-accounts is shown. If the "All Sub-Accounts" filter is selected and the trial balance is taken, the sub-accounts linked to the parent account will be listed. The total balances of all listed sub-accounts are summed and displayed on the line containing the parent account.
Uniform Order: It enables the creation of a trial balance in accordance with uniform order and IFRS standards.
Opening Slip: Lists only the accounts linked to the selected ones among the slip options. For example; When the trial balance is taken by selecting the collection voucher, the account codes that have not been recorded with the collection voucher are not listed.
Branch: The accounting account codes that have been processed through the selected branch are listed. It is recommended to use it with the "branch" filter in the report type. For example; Let's consider the 100.01 Central Cash TL accounting account code. When the trial balance is received by selecting the branch, if there is a transaction under this account, the account code 100.01 will be listed in the trial balance lines. When the past movements of the relevant account code are examined, it will be seen that there are transactions recorded in the branch account such as closing invoices, payment, depositing money to the account.
Balance Sheet Accounts Should Not Be Included: Balance sheet accounts are the main account groups starting with 1, 2, 3, 4 and 5. Main accounts are located below the balance sheet accounts. If these Balance Sheet accounts are not included, only the parent accounts will be listed. When this filter is not selected, the order in the Trial Balance is listed as 1-Current Assets 10- Current Values and 100,101,102 main accounts. When the "Do not list balance sheet accounts" option is selected, Account groups of 1 and 10 are not listed, the trial balance starts directly from the main account groups of 100.
Let's examine the options in this article below:

Show Amount: Shows the number of transaction transactions posted to the accounts
Top Accounts Do not include: If selected, only subaccounts are listed. Parent accounts work in conjunction with filter options. If one is selected, the other cannot be selected.
Fetching Those That Do Not See Movement: Accounting code lines that do not see movement are not listed.
Those That Have Balance Only: Accounting code lines that have zero balance are not listed.

Balance Calculation in the Trial Balance

In the Trial Balance When calculating balances, sub-accounts and parent accounts are always added together to give the total of the upper accounts. For example; Sub accounts are summed and reflected in the total of the parent account to which they are linked, while the parent accounts give the total of the Balance Sheet accounts they are linked to.

As can be seen in the image, the debt balances of accounts 111.01 - 111.02 - 111.03 (marked in orange) are added together, gave the total of the account number 111 to which they are affiliated.

In the image, it can be seen that the sub-account groups starting with 100.01.001, shown with black arcs, are collected on top of each other and form the total amount of the main account 100.01.

Sub-account 100.02.001, shown with pink arcs. It is seen that the 100.03.0001 sub-account groups, shown with Green Springs, are added together to form the total of the main account 100.03.

Since account code 100.34 does not have a sub-account, the total amount is directly transferred to the main account.

Archived trial balances can be accessed from the Trial Balance - Archive page.

Note: According to the logic explained above in the Balance calculation, the trial balance bottom total actually gives the total of the main accounts according to the criteria you set. When checking the balances on the trial balance, pay attention to the distinction between main account and sub-account.

Attention: Account codes on the trial balance come from the "Chart of Accounts" definitions. First of all, make sure that you have created your Chart of Accounts properly.

Feedback

Did you find this content helpful?

Please Write Your Feedback!

Name*

Last Name*

Email *

About Workcube Objects

Trial Balance Report

It is used to obtain a detailed trial balance with all its breakdowns.

Type: Report Version: Catalyst v11 Licence: Standard Author: Workcube Core