Average Daily Balance Ledger
Calculate a summary total and ratio of the GL accounts.
Printing the Average Daily Balance Ledger Report
1. Open Connect General Ledger> Reports > Average Daily Balance Ledger.
2. Select a report title.
3. Set up the report options.
4. Click Print (CTRL+P).
The report prints.
Options
Accounts to include
Use Accounts to Include to filter the accounts on the report. Use All to include all accounts in the General Ledger. Use With a Zero Balance to limit the account summary to show only accounts that have neither a positive or negative balance. Use With Balances to only include accounts that have a positive or negative balance. Use With Balances or Activity to include only accounts that have a balance and have transactions recorded during the report date range.
Which accounts do you wish to include?
Use the Accounts to Include drop-down list to select and apply a filter.
Digits of account number of Average Daily Ratio
The average daily ratio assigns a percentage by calculating the sum of the selected GL accounts and dividing the calculated sum by the grand total of all of the GL accounts that are included in the report.
Example: Jane wants to know the percentage that is contributed by accounts that belong to the general fund by department code, specifically, she is looking for the percentage contributed by accounts that begin with 10-31. She sets the Digits of Account Number of Average Daily Ratio to the number 4. She chooses the number 4 because the fund is the first two digits in the account mask and the department code is the next 2 digits. This is a simplified example of how this feature works...
GL Account |
|
Amount ($) |
Percent (%) |
10-31-100 10-31-200 |
1031 |
100.00 250.00 |
8.33% |
10-32-100 |
1032 |
175.00 450.00 |
15.00% |
10-40-110 |
1040 |
800.00 400.00 1,200.00 |
40.00% |
10-44-210 |
1044 |
1,100.00 1,100.00 |
36.67% |
|
Grand Total |
3,000.00 |
100% |
The account sums amounts for accounts that begin with 10-31, 10-32, 10-40, and 10-44. When the first 4 digits in the 10-31 account changes to 10-32 the report prints a total for the account segments that begin with 10-31. Then, it lists the amounts for all of the accounts that begin with 10-32. When the last 10-32 account prints, the report prints the 10-32 total and starts printing amounts for accounts that begin with the next value, in this case, 10-40.
Jane sees the percent contributed for 10-31 is 8.33%, or the 10-31 account total [250.00] divided by the grand total [3,000].
Do you want to calculate the average daily ratio?
I want to set the number of digits to calculate the average daily ratio. Use the Digits of Account Number for Average Daily Ratio field to enter a number. Note: The number of digits in the account is maximum valid value. Using a value that is greater than the number of digits in the account is allowed, however, the system will default to the number of digits in the account.
I want to use the full account length to calculate the average daily ratio. Enter 0 (zero) in the Digits of Account Number for Average Daily Ratio field.
Print period totals
A period total is the sum of the amounts in the selected period. Use Print Period Totals to print a one-line summary for each transaction in the period. An asterisk (*), shown in the asterisk column, identifies the period totals. This option will not include inactive periods, a period that does not have any transactions.
Note: If you select the option to Print Period Totals AND Summarize Payroll Detail, this option will summarize the transactions that are linked to the Payroll (CDP) journal code for the account AND period.
Do you want to print period totals?
Yes, print period totals. Click to select Print Period Totals.
No, do not print period totals. Click to deselect Print Period Totals.
Bold total lines
Use bold total lines to apply bold formatting to lines in the report that show totals.
Do you want to print totals in bold type?
Yes, print totals in bold type. Click to select Bold Total Lines.
No, do not print totals in bold type. Click to deselect Bold Total Lines.
Print running balance
A running balance is the sum of the credits and debits in an account at a given time and date, like this
Do you want to print the running balance after each transaction?
Yes, print the running balance. Use the Additional Options tab to select the Print Running Balance checkbox.
No, do not print the running balance. Use the Additional Options tab to deselect the Print Running Balance checkbox.
Do you want to set the running balance to zero if the report range includes the fiscal year-end?
Yes, set the balance to zero at the fiscal year end. Click to select Zero the Balance at Fiscal Year-end.
No, continue the running balance without regard to the fiscal year-end. Click to deselect Zero the Balance at Fiscal Year-end.
Print transactions in date order
Use the Print Transactions in Date Order option to print transactions by date. When this option is not selected, the report will sort transactions by journal code.
What do you want to do?
I want to sort transactions by transaction date. Click to select Print Transactions in Date Order.
I want to sort transactions by journal code. Click to deselect Print Transactions in Date Order.
Report dates
Report Dates is the report date range the report will use to filter transactions.
Do you want to use the current period as the report date range?
Yes, I want to use the current period. Continue to the next step.
No, I want to use a different period. Change the Report Date, or click Advanced Options.
Copyright © 2020 Caselle, Incorporated. All rights reserved.