The following general ledger reports are available:
The 1099 report displays an overall balance of what has been paid to a third party during a specific time period. This report allows you to export relevant data to be imported to other software programs that format the information to print on 1099 forms.
Use the Balance Sheet to
determine whether the General Ledger is in balance. The Balance Sheet
displays a summary of an agency’s financial status, listing the agency's
assets, liabilities, and owner's equity as of a specific month. Add the
optional GL Posted Date criterion
to run the financials for General Ledger balances through a specific date
(rather than including everything for the selected accounting month).
The Balance Sheet lists the balances of each account, with or without
subaccount details.
This is one of the reports that agencies run during the Month-End process. If your organization is set up as multiple agencies, you can run this report for selected agencies or sort the results by agency. The agencies selected must use the same fiscal period.
The Balance Sheet - Comparisons report is similar to the Balance Sheet but allows comparisons between multiple sets of data. You can use this report to compare actual amounts to actual amounts, actual amounts to budgeted amounts, or budgeted amounts to budgeted amounts (you must enter budget figures in the GL Budgeting area before you can access them via this report). This report only displays the balances for asset, liability, and equity accounts.
To add comparison sets to the report,
Note: You may edit the default layouts as desired or add custom layouts.
The Bank Reconciliation Detail report displays all items that are outstanding and cleared on a bank reconciliation statement.
To run this report for a specific bank account,
To include or exclude outstanding items in your report,
This report displays all outstanding additions and withdrawals for a specific time period.
The Deposit Register report displays information about finalized receipts. Two layouts are available:
You can customize layouts for the Deposit Register via the Create a New Report action. Any layout saved to the main General Ledger report list (rather than to My Reports) will be available when you run the On Demand Deposit Register report from the Receipts area.
This report displays the details for disbursements, receipts, and journal entries. You can create separate versions of this report for disbursements, receipts, vouchers, and journal entries if you need them to be separate reports.
If the Journal Entry Approval Process is enabled, you can add the optional Approval Status criterion to this report to see each journal entry's status, or to include only journal entries with specific statuses. You can also use the GL Posted Date criterion to include the date each item was applied to the GL balances.
To run the report for different types of entries,
To run the report for a specific accounting month,
To run the report for a specific GL account,
The General Ledger Schedules report allows you to generate a report for a specific general ledger Schedule to track revenue and expenses.
If the Journal Entry Approval Process is enabled, you can add the optional Approval Status criterion to this report to see each journal entry's status, or to include only journal entries with specific statuses. You can also use the GL Posted Date criterion to include the date each item was applied to the GL balances.
The Income Statement reflects the agency's income, expenses, and net profit or loss for a selected accounting month. It shows the current period and year-to-date figures for the selected accounting month and the selected comparison period. The criteria selections determine the details that display. These selections print on the parameter report.
If an Income account has a debit balance, the balance displays as a negative amount. If an Expense account has a credit balance, the balance displays as a negative amount. For an up-to-the-minute Income Statement, select the Open checkbox on the Criteria tab. For an Income Statement for one period only, select only that month in the range. Add the optional GL Posted Date criterion to run financials for General Ledger balances through a specific date (rather than including everything for the accounting month). To ensure an accurate Income Statement, you must post all prior years.
You can sort by Region, Agency, Branch, Department, and Profit Center to see the general ledger breakdown at each structure level. You should run this report as part of the Month-End process, but you can also run it at any time to view the agency’s income for a specific time period.
To sort by Region, Agency, Branch, Department, or Profit Center,
Optionally exclude year-end entries
One report for agencies with different Fiscal Periods
The Income Statement - Comparisons report is similar to the Income Statement report but allows comparisons between multiple sets of data. You can use this report to compare actual amounts to actual amounts, actual amounts to budgeted amounts, or budgeted amounts to budgeted amounts (you must enter budget figures in the GL Budgeting area before you can access them via this report). This report only displays the balances for income and expense accounts.
To add comparison sets to the report,
Note: You may edit the default layouts as desired or add custom layouts.
This report gives you insight into General Ledger information specific to journal entries and is especially helpful for tracking the Journal Entry Approval Process, if it is enabled. This process requires a user to review every manually entered journal entry for accuracy and approve it before it affects your balance sheet, income statement, and trial balances.
The Journal Entry Report is unique among General Ledger reports in that you can set it up to include associated activities (for example, for auditing information about journal entry approvals). If you also want to include the notes on each activity, add the Activity Notes criterion.
This report verifies that there is enough money in the Premium Trust bank account to pay net premium liabilities based on payments from clients and premium payments. Qualifying transactions must have either client payments or premium payable payments associated with them to display on the report.
Many states are governed by statutes that regulate the identification of the dollar amount, by category, of funds comprising the balance of what is called a control account. One such control account is the Premium Trust account, and the categories requiring reconciliation are premiums, advance premiums, and return premiums. For clarification, "Premium Fund Trust Account" is a special fiduciary account established and maintained by a licensee into which all premiums collected are to be deposited. The Premium Trust Reconciliation report allows an agency to verify that there is enough money in a Premium Trust bank account to pay carrier liabilities based on payments from clients and payments to the carrier.
To help you determine when the amount paid to the carrier will display on the report, items that have been flagged for payment on a reconciliation statement will not be considered paid to the carrier until that statement is associated to a general ledger item (disbursement, receipt, journal entry). However, if that general ledger item is a voucher, the detail from the reconciliation statement will not be included on the report until that voucher is paid with a disbursement.
The Status of Accounts report provides account details for all General Ledger entries made for the selected period. This report includes opening and ending balances, all transactions affecting the balance, and net change in the balance.
If the Journal Entry Approval Process is enabled, you can add the optional Approval Status criterion to this report to see each journal entry's status, or to include only journal entries with specific statuses. You can also use the GL Posted Date criterion to include the date each item was applied to the GL balances.
This is another report that should be run as part of the Month-End process. However, you can run it at any time to see the activity for a specific account or all accounts.
The Trial Balance report provides balances for each account in the General Ledger (by structure level) for a selected range of months, to allow you to confirm that debits equal credits. Agencies typically run this report for the current accounting month. Add the optional GL Posted Date criterion to run financials for General Ledger balances through a specific date, rather than including everything for the accounting month. This report displays year-to-date or comparative totals, based on the output format chosen.
Note: This report does not include the full details of all entries. For full details, run the individual registers. If debits do not equal credits, run the individual registers to find where the problem occurred.
You should run this report during your Month-End process.
To specify time, structure, and account for this report,
The Trial Balance - Comparisons report is similar to the Trial Balance report but allows comparisons between multiple sets of data. You can use this report to compare actual amounts to actual amounts, actual amounts to budgeted amounts, or budgeted amounts to budgeted amounts (you must enter budget figures in the GL Budgeting area before you can access them via this report).
To add comparison sets to the report,
Note: You may edit the default layouts as desired or add custom layouts.
The Voucher report allows you to balance your Pending Payables required account. Running a vouchers report for all Unpaid Vouchers provides the total of entries that should be included in the Pending Payables required account.