370 likes | 549 Views
Spreadsheet Journal. Finance Business Solutions. Shaleen Batra Finance Business Solutions – User Support & Training. Agenda. Overview Excel - Setup files Excel - Enter Data Import Journal Edit Journal Budget Check and Post. Journals Overview. Spreadsheet Journals. Excel
E N D
Spreadsheet Journal Finance Business Solutions Shaleen Batra Finance Business Solutions – User Support & Training
Agenda • Overview • Excel - Setup files • Excel - Enter Data • Import Journal • Edit Journal • Budget Check and Post
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
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
Launching templates DO NOT launch the template from Windows Explorer. Open Microsoft Excel and use File Menu to open
Setup template This is one time setup for your journal template
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
Setup template While creating or Approving Purchase Orders you would be able to see “S” instead of “Z”
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
Journal Sheet Journal Header Journal Lines
Journal Lines Information can be pasted in this grey area
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 forapproval. Approver will get error message at the time of approving the PO.
Journal in NSF Search Journal in NS Financials Attach Supporting documents Select Approver Save Journal Edit Journal Process Submit Journal Process
Journals with errors Contact your Management Accountant http://www.fin.unsw.edu.au/InformationCentre/WhoCanHelp.html#8
Deleting Journals Journals cannot be deleted once posted to the Ledger. Create another journal to correct the error
Who Can Help? For any Accounting Assistance contact your Management Accountant or Finance Manager
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