NAB to Excel

Sync your NAB transactions, balances and holdings into Excel on a schedule, through the regulated CDR consent, with no screen-scraping.

NAB Classic Banking and NAB Business Everyday, synced at 6:02am into the Transactions 2026 workbook.

NAB to Excel, in three steps.

  1. 01

    Connect your NAB account

    Choose NAB from the bank list. Authorise read-only access under the Consumer Data Right (CDR), on your bank’s own consent screen. Your credentials stay with NAB.

    NABRead-only
    CommBankRead-only
    UpRead-only
    ConsentCDR
  2. 02

    Pick Excel and map fields

    Connect your Excel workspace and point each supported field at a column.

    DateA · Date
    MerchantB · Description
    CategoryC · Category
    AmountD · Amount
    AccountE · Account
  3. 03

    Save and sync

    Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

    HourlyDailyWeekly
    Next runTomorrow, 6:00am
    Last run● 3 new rows, 6:02am

Set up Excel, start to finish.

Create a feed, map source data, and refresh the workbook you already use. Filmed with sample accounts; NAB connects the same way.

What lands in your workbook.

Date
The day the bank posted the transaction. 19/10/2026
Description
The description the bank gives the transaction. AGL Energy
Category
A spending category you can filter, group and chart by. Utilities
Amount
Signed, in the account’s currency: money out is negative. -$164.30
Account
The account the row came from, so several banks share one table. NAB Classic Banking
Account #
The last four digits of the account number. xxxx4116
Map them onto the columns you already have, in any order. One row per transaction, keyed so a re-sync never writes it twice.

One bank, one destination. Not the whole story.

NAB to Excel, in short.

How
To sync NAB to Excel: sign up for BankSync, authorise NAB via the regulated CDR consent (your credentials never leave NAB), pick Excel as the destination, map fields, and save. Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
CDR
Consumer Data Right, regulated by ACCC & Treasury. Australia's Consumer Data Right (CDR) is the regulated open banking framework letting you securely share your bank data with accredited recipients. BankSync routes through Fiskil, an accredited Data Recipient (ADR). Routed via Fiskil (Accredited Data Recipient, ADRBNK000246).CDR overview (Treasury)CDR register (ACCC)Data standards (DSB)
Data
Transactions, balances and holdings, where the provider, account type and your consent support them.
History
United States, Canada, and Australia up to 2 years and United Kingdom up to 60 days.

Questions, answered.

How do I sync NAB transactions to Excel?

Sign up for BankSync, connect your NAB account via the regulated CDR consent flow, choose Excel as the destination, map fields, and save. Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

Is NAB supported by BankSync?

Yes. NAB is supported via Consumer Data Right (CDR). Routed via Fiskil (Accredited Data Recipient, ADRBNK000246).

What NAB data can I sync to Excel?

The available data types depend on the provider, account type, and permissions you grant. BankSync offers only the supported fields for mapping into Excel.

Is my NAB data safe with BankSync?

Yes. BankSync only ever holds a scoped, revocable CDR consent, never your NAB credentials. Data is encrypted in transit (TLS 1.3) and at rest (AES-256). You can revoke consent at any time from NAB or BankSync.

How often does Excel update?

Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

Can I sync multiple Australian banks to the same Excel workspace?

Yes. Add as many Australian institutions as you want; BankSync writes them all into the same Excel spreadsheet with a per-account column.