1 / 37

Spreadsheet Journal

Enhance your financial business operations with our comprehensive Excel-based solutions. Learn to manage journals, budgets, and more with user-friendly training and support resources.

kisrael
Download Presentation

Spreadsheet Journal

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 Finance Business Solutions Finance Business Solutions – User Support & Training

  2. Agenda • Overview • Excel - Setup files • Excel - Enter Data • Import Journal • Edit Journal • Budget Check and Post

  3. Journals Overview

  4. Spreadsheet Journals • Excel • Download Excel files • Setup • Enter data into Spreadsheet • Import Journal • NS Financials • Search the Journal • Attach documents • Select approver • Edit Journal Process • Submit Journal Process

  5. Download Excel Templates Add Attachments Excel NS Financials Select Approver and Save Setup Excel Overview Enter Journal Lines and upload to NS Financials Edit Journal Process Submit Journal Process

  6. Download templates

  7. Extract templates

  8. Extract templates

  9. Launching templates DO NOT launch the template from Windows Explorer. Open Microsoft Excel and use File Menu to open

  10. Launching templates

  11. Setup template This is one time setup for your journal template

  12. Setup template This is the actual identity. In some cases this one may be “S” This is the user id that is used for logging in NS Financials

  13. Setup template While creating or Approving Purchase Orders you would be able to see “S” instead of “Z”

  14. Template 2 New: Create a new Spreadsheet Journal Edit: Edit your previously saved journal sheets 3 6 2 Copy: Copy previous Journal 5 1 7 3 4 5 1 Notes: Let you add notes to your sheet. This will not get imported into NS Financials 4 Delete: Delete journal sheets (this won’t delete journal from NS Financials once imported) 6 Import: Import Journals into NS Financials(You can create several sheets and import them all at once) 7 Write File: Allows you to create a .txt file from your journal sheet

  15. Create a new Journal

  16. Journal Sheet Journal Header Journal Lines

  17. Journal Header

  18. Journal Lines

  19. Journal Lines Information can be pasted in this grey area

  20. Import Journal

  21. Import Journal If there are blank lines in the spreadsheet with accounts only, it will be imported to NS Financials. You will be able to submit it for approval. Approver will get error message at the time of approving the PO.

  22. Journal in NSF Search Journal in NS Financials Attach Supporting documents Select Approver Save Journal Edit Journal Process Submit Journal Process

  23. Search Journal in NSF

  24. Search Journal in NSF

  25. Journal in NSF

  26. Select Approver and Save the Journal Save

  27. Edit Journal Process

  28. Submit Journal Process

  29. Journals with errors

  30. Journals with errors Contact your Management Accountant http://www.fin.unsw.edu.au/InformationCentre/WhoCanHelp.html#8

  31. Copy Journal Sheet

  32. Copy Journal Sheet

  33. Deleting Journals Journals cannot be deleted once posted to the Ledger. Create another journal to correct the error

  34. Who Can Help? For any Accounting Assistance contact your Management Accountant or Finance Manager

  35. User Support & Training • Finance Website – Training • https://www.fin.unsw.edu.au/NSF_KnowledgeBase/FKB_Training.html • Training Enquiries • Ext. 53550 / 57665, Email fti@unsw.edu.au

  36. Questions

More Related