Sync Bank Transactions to Excel Automatically

BankSync writes into an Excel workbook stored on OneDrive. Connect your Microsoft account once, then in the feed’s Destination tab pick the workbook and worksheet and map bank fields to columns. No file to download, no import step.

Yes. BankSync can only read your data; it cannot move money, change settings or passwords, trade, or apply for products. You sign in inside the provider’s own window (Plaid, Fiskil or SnapTrade), so BankSync never sees or stores your bank password.

Pick Hourly, Daily, Weekly or Manual on the feed’s Schedule tab; Free and Starter run weekly, Standard adds daily, and Professional and above unlock hourly. “Sync Now” works on every plan, and rows appear in Excel once the provider has the data.

Transactions, balances, investment trades, holdings, open orders and loan data, plus receipts, invoices and documents, where the accounts and provider support them. One feed carries one data type, so transactions and balances to Excel means two feeds, and investment accounts cannot share a feed with checking or savings.

No. Every record is keyed on the provider’s unique id and skipped if already written, so overlapping ranges, retries and back-to-back syncs are safe. Exceptions: two feeds writing the same account deduplicate separately, edited or deleted rows are not re-detected, and re-running a feed from the beginning can duplicate.

The first run backfills what the bank’s provider returns, and the ceiling is set by the market, not your plan: Australia up to 2 years (Fiskil), United States up to 2 years (MX), United States up to 2 years (Finicity), United States and Canada up to 2 years (Plaid), and United Kingdom up to 60 days (Salt Edge). Individual banks vary, a backfill can reach the rest of that window, and balances, holdings and loans are point-in-time, so their history starts at your first sync.

Disconnect from the Banks tab after removing the bank from any feeds that use it. It is a soft delete with a “Reactivate Bank” option for about 30 days; on permanent removal the provider connection is revoked, and data already written to Excel stays where it is.

Enrichments fill fields as transactions sync: your rules and learned corrections apply first, and the AI Categorizer fills what is still empty. Merchant Cleanup turns “SQ *BLUE BTL COF 0442 OAK” into “Blue Bottle Coffee”. The AI Categorizer is in beta on Professional plans and above.

All plans include a 14-day free trial. A card is collected at signup, but it is not charged during the trial, and you can cancel before it ends.

Yes. The workbook must live on OneDrive (personal, or OneDrive for Business with a work or school account), because BankSync connects through Microsoft’s OAuth. Your IT admin may need to approve the connection once, and you need Editor access or above in the BankSync workspace.

Yes. Australian banks, including CommBank, Westpac, NAB and ANZ, connect under the Consumer Data Right (CDR) through Fiskil, an accredited data recipient.