Guides

ABN checks in Google Sheets, step by step.

Free methods first, then how ABN Formula speeds them up. Written for Australian bookkeepers, accounts payable teams and small business owners.

• How to validate ABNs in Google Sheets

  A quick way to catch typos in a column of Australian Business Numbers, then confirm the real ones against the Australian Business Register.

• Bulk ABN lookup in a spreadsheet

  Your options for checking a whole column of ABNs at once, from free government tools to a spreadsheet formula.

• Check GST registration for a list of suppliers

  Which of your suppliers are registered for GST, and since when? Here is how to answer that for a whole list.

• Check ABNs are active before paying invoices

  A short check you can add to every pay run, so you are not paying invoices against cancelled or mistyped ABNs.

ABN Formula is not affiliated with, endorsed by, or part of the Australian Government, the Australian Taxation Office or the Australian Business Register. ABN status, entity names and GST registration come from the ABR through the free ABN Lookup web services. This guide is general information, not tax advice.