1 / 15

Spreadsheet Journal Upload

Spreadsheet Journal Upload. 2 Sides to Journals. Excel 3 Excel Files Setup Enter data into Spreadsheet Import Journal NS Financials Edit Journal Budget Check Journal Post Journal. Excel – Security Warning.

baruch
Download Presentation

Spreadsheet Journal Upload

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. Spreadsheet Journal Upload

  2. 2 Sides to Journals • Excel • 3 Excel Files • Setup • Enter data into Spreadsheet • Import Journal • NS Financials • Edit Journal • Budget Check Journal • Post Journal

  3. Excel – Security Warning By selecting to enable digitally signed macros as a permanent setting this will remove the automated Security Warning message, eliminating any manual intervention.

  4. Excel – Main Page

  5. Excel – One Off Setup The Header Defaults section contains your system profile User ID in NS Financials. This may differ from your log on User ID in the Import Control section. (i.e. z-userid) This must be entered here using a upper case S or Z userid – this depends which is applicable to you. To verify which is correct this can be checked on the process monitor. The Online Import Control section contains your log on User ID to access NS Financials. Use your z userid here.

  6. Excel - New Journal

  7. Excel – Journal Entry

  8. Excel – Journal Header

  9. Excel – Journal Header

  10. Excel – Journal Lines

  11. Excel – Journal Lines

  12. Excel – Journal Lines

  13. Excel – Main Page

  14. Excel – Import

  15. Spreadsheet Journals Thank you!

More Related