Microsoft Excel setup and field reference
Transactions and balances from 12k+ banks land as new rows in your workbook, hourly, daily or weekly, mapped to the columns you already use.
From bank to Microsoft Excel in three steps.
- 01
Connect your bank
Any of 12k+ banks, read-only, through your bank’s own consent screen.
ChaseRead-onlyAmerican ExpressRead-onlyConsentBank’s own screen - 02
Link Microsoft Excel
Sign in with Microsoft, pick a workbook on OneDrive and map bank fields to its columns.
DateA · DateMerchantB · DescriptionCategoryC · CategoryAmountD · AmountAccountE · Account - 03
Pick a schedule
Hourly, daily or weekly, or on demand. New transactions arrive as new rows.
HourlyDailyWeeklyNext runTomorrow, 6:00amLast run● 3 new rows, 6:02am
What lands in your workbook.
- Date
- The day the bank posted the transaction. 10/19/2026
- Description
- The description the bank gives the transaction. Whole Foods Market
- Category
- A spending category you can filter, group and chart by. Groceries
- Amount
- Signed, in the account’s currency: money out is negative. -$86.42
- Account
- The account the row came from, so several banks share one table. Amex Gold
- Account #
- The last four digits of the account number. xxxx9880
The same data can also go to spreadsheets, workspaces, AI assistants and your own code.
Microsoft Excel, in short.
- Data
- Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status, chosen per feed.
- Schedule
- Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
- History
- United States, Canada, and Australia up to 2 years and United Kingdom, Austria, Belgium, Bulgaria, Cyprus, Czechia, Germany, Denmark, Estonia, Spain, Finland, France, Greece, Croatia, Hungary, Ireland, Iceland, Italy, Liechtenstein, Lithuania, Luxembourg, Latvia, Malta, Netherlands, Norway, Poland, Portugal, Romania, Sweden, Slovenia, and Slovakia up to 60 days.
- Access
- Read-only, authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
- Setup
- About 5 minutes. Requires a Microsoft 365 / OneDrive account.
- Status
- Available today.
- Choosing a tool?
- See how BankSync syncs bank transactions to Excel, what it costs, and how it compares.
Questions, answered.
How does the BankSync Microsoft Excel integration work?
Connect your bank read-only, connect Microsoft Excel and pick where rows go, then map bank fields to your columns. Each scheduled run adds new transactions as new rows.
Which fields can BankSync sync to Microsoft Excel?
Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status. You choose which ones to map, and to which column.
How often does Microsoft Excel update?
Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
Will a re-sync create duplicate rows in Microsoft Excel?
No. Every transaction is keyed by its bank transaction id, so a re-sync updates or skips it instead of writing it twice.
Can BankSync move money or see my bank password?
No. Access is read-only and authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
Bank data in Microsoft Excel.
BankSync is not affiliated with, endorsed by, or an official partner of Microsoft Excel. Microsoft Excel trademarks belong to their respective owners.