G/L Average Daily Balance Calculator

Screen ID:  IAVBAL-01
Screen Title: Average Daily Balance Calculator
Panel ID: 4582
Tool Number: Multiple
    Click here to magnify

This screen appears when you use ADB Calculator (F9) on the Loan/Share Trial Balance Review screen.  It is also accessed by selecting Tool #116: ADB Calculator Savings & Loans) (Shortcut: adb).

Create full-color PDFs of the data on the screen – PDF Exports

Learn about downloading data to Excel or acomma-delimited file

Dashboard Tips – Questions to Ask When Comparing a Dashboard with Another Dashboard or Report

Understanding the Average Daily Balance (ADB) Dividend Calculation Method

Did you ever want to know what the average daily balance was for your member share accounts over a 2-month period?

The Average Daily Balance Calculator was designed to help you accurately calculate the average daily balance for your Member Trial Balance G/L accounts, including both principal and accrued dividends/interest.

You can even export the results to Excel for additional analysis. A great new tool for your management analysis and Board reporting!

  • See “Field Descriptions” below for details about displaying just the data you wish to see.

Field Descriptions

Be sure to use Enter to refresh the screen after making any changes to your selections.

Field Name

Description

Select

Choose Savings to see only savings balances, or Loans to see loan balances, or Both (the default) to see both types of accounts.

Summary

Check this flag to see G/L accounts summarized for all branches. Remove the check mark and press Enter to refresh the list and display each branch/location separately.

Corp ID

Enter the corporate ID to display data for a single corporation. (Default is 01.)

Branch

Use this to display balances for a single branch. (Click the lookup button images\magnifyingglasslookup_shg.gif to see a list of your credit union’s configured locations.) Leave the field blank to include all branches.

Date range

Use this to specify the starting and ending date range to be included in the calculation. By default, the full previous month will be entered.

G/L account

Use this to calculate balances for only a single G/L account. Leave the field blank to include all member trial balance G/Ls.

  • NOTE: In this context, “all” means all of the G/L accounts that are configured as principal or accrual accounts in your share dividend applications, certificate types, and loan categories.