Docstoc

General Ledger General Ledger

Document Sample
General Ledger General Ledger Powered By Docstoc
					Welcome!

Presenter: Jeff Weaver
                                        General Ledger
                                        General Ledger

Major Topics To Be Covered In This Presentation
• Internal GL vs. GL Interface/Export
   • Different Options (Customizable)

• GL Interface/Export
   • Setup and Process Overview

• Internal GL
   • Setup
   • Posting Process
   • Auditing
   • Reports
                                                General Ledger
                                                General Ledger

Internal GL vs. GL Interface/Export
• Internal GL
   • Self Contained
   • Generates Financial Reports and Audit
   • Ability to Drill Down on Detail

• GL Interface/Export
   • Export Balances to 3rd Party Accounting Software
   • Ability to use Accounting Software to Generate
     Reports
   • Write Checks from Accounting Software
General Ledger
General Ledger
                                       General Ledger
                                       General Ledger

GL Interface/Export Setup
• Chart of Accounts
   • Export from Accounting Software
   • Import to Celerant Command
• Categories
   • Payable Categories
   • Payout Categories
   • Tenders
   • Transfer Categories
   • AR Adjustment Categories
   • Bank Accounts
• GL Export Rules
Insert Screenshots, etc.
Insert Screenshots, etc.
                              General Ledger
                              General Ledger

GL Interface/Export Process
• GL Balance Export
   • QB Export
   • GL Journal Export

• Payable Export
   • QB Payable Export
   • Payable Export
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
                                General Ledger
                                General Ledger

Internal GL Setup
• Chart of Accounts

• Categories
   • Payable Categories
   • Payout Categories
   • Tenders
   • Transfer Categories
   • AR Adjustment Categories
   • Bank Accounts
                                    General Ledger
                                    General Ledger

Internal GL Settings
• Store Settings
   • Custom Categories – Misc. 5
   • Store Segment

• Enterprise Settings
   • Use Command’s General Ledger
   • First Month
   • Default Company Segment
   • Default Year End Account
Insert Screenshots, etc.
                                                 General Ledger
                                                 General Ledger

System Settings
• Enterprise Settings

   •   Use Command’s General Ledger
   •   First Month – Financial Year
   •   Default Company Segment – Segment 2
   •   Default Year End Account – Closing Entry Account
Insert Screenshots, etc.
                                                  General Ledger
                                                  General Ledger

Chart Of Accounts
• Account Number, Description, Type
   • Type – Asset, Liability, Equity, Expense, COGS,
     Income, Other Income
      • COGS and Income – Determines selectable
         Accounts for Sale Groups
   • Break out by Store
   • Inactive Flag – Will not display on Financial Reports
   • Note: Must reload the Front End for the Accounts to
     display under the Drop Downs.
Insert Screenshots, etc.
                                               General Ledger
                                               General Ledger

Account Categories
• G/L Sales Groups
   • Flow – Customer Type, Inventory, Default Mapping

• G/L Source Codes – Hard Coded
   • Cash and Sales
   • Transfers
   • AP
   • Manual Entry
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
Insert Screenshots, etc.
                                               General Ledger
                                               General Ledger

Default Mappings

• Every option under the Default Mappings should be
  assigned a GL account

• Edit Each Entry Name and Assign a valid Account

• Refer to Recommended Default Mappings
Insert Screenshots, etc.
General Ledger
General Ledger
Insert Screenshots, etc.
                                                   General Ledger
                                                   General Ledger

Build Postings
• Verifies the posting the transaction is making is in balance
  and has the associated GL Accounts.

• Combines postings by Store, Date, and Source Code

• Transactions that are compliant will display under Post
  Transactions

• Transactions that are not compliant will display under
  Unpostable Transactions until they are corrected
Insert Screenshots, etc.
                                                     General Ledger
                                                     General Ledger

Post Transactions
• Able to search based off Transaction Date, Store, and/or
  Source Code

• Select the transactions to post – Able to select all or
  individual transactions

• Change the Post Date of the transactions being posted
   • Post Date is used when running Financial Reports
                                                    General Ledger
                                                    General Ledger

Unpostable Transactions
• Search will display all unpostable Transactions

• Able to View Entries and/or the Source Transaction to
  determine the cause of the problem
   • Example: Tender setup without a GL Account (Missing
     Account)
Insert Screenshots, etc.
                                                General Ledger
                                                General Ledger

End of Year Process


• Will take the balances from Income, Expense, COGS, and
  Other Income account types and make the appropriate
  entry to the Default Year-End Closing Account found under
  Enterprise Settings or Company Settings
Insert Screenshots, etc.
General Ledger
General Ledger
                                                  General Ledger
                                                  General Ledger

Journal Entries List
• Only displays Posted Transactions

• Able to use wildcard searches under Reference #

• Able to search by Transaction Date or Posting Date

• Will display every entry that affected the GL Balance

• Able to enter Manual Journal Entries
Insert Screenshots, etc.
                                                 General Ledger
                                                 General Ledger

Journal Entries List
• Able to enter Manual Journal Entries

   • User is able to make two-sided GL Entry
   • Date entered represents the Transaction Date and
     Posting Date for Manual Entries
   • Memo will display under Journal Entries List for
     reference
   • End of Year flag will make a GL entry to the previous
     year
General Ledger
General Ledger
                                                   General Ledger
                                                   General Ledger

Financial Reports
• All GL Reports are Exported to Microsoft Excel for Ease of
  use
• Common Selection Options
   • Date – Based off the Posting Date, NOT the
      Transaction Date
   • Store Detail – Enabling will break out accounts with
      segment 2 and 3
       • If an account is setup to not break out by store, the
          default segment will display
   • Store – Able to select what store to run the report for
   • No Zero Balances – Enabling this will remove zero
      balance accounts from the report in order to shorten
      the report
Insert Screenshots, etc.
                                                   General Ledger
                                                   General Ledger

Trial Balance
• Lists all active accounts with the balances of posted
  transactions based off the posting
Insert Screenshots, etc.
                                            General Ledger
                                            General Ledger

Income Statement
• Format – Income, COGS, Expense, Other Income
Insert Screenshots, etc.
                                                     General Ledger
                                                     General Ledger

Balance Sheet
• Format – Assets, Liabilities, Equity, Net Income
Insert Screenshots, etc.
                                                   General Ledger
                                                   General Ledger

Activity Report
• Displays the detail activity on an account or group of
  accounts that have been posted with the beginning
  balance, activity posted, and ending balance
Insert Screenshots, etc.
                                               General Ledger
                                               General Ledger

Detailed Reports
• Reports to use to tie out GL Balances
   • Accounts Payable
      • Accounts Payable > View Payables

   • Accounts Receivable
      • Analysis > Accounts Receivable > AR Aging Trial
        Balance

   • Inventory Value
      • Analysis > Inventory > Summary
The End!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:36
posted:9/29/2012
language:Unknown
pages:69