jagomart
digital resources
picture1_Excel Sheet Download 30918 | Bpa Roles Fin With Formulas 21214


 337x       Filetype XLSX       File size 0.18 MB       Source: seattlecentral.edu


File: Excel Sheet Download 30918 | Bpa Roles Fin With Formulas 21214
finance business processes who is currently general ledger step peoplesoft role filling role post journals and update ledger balance edit journal entries post journal process ensures that amounts submit journal ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                                  Finance Business Processes
                                                                                                                                                                                                                 Who is currently
                               General Ledger                                                                    Step                                                        PeopleSoft Role                       filling role?
         Post Journals and Update Ledger Balance                                                          Edit Journal Entries
         Post Journal process ensures that amounts                      Submit journal entry for approval                                                      General Ledger Accountant
         in the journals are posted to appropriate                      Approve, deny, push back, or hold journals                                             Controller/Acct Supervisor/GL Accountant
         General Ledger accounts.  In other words,                      Identify journals that are ready to post online                                        General Ledger Accountant
         the Journal Post process updates the final                     Create/update journal entries                                                          General Ledger Accountant
         account balances in General Ledger.  These                     Identify journals that are ready to post and request process to mark them              General Ledger Accountant
         final account balances are then reported                       Post all journals marked for posting                                                   General Ledger Accountant
         through financial statements such as                           Review status of journals and journal line details                                     General Ledger Accountant
         Income statement and Balance sheet by                          Create a summary report of all posted journals                                         General Ledger Accountant
         organization.                                                                                Process Summary Ledgers
         Build Summary Ledgers                                          Capture transactions                                                                   General Ledger Accountant/Acct Supervisor
                                                                        Identify ledger template and summary ledger Chartfield information                     General Ledger Accountant/Acct Supervisor
                                                                        Associate business unit(s) and a calendar to a summary ledger                          General Ledger Accountant/Acct Supervisor
                                                                        Create summary ledger and update summary ledger balances                               General Ledger Accountant/Acct Supervisor
                                                                        Review status of summary ledger(s)                                                     General Ledger Accountant/Acct Supervisor
                                                                        Review summary ledger reports                                                          General Ledger Accountant/Acct Supervisor
                                                                        Calculate average daily balance capture                                                General Ledger Accountant/Acct Supervisor
         Close Ledgers                                                  Capture transactions                                                                   General Ledger Accountant/Acct Supervisor
                                                                        Identify closing options, net income/retained earnings, journal options                General Ledger Accountant/Acct Supervisor
                                                                            and roll forward options
                                                                        Identify closing rules and steps                                                       General Ledger Accountant/Acct Supervisor
                                                                        Identify ChartFields and close ledgers according to specified criteria (year-          General Ledger Accountant/Acct Supervisor
                                                                            end or interim) and create adjusting entries.
                                                                        Create closing reports                                                                 General Ledger Accountant/Acct Supervisor
                                                                        Record journal entries                                                                 General Ledger Accountant
                                                                        Archive journals and ledgers                                                           General Ledger Accountant/Acct Supervisor
         Close Accounting Period                                        Consolidate financial information                                                      GL Accountant/Accounting Supervisor
                                                                        Perform account reconciliations                                                        GL Accountant/Accounting Supervisor
                                                                        Close ledgers                                                                          GL Accountant/Accounting Supervisor
                                                                        Prepare financial reports                                                              Financial Analyst/Accounting Supervisor
         Consolidate Financial Data                                     Capture transactions                                                                   GL Accountant/Accounting Supervisor
         Users can consolidate multiple organiza-                       Define consolidation ledger sets                                                       GL Accountant/Accounting Supervisor
         tions (BUs) when they areport on overall                       Define consolidation trees                                                             GL Accountant/Accounting Supervisor
         operations, presenting financial statements                    Define elimination sets                                                                GL Accountant/Accounting Supervisor
         that accurately describe financial status.                     Define consolidation set                                                               GL Accountant/Accounting Supervisor
         To gain a complete picture of the entire                       Identify and add any additional required ChartField values, and submit to              GL Accountant/Accounting Supervisor
         organization, users must combine                                   workflow for approval
         (consolidate) all the assets and liabilities                   Approve new Chartfield values added.                                                   GL Accountant/Accounting Supervisor
         of each business unit, eliminating inter-                      Identify accounts to offset debit and credit if elimination set doesn't eliminate      GL Accountant/Accounting Supervisor
         company transactions.                                          Identify related group of accounts & posting accounts, if set does not eliminate,      GL Accountant/Accounting Supervisor
                                                                            & specific accounts to eliminate
                                                                        Identify journal options                                                               GL Accountant/Accounting Supervisor
                                                                        Request consolidation, including journal entry creation, editing & posting             GL Accountant/Accounting Supervisor
                                                                        Review results online                                                                  GL Accountant/Accounting Supervisor
                                                                     Review consolidation processing                                                     GL Accountant/Accounting Supervisor
                                                                     Analyze if adjustment is required                                                   GL Accountant/Accounting Supervisor
                                                                     Process allocations                                                                 GL Accountant/Accounting Supervisor
                                                                     Manually adjust journal entries                                                     GL Accountant/Accounting Supervisor
                                                                     Edit and post journal entries                                                       GL Accountant/Accounting Supervisor
                                                                     Review consolidation results                                                        GL Accountant/Accounting Supervisor
                                                                     Prepare Financial reports                                                           Controller/Enterprise Reporting Mgr./Fin Analyst
         Prepare Financial Reports                                   Close accounting period                                                             General Ledger Accountant/Acct Supervisor
                                                                     Review results of consolidations                                                    Controller/Financial Analyst
                                                                     Review journal or ledger information from integrations                              Controller/Financial Analyst
                                                                     Review journal or ledger information                                                Controller/Financial Analyst
                                                                     Analyze ledgers using online analytical processing                                  Controller/Financial Analyst
                                                                     Perform GL subsystem reconciliation                                                 Controller/Financial Analyst
                                                                     Review GL work center                                                               Controller/Financial Analyst
                                                                     Create balance sheets and income statements using XBRL                              Controller/Financial Analyst
                                                                     Create general reports                                                              Controller/Financial Analyst
                                                                     Extract data for statutory reports                                                  Controller/Financial Analyst
                                                                     Create general ledger statutory reports                                             Controller/Financial Analyst
                                                                     Create consolidation reports                                                        Controller/Financial Analyst
                                                                     Analyze financial information                                                       Accounting Supervisor/Financial Analyst
                                                                     Review calendar and approve dates                                                   Accounting Supervisor/Financial Analyst
                                                                     Create and assemble reporting as a template(IPEDS)                                  Enterprise Reporting Manager
                                                                     Receive template and provide content for report                                     Campus Controller
                                                                     Approve appropriate sections of report                                              Campus Controller
                                                                     Prepare reports                                                                     Financial Analyst
                                                                     Obtain final approval from senior management                                        Campus Controller
                                                                     File report with reporting institution                                              Financial Analyst
                                                                     Receive report                                                                      Reporting Authority
         Capture Transactions Overview                               Manage Budgets                                                                      Budget Manager
                                                                     Manage Grants                                                                       Principal Investigator
                                                                     Record Journal Entries                                                              General Ledger Accountant/Acct Supervisor
                                                                     Edit Journal Entries                                                                General Ledger Accountant/Acct Supervisor
                                                                     Correct Journal Entry Errors                                                        General Ledger Accountant/Acct Supervisor
                                                                     Post Journals and Update Ledger Balances                                            General Ledger Accountant/Acct Supervisor
                                                                     Process Allocations                                                                 General Ledger Accountant/Acct Supervisor
                                                                     Process Summary Ledgers                                                             General Ledger Accountant/Acct Supervisor
                                                                     Calculate Average Daily Balances                                                    General Ledger Accountant/Acct Supervisor
         Record Journal Entries                                                     Manage Budgets, Manage Grants, Operational Activity
         This process enables recording Journals                     Manage Budgets                                                                      Budget Manager
         through online or Batch, Journals Approv-                   Manage Grants                                                                       Principal Investigator
         al, Edit Journals, Post Journals and                        Define Import or Update ledgers                                                     Accounting Supervisor/GL Accountant
         correcting Journals.                                        Create from subsystem transactions                                                  Accounting Supervisor/GL Accountant
                                                                     Define accounting entry defaults, including mapping                                 Accounting Supervisor/GL Accountant
                                                                     Define how to process transactions into journal entries                             Accounting Supervisor/GL Accountant
                                                                     Read transaction tables to create general ledger journal entries                    Accounting Supervisor/GL Accountant
                                                                     Review status of journals and journal line details                                  Accounting Supervisor/GL Accountant
                                                                                                    Record Journal Entries
                                                                     Edit journals                                                                       Accounting Supervisor/GL Accountant
                                                                     Identify journal to be copied                                                       Accounting Supervisor/GL Accountant
                                                                            Run copy journal process                                                                  Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
                                                                            Load external flat files into GL                                                          Accounting Supervisor/GL Accountant
                                                                            EIP (GL_JRNL_IMP) Import data from flat files into General Ledger journal tables          Accounting Supervisor/GL Accountant
                                                                            EIP (GL_JRNL_IMP) Move flat files created in Excel into journal tables                    Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
                                                                            Edit journal entries                                                                      Accounting Supervisor/GL Accountant
                                                                            Correct journal entries                                                                   Accounting Supervisor/GL Accountant
                                                                            Import journal from Excel spreadsheet journals                                            Accounting Supervisor/GL Accountant
                                                                            EIP (Excel_Journal_Import) Import journals created in Excel via XML link                  Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
                                                                            Load information from external sources to GL interface tables                             Accounting Supervisor/GL Accountant
                                                                            Create journals via journal generator                                                     Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
                                                                            Identify journal entries and scheduling options (Define standard journals)                Accounting Supervisor/GL Accountant
                                                                            Create journal entries from standard or recurring journals (Create standard journals)     Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
                                                                            Identify allocation type and special operations                                           Accounting Supervisor/GL Accountant
                                                                            Identify allocated pool and basis of allocation                                           Accounting Supervisor/GL Accountant
                                                                            Assign allocation to a group                                                              Accounting Supervisor/GL Accountant
                                                                            Execute allocation                                                                        Accounting Supervisor/GL Accountant
                                                                            Create reports to review allocation information                                           Accounting Supervisor/GL Accountant
                                                                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
         Edit Journal Entries                                               Request background process to edit journals; budget check if choose                       Accounting Supervisor/GL Accountant
         This process validates created journals                            Review status of journals and journal line details                                        Accounting Supervisor/GL Accountant
         based on the validation criteria to ensure                         Create report of errors detected during edit (Journal Edit Errors Report)                 Accounting Supervisor/GL Accountant
         that there are no accounting errors.  If any                       Correct journal entry errors                                                              Accounting Supervisor/GL Accountant
         errors are found, those journals are                               Request background process to edit journals; budget check if choose                       Accounting Supervisor/GL Accountant
         accordingly marked.  They can be process-                          Request budget check on journals against available funds                                  Accounting Supervisor/GL Accountant
         ed further only after their errors are                             Identify transactions failing budget check, analyze transaction                           Accounting Supervisor/GL Accountant
         manually resolved.  Successfully validated                         Correct journal or request budget correction                                              Accounting Supervisor/GL Accountant
         journals are eligible for posting.                                 Re-request budget check on journals against available funds                               Accounting Supervisor/GL Accountant
                                                                            Edit and budget check journal                                                             Accounting Supervisor/GL Accountant
                                                                            Identify and correct edit errors                                                          Accounting Supervisor/GL Accountant
                                                                            Edit and budget check journal                                                             Accounting Supervisor/GL Accountant
                                                                            Identify, analyze, and correct budget errors                                              Accounting Supervisor/GL Accountant
                                                                            Edit and budget check journal                                                             Accounting Supervisor/GL Accountant
                                                                            Post journal and update ledger balances.                                                  Accounting Supervisor/GL Accountant
         Correct Journal Entry Errors                                       Post journal entries and update ledger                                                    General Ledger Accountant
                                                                            Create new journal entry to correct and reverse the journal suspense line                 Accounting Supervisor/GL Accountant
                                                                            review suspense activities and cross-reference                                            Accounting Supervisor/GL Accountant
                                                                            Edit journal entries                                                                      Accounting Supervisor/GL Accountant
                                                                            post journals and update ledger                                                           Accounting Supervisor/GL Accountant
                                                                            Identify journals that need to be posted and mark them                                    Accounting Supervisor/GL Accountant
                                                                            Post all journals where overrides are appropriate                                         Accounting Supervisor/GL Accountant
                                                                            Edit journal entries                                                                      Accounting Supervisor/GL Accountant
                                                                            post journals and update ledger                                                           Accounting Supervisor/GL Accountant
                                                                            Adjust journal entries                                                                    Accounting Supervisor/GL Accountant
                                                                            Edit journal entries                                                                      Accounting Supervisor/GL Accountant
                                                                            Submit journal for workflow approval                                                      Accounting Supervisor/GL Accountant
         Calculate Average Daily Balances                                  Identify source for calculation and where stored, adjustment period option               Accounting Supervisor/GL Accountant
                                                                               and ChartFields
                                                                           Post ADB source ledger                                                                   Accounting Supervisor/GL Accountant
                                                                           Calculate average daily balance or delete previous calculated ADB                        Accounting Supervisor/GL Accountant
                                                                           Review average daily balance reports and logs                                            Accounting Supervisor/GL Accountant
                                                                           Post journals and update ledger balances                                                 Accounting Supervisor/GL Accountant
         Process Allocations                                               Define allocation                                                                        General Ledger Accountant
                                                                           Identify allocation type and special operations, allocated pool and basis including      General Ledger Accountant
                                                                               destination and offsets
                                                                           Assign an allocation to an allocation group                                              General Ledger Accountant
                                                                           Request allocations                                                                      General Ledger Accountant
                                                                           Record journal entries                                                                   General Ledger Accountant
                                                                           Create reports to review allocation information                                          General Ledger Accountant
The words contained in this file might help you see if this file matches what you are looking for:

...Finance business processes who is currently general ledger step peoplesoft role filling post journals and update balance edit journal entries process ensures that amounts submit entry for approval accountant in the are posted to appropriate approve deny push back or hold controlleracct supervisorgl accounts other words identify ready online updates final createupdate account balances these request mark them then reported all marked posting through financial statements such as review status of line details income statement sheet by create a summary report organization ledgers build capture transactions accountantacct supervisor template chartfield information associate unit s calendar reports calculate average daily close closing options net incomeretained earnings roll forward rules steps chartfields according specified criteria year end interim adjusting record archive accounting period consolidate gl accountantaccounting perform reconciliations prepare analystaccounting data users ca...

no reviews yet
Please Login to review.