Skip to main content

Finance Staff

New to Finance?

 

Please visit the Finance Staff Portal and make yourself familiar with the information posted in the Finance Strategy & Principles and Working for Finance sections.

It is important to read the Finance 101 handbook to understand the services we provide to our customers.

If your role involves Financial Reporting please ensure you visit the Reporting page.  Please pay attention to the document names as there may be accompanying materials that are specific to Finance staff.  For example, there is a handbook called Project Financials, there is also a handbook called Project Financials - Finance support staff addendum, the first is outwardly facing for customers, the latter contains additional information specific to Finance Support Staff.

 

 


 

 

  • General Ledger

    Spreadsheet Journal Templates

    Checklist for the successful use of Spreadsheet Journals:

    • You are using the latest template (above)
    • You are following the setup instructions
    • All three of the journal template files are saved in the same directory
    • You are not launching the file (you are using File Open in Excel)
    • You are saving the file before loading
    • There are no blank lines in your journal
    • You are not receiving a "your password is about to expire" message.  If you are please change your password immediately.
  • Project Load

    Spreadsheet Project Load is used to load many projects into NS Financials at one time.

Operational Query Reports

 

DELETED QUERY REPLACED BY IN FOLDER
UNSW_PO_MATCH_NO_RECV_BLT UNSW_PO_MATCH_NO_RECEIPT OPERATIONS
UNSW_PO_MATCH_NO_RECV_BUS "  
UNSW_PO_MATCH_NO_RECV_COFA "  
UNSW_PO_MATCH_NO_RECV_DIVS "  
UNSW_PO_MATCH_NO_RECV_ENG "  
UNSW_PO_MATCH_NO_RECV_FASS "  
UNSW_PO_MATCH_NO_RECV_LAW "  
UNSW_PO_MATCH_NO_RECV_MED "  
UNSW_PO_MATCH_NO_RECV_SCI "  
UNSW_PO_MATCH_OTHER_BLT UNSW_PO_MATCH_OTHER OPERATIONS
UNSW_PO_MATCH_OTHER_BUS "  
UNSW_PO_MATCH_OTHER_COFA "  
UNSW_PO_MATCH_OTHER_DIV1 "  
UNSW_PO_MATCH_OTHER_DIV2 "  
UNSW_PO_MATCH_OTHER_DIVS "  
UNSW_PO_MATCH_OTHER_ENG "  
UNSW_PO_MATCH_OTHER_FASS "  
UNSW_PO_MATCH_OTHER_LAW "  
UNSW_PO_MATCH_OTHER_MED "  
UNSW_PO_MATCH_OTHER_SCI "  
UNSW_PO_NOT_D_C_X_BLT UNSW_PO_NOT_D_C_X OPERATIONS
UNSW_PO_NOT_D_C_X_BUS "  
UNSW_PO_NOT_D_C_X_BY_BU "  
UNSW_PO_NOT_D_C_X_BY_BUYER "  
UNSW_PO_NOT_D_C_X_COFA "  
UNSW_PO_NOT_D_C_X_DIVS "  
UNSW_PO_NOT_D_C_X_ENG "  
UNSW_PO_NOT_D_C_X_FASS "  
UNSW_PO_NOT_D_C_X_LAW "  
UNSW_PO_NOT_D_C_X_MED "  
UNSW_PO_NOT_D_C_X_SCI "  
UNSW_PO_OPEN_NO_ACTIVITY_BLT UNSW_PO_OPEN_NO_ACTIVITY OPERATIONS
UNSW_PO_OPEN_NO_ACTIVITY_BUS "  
UNSW_PO_OPEN_NO_ACTIVITY_COFA "  
UNSW_PO_OPEN_NO_ACTIVITY_DIVS "  
UNSW_PO_OPEN_NO_ACTIVITY_ENG "  
UNSW_PO_OPEN_NO_ACTIVITY_FASS "  
UNSW_PO_OPEN_NO_ACTIVITY_LAW "  
UNSW_PO_OPEN_NO_ACTIVITY_MED "  
UNSW_PO_OPEN_NO_ACTIVITY_SCI "  
UNSW_PO_RECV_NO_INVOICED_ARCHI UNSW_PO_RECEIVED_NOT_INVOICED OPERATIONS
UNSW_PO_RECV_NO_INVOICED_BLT "  
UNSW_PO_RECV_NO_INVOICED_BUS "  
UNSW_PO_RECV_NO_INVOICED_COFA "  
UNSW_PO_RECV_NO_INVOICED_DIVS "  
UNSW_PO_RECV_NO_INVOICED_ENG "  
UNSW_PO_RECV_NO_INVOICED_FACIL "  
UNSW_PO_RECV_NO_INVOICED_FASS "  
UNSW_PO_RECV_NO_INVOICED_LAW "  
UNSW_PO_RECV_NO_INVOICED_MED "  
UNSW_PO_RECV_NO_INVOICED_SCI "  
FUP_MATCH_EXCEPTIONS_BY_USER UNSW_AP_MATCH_EXCEPTIONS OPERATIONS
FST_CIRD_SUBMITTED UNSW_BI_CIRD_TO_ACTION OPERATIONS
FUP_PO_VCHR_PYMT UNSW_PO_AP_PAYMENT_DETAILS OPERATIONS
FUP_PO_OPEN_ENCUMB_ALL_BU UNSW_PO_OPEN_ENCUMBRANCES OPERATIONS
FUP_EX_PENDING_BU UNSW_EX_PENDING_STU_PAYMENTS OPERATIONS
SHIP_TO_LOCATIONS UNSW_PO_SHIP_TO_LOCATIONS OPERATIONS
FUP_AP_VCHR_ON_HOLD UNSW_AP_VCHR_ON_HOLD OPERATIONS
FUP_AP_CHEQUES_UNPRESENTED UNSW_AP_CHEQUES_UNPRESENTED OPERATIONS
FUP_EPROC_DAILY_CHECK_01 UNSW_EP_EPROC_DAILY_CHECK_01 OPERATIONS
FUP_EPROC_DAILY_CHECK_02 UNSW_EP_EPROC_DAILY_CHECK_02 OPERATIONS
F91_JAG_MANUAL_INTERVENTION UNSW_PO_JAGER_MANUAL_INTERVENT OPERATIONS
F91_JAGGAER_RECEIPT_RECONC UNSW_PO_JAGER_RECEIPT_RECONC OPERATIONS
F91_JAGGAER_REQ_RECONC_REVISED UNSW_PO_JAGER_RECON_REVISED OPERATIONS
F91_TVL_JRNL_ERR_KP UNSW_GL_TVL_JRNL_ERRORS OPERATIONS
F91_UNE_JRNL_ERR                         UNSW_GL_UNE_JRNL_ERRORS OPERATIONS
FUP_CC_7573_AND_PAYMENT UNSW_CC_7573_AND_PAYMENTS OPERATIONS
MY_DEPATMENT UNSW_DEPARTMENT_LISTING OPERATIONS
PO_NOT_DISPATCHED_CANC_COMP            UNSW_PO_NOT_DISP_CANC_COMP OPERATIONS
UNSW_PO_RECV_NO_INVOICED_AP UNSW_PO_RECEIVED_NOT_INVOICED OPERATIONS
VCHR_PYMNT_DETAILS_ALLUNITS_KP UNSW_AP_VCHR_PAYMENT_DETAILS OPERATIONS
FUP_EXPENSE_CLAIMS_DTL  UNSW_EX_EXPENSE_CLAIM_DETAILS OPERATIONS
MY_PO_LINE_STATS UNSW_PO_LINE_STATS OPERATIONS
AZ_PO_RECT UNSW_PO_RECEIPT_STATS OPERATIONS
MY_REQ_LINE_STATS UNSW_EP_REQUISITION_LINE_STATS OPERATIONS
BI_INV_CR_W_NOTES UNSW_BI_INV_CR_W_NOTES OPERATIONS