Xero procedures guide
Internal use only

This guide covers the key Xero tasks carried out by the operations manager on a daily, weekly and ad hoc basis. It is written for a colleague who is familiar with Xero fundamentals and is covering in the operations manager's absence.

Where relevant, links to Xero's help documentation are included alongside each process.

Every morning
Reconciliation
Bank reconciliation across the main account, Amex and Visa cards
Every Monday
Invoice review
Review draft advisory invoices with Kerryn and send approved ones
Every Friday
Bill payments
Process batch payment in Xero and upload to NAB Connect
New to covering this role? Start with the daily reconciliation section — it is the most frequent task and also sets up the planned payment dates used every Friday.

Open Xero and navigate to the home screen. Work through both invoices and bills transactions as follows.

1.1 Green transactions (matched) — invoices and purchases (bills)

A green transaction has been automatically matched to an existing invoice or bill in the system.

  • For invoicing, before clicking OK, check whether the invoice shows a job number (for example, R26-234 or A26-288). If it does, write it down.
  • Confirm the match looks correct and click OK.
  • Go to Bills awaiting payment and type the last three digits of the job number into the search bar.
  • If a matching bill appears, set the planned payment date to the coming Friday. These are payments for the consultants who have completed all or part of a job.
Note: all bills with a planned payment date are paid every Friday. Update the planned payment date daily so everything due is captured for the coming Friday's payment run.
Xero help: reconcile your bank account
1.2 Transactions not matched — mainly for purchases/bills (not green)

If a transaction is not green, no automatic match has been found. Follow the steps below.

  • Go to Draft bills and look for a bill that matches the transaction.
  • Also look in Files under the Directors Australia name in case Kerryn has added some there — just add to the bill and follow the steps.
Xero DA menu showing Files option

The Files option is found by clicking the DA logo in Xero.

  • If a matching draft bill exists, complete all missing details and click Approve. Once approved, the transaction will turn green and can be reconciled.
  • If there is no matching draft bill, follow the relevant process below depending on whether the transaction is an Amex or Visa transaction.
Xero help: enter and approve bills
1.3 Amex transactions with no matching bill

Check the card number on the transaction to identify the cardholder.

Card (last 4 digits)Cardholder
1005Kerryn
1039Vanessa
1047Brad
1054Sheree
1062Geraldine
  • If you have the receipt or invoice, import it into Xero, complete the bill information and click Approve. It will then turn green for reconciliation.
  • If you do not have the receipt or invoice, contact the relevant cardholder and request one before proceeding.
  • Then approve the bills as per above.
Xero help: import receipts and bills
1.4 Visa transactions

The Visa is a general company card not assigned to an individual. Also check the Visa account each morning for any transactions that need reconciling and follow the same process as for Amex transactions above.

Each Monday morning, review draft advisory invoices with Kerryn to determine which are ready to go out. Note: this review covers advisory (A-prefix) invoices only.

  • Go to Draft invoices and type A-2 in the search bar to filter to advisory invoices only.
  • Go through each draft invoice with Kerryn to confirm the amounts and whether they are ready to send.
2.1 If the invoice is ready to send
  • Ensure you remove the 'DRAFT' wording in the reference before sending. Also make sure the invoice date is today, then click Approve and email.
Invoice approve and email screen in Xero

Remove 'DRAFT' from the reference field, set today's date, then click Approve and email.

  • If there is no contact listed on the invoice when you click Approve and email, ask the lead consultant on the job who it should be sent to.
  • Copy yourself on the email (there is a checkbox when sending in Xero).
  • Once you receive it in your inbox, save it to the relevant job folder within the A_Contracts sub-folder in the Advisory (A) library in SharePoint.
Xero help: send invoices
2.2 If the draft invoice is not ready to send

Update the draft invoice date by pushing it forward a couple of weeks so it appears further up the list.

Each Friday, process payment for all bills that have a planned payment date set to that Friday. This process has three parts.

1
Xero batch
2
Remittance
3
NAB Connect
3.1 Process the batch payment in Xero
  • Go to Bills awaiting payment and filter by the planned payment date for today (Friday).
  • Select all relevant bills by ticking the checkboxes on the left of each bill.
  • Click Make payment and select Directors Australia main account (Cheque Account 8745).
Make payment screen in Xero

Click Make payment and select the Directors Australia main account.

  • Payment date: set to today's date.
  • Payment reference: enter the date followed by 'bills' — for example 100426bills.
  • Each payment line must have a payee reference and correct BSB and account details. If a line is incomplete and cannot be resolved, use the three-dots menu on the right to remove it from the batch.
Payment lines detail in Xero

Check each line has a payee reference and correct bank details before proceeding.

  • Click Continue to payment summary, then Export batch file. This saves an .aba file to your computer.
Export batch file button highlighted

Click Export batch file to save the .aba file to your computer.

Xero help: batch payments
3.2 Send remittance advice

Click Send remittance to send remittance advice to each payee, noting:

  • if there is no email address on file, try to locate one — if you cannot find it, leave it;
  • if Xero warns there is no placeholder for a contact, continue sending anyway; and
  • no need to copy yourself on remittance emails.
3.3 Upload to NAB Connect

Kerryn is responsible for uploading the payment file and authorising the payment in NAB Connect.

  • Log in to NAB Connect.
  • Click Payments in the top menu, then select Direct credit.
NAB Connect Payments menu showing Direct Credit option

In NAB Connect, click Payments then select Direct credit.

  • Click Upload file, locate the .aba file on your computer and select it.
  • In the Reference field, enter the date followed by 'bills' — for example 100426bills.
NAB Connect upload a payment file screen

Set Payment type to Direct Credit, choose the .aba file and enter the reference.

  • Kerryn will click View payment to check the details and then authorise the payment herself.
Important: if anyone other than Kerryn is processing payments, any payment over $3,000 must be authorised by Kerryn. In this case, notify Kerryn that bills are awaiting authorisation in NAB Connect and she will log in and authorise them herself.