The Ending Balance column is intended to show Ending Balance computed based on the rows' filtered account/s and the dates configured in the Start Offset and End Offset . This type of column is most likely be used on Trial Balance report. 

Follow these steps on how to create Ending Balance column type.

  1. A new row will be available in the grid section.
  2. In the Column Type field, select Ending Balance.
  3. In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name.  This is discussed more on How to Add Column Name Row.
  4. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
  5. The Start Offset field will be defaulted to BOT, which stands for Beginning of Time. This field is read only to prevent you from modifying it. 
  6. The End Offset field will be defaulted to 0, which stands for Run Date month or the current month. Change this field when you need to.

    *When Start Offset and End Offset are combined, it is read as From Beginning of Time up to This Month. This is discussed more on How Start and End Offset works.

  7. The Start Date field will show the date based on the Start Offset selected and the Run Date. This gives you a preview of what the Start Date will be. It is only when Custom is selected in the Start Offset field where you need to specify the date. The rest are computed by the system.
  8. The End Date field will show the date based on the End Offset selected and the Run Date. This gives you a preview of what the End Date will be. It is only when Custom is selected in the End Offset field where you need to specify the date. The rest are computed by the system.
  9. Leave the Column Calculation field blank.
  10. The Segment Filter field is useful to this column type since it allows you to specify location/s filter if you need to. This is discussed more on How to Use Segment Filter in the Column Designer.
  11. Leave the Budget Code field blank.
  12. Leave the Percentage field blank.
  13. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  14. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  15. There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
  16. All other fields are not anymore necessary so you can leave those out.

This is how Ending Balance column will look like when you follow the above steps.

The Ending Balance column is intended to show Ending Balance computed based on the rows' filtered account/s and the dates configured in the Start Offset and End Offset . This type of column is most likely be used on Trial Balance report. 

Follow these steps on how to create Ending Balance column type.

  1. A new row will be available in the grid section.
  2. In the Column Type field, select Ending Balance.
  3. In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name.  This is discussed more on How to Add Column Name Row.
  4. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
  5. The Start Offset field will be defaulted to BOT, which stands for Beginning of Time. This field is read only to prevent you from modifying it. 
  6. The End Offset field will be defaulted to 0, which stands for Run Date month or the current month. Change this field when you need to.

    *When Start Offset and End Offset are combined, it is read as From Beginning of Time up to This Month. This is discussed more on How Start and End Offset works.

  7. The Start Date field will show the date based on the Start Offset selected and the Run Date. This gives you a preview of what the Start Date will be. It is only when Custom is selected in the Start Offset field where you need to specify the date. The rest are computed by the system.
  8. The End Date field will show the date based on the End Offset selected and the Run Date. This gives you a preview of what the End Date will be. It is only when Custom is selected in the End Offset field where you need to specify the date. The rest are computed by the system.
  9. Leave the Column Calculation field blank.
  10. The Segment Filter field is useful to this column type since it allows you to specify location/s filter if you need to. This is discussed more on How to Use Segment Filter in the Column Designer.
  11. Leave the Budget Code field blank.
  12. Leave the Percentage field blank.
  13. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  14. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  15. There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
  16. All other fields are not anymore necessary so you can leave those out.

This is how Ending Balance column will look like when you follow the above steps.

Here's how it is shown when report is previewed/printed. Highlighted is the Ending Balance column type.


The Ending Balance column is intended to show Ending Balance computed based on the rows' filtered account/s and the dates configured in the Start Offset and End Offset . This type of column is most likely be used on Trial Balance report. 

Follow these steps on how to create Ending Balance column type.

  1. A new row will be available in the grid section.
  2. In the Column Type field, select Ending Balance.
  3. In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name.  This is discussed more on How to Add Column Name Row.
  4. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
  5. The Start Offset field will be defaulted to BOT, which stands for Beginning of Time. This field is read only to prevent you from modifying it. 
  6. The End Offset field will be defaulted to 0, which stands for Run Date month or the current month. Change this field when you need to.

    *When Start Offset and End Offset are combined, it is read as From Beginning of Time up to This Month. This is discussed more on How Start and End Offset works.

  7. The Start Date field will show the date based on the Start Offset selected and the Run Date. This gives you a preview of what the Start Date will be. It is only when Custom is selected in the Start Offset field where you need to specify the date. The rest are computed by the system.
  8. The End Date field will show the date based on the End Offset selected and the Run Date. This gives you a preview of what the End Date will be. It is only when Custom is selected in the End Offset field where you need to specify the date. The rest are computed by the system.
  9. Leave the Column Calculation field blank.
  10. The Segment Filter field is useful to this column type since it allows you to specify location/s filter if you need to. This is discussed more on How to Use Segment Filter in the Column Designer.
  11. Leave the Budget Code field blank.
  12. Leave the Percentage field blank.
  13. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  14. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  15. There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
  16. All other fields are not anymore necessary so you can leave those out.

This is how Ending Balance column will look like when you follow the above steps.

Here's how it is shown when report is previewed/printed. Highlighted is the Ending Balance column type.

The Ending Balance column is intended to show Ending Balance computed based on the rows' filtered account/s and the dates configured in the Start Offset and End Offset . This type of column is most likely be used on Trial Balance report. 

Follow these steps on how to create Ending Balance column type.

  1. A new row will be available in the grid section.
  2. In the Column Type field, select Ending Balance.
  3. In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name.  This is discussed more on How to Add Column Name Row.
  4. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
  5. The Start Offset field will be defaulted to BOT, which stands for Beginning of Time. This field is read only to prevent you from modifying it. 
  6. The End Offset field will be defaulted to 0, which stands for Run Date month or the current month. Change this field when you need to.

    *When Start Offset and End Offset are combined, it is read as From Beginning of Time up to This Month. This is discussed more on How Start and End Offset works.

  7. The Start Date field will show the date based on the Start Offset selected and the Run Date. This gives you a preview of what the Start Date will be. It is only when Custom is selected in the Start Offset field where you need to specify the date. The rest are computed by the system.
  8. The End Date field will show the date based on the End Offset selected and the Run Date. This gives you a preview of what the End Date will be. It is only when Custom is selected in the End Offset field where you need to specify the date. The rest are computed by the system.
  9. Leave the Column Calculation field blank.
  10. The Segment Filter field is useful to this column type since it allows you to specify location/s filter if you need to. This is discussed more on How to Use Segment Filter in the Column Designer.
  11. Leave the Budget Code field blank.
  12. Leave the Percentage field blank.
  13. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  14. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  15. There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
  16. All other fields are not anymore necessary so you can leave those out.

This is how Ending Balance column will look like when you follow the above steps.

Here's how it is shown when report is previewed/printed. Highlighted is the Ending Balance column type.

The Ending Balance column is intended to show Ending Balance computed based on the rows' filtered account/s and the dates configured in the Start Offset and End Offset . This type of column is most likely be used on Trial Balance report. 

Follow these steps on how to create Ending Balance column type.

  1. A new row will be available in the grid section.
  2. In the Column Type field, select Ending Balance.
  3. In the Column Name field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the Caption field for that column is set to Column Name.  This is discussed more on How to Add Column Name Row.
  4. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Column Name Row.
  5. The Start Offset field will be defaulted to BOT, which stands for Beginning of Time. This field is read only to prevent you from modifying it. 
  6. The End Offset field will be defaulted to 0, which stands for Run Date month or the current month. Change this field when you need to.

    *When Start Offset and End Offset are combined, it is read as From Beginning of Time up to This Month. This is discussed more on How Start and End Offset works.

  7. The Start Date field will show the date based on the Start Offset selected and the Run Date. This gives you a preview of what the Start Date will be. It is only when Custom is selected in the Start Offset field where you need to specify the date. The rest are computed by the system.
  8. The End Date field will show the date based on the End Offset selected and the Run Date. This gives you a preview of what the End Date will be. It is only when Custom is selected in the End Offset field where you need to specify the date. The rest are computed by the system.
  9. Leave the Column Calculation field blank.
  10. The Segment Filter field is useful to this column type since it allows you to specify location/s filter if you need to. This is discussed more on How to Use Segment Filter in the Column Designer.
  11. Leave the Budget Code field blank.
  12. Leave the Percentage field blank.
  13. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  14. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  15. There is an ability to show or hide the column. Check the Hidden checkbox if you decide to hide the column. This is discussed more on How Hidden checkbox works when enabled.
  16. All other fields are not anymore necessary so you can leave those out.

This is how Ending Balance column will look like when you follow the above steps.

Here's how it is shown when report is previewed/printed. Highlighted is the Ending Balance column type.

The Ending Balance column is intended to build formula from existing columns. Calculation, Debit and Credit columns can be used to build the formula. This report is most likely be used in a Trial Balance type of report.

This column is like Column Calculation in the sense that you can build formula. The only difference is, the Ending Balance column checks first whether the account has Debit or Credit normal balance.

Say this is your formula: Beginning Balance + Debit - Credit = Ending Balance

Where: 

  • Beginning Balance is a Calculation column
  • Debit is a Debit column
  • Credit is a Credit Column
  • Ending Balance is an Ending Balance column

If Ending Balance is a Calculation column type - it will compute for the amount using the above formula, regardless of account normal balance. However if Ending Balance is an Ending Balance column type, this rule applies:

  • If account has Debit normal balance, then Debit - Credit applies. Therefore in the above formula it would be Beginning Balance + Debit - Credit = Ending Balance
  • If account has Credit normal balance, it reverses the formula to be Credit - Debit. Therefore in the above formula it would be Beginning Balance + Credit- Debit = Ending Balance 

Follow these steps to add an Ending Balance column.

  1. A new row will be available in the grid section.
  2. In the Column Description field, enter the name you would like to call the column. The value entered in this field may show on your financial report, granted the caption for that column is set to Column Header.  This is discussed more on How to Add Description Title Row.
  3. In the Caption field, select the type of caption you want for the column. This is discussed more on How to Add Description Title Row.
  4. In the Column Type field, select Ending Balance.
  5. Column Calculation screen will automatically be opened where you can configure your formula. See How to Configure Formula for Column Calculation column to guide you on how to build your formula.
  6. Leave the Filter Type field blank.
  7. Leave the Segment Used field blank.
  8. Leave the Budget Code field blank.
  9. Leave the Start and End Date fields blank.
  10. In the Width field, set it to your desired column width. By default it is set to 160 pixels, which is approximately 1 1/4 inches.
  11. In the Alignment field, set how the value for the column be displayed.
    • Select Center if you want it Centered
    • Select Left if you want it Left Aligned
    • Select Right if you want it Right aligned
  12. In the Format field, assign how the numbers be shown in the column. Will it have decimals, money sign or in percentage format.
  13. Leave Hidden checkbox unchecked. See How Hidden checkbox works when enabled.

This is how Column Calculation column will look like when you follow the above steps.

Here's how it is shown when report is previewed/printed. The balances shown on Ending Balance column is computed as:

  • Beginning Balance + Debit - Credit for account with Debit normal balance
  • Beginning Balance + Credit - Debit for account with Credit normal balance



  • No labels