Contents
- 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
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. 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. Cougar Mountain Software’s Denali Business is a complete accounting solution with the ability to customize. Data servers should have 4 GB for up to 4 users with an additional 2 GB of RAM per user over 4 (i.e. 5 users would be 6 GB, 6. Payroll, General Ledger, Bank Reconciliation, Accounts Receivable, and Accounts Payable can all work. Oracle General Ledger User's Guide. Performing Manual Account Reconciliation Reversal. Using Attachments in General Ledger.
- 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
Free General Ledger Software
- 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
- 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
Cougar Mountain Software General Ledger User Manual Download
- Using Attachments in General Ledger
- General Ledger Windows with the Attachments Feature
- Creating an Attachment
- Deleting an Attachment
- Types of Attachments
- Attachment Security