Download - Business User Group
![Page 1: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/1.jpg)
February 12th, 2009
9:00 AM – 11:30 AM
Business User Group
![Page 2: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/2.jpg)
• Announcements
• Presentations~ Cash Flow & Accounting 102~ COSO (Committee of Sponsoring Organization Plan~ Work Instruction Refresher – Tips & Tricks~ Using Sub-Ledgers~ Posted not Paid Report
~ Close Out Old POs
• Questions and Answers
Today’s BUG Agenda
2
![Page 3: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/3.jpg)
Opening Remarks
3
Paul Carlson
![Page 4: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/4.jpg)
Announcements
4
Website (Lynda)
Reconciling Payroll to the G/L (Lynda)
Next BUG – End of Year Issues – Please Plan To Attend (Paul)
Audits (Paul)
![Page 5: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/5.jpg)
Cash Flow & Accounting 102Paul Carlson
5
![Page 6: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/6.jpg)
Cash Flow & Accounting 102
6
CASH FLOW• Determine which agency funds you want to analyze.
• Determine what period of time you want to show.
• Use a report or query?
• Which reports/queries will you need?
• Which accounts will you have to analyze?
• How does fund balance come into play?
![Page 7: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/7.jpg)
Cash Flow & Accounting 102
7
CASH FLOW• Example of State’s Daily Cash Flow Statement
• Demonstration of how to compute cash flow
• Example of a Cash Flow Statement
![Page 8: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/8.jpg)
Cash Flow & Accounting 102
8
Accounting 102(and a review of Accounting 101) What are the three main statements that accountants prepare for management and the readers of the statements? What is the difference between a Statement of Changes in Fund Balance and a Cash Flow Statement? What is the purpose of preparing a Cash Flow Statement? Regarding the Cash Flow Statement, what is the biggest change going from cash basis statements to accrual basis statements?
![Page 9: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/9.jpg)
Cash Flow & Accounting 102
9
Accounting 102(and a review of Accounting 101) What do you call a payable account that has a debit balance? Why would you have this situation? Why would you have an accounts receivable account with a credit balance? What do you call a fund that has a debit fund balance?
![Page 10: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/10.jpg)
COSO (Committee of Sponsoring Organization) Plan
Lynda Roesler
10
![Page 11: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/11.jpg)
Internal Controls
Where they come from
Why we need them
Where we are going
COSO Plan
11
![Page 12: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/12.jpg)
Where Internal Controls Come From
• COSO – Committee of Sponsoring Organizations of the Treadway Commission
• A private-sector initiative, formed in 1985. Its major objective is to identify the factors that cause fraudulent financial reporting and to make recommendations to reduce its incidence. COSO has established a common definition of internal controls, standards, and criteria against which companies and organizations can assess their control systems.
• COSO is sponsored and funded by 5 main professional accounting associations and institutes; American Institute of Certified Public Accountants (AICPA), American Accounting Association (AAA), Financial Executives International (FEI), The Institute of Internal Auditors (IIA) and The Institute of Management Accountants IMA).
COSO Plan
12
![Page 13: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/13.jpg)
Background• The Sarbanes-Oxley Act of 2002 (“SOX”) requires publicly traded
companies to document the safeguards they have in place to prevent errors and fraud – known as internal controls
• The GAO (United States General Accounting Office) issued Standards on Internal Control in the Federal Government in November of 1999.
• Updated OMB Circular A-123 effective in FY06 – defines management responsibility for internal controls. The Circular provides updated internal control standards and new specific requirements for conducting management’s assessment of the effectiveness of internal control over financial reporting
COSO Plan
13
![Page 14: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/14.jpg)
Currently -
• Many government organizations have already implemented requirements for internal controls
• At meetings/conferences, staff from OMB (Federal Government Office of Management & Budget) are letting States know they may be putting their grant money at risk if they do not implement an internal control plan at the State/Agency level.
COSO Plan
14
![Page 15: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/15.jpg)
Why we need Internal Controls
• Internal controls will give reasonable assurance the Agency can meet it’s mission and goals.
• Internal controls are the checks and balances that help managers detect and prevent problems.
• Internal controls must become a broadly understood and important element of the corporate culture in which they operate.
COSO Plan
15
![Page 16: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/16.jpg)
COSO’s 5 Inter-related Standards
Control Environment
COSO Plan
16
![Page 17: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/17.jpg)
Where we are going
• Each Agency will designate an Internal Control Coordinator
• Training will be provided on developing an internal control plan
• State Accounting will provide Resources to assist agencies in developing the plan
• Agencies will Respond to a set of internal control questions about their operations on an annual basis
COSO Plan
17
![Page 18: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/18.jpg)
COSO’s 5 Inter-related Standards
Control Environment
COSO Plan
18
![Page 19: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/19.jpg)
COSO Cube
COSO Plan
19
![Page 20: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/20.jpg)
Work Instructions RefresherTips & Tricks
Lynda Roesler
20
![Page 21: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/21.jpg)
Work Instructions Refresher – Tips & Tricks
21
![Page 22: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/22.jpg)
NDE Uses of Sub-LedgersPaul Haas
22
![Page 23: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/23.jpg)
• Used on Expense Reimbursement Documents to track individual employee’s travel expenditures. The sub-ledger we use for employees and Board Members is their Address Book Number.– Particularly important for tracking our State Board
Members expenses.– Use it on Direct Billed items, such as lodging to get a full
cost of each individuals travel costs.
NDE Uses of Sub-Ledgers
23
![Page 24: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/24.jpg)
• Used on payment of independent contractors. We use the NDE assigned contract number.– Important to track all expenditures associated with a
contract if the contract allows for certain items (lodging) to be Direct Billed to NDE. Because we are not directly paying the contractor for those expenditures and that amount is not included in the procurement portion of NIS we still needed a way to track the direct billed expenditures to the contract.
NDE Uses of Sub-Ledgers
24
![Page 25: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/25.jpg)
• Used on payment of independent contractors. We use the NDE assigned contract number.– Important to track all expenditures associated with a contract if the
contract allows for certain items (lodging) to be Direct Billed to NDE. Because we are not directly paying the contractor for those expenditures and that amount is not included in the procurement portion of NIS we still needed a way to track the direct billed expenditures to the contract.
• Used for payment of employee/employer relationship contractors. Use NDE assigned contract number.– Payroll purposes
• Regular payroll costs• Includes use for Workers Compensation costs
NDE Uses of Sub-Ledgers
25
![Page 26: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/26.jpg)
• Use structured sub-ledgers for single business units that different teams or offices within a team make payments.– Vocational Rehabilitation team has several large federal
grants that they administer throughout the State. They have about 12 offices throughout the State that administer the grant. Instead of creating 12 business units for each grant with authorization for each business unit, we use one business unit for each grant with 12 sub-ledgers. This allows us to track all of the expenditures (payroll and operations) by site.
NDE Uses of Sub-Ledgers
26
![Page 27: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/27.jpg)
Early Childhood team has several grants that they administer with the Special Education team. The Early Childhood team consists of staff at the State Agency as well as staff located in Omaha at the Early Childhood Training Center. Again, we set up one business unit with 3 structured sub-ledgers.
NDE Uses of Sub-Ledgers
27
![Page 28: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/28.jpg)
• Cash funds – Early Childhood Training Center charges a nominal fee to
entities and individuals for the training\conferences that it provides. The receipts are tracked using a sub-ledger and the expenditures for the training (contracted trainer, room rent, etc) are coded with the same sub-ledger so that we can make sure that the Training Center is not making a profit on any particular training. If other funds other than the cash fund are needed to cover the cost of a particular training, it is also coded with that sub-ledger.
NDE Uses of Sub-Ledgers
28
![Page 29: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/29.jpg)
– Nutrition Services Section has a cash fund for recovery of over-claim payments received for prior fiscal year audits. NS administers several federal USDA programs that require claims to be audited. Typically that auditing is completed well after the grant for that fiscal year has been closed and a repayment agreement exists that cover more than one year. Only one cash fund is used with several business units (for each type of federal program) with structured sub-ledgers for the fiscal year of the over-claim.
• Cash Funds continued
NDE Uses of Sub-Ledgers
29
![Page 30: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/30.jpg)
Receipt of grant funds from non-federal outside sources. Use the sub-ledger to receipting and expending the funds.
• Cash Funds continued
NDE Uses of Sub-Ledgers
30
![Page 31: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/31.jpg)
• Accounting– Inquiries and Reports
• Accounting Reports– General Ledger Reports
» G/L with Sub-ledger Totals
• Reports -G/L with Subledger Totals
NDE Uses of Sub-Ledgers
31
![Page 32: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/32.jpg)
32
![Page 33: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/33.jpg)
33
![Page 34: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/34.jpg)
34
![Page 35: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/35.jpg)
35
![Page 36: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/36.jpg)
Open Payables, Posted Not Paid ReportBruce Snyder
36
![Page 37: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/37.jpg)
Open Payables, Posted Not Paid Report
37
What is this new report?
o CSV Report, too many columns to format as pdfo Lists open, posted vouchers by Agencyo Where due date < current date and > 60 days in futureoReport will help agencies identify why vouchers are not paido Will run in MREPORT daily beginning week of 2-23-09
![Page 38: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/38.jpg)
Reasons for a Voucher not being paid– Voucher is not posted– Insufficient cash in fund– Future Due Date (Discount Due Date)– Vendor in pre-note status– Voucher on hold– Warrant vendor with multiple vouchers totaling more
than allowable warrant amount (currently $75,000, will be lowered)
– Warrant vendor with “T” payment instrument
Open Payables, Posted Not Paid Report
![Page 39: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/39.jpg)
Open Payables, Posted Not Paid Report
39
How do I use the report to determine why vouchers are not paid?
• Future Due DateUse the Due Date and Discount Due Date fields to see if a date is in the future –voucher will not pay until this date. Change using
Special Handle a Voucher.
• Vendor in pre-note statusA future date in the Pre-Note Date field indicates that the vendor is starting to receive electronic payments or has changed bank
accounts. Voucher will pay on this date if Pay Instrument field is “T”.
![Page 40: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/40.jpg)
Open Payables, Posted Not Paid Report
40
How do I use the report to determine why vouchers are not paid?
• Voucher is on holdAn “H” in the Pay Status field indicates the voucher is Hold Status.
• Warrant vendor with multiple vouchers totaling more than allowable warrant amount
Use Open Amount and Payee Total fields to determine if this is the reason. Open Amount field is the document total for the vendor.
Payee Total is total open amount for the vendor.
![Page 41: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/41.jpg)
Open Payables, Posted Not Paid Report
41
How do I use the report to determine why vouchers are not paid?
• Insufficient cash in fund.Fund field is the fund for the first line of the document. This can
help determine if this is why a voucher is not paid before an agency is contacted by State Accounting.
• Warrant vendor with “T” payment instrumentPayee Number and Pay Instrument fields provide information to
determine if this is a reason for not being paid.
![Page 42: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/42.jpg)
Close Out Old POsAmy Wilson
42
![Page 43: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/43.jpg)
PURCHASE ORDER CLEAN UP1. Allotment Status Report - R5509146A - MREPORT
Check the Encumbrance Column
2. Allotment Status Encumbrance Detail – R55097NIS Menu: General Accounting, General Accounting - Agencies > Inquiries and Reports > Accounting Reports > Allotment Status Encumbrance Detail Report
3. Open PO Detail by Branch/Plant – R43632 NIS Menu: Purchasing – Agencies > Inquiries & Reports >
Purchasing Reports > Procurement Reports > Open PO Detail by Branch/Plant
Close Out Old POs
43
![Page 44: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/44.jpg)
PURCHASE ORDER CLEAN UP (Cont.)4. PA Commitment Inquiry
NIS Menu: Role – Procurement, Purchasing - Agency > Inquiries & Reports > Purchasing Inquiries > PA Commitment Inquiry
In the QBE Account Number column - *Business Unit.Object*
Find
Highlight first line of PO Row / Order Entry
Close Out Old POs
44
![Page 45: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/45.jpg)
Close Out Old POs
45
![Page 46: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/46.jpg)
Close Out Old POs
46
![Page 47: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/47.jpg)
Close Out Old POs
47
![Page 48: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/48.jpg)
Close Out Old POs
48
![Page 49: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/49.jpg)
Close Out Old POs
49
![Page 50: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/50.jpg)
STATE ACCOUNTING IS SEEING• POs open that should be cancelled – Agency is not
going to receive the goods or services• Purchasing tables that are not the same • Cancel date in the future • Rounding
Close Out Old POs
50
![Page 51: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/51.jpg)
FINANCIAL PROBLEMS w/ POs• Send email to State Accounting’s mail-in database using the
following link: http://www.das.state.ne.us/accounting/nis/contacts.htm
• Select link for Purchasing • Provide in email
– Order #– Order Type – Short description of problem
Close Out Old POs
51
![Page 52: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/52.jpg)
REMEMBER June 30, 2009 is end of biennium and all
open Purchase Orders will be encumbrances
DON’T DELAYDON’T DELAYDON’T DELAYDON’T DELAY
Close Out Old POs
52
![Page 53: Business User Group](https://reader035.vdocuments.us/reader035/viewer/2022062806/56814eb5550346895dbc5cce/html5/thumbnails/53.jpg)
Questions & Answers
53