General Ledger
Reporting - General Ledger
Create a Finance Worksheet for Audit Export
See Attachment
Balancing Accounts
See Attachment Drop Files to Attach
miExcel Import Journal Entry
Import Amounts
Journal Approvals
Copy Journal Entries
Journal Templates
Journal Entries
Journal Entries - Periods
Journal Codes
Enter Journal Amounts
Budgeting
See attachment
Finance Worksheet for Audit Export
The report definition is also attached. It can be loaded by downloading it. Then logging into Connect, going to System Management – System Tools – Import Report Forms/Definitions. Click the Browse button and search out to your download folder (or ...
Audit Checklist
To download a checklist, right-click on the links below and select Save link as or something similar. Then, save the checklist to a location on your computer or network. When the Download compete screen appears, click Close. Open the Connect program. ...
General Ledger Reports
See attached.
Journal Entries
See attached.
Bank Reconciliation
See attached
Cash Clearing Flow
See attached.
Balancing Utility Billing to the General Ledger
See attachment
Balancing Accounts
See attachment
Connect General Ledger User Guide
Connect General Ledger User Guide
Journal Approvals
Journal Approvals Manual journal entries can be sent through an approval process before the entry is posted to the general ledger account. This requires setting up an approval process. Once setup, users can enter entries as normal. The entries are ...
Adding an Activity Number to an Existing Transaction
When we enter an invoice and forget to add a GL Activity number, we have the ability to add it after the fact in the General Ledger. Follow these steps: Go to General Ledger | Journals | Enter Journal Amounts. Specify the appropriate Journal ...
Reporting on a GL Activity
To report on a GL Activity to find out how much and which expenses were coded to an Activity, there are several reports and an inquiry screen that can be used to find out this information. INQUIRY To quickly view how much has been charged to ...
Tracking Expenses Related to Novel Coronavirus (COVID-19)
Local health departments stand on the front lines of coping with Novel Coronavirus (COVID-19). As a result, the Federal Government has recommended that local governments track expenses related to the COVID-19 response for possible future ...
General Ledger Open Periods
The ability to make entries to a GL period is controlled in GL - Organization - Organization: There are three fields of primary interest here: 1. Current period: This controls which period will show by default on your reports and is used as a ...
Processing Reserve Accounts as Part of General Combined Cash
Reserves are funds set aside or earmarked for a specific purpose. These funds are usually kept in the same bank account as operating funds, but are tracked separately for reporting to the board/council. These steps will help you keep all of the ...
Report Setup
Date and custom options – This area of the Report Options tab will allow you to select the date or date range that you wish to run the report for. Some reports will give you additional options here, like the ability to include all accounts or ...
Budget Reports
BUDGET BY LEVELS REPORTS The Budget by Levels report will show the budget amount from the various stages of the budget creation process. The options allow you to choose which levels will print and whether to print the account detail or summaries ...
Viewing the Budget
The system has several ways to view or review budget information. ACCOUNT INQUIRY Account Inquiry can help you quickly view budget levels and compare current approved budgets with year-to-date actual amounts. Budget information can be found ...
Import Amounts - Budget
Import Amounts allows you to import information into the General Ledger database from a commadelimited (.csv) file. If you have been preparing budget information in a spreadsheet, this routine allows you to import that work into Caselle. Importing ...
Budget Entry Tools
ENTRY TOOLS Enter Budget Amounts has several tools that can help with entering and proofing your budget. Three (3) of those tools are the Walk Next, Clear Entry Total, and Redisplay. Walk Next When you do not select Worksheet Style, you can ...
Budget Journals
Once levels are established, you can create individual budget journals that are tied to a specific budget level or you can use a single journal not assigned to a specific level. This is done by going to General Ledger | Organization | Journal ...
Budget Levels
Budget Levels allow you to organize and store budget amounts at various phases of the budget creation process. Budget Levels will assist reporting the accumulation of budget amounts in one place and will display changes that are recorded during each ...
Budget Periods
BUDGET PERIODS Budget periods are used by the system to determine which fiscal year the budget amounts belong to. They also determine whether the budget amounts are adopted amounts or whether the amounts are being used for projection purposes. ...
New Fund Setup - Copy Account Ranges
To create a new fund you may want to consider copying the account numbers from a current fund to a new fund number. Find a fund that best matches the numbering of the new fund. In the sample fund 365 is used as a template for fund 366. Copy account ...
How do I close year-end in General Ledger?
Closing the year-end is a step in the Year-end Checklist. When you are done with the last month of the year, your ready to close the year end. Closing the year-end is a "soft close", which means Connect will add one year of future dates and you can ...
Formatted account number is not correct (Checkout error)
If you receive a Checkout error indicating that a formatted account number is not correct for account number, follow these steps to correct this issue: 1. Open General Ledger > Organization > Recalculate. 2. Check the Reformat account ...
How do I add an account?
The following will walk you through the steps to add an account into your Chart of Accounts. Learn more about the Chart of Accounts such as activation date, copy an account, delete an account, termination date, budget notes, account notes, and more ...
Next page