General Ledger ReNumbering: The Good, The Bad

1
General Ledger Re-NumberingThe Good, The Bad
The Ugly Session 32810

• Reid Ellis
• R. Reid Ellis, Jr., CPA, CCP, LLC
• ReidEllis_at_aol.com
• 301-526-6412

2
The Good, The Bad and The Ugly

• Introductions
• Who IS Reid Ellis? (The Good, The Bad, or The
  Ugly)
• Why are we here?

3
New Chart of Accounts

• Business has grown over years
• Now Publicly Traded
• Originally a Land Line Company
• Buy a share of stock to get a phone line
• Now Heavily Cell Technology Retail
• Build Cell Towers Lease Space Equipment
• SEC Agreement to re-organize Chart

4
The Good, The Bad The Ugly
5
The Good, The Bad The Ugly

• Management Support
• Buy-in by staff
• Dedicated Team Members
• Accounting, Project Management, Technical
• Weekly Status Meetings
• Project planning / reporting

6
The Good, The Bad The Ugly

• Design, Design, Design
• Reporting Design for new chart
• Review of existing reports
• Standard reports
• Review of off system/custom reports
• Design of Chart that would meet these needs

7
The Good, The Bad The Ugly

• Plan, Plan, Plan
• Investigate Options
• Outside package (None Found)
• In-House staff
• Resources available
• Project Plan - Iterations
• Test Scripts writing / documentation

8
The Good, The Bad The Ugly

• Design, Design, Design
• Programming Design options
• Update in Place
• Update from spreadsheet
• Old / New File
• example FZ0901 File
• / --- Old F0901 Rec --/ --- New F0901Rec --/

9
The Good, The Bad The Ugly

• Files Analysis
• Files to Change
• F0901, F0902, F0911, F0301, F0311, F4301, F4311,
  etc, etc, etc.
• Fields to Update
• CO, MCU, OBJ, SUB, GLC, ANI, AID, etc, etc.
• Trap Re-Used Data Fields
• Used visual scan of file to determine

10
The Good, The Bad The Ugly

• Spreadsheet file for master X-Ref Table

11
The Good, The Bad The Ugly

• Data Review Fields for conversion

12
The Good, The Bad The Ugly

• Testing Plans assign responsibility

13
The Good, The Bad The Ugly

• Testing Plans Process checklist

14
The Good, The Bad The Ugly

• Benefits
• Visibility of Data eg FZ0901 File
• / -Old F0901 Rec - / /- -New F0901 Rec - /
• Run time to Process Conversion
• 2 3 Hours to Process entire system / all years
• Ease of Rebuild Re-Run of Test Runs

15
The Good, The Bad The Ugly
16
The Good, The Bad The Ugly

• Getting Keeping Users Involved
• Master Data Spreadsheet
• SQL Update
• Validating Catching ERRORS
• Project Plan
• Project Monitoring
• Custom Programs
• Functions now available in A9.1?
• Unk Unks (Unknown Unknowns)

17
The Good, The Bad The Ugly

18
The Good, The Bad The Ugly

• Testing, Testing, Testing
• Validation
• Layered
• Changes create new problems
• Re-Tests
• Users repeating tests
• Error Trapping
• Trap Re-Used Data Fields
• Keeping Users Involved Motivated

19
General Ledger Re-NumberingThe Good, The Bad
The Ugly Session 32810

• Q A
• Reid Ellis
• R. Reid Ellis, Jr., CPA, CCP, LLC
• ReidEllis_at_aol.com
• 301-526-6412