Skip to main content

Trial Balance - Version 2

The Trial Balance - Version 2 workbook builds on the standard trial balance by adding a beginning balance and an ending balance alongside the period debit and credit activity. This makes it more suited for reconciliations and period-end reviews where you need to see not just what was posted, but where balances started and where they ended up.

Selection page​

When you open the workbook, the Selection Page appears before the workbooks loads. You can also click the Selection Page sheet at any time to update your parameters directly.

  • Fiscal Year
  • Fiscal Period
  • Company
  • Department
  • Cost Center

Trial Balance​

The report lists each account with its opening balance, period activity, and closing balance for the selected period.

  • Beginning Balance: account balance at the start of the selected period, carried forward from the prior period.
  • Ptd Debit: total debits posted to the account during the period. Debits generally increase assets and expenses, and decrease liabilities and equity.
  • Ptd Credit: total credits posted to the account during the period. Credits generally decrease assets and expenses, and increase liabilities and equity.
  • Ending Balance: balance at the end of the period, calculated as Beginning Balance + Ptd Debit - Ptd Credit.