Finance Systems Training
This presentation is the property of its rightful owner.
Sponsored Links
1 / 94

Finance Systems Training PowerPoint PPT Presentation


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

Finance Systems Training. Billing Fundamentals Rohin Whitford Training & User Support / Finance. Agenda. AR Overview NSF Overview NSF Menu walkthrough Bill Headers Bill Lines GST calculation Accounting Distribution Creating a single line bill Finalising your bill GST Rounding issues

Download Presentation

Finance Systems Training

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Finance systems training

Finance Systems Training

Billing Fundamentals

Rohin Whitford

Training & User Support / Finance


Agenda

Agenda

  • AR Overview

  • NSF Overview

  • NSF Menu walkthrough

  • Bill Headers

  • Bill Lines

  • GST calculation

  • Accounting Distribution

  • Creating a single line bill

  • Finalising your bill

  • GST Rounding issues

  • Copy Bill

  • Credit Adjustments

  • FX Invoices & hedging

  • Correcting bill errors

  • Checking payments

  • Customer Statements

  • AR help & forms


Accounts receivable

Accounts Receivable


Accounts receivable1

Accounts Receivable

  • UNSW Payment Terms – 30 Days

  • Debtor Management

    • Monthly account statements

    • Chase overdue accounts

    • Agency referral

    • Business Unit Support

    • Aged Debt Analysis & Reporting

  • Controlled Entity Invoices

  • Credit Adjustments

  • Create & Update Customer Accounts


Finance systems training

NS Financials

eProcurement

Asset

Management

Procurement

Card

Purchasing

Billing

General Ledger

Expenses

Accounts

Payable

Accounts

Receivable


Customer accounts

Customer Accounts

To Create – Customer Requests

Request new customer accounts

To View - Customers

View and Requests updates to existing customer accounts


Customer accounts1

Customer Accounts


Customer accounts2

Customer Accounts


Finance systems training

Accessing Billing

Create and Maintain Bills

Create & Copy

Generate Invoices

Reprint & Reports

Locate Bills

Search for Bills

Review Billing Information

Review bill summaries, billing detail (incl. single reprint), pending items, accounting entries.


Finance systems training

Maintain Bills

  • Create / Update Bills

  • Copy Bills


Finance systems training

Generate Invoices

  • Reports

  • Reprint invoices


Finance systems training

Locate Bills

  • Search for bills that match a selected criteria.


Finance systems training

Review Billing Information

  • Review bill summaries, billing detail (reprint single invoice), pending items or accounting entries.

/


Billing process

Billing Process

  • Identify your Business Unit

  • Identify the Customer

  • Confirm customer address

  • Quote PO or Contract number(s) (optional)

  • Add a header note (optional)

  • Add line(s)

  • Enter Accounting Distribution

  • Calculate Taxes

  • Add a line note (optional)


Finance systems training

Exercise 1

The University Gymnasium is raising a bill to Tiny Tots Tennis for Tennis Court usage for the month of February (we are attaching a schedule for them to refer to with regard to dates and times they can use the court and make a comment in the line referring to the attachment).

Tennis court usage is for 8 hours of court usage @ $30 per hour (which is GSTable).

The revenue is to go to Fund code OP001 and department CEIC (there is no project id used in this exercise).


Finance systems training

Billing Fundamentals

Adding a new bill


Finance systems training

Billing Fundamentals


Finance systems training

Billing Fundamentals

When adding leave this as NEXT and the next sequential number will be assigned to the bill


Finance systems training

Billing Fundamentals

Most Faculties / Organisations have their own Bill Type Identifiers – the most commonly used is MSC


Finance systems training

Billing Fundamentals

Not all business units have bill sources.


Finance systems training

Billing Fundamentals

Search for and select the customer

“Tiny Tots Tennis”


Finance systems training

Bill Header & Lines


Finance systems training

Bill Header


Finance systems training

Entering Bills

Page Series


Finance systems training

  • Bill Header

  • Address Info (check)

  • Header Misc Info (optional)

  • Header Note (optional)

  • Header Info 2 (optional)

  • Line Info 1

  • Acctg Rev Dist

  • Line VAT Info

  • Line Note (optional)

  • Check your GST

  • Finalise your bill

Page Series Entry


Finance systems training

Address Information


Finance systems training

Header Misc Info

The use of this page is optional


Finance systems training

Header Note

The use of this page is optional


Finance systems training

Header – Info 2

The use of this page is optional


Finance systems training

Line – Info 1


Finance systems training

Acctg – Rev Distribution


Finance systems training

VAT Page


Finance systems training

Line – VAT Info


Finance systems training

GST Codes


Finance systems training

GST Codes


Finance systems training

Line - Note

The use of this page is optional (enter the note referring to the attachment)


Finance systems training

Finished!


Finance systems training

Calculate Taxes


Finance systems training

Calculate Taxes


Finance systems training

Calculate Taxes


Finance systems training

Calculate Taxes


Finance systems training

Calculate Taxes


Finance systems training

Informational Message

When saving you’ll receive an informational message asking you to check your GST.

Say yes to cancel saving and check your GST

Say no to continue Saving.


Finance systems training

Finalising your Bill


Finance systems training

Bill Status’


Finance systems training

Ready to Bill


Finance systems training

Print


Finance systems training

Print

NOTE: Your invoice will not show on the General Ledger until the following day – budget check occurs during overnight process


Finance systems training

Invoice

Header Note

Line Note


Finance systems training

Remittance Advice


Finance systems training

Over night Process - Collecting your Invoice

UPK

  • Ensure the invoice status is RDY.

  • Wait until the next morning and check your report manager.

  • Open the pdf and extract your invoice.

  • If you do not see your invoice in the report manager check for billing errors.

  • If you don't want your bill to be processed change the status of the bill to Hold 'HLD'.

//


Finance systems training

Navigation Menu


Finance systems training

Navigation Menu


Finance systems training

GST Rounding


Finance systems training

GST Rounding


Finance systems training

GST Rounding


Finance systems training

GST Rounding


Finance systems training

Supporting Documentation


Finance systems training

Supporting Documentation


Finance systems training

Cancelling / Copying

Cancelling Bills

You can cancel a bill before it is invoiced – after it is invoiced it will need to be credited.

Credit Adjustment request form available on Finance Website at AR page –

http://www.fin.unsw.edu.au/OurServices/FinancialOperations_Billing_Forms.html

Copying Bills

You can copy other bills to use as a “template” for the bill you are creating.


Finance systems training

Copy Invoice


Finance systems training

Copy Invoice


Finance systems training

Copy Invoice

  • Are the revenue chartfields valid?

  • The revenue chartfields used on a prior invoice may not be a valid combination for the current budget period. Check to ensure your chart fields are valid.

  • Confirm tax

  • If you copy an invoice and change the customer or location details this may effect the VAT on your invoice.

  • Confirm currency

  • FX Invoice?

  • If copying an invoice issued in USD, GBP, EUR, SGD or CAD - confirm the correct account is showing at header info 1


Finance systems training

Exercise 2

  • Exercise 2 – Create a multiple line invoice

  • Access the invoice you have created for Tiny Tot’s Tennis :

  • Add another line to the invoice for March Tennis Court Hire – 10 hours @ $30/hour.

  • Add a third line with an administrative fee of $20.00 (which is GST free)

  • Use the chartfield combination of Fund OP001 and Dept CEIC (we are not using a project id in this exercise).

  • Check your tax calculation and recalculate the taxes.

  • Finalise your bill.

//


Finance systems training

FX Invoices


Finance systems training

FX Invoices


Finance systems training

FX Invoices – Bank Account


Finance systems training

FX Invoices


Finance systems training

Remittance Advice


Finance systems training

FX Invoices – Hedge

In order to manage foreign exchange risks effectively, UNSW requires that revenue in foreign currency, which is greater than Australian Dollar equivalent of $50K, should be hedged with Treasury.

The application form is available upon request by emailing Deputy Treasurer Gavin Wallace - [email protected]

Hedging should be done prior to raising GRP invoices in FX.


Finance systems training

Reprint Invoice

  • Single Invoice Reprint

Main Menu > Billing > Review Billing Information > Details

  • Reprint Invoices

Billing > Generate Invoices > Non-Consolidated > Reprint Invoices


Finance systems training

Reprint Invoice


Finance systems training

Exercise 3

Reprinting an Invoice

Reprint invoice SCTEC GRP0143726

  • Reprinting Invoices:

  • Access the invoice you want to print from the Review Billing Information menu (Details sub menu).

  • Press the Printer icon

  • Wait for your invoice to open in PDF format (be patient, it could take a minute or two).


Finance systems training

Billing Workflows

Bills On Hold Workflow

If you place a bill on hold you will receive a periodic workflow e-mail asking if you intend to invoice this bill. You are not encouraged to leave bills on hold for a lengthy period of time.

Billing Errors Workflow *

If the process to pick up your bill and create an invoice fails you will receive a workflow e-mail. You will need to take action in order for your invoice to be generated.


Finance systems training

Billing Errors

If you invoice has not successfully generated or if you have printed your invoice and it is not showing in the GL the following day


Finance systems training

Billing Errors

Example of the settings of a bill that has passed all criteria to become an invoice


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.

*


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.


Finance systems training

Billing Errors

Pre-Load Status – Not Done

Correct the Chartfield Combination Errors.

Budget Check Status – Not Valid

Correct the Budget Checking errors.

VAT Defaults Applied - Not Ticked

IF not ticked correct the VAT defaults on the bill and set the Bill Status to RDY

Invoice Printed - Not Ticked

Check the invoice layout connected to the bill.

Currency Converted - Not Ticked

Check the currency of the bill and exchange rate.

GL Entries Created – Not Ticked

See Pre-Load Status.

AR Pending Item Created – Not Ticked

See Budget Check Status.

/


Checking if your invoice has been paid

Checking if your invoice has been paid


Finance systems training

Checking Payment

/


Finance systems training

Customer Statements


Finance systems training

Customer Statements


Finance systems training

Customer Statements


Finance systems training

Customer Statements


Finance systems training

Reporting

  • Billing Reports

  • Billing / Generate Invoices / Reports

  • Query

  • FUP_AR_PAYMENT_ITEM

  • FUP_PROJECT_COMBINATION

  • FUP_BILLING_PROJECT

  • FUP_BI%


Finance systems training

Finding your AR Contact

//


Finance systems training

Other Training and Materials

  • Finance Web Site

    • Check the Training Section of the Finance Web site www.fin.unsw.edu.au

  • Online Training – UPK

    • Is available under Training on the Finance web site.


Finance systems training

THANK YOU!

Please complete a course evaluation form,

your feedback is important.


  • Login