Importing Into MUNIS

1. Importing Into MUNIS KASBO Conference May 2014 Presented by: Erin Harlow Kenton County School District Supervisor of Accounting erin.harlow@kenton.kyschools.us

2. Select Account in GL Inquiry • After finding your accounts, be sure to select Browse first • Select the Excel button to export

3. Create your amendment • Calculate the change in your budget

4. Create your amendment . . . • Sort spreadsheet by Change in Amendment • Delete accounts that do not require a change

5. Create your amendment . . . • Add your Debit and Credit Column – see column J • Multiply your Credits by -100 (negatives are not allowed) and Debits by +100 to create column K C= Neg Change D=Pos Change Column F-Column E

6. Create your amendment . . . • Select entire spreadsheet • Change Format to Text • Save As – Use the Excel Worksheet and file name 3480amend Select All

7. Copy to Budget Template

8. Copy to Budget Template Copy account codes-You can’t select the column header, you have to select each cell Copy D/C column Copy amount – VERY IMPORTANT – after you select your amounts in file 3480amend, when you switch to the Budget Template file, you must RIGHT CLICK and select Paste Values instead of All so only the numbers are copies and not #REF# because of the formula

9. Copy to Budget Template Cont.. Modify columns E, F, and G in row 1 and copy down to all rows in the spreadsheet. Column E is the individual line desciption, F and G are reference fields from the budget header screen. Copy column K, the “B”, down to the last row in the amendment

10. Save file to Import • Save as Formatted Text

11. Save file to Import . . . • Select YES

12. Save file to Import . . . • Close Excel • Select NO

13. Import Into MUNIS • Go into Import Journals • Define: • Import Source should be Budget Import File • Import File – find your .prn file • Budget amendment type – should be 1 for only expenditure amendments • and type 3 for amendments with both revenue and expenditures

14. Importing Budget Amendments

15. Import Into MUNIS

16. Import Into MUNIS . . . • Select the Pre-Edit button • No Errors were Found should appear – select OK • Select Import • Print or Spool your amendment report • Exit the Import JE menu and go to the Budget Transfers & Amendments Menu • Select Browse all your own journals and select your journal to post • Adjustments can be made if you forgot an account

17. Import Into MUNIS . . . • If errors were found, a print option would appear for you to print the errors • Errors that I have encounter while learning this process • Forgot to copy the column K, the “B” down to all rows • Forgot to change my credits to positive numbers