Work out an extended trial balance

You can print a worked out extended trial balance with extended options for comments.

You can use the Plan trial balance function to process preliminary journal entries off-balance sheet (outside of the accounting system) and also to undo them (perhaps temporarily).

If desired, you can permanently process the preliminary journal entries in the financial administration. The main advantage here is that the complete history of the preliminary journal entries is saved, which means you can retrieve the historical data and track the changes at any time.

To work out an extended trial balance:

1. Go to: Financial / Reporting / Reporting cockpit.
2. Select the project.
3. Click on the action: Plan trial balance.

   Profit starts the entry layout. The totals for Balance, Preceding journal, Profit/Loss and Balance sheet are at the bottom of the window. These are total balances, not just those for the displayed ledger accounts.

   Some data from the layout is explained below:

   • Marked

     After working out in a check step, you can highlight the approved accounts.

   • Memo

     You can enter a memo text for the ledger account. Profit shows this memo text on the 'Dossier list (Profit)' report.

   • Preceding journal item

     In this column, Profit totals up the preliminary journal entries.

4. Click on the action:
   • Preceding journal items

     You can enter preliminary journal entries.

   • Info account

     You open the detailed information for the selected account. The detailed information contains the preliminary journal entries and all financial entries within the reporting period on the relevant account

   • Afdruk kolbal

     You generate an extended trial balance including the preliminary journal entries.

   • Print provisional journal entries

     You generate an overview of all active preliminary journal entries, including the memo fields linked to the journal entries.

   • Print client record

     You print a dossier. This is an extended trial balance, which has been worked out, expanded with the memo fields linked to a ledger account and the preliminary journal entries.

   • Process

     You can process the preliminary journal entries in the administration. For this, the relevant administration must be available on the system. After processing the preliminary journal entries, the environment is refreshed. This means that Profit retrieves the updated balances and entries again from the administration and deletes the processed preliminary journal entries from the project.

   Note:

   In order to be able to process these journal entries, you need the Plan trial balance journal of the type general journal. You record this journal via Financial / Management / Settings, on the General tab, in the Journal code field.

   • Export provisional journal entries

     If the source administration is no longer available on the system, you can export the preliminary journal entries to an ASCII file. Import this file into the administration.

   • Import provisional journal entries fixed assets
   • Refresh
   • Provisional journal entry history

     All preliminary journal entries are also stored in a historical file. You can maintain these entries. It works the same as the Preceding journal items.

   • Copy

     You can copy preliminary journal entries from the historical file to the current file.