Cougar Mountain Software General Ledger User Manual

Posted : admin On 12/26/2021

Contents

Mountain
The General Ledger Accounting Cycle
Entering Journals
Creating Journal Batches
Entering Journals
Entering Journal Lines
Entering Taxable Journal Entries
Entering Entered Currency Journals
Entering Statistical Journals
Autocopying Journal Batches
Changing a Batch Period
Changing the Journal Entry Currency
Checking or Reserving Funds for a Journal Batch
Submitting Journal Batches for Approval
Approving Journal Batches
Journal Wizard
Journal Wizard Overview
Prerequisites
Creating Journal Entries with the Journal Wizard
Working with Web ADI Layout
Customizing the Layout
Uploading Data
Importing Data using Web ADI Content
Entering Journals for a Prior Period
Entering Journals for a Future Period
Reviewing Budgetary Control Transactions
Reviewing Budgetary Control Transaction Detail
Printing a Budgetary Control Transactions Report
Journal Approval
Journal Approval Overview
GL Initialization & Validation Process
GL Preparer Approval Process
GL Approval Process
GL Request Approval Process
GL No Approver Response Process
Customizable: Verify Authority Process
Allocating Amounts with Recurring Journals and MassAllocations
Creating Allocation Entries
Creating Allocations Using Recurring Journal Formulas
Creating Net Allocations
Creating Step-Down Allocations
Creating Rate-Based Allocations
Creating Usage-Based Allocations
Using Allocations for Standard Costing
Recurring Journals
About Recurring Journals
Creating Recurring Journal Formula Batches
Securing Recurring Journals
Creating Recurring Journal Entries
Entering Recurring Journal Entry Lines
Entering Recurring Journal, Budget, and Eliminating Entry Formulas
Reporting Currencies
Entering Formulas with EasyCalc
Creating Skeleton Journal Entries
Creating Standard Recurring Journal Entries
Creating Entered Currency Recurring Journal Entries
Copying Entries from an Existing Recurring Journal Batch
Changing a Recurring Journal Entry
Performing Standard Costing with Recurring Journals
Generating Recurring Journal Batches
Scheduling Your Recurring Journal Batch
MassAllocations
About MassAllocations
Creating MassAllocation Batches
Creating MassAllocation Formulas
Entering MassAllocation Formula Lines
Entering a Target Account
Entering an Offsetting Account
Allocation Formula Rules
Validation Business Rules
Reporting Currencies
Generating MassAllocation Journals
Reusing MassAllocation Formulas for Different Ledgers and Balancing Segment Values
Choosing an Allocation Method
MassAllocation Examples
AutoAllocations
AutoAllocations Overview
Oracle Projects and Oracle General Ledger
Parallel Allocation Sets
Step-Down AutoAllocation Sets
Securing AutoAllocation Sets
Submitting AutoAllocation Set Requests
Reviewing the status of your AutoAllocation Sets
Step-Down AutoAllocation Approval Process
Customizing Step-Down AutoAllocations
AutoAllocation Processes
Journal Import
Integrating General Ledger Using Journal Import
Preparing to Import Journals
Exporting Data From Your Feeder System
The GL_INTERFACE Table
Assigning Values for Accounts
Assigning Values for Additional Required and Conditionally Required Columns
Assigning Values for Currency Conversion
Assigning Values to Optional Columns
Required NULL Columns in the GL_INTERFACE Table
Importing Specialized Data
About Journal Import Validation
Multi-Table Journal Import
Interface Data Transformer
Importing Journals
How to Import Journals
Setting the Journal Import Run Options
Running the Journal Import Program from Standard Report Submission (SRS)
Correcting Journal Import Data
Correcting Accounts in Journal Import Data
Troubleshooting
Deleting Journal Import Data
Posting Journals
Posting Journal Batches
Cancelling a Batch Posting
Posting to a Suspense Account
Reviewing the Batch Posting Status
Correcting Batch Posting Errors
Posting Journal Batches Automatically (AutoPost)
Generating Reporting Currency Journals
Reversing Journals
Defining Reverse Journal Entries
Generating Reversing Journal Batches
Automatic Journal Reversal
Automatic Journal Reversal Overview
Definition Access Sets
Default Reversal Criteria for Seeded Journal Categories
Setting up an Automated Reversal in a Secondary Ledger
Overview of Journal Reconciliation
Entering Reconciliation References
Performing Automatic Account Reconciliation
Performing Manual Account Reconciliation
Performing Manual Account Reconciliation Reversal
Reconciliation of Transactions with Single or Multiple Currencies
Automatic Journal Scheduling
Incrementing Submissions
Year-End Closing Journals
Income Statement Closing Journals
Balance Sheet Closing Journals
Secondary Tracking Segment
Year-End Close Checklist
Overview of Budgeting
Budgeting Methods
Creating Budget Formulas to Allocate Budget Amounts
Creating a Flexible Budget
Using Top-Down, Bottom-Up, and Middle-Out Budgeting
Using MassBudgeting
Creating Master/Detail Budgets
Master/Detail Budget Example
Uploading Budgets from a Spreadsheet
Budgets
Defining Budgets
Assigning Budget Periods
Opening a Budget Year
Copying Budget Amounts from an Existing Budget
Budget Organizations
Defining Budget Organizations
Assigning Account Ranges to a Budget Organization
Protecting a Budget Organization with a Password
Setting Budgetary Control Options for an Account Range
Copying Account Ranges from an Existing Budget Organization
Adding or Changing Individual Accounts
Changing a Budget Organization
Deleting a Budget Organization
Budget Formulas
Creating Budget Formula Batches
Creating a Budget Formula Entry
Securing Budget Formulas
Entering Budget Formula Entry Lines
Copying Existing Budget Formulas
Changing a Budget Formula Entry
Calculating Budget Amounts
Scheduling Your Budget Formula Batch
MassBudgets
Overview
Defining MassBudgets
Defining a MassBudget Formula
Entering MassBudget Formula Lines
Assigning Segment Types
Entering a Target Account
Entering an Offset Account
Generating MassBudget Journals
Choosing an Allocation Method
Scheduling Your MassBudget Journal Batch
Entering Budget Amounts
Entering Budget Amounts for Multiple Accounts
Using Budget Rules to Distribute Budget Amounts
Budget Rules
Setting the Budget Rule Rounding Options
Entering Statistical Budget Amounts
Entering Budget Journals
Entering Statistical Budget Journals
Creating Unposted Budget Journal Batches
Budget Wizard
Creating a Budget Worksheet
Changing the Budget Worksheet View
Updating Budget Balances Using Budget Wizard
Adding Budget Notes to a Budget Worksheet
Graphing Budgets
Uploading Budgets from Budget Wizard to General Ledger
Transferring Budget Amounts
Transferring Budget Amounts Using Budgetary Control
Entering Budget Transfer Amounts
Uploading Budgets
Integrating General Ledger Using Budget Upload
Understanding the Budget Interface Table
Creating Your Budget Spreadsheet
Loading Data into the Budget Interface Table
About Budget Upload Validation
Correcting Budget Upload Errors
Uploading Budgets to Undefined Accounts
Uploading Budget Amounts to Undefined Accounts
Freezing Budgets
Freezing Budget Formula Batches
Freezing Budget Organizations
Freezing Budgets for a Range of Accounts
Using Budgetary Control and Online Funds Checking
Overview
Funds Checking and Encumbrance Accounting
Defining an Account
Budgetary Control Options
Funds Check Level
Tolerance Percent and Tolerance Amount
Override Amount
Amount Type and Boundary
Latest Encumbrance Year
Budgetary Control Options for Accounts
Budgetary Control Options for Journal Sources and Categories
Detail and Summary Level Budgetary Control
Changing Budgetary Control Options
About Funds Checking
Setting Up Budgetary Control
Reports
Creating Your Own Funds Available Reports
Inquiry
Setting Up Budgetary Control in Purchasing and Payables
Budgetary Control in Purchasing
Checking Funds on Purchasing Documents
Failing Funds Checking
Document Approvals
Reserving Funds for a Purchasing Document
Funds Reservation Status of Purchasing Documents
Requisitions and Budgetary Control
Creating a Requisition
Importing Approved Requisitions
Cancelling a Requisition
Internal Requisitions
Closing a Requisition
Purchase Orders and Budgetary Control
Creating a Purchase Order
Planned Purchase Orders
Blanket Purchase Agreements
Reserving Funds for a Purchase Order
Modifying a Purchase Order
Cancelling a Purchase Order
Receiving
Closing a Purchase Order
Reports and Inquiries in Oracle Purchasing
Budgetary Control in Oracle Payables
Entering an Invoice
Final Match
Prepayments
Approval and Online Invoice Validation
Releasing Funds Holds
Maintaining a Matched Invoice
Relieving Encumbrance Entries
Multiple Currency Transactions
Creating a Budgetary Control Group
Setting Budgetary Control Options for Journal Sources and Categories
Running the Create Journals Program
Running the Mass Funds Check/Reservation Program
Cougar mountain software general ledger user manual free
Overview of Encumbrance Accounting
Defining Encumbrance Types
Entering Encumbrances
Reviewing Encumbrances
Relieving Encumbrances
Viewing Funds Available
Year-End Encumbrance Processing
Performing Year-End Encumbrance Processing
Carrying Forward Year-End Encumbrance and Budget Balances
Overview of Average Balance Processing
Basic Business Needs
Average Balance Examples
General Example
Relationship Between Aggregate and Average Balances
Example: Period Average-to-Date Balance
Example: Quarter Average-to-Date Balance
Example: Year Average-to-Date Balance
Major Features
Effective Date Handling
Back-Value Transactions
Weekends and Holidays
Set Up and Maintenance
Enabling Average Balance Processing
Processing Options for Non-Business Days
Opening a New Period
Archiving and Purging
Multi-Currency Processing
Conversion
Revaluation
Translation
Consolidation
Consolidating Transactions
Consolidating Balances
Online Inquiry
Reporting
Standard Reports
Financial Statement Generator
Introduction
Overview of Account Analysis and Drilldown
Overview of Account Inquiry
Account Inquiry
Performing an Account Inquiry
Account Inquiry Example
Performing an Account Inquiry for Ledger Sets
Reviewing Balances in an Account Inquiry
Reviewing Variances Between Account Balance Types
Drilling Down to Journal Detail
Performing a Journal Entry Inquiry
Drilling Down to Oracle Subledger Applications
Drilling Down to Subledger Detail
T-Accounts
Average Balance Inquiry
Performing an Average Balance Inquiry
Detail Average Balance Inquiry
Summary Average Balance Inquiry
Inquiring on Budgets
Performing a Budget Inquiry
Reviewing Budget Balances in a Master Budget Inquiry
Reviewing Budget Balances in a Detail Budget Inquiry
Reviewing Detail Account Balances
Reviewing Budget Journal Detail
Consolidated Balance Inquiry
Performing Consolidated Balance Inquiries
Overview of Reporting in General Ledger
Overview of the Financial Statement Generator
Report Building Concepts
Simple Reports
Special Format Reports
Report Distribution
Other FSG Features
Tips and Techniques for Using FSG
Using Financial Statement Generator
Suggestions for Specific Financial Reports
Tips for Designing FSG Reports
Frequently Asked Questions About FSG
FSG Tasks
Defining Row Sets
Securing Row Sets
Assigning Accounts
Defining Report Calculations
Defining Column Sets
Using the Column Set Builder
Creating Column Headings
Defining Column Exceptions
Defining Content Sets
Securing Content Sets
Defining Row Orders
Securing Row Orders
Defining Display Sets
Copying Report Objects
Defining Financial Reports
Securing Reports
Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in an FSG Report
Defining Financial Report Sets
Securing Report Sets
Copying Report Objects From Another Database (FSG Transfer Program)
FSG Transfer Program Parameters
Running Financial Reports
Running Financial Reports with BI Publisher
FSG Security Rules
Creating a Report Template Using Report Manager
Reporting Attributes
Setting Up Reporting Attributes
Defining Reporting Attribute Value Sets and Values
Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes
Assigning Reporting Attribute Values to Account Segment Values
Specifying Descriptive Flexfield Segments to Use as Reporting Attributes
Running the Reporting Attribute Preparation Program
Running the Reporting Attribute Historical Program
Reporting Attributes Examples
Defining Ad Hoc Reports
Deleting Ad Hoc Reports
Downloading Financial Reports
FSG Reference Information
Row Set Format Options
Row Set Display Types
Content Set Display Types
Standard Column Sets
Amount Types
Column Set Builder Toolbar
Format Masks
Balance Control Options
Currency Control Value Options
Row Set Advanced Options
Column Set Advanced Options
Override Segment Assignments
Display Options
Relative Headings
Row and Column Overrides
FSG Report Parameters
XBRL
Loading/Removing XBRL Taxonomies
BI Publisher Basic Report Templates
Country-Specific Reports
Mass Maintenance
Moving or Merging Account Balances
Defining a Move/Merge Request
Submitting a Move/Merge Request
Mass Maintenance Statuses
Validation and Prevalidation
Reversing a Move/Merge
Purging Move/Merge Tables
Reviewing Move/Merge Audit Journals
Creating New Accounts with Mass Creation
Correcting Misclassified Account Types
Archiving Account Balances and Journal Detail
Prerequisites
Creating a Tablespace for Archived Data
Exporting Archived Data
Purging Archived Account Balances and Journals

General Ledger Manual Table of Contents SIMMS Setup Menu General Ledger First Steps Banking Chart of Accounts Creating New Accounts. Import CSV Data into the SIMMS General Ledger Important SIMMS Software Contact Information. SIMMS Setup Menu Even if you work with the GL only, it is necessary to go through the SIMMS Setup menu. Mountain Software, and Cougar Mountain Software cannot guarantee the accuracy of any information presented after the date of publication. This documentation is for informational purposes only and is not a qualified accounting reference. COUGAR MOUNTAIN SOFTWARE MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AS TO THE INFORMATION IN THIS DOCUMENT.

Global Consolidation System
Overview
What You Can Consolidate
Special Considerations for Average Daily Balance Ledgers
Implementation Options
Consolidation Process Steps
Consolidation Workbench
Using the State Controller
Gathering Subsidiary Data from Multiple Instances Using Oracle Applications
Gathering Subsidiary Data from Multiple Instances Using Non-Oracle Applications
Consolidating Ledgers with Different Charts of Accounts
Defining Consolidation Definitions
Definition Access Set Security
Consolidation Run Options
Creating Consolidation Sets
Preparing Subsidiary Data
Transferring Subsidiary Data to Your Parent
Consolidating Balances
Consolidating Transactions
Transferring Consolidation Sets
Posting Subsidiary Data
Eliminating Entries
Creating Eliminating Entries
Inquiry, Reporting, and Analysis
Purging Consolidation Audit Data
Overview of Multi-Currency Accounting
Overview
Currencies
Defining Currencies
Conversion Rates
Defining Conversion Rate Types
Entering Daily Rates
Loading Daily Rates Automatically
Entering Historical Rates
Revaluing Balances
Translating Balances
Notes on Translation with Historical Rates and Amounts
Notes on Translating Owners' Equity Accounts
Notes on Translating Revenue/Expense Accounts
Notes on Translating Average Balances
Currency Rates Manager
Cross Rates
Using the Daily Rates Spreadsheet Interface
Using the Historical Rates Spreadsheet Interface
Running Standard Reports and Listings
Generating Standard Reports Using BI Publisher
XML Output File
Placeholder Syntax for Standard Report Templates
Example of Report Template Layout
General Ledger Standard Reports and Listings
Account Analysis Reports
Account Analysis - Contra Account
Account Analysis Report
Budget Reports and Listings
Budget Hierarchy Listing
Budget Journals by Account Report
Budget Organization Listing
Budget Organization Range Listing
Budgetary Control Transactions Report
Frozen Budgets Accounts Listing
Funds Available Analysis Report
Master/Detail Budget Report
Summary/Detail Budget Report
Unbudgeted Master/Detail Accounts Report
Chart of Accounts Reports and Listings
Account Hierarchy Report
Chart of Accounts Detail Listing
Chart of Accounts Mapping Rules Report
Rollup Detail Listing
Rollup Range Listing
Inactive Accounts Listing
Segment Values Listing
Suspense Accounts Listing
Consolidation Reports
Consolidation Audit Report
Consolidation Exception Report: Disabled Parent Accounts
Consolidation Exception Report: Unmapped Subsidiary Accounts
Consolidation Journals Report
Currency Listings
Daily Conversion Rates Listing
Historical Rates Listing
Financial Statement Generator Reports and Listings
Column Set Detail Listing
Column Set Summary Listing
Content Set Detail Listing
Content Set Summary Listing
Report Detail Listing
Report Set Detail Listing
Report Set Summary Listing
Report Summary Listing
Row Order Detail Listing
Row Set Detail Listing
Row Set Summary Listing
Where Used Report
General Ledger Reports
General Ledger Account Balances Across Ledgers Report
Entered Currency General Ledger Report
General Ledger Report
Journals Reports
Entered Currency Journals Report
General Journals Reports
Journal Batch Summary Report
Journal Entry Report
Journals Line Report
Journals by Document Number Report
Journals - Extended
Journals - Day Book
Journals - Voucher
Journals - Check Report
Tax Journals Report
Automatic Reconciliation Report
Reconciled Transactions Report
Unreconciled Transactions Report
Trial Balance Reports
Trial Balance Report
Average Balance Trial Balance Report
Budget Trial Balance Report
Detail Trial Balance Report
Encumbrance Trial Balance Report
Expanded Trial Balance Report
Trial Balance - Additional Segment Detail Report
Translation Trial Balance Report
Encumbrance Reports
Other Reports and Listings
MassAllocation Formula Listing
Open Encumbrance Balance With Transaction Detail Report
Recurring Formula Listing
Transaction Code Listing
Units of Measure Report
Value-Added Tax Report
Execution Reports
Archive and Purge Audit Report
Assign Budget Account Ranges Execution Report
AutoPost Execution Report
AutoReverse Execution Report
Budget Assignments AutoCopy Execution Report
Budget Spreadsheet Upload Execution Report
Calendar Validation Execution Report
Carry Forward Execution Report
Create Journal Entries Execution Report
Delete Journal Import Data Execution Report
Historical Rates Execution Report
Journal Import Execution Report
MassAllocations/MassBudgeting Execution Report
Mass Funds Check/Reservation Journal Execution Report
Posting Execution Report
Revaluation Execution Report
Segment Value Inheritance Execution Report
Overview of Reporting Currencies
When to Use Reporting Currencies
Translation versus Reporting Currencies
Reporting Currency Features
Setting Up Reporting Currencies
Reporting Currency Setup Steps
Step 1 - Enable or Define Ledgers
Step 2 - Enable and/or Define Currencies
Step 3 - Define Reporting Currencies
Step 4 - Define Responsibilities
Step 5 - Assign Data Access Sets to Responsibilities
Reporting Currency Conversion Rules
Conversion Rounding
Using Reporting Currencies
Considerations For Entering Data into Reporting Currencies
Performing Standard General Ledger Activities
Completing Reporting Currencies-Related Activities in the Correct Order
Implementation Considerations
Terms
Type of Installation
Defining Reporting Currencies for Fresh Install or Upgrade Scenario One
Defining Reporting Currencies for Upgrade Scenario Two
Reporting Currency - Create Opening Balance Journals in Reporting Currency Program
Initialization Tasks
Plan the Initialization
Prepare for the Initialization
Perform the Pre-initialization Tasks
Perform the Initialization
Perform the Post-initialization Tasks
Resume Normal Transaction Processing
Perform Historical Conversion Maintenance
Parameters for Reporting Currency - Create Opening Balance Journals in Reporting Currency Program
Running the Reporting Currency - Create Opening Balance Journals in Reporting Currency Program
Reporting Currency Account Type Specific Conversion
Reporting Currency Account Type Specific Conversion
Setup
ADI Journal Wizard Entry
Transaction Processing
Inquiry and Reporting

General Ledger Template

Using Attachments in General Ledger
General Ledger Windows with the Attachments Feature
Creating an Attachment
Deleting an Attachment
Types of Attachments
Attachment Security