Trial Balance

Trial Balance [report]

From the DockMaster menu, select General Ledger > Reports > Trial Balance

The Trial Balance and General Ledger Reports may be executed for any accounting period on file. Either function may be executed for closed periods and may span several accounting periods (quarterly T/B etc.). The Trial Balance may be executed for selected companies with production of a Trial for each company or alternatively, consolidating the given companies into a single Trial Balance.

• Enter the Starting Report Date.

• Enter the Ending Report Date.

• Enter an Account Type(s) or leave the prompt blank to include ALL account types. The valid account types are:

  • 1 = Assets
  • 2 = Liabilities
  • 3 = Equity
  • 4 = Income
  • 5 = Expenses

• Enter a Company Number(s) or leave the prompt blank to include ALL companies.

• Enter a Cost Center(s) or leave the prompt blank to include ALL cost centers.

• Enter an Account Number(s) or leave the prompt blank to include ALL account numbers.

• Click the Bypass Zero-Activity Accounts box to include only accounts that have a beginning or ending balance or transaction activity for the dates entered.

• Click the Consolidate Companies box if ALL companies should be selected for Trial Balance production, they will be consolidated into a single Trial Balance. If this option is left blank, a separate Trail Balance will be printed for each of the selected companies

  Note: If the consolidated option is checked, the company portion of the selected group of accounts is ignored and the selected group is merged by Cost Center and Detail line. As the Trial Balance is printed, asterisks are substituted for the company portion of the account number to indicate that the given report is a Consolidated Trial Balance.

• Click the Include Sub-totals by Source box to sub-total the General Ledger report by source.

• Select the Report Type you want to print; Detail, Summary, Rolling, or Working. Click the down arrow to see the choices. The default option is Summary. A description of each report is shown below:

  • Detail - shows opening balance for the beginning date, detail entries for debits, credits, and the ending balance for the ending date entered.
  • Summary - shows opening balance for the beginning date, total debits, total credits, and the ending balance for the ending date entered.
  • Rolling - shows opening balance for the beginning date, the net balance in each account for each month in the date range selected, and the ending balance for the ending date entered.
  • Working - similar to summary report, however, an adjustment column is added to allow you to write in adjustment amounts.

• Select a Sort Option for this report; G/L Number, Type, Cost Center, or Detail. Click the down arrow to see the choices. The default option is G/L Number. A description of each Sort Option is shown below.

  • G/L Number - By Ascending G/L Account Number
  • Type - By Account Type and G/L Account Number
  • Cost Center - By Company and Cost Center Number
  • Detail - By Company and Detail Line Number

• For multi-currency databases If multi-currency has been activated on the account then the options shown below will be accessible.

  • Select a Currency Type to determine how you want to view your Trial Balance Report. The currency rates are set up in the Rate of Exchange. Note: Only the Detail Trial Balance will use the Currency Rates. If a report type other than detail is selected, then the currency type will be ignored.
  • Click create journal transaction box to move the monthly multi-currency database.
  • In the move to database dropdown select the database to move the monthly multi-currency conversion journal transaction too.

• Click the Print button to print the report.