spreadsheet journal upload - university of new south wales · format q clear acrobat number format...

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

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

Excel – Main Page

Excel – One Off Setup

The Online Import Control section contains your log on User ID to access NS Financials. Use your z userid here.

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.

Excel - New Journal

Excel – Journal Entry

Excel – Journal Header

Excel – Journal Header

Excel – Journal Lines

Excel – Journal Lines

Excel – Journal Lines

Excel – Main Page

Excel – Import

Spreadsheet Journals

Thank you!