Spreadsheet: mary_fischer__25808__EA account conversion for Bentlty
Sheet: Sheet1

Account conversion
Base Account |  | SAP Account # | SAP A/C Description | New SAP A/C | New SAP A/C Description | Hyperion Line Item | Comments
 | [NAME]
1110 | Accounts Receivable | 20016000 | A/R 3rd party DP
1135 | Intercompany EES | 20029200 | A/R Non Trade 3rd Party | 20025000 | A/R Non Trade I/C | 0051
1150 | Allowance for Doubtful Accounts | 20017000 | Allowance for Doubtful Accounts |  |  | 0065
1210 | WIP - Unbilled Revenue | 26152000 | CWIP PP&E | 30502000 | Billings in Excess Current | 0655 | Revenues earned in Prior Month not yet billed. Can be over or under billed.  This is a net number.  This mapping is consistent with other EFS groups.
1270 | WIP- Permit Deposits |  | CWIP PP&E | 30502000 | Billings in Excess Current | 0655 | Account is currently not used.
1320 | Prepaid Expenses | 26152000 | CWIP PP&E | 23071500 | Prepayments Other | 0175
1800 | OH Accumulations- Payroll Taxes |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
1810 | OH Accumulations- Employee Benefits |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
1820 | OH Accumulations- Accrd Vacation |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
1830 | OH Accumulations- Holiday Pay | 25149100 | Other Deferred Debits |  |  | 0360
1835 | OH Accumulations- Sick Pay | 25149100 | Other Deferred Debits |  |  | 0360
1840 | OH Accumulations- Other Empl Benefits |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
1860 | OH Accumulations- General Liability |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
1885 | OH Accumulations- PTO & Holiday Burden | 25149100 | Other Deferred Debits |  |  | 0360
1890 | OH Accumulations - Allocated Burden | 25149100 | Other Deferred Debits |  |  | 0360
1920 | Job Cost Transfer Clearing |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
2020 | Accounts Payable-Specl Accrls |  |  | 25149100 | Other Deferred Debits | 0360 | Acct currently not used.  Mapped in case used
2040 | Contract Employees | 30700000 | Other Current Liabilities | 30016000 | A/P Trade 3rd Party DP | 0515
2110 | Accounts Payable | 30700000 | Other Current Liabilities | 30016000 | A/P Trade 3rd Party DP | 0515
2120 | Accrued Vacation | 30403000 | Benefit Plan Liabilities - Corp | 30404000 | Misc Payroll Liabilities | 0620
2310 | Payroll Clearing | 30050000 | FIT Current Liability | 30406000 | Net Pay Clearing | 0624
2810 | General Obligations Contingency |  |  | 33605000 | Other  Deferred Credits | 0860 | Old [NAME] - not uploaded into the Flex File.  Needs to be resolved.  [NAME] peak advised [NAME] B that these were old.   $297K at 6/30
3500 | [NAME] |  |  | 33605000 | Other  Deferred Credits | 0860 | Old [NAME] - not uploaded into the Flex File.  Needs to be resolved.  [NAME] peak advised [NAME] B that these were old. $976K.  [NAME] was told it was R/E
3800 | Unmapped Transactions | 33605000 | Other  Deferred Credits | 33605000 | Other  Deferred Credits | 0860 | $475.00 6/30
3900 | Suspense |  |  | 33605000 | Other  Deferred Credits | 0860 | $1,400 in this account
4110 | Revenue - Service Billings | 44200000 | Service Revenues Other 3rd Parties |  |  | 1070
5110 | Direct Labor | 51009000 | C of GS Other |  |  | 1150
5130 | Direct Labor- Allocated Burden | 51009000 | C of GS Other |  |  | 1150
5300 | Subcontract Costs / Contract Labor | 51009000 | C of GS Other |  |  | 1150
5410 | DPE- Project Expenses | 51009000 | C of GS Other |  |  | 1150
5420 | DPE- Travel & Transportation | 51009000 | C of GS Other |  |  | 1150
5430 | DPE- Meals & Entertainment | 51009000 | C of GS Other | 52003500 | Employee Client Meals & Entertainment | 1325 | This is strictly for client meals.  Any grp meals is charged to IPE M&E
5510 | Development Labor | 52000500 | Salaries and Wages |  |  | 1325
5530 | Development Labor- Allocated Burden | 52001000 | Employee Pension & Benefits |  |  | 1325
5710 | IPE- General Expenses | 52004500 | Employee Travel and Lodging |  |  | 1325
5720 | IPE- Travel & Transportation | 52004500 | Employee Travel and Lodging |  |  | 1325
5730 | IPE- Meals & Entertainment | 52003500 | Employee Client Meals & Entertainment | 52003000 | Employee Group Meals & Entertainment | 1325
5750 |  | 52501000 | Bad Debt Expense |  |  | 1325
5810 | Indirect Labor | 52000500 | Salaries and Wages |  |  | 1325
5830 | Indirect Labor Burden | 52001000 | Employee Pension & Benefits |  |  | 1325
6010 | NPE- General Travel/Lodging | 52004500 | Employee Travel and Lodging |  |  | 1325
6020 | NPE- Meals & Entertainment | 52003500 | Employee Client Meals & Entertainment |  |  | 1325
6030 | NPE- Automobile/Mlg/Gs Expenses | 52002500 | Employee Expense Other |  |  | 1325
6050 | Education/Training | 52004500 | Employee Travel and Lodging | 52002000 | Employee Course Registration and Fees | 1325
6055 | Placement Fees | 52507500 | O/S Svcs Non Professional Other |  |  | 1325
6060 | Dues & Subscriptions | 52004000 | Employee Professional Memberships & Dues |  |  | 1325
6080 | Cellr Phn Paging & Other Comm | 52503500 | Communications Expense |  |  | 1325
6100 | Salaries & Wages | 52000500 | Salaries and Wages |  |  | 1325
6105 | Allc Taxes In & Other Empl Benefits | 52001000 | Employee Pension & Benefits |  |  | 1325
6210 | Office Supplies (Educ/Training/Seminars) | 53600000 | Supplies and Expenses |  |  | 1325
6220 | Shipping (Dues and Subscriptions) | 52508100 | Postage and Freight Expense |  |  | 1325
6230 | Advertising (Temporary Labor) |  |  | 52507500 | O/S Svcs Non Professional Other | 1325
6240 | Reproduction (Advertising) | 52500500 | Advertising Expense |  |  | 1325
6310 | Rental- Equipment | 53800000 | Rent Expense Personal Property |  |  | 1325
6330 | Rent | 53801000 | Rent Expense Real Property |  |  | 1325
6410 | Repairs and Maintenance | 54005000 | General Business & Advertising Expense |  |  | 1325
6420 | Computer Expenses | 52504500 | Computer Expense |  |  | 1325
6430 |  | 52002500 | Computer Expense |  |  | 1325
6470 | Licenses and Registration | 52505500 | Fees and Permits |  |  | 1325
6480 | Permits & Fees | 52505500 | Fees and Permits |  |  | 1325
6490 | Professional Fees | 52004000 | Employee Professional Memberships & Dues |  |  | 1325
6520 | Contributions | 56000000 | Contribution in Aid of Construction | 52504100 | Charitable Contributions | 1325
6530 | Telephone |  |  | 52503500 | Communications Expense | 1325
6570 | Bad Debt | 52501000 | Bad Debt Expense |  |  | 1325
6580 | Late Fees | 54005000 | General Business & Advertising Expense |  |  | 1325
6890 | Misc Income |  |  | 69000000 | Other Income 3rd Party | 1775
New Accounts to set up
 | [NAME] |  |  | 69005000 | Other Deductions | 1775
 | FIT Deferred Current Liab |  |  | 30053000 | FIT Deferred Current Liab | 0565
 | SIT Deferred Current Liab |  |  | 30054000 | SIT Deferred Current Liab | 0566
 | Accrued Sales Tax |  |  | 30100000 | Accrued Sales Taxes | 0560
 | FIT Non Current Liab |  |  | 32000000 | Deferred FIT [NAME] | 0780
 | SIT Current Liab |  |  | 30051000 | SIT Current Liability | 0540
 | SIT Non Current Liab |  |  | 32001000 | Deferred SIT [NAME] | 0785
 | ER FICA Expense |  |  | 59003000 | Pyaroll Tax FICA Expense | 1445
 | ER Futa Expense |  |  | 59003100 | Payroll Tax Futa Utility Expense | 1445
 | ER Suta Expense |  |  | 59003200 | Payroll Tax Suta Utility Expense | 1445
 | Bentley Employee Benefit Plan Liabilities |  |  | 30403000 | Benefit Plan Liability Accounts - Corp
 | EFS Benefits ER 401(k) Match |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630 | Need the EFS Account number from current chart of accounts
 | EFS Benefits EE 401(k) Contrib - Pre Tax |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630 | This is in response Benefits needing accounts to reconcile
 | EFS Benefits EE 401(k) Contrib - Post Tax |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630
 | EFS Benefits Pension Liability |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630
 | EFS Benefits Health Care |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630
 | EFS Benefits - Other |  |  | 30403300 | Benefit Plan Liability Accounts - EFS | 0630
 | P/R Taxes EE FIT |  |  | 30103000 | P/R Taxes EE FIT | 0560
 | P/R Taxes EE FICA |  |  | 30103100 | P/R Taxes EE FICA | 0560
 | P/R Taxes EE Medicare |  |  | 30103200 | P/R Taxes EE Medicare | 0560
 | P/R Taxes EE SIT |  |  | 30103300 | P/R Taxes EE SIT | 0560
 | P/R Taxes EE Local |  |  | 30103400 | P/R Taxes EE Local | 0560
 | Garnishments |  |  | 30404000 | Misc P/R Liabilities | 0620
 | P/R Taxes ER FICA |  |  | 30104000 | P/R Taxes ER FIT | 0560
 | P/R Taxes ER Medicare |  |  | 30104100 | P/R Taxes ER FICA | 0560
 | P/R Taxes ER FUTA |  |  | 30104200 | P/R Taxes ER FUTA | 0560
 | P/R Taxes ER SUTA |  |  | 30104300 | P/R Taxes ER SUTA | 0560
 | P/R Taxes ER Local |  |  | 30104400 | P/R Taxes ER Local | 0560
 | Intercompany Interest Expense |  |  | 70090100 | Interest Expense Intercompany | 1751 | Needs TP with 926
 | FIT Expense Non Utility Current |  |  | 75001000 | FIT Expense Non Utility Current | 1795
 | SIT Expense Non Utility Current |  |  | 75002000 | SIT Expense Non Utility Current | 1800
 | Def FIT Expense Non Utility Current |  |  | 76001000 | Def FIT Expense Non Utility Current | 1840
 | Def SIT Expense Non Utility Current |  |  | 76002000 | Def SIT Expense Non Utility Current | 1845
 | Def FIT Expense Non Utility Non Current |  |  | 77001000 | Def FIT Expense Non Utility Non Current | 1825
 | Def SIT Expense Non Utility Non Current |  |  | 77002000 | Def SIT Expense Non Utility Non Current | 1830