1 / 19

Importing Into MUNIS

Importing Into MUNIS. KASBO Conference May 2014. Presented by: Erin Harlow Kenton County School District Supervisor of Accounting erin.harlow@kenton.kyschools.us. Select Account in GL Inquiry. After finding your accounts, be sure to select Browse first

ludwig
Download Presentation

Importing Into MUNIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related