Skip to content

NetSuite

Part of the Finance Systems & Processes Knowledge Base.

Key Duties & Backup Personnel

Task Backup
Add Employee Grace
Payment File Failure AP

Bank Feeds

Setting up a bank feed in NetSuite.

Bank / Provider Signature required Send to
SISS Data Services Yes — Nick SISS directly
ANZ No Caren Cassidy (ANZ Account Manager)

SISS Data Services — data form

  1. Create the SISS data form in NetSuite.
  2. Obtain Nick's signature on the form. Signature is mandatory.
  3. Send the signed form directly to SISS Data Services.

ANZ — form

  1. Create the ANZ form in NetSuite.
  2. No signature required.
  3. Send the form to Caren Cassidy, ANZ Account Manager.
Adding the bank feed into NetSuite

TBC — step-by-step process to be added.

Accounting Items vs GL Accounts

  • NetSuite customer invoices (intercompany and external) are driven by items as line entries — you cannot post an invoice line directly to a COA GL account.
  • NetSuite holds a separate list of Accounting Items that map through to GL accounts (Lists > Accounting > Items).
  • Historically, a new GL account needed a matching Accounting Item created manually — if missed, the account couldn't be invoiced against.

Current state

An automation now runs weekly (weekend) and creates the corresponding Accounting Item entries for new GL accounts automatically.

Vendor to Subsidiary Relationships

By default in NetSuite OneWorld, each vendor is assigned to only one subsidiary. The ProSpend integration requires the vendor to be available across the relevant subsidiaries — missing this caused a recurring class of integration errors.

Current state — automation in place

Field Value
Script name 1GPG MR Vendor Sub Relation Scheduled
Script ID CUSTOMSCRIPT4565
Frequency Daily, overnight — 2:00 am
Subsidiary scope All active subsidiaries
Vendor scope All active vendors

How to Add an Employee

Linked to the "Add Employee" duty above (backup: Grace).

  1. Go to Lists > Employees > Employees > New
  2. On the Human Resources tab, fill in Name and Location / Subsidiary
  3. Go to Bank Payment Details — tick EFT, Add New Bank Details (BSB + account number)

Expected behaviour

The bank account record duplicates into 3 records after entering bank details. This is normal, not an error — do not delete the extras. There are 3 payment file formats, and an automation creates one bank detail record per format.

TPAR — Annual Reporting

Process

TBC — step-by-step process to extract TPAR data from NetSuite to be detailed and added here.

Related pages: