General Ledger Overview
The General Ledger is a complete record of financial transactions over the life of the foundation. If contains the information needed to prepare financial statements and includes accounts for Assets, Liabilities, Equity, Revenue and Expenses. To perform a search of the general ledger, go to the General Ledger page and enter the applicable search cri...
Open the Books
Navigate to General Ledger from the Home page. Select Open Books from the left-side menu. In the Open Books Back To window: Click the drop-down menu to the right of End of Month and select a month. Enter a Year. Click Open. Note: If you open the books and make changes to existing transactions; all reports, statements, etc. will be altered to reflect...
Close the Books
Select General Ledger from the home page. Select Close Books. Click the End of Month drop-down, and select a month. Enter a Year. Click Close. Note: When you close the last period of your year-end, the system will close the books for the year and create the appropriate closing entries. Pro Tips: After closing the books you can not make changes or ...
Record a Journal Entry
You can utilize Journal Entry (JE) to record adjusting entries. For example, at the end of each month, there may be a journal entry to record equipment depreciation. This JE will include a debit to Depreciation Expense (E) and a credit to Accumulated Depreciation (A). To Record a Journal Entry: Navigate to General Ledger. Select Journal Entry from t...
FIMS Reconcile
Within FIMS, export your Fund Trial Balance to your computer. You will need to adjust the column titles of your FIMS data to match the format below: fund (short name) acc_number debit credit Within CommunitySuite, navigate to General Ledger from the Home page. Select FIMS Reconcile from the left-side menu. In the Upload Fund Trial Balance window, cl...
Reclass Transactions
Use the Reclass feature to move transactions from one General Ledger account to another. Navigate to General Ledger from the Home page. In the Show Transactions window: Enter your desired search criteria. Click Show. Select Reclass from the left-side menu. In the Reclass Transactions window: Click the box next to each transaction that you want to r...
Imported Data*
During your implementation process, you will be working with your Client Success Manager to import your financial data. Generally, when you "go live" you will no longer need to worry about importing data into your system. However, there are times when you will want or need to import Journal Entries. Import Journal Entries In General Ledger, click Im...
Import Financial Transactions
Use the process below to import and post historical financial transactions into CommunitySuite. Select General Ledger from the Home page. Select Import. Click Download Template, then enter your financial transaction data into the template, and save the template to your computer. Select Choose File, then locate the file (template) containing the fina...
Bulk Unpost Imported Financial Transactions
If you import financial transactions and realize that you made a mistake (after the data has been posted), you can unpost all imported transactions (from that specific import) at the same time. Select General Ledger from the Home page. Select Import. Click Bulk Unpost. Click the Transaction Timestamp of the transaction that you want to unpost. Sele...