Tutorial guides for better financial systems.

Practical tutorial articles for connecting financial data and automating the work around it.

Watercolour month-end ledger, linked receipts and a completed review checklist on an ivory desk.

TutorialNovember 1, 20265 min read

Build a Month-End Money Review with BankSync Tables and Dashboards

Turn a month of bank data into a review you can finish: reconcile cash, chase missing receipts and resolve exceptions before trusting the totals.

Read guide

Watercolour delivery trays, a small brass bell and a ledger representing a bank-feed review workflow.

TutorialOctober 31, 20265 min read

Build a Bank-Feed Failure Review Workflow with BankSync Automations

Catch delivery problems before you trust an Excel or Notion report, with a focused automation, realistic tests and a clear recovery checklist.

Read guide

Three merchant slips filed by category, with one slip still to review.

TutorialOctober 30, 20264 min

How to Categorise UK Bank Transactions in Securo Without Misclassifying Refunds

Turn repeated bank descriptions into useful categories in Securo. Use a UK current-account example to test merchant rules, catch refunds and keep ambiguous purchases for review.

Read guide

Watercolour savings jars beside an annual planning calendar and household ledger.

TutorialOctober 29, 20265 min read

Build an Excel Sinking-Fund Tracker Without Double-Counting Savings

Plan for annual bills, track money set aside and record the final expense once—with a clear Excel model for UK household bank data.

Read guide

One large invoice sheet linked by separate ribbons to two smaller payment slips and an allocation ledger.

TutorialOctober 27, 20265 min read

Track Invoice Part-Payments with BankSync Table Relations

Use an allocation table to connect invoices and bank payments without counting the full invoice or payment more than once.

Read guide

A set of varied receipt slips sorted into three neatly labelled-by-colour ledger sections.

TutorialOctober 25, 20265 min read

Keep Excel Spending Categories Consistent with BankSync Lookup Tables

Map recurring bank descriptors to consistent categories, preview the changes and keep ambiguous merchants in a review queue.

Read guide

An open cash tin, a till receipt and a ruled cash-count sheet.

TutorialOctober 24, 20266 min read

Petty Cash Reconciliation for Australian Shops

An A$100 cash top-up, two receipts and a Friday count leave a shop A$1.50 short. Link the three records and see exactly what still needs checking.

Read guide

A small shopfront model beside a cash ledger and a neatly arranged set of review cards.

TutorialOctober 23, 20265 min read

Build a Weekly Cash Review Dashboard for a Small UK Business

Put verified cash, upcoming commitments and unresolved transactions into one focused review, without confusing bank activity with a forecast.

Read guide

Uneven stacks of coins and client envelopes beside a weekly cash-planning workbook.

TutorialOctober 21, 20265 min read

Build an Irregular-Income Cash Tracker in Excel for UK Freelancers

Separate money received from money expected, then test whether a late client payment changes your next few weeks of cash.

Read guide

Three separate budget notebooks receiving selected coloured ribbons from an organised bank-account card box.

TutorialOctober 19, 20265 min read

Give Each Budget App Only the Bank Accounts It Needs

Design separate BankSync SimpleFIN accesses for Actual, Sure and Securo, with a clear account matrix and a reliable offboarding routine.

Read guide

Organised paper trays and transaction slips leading into a household budget notebook.

TutorialOctober 17, 20265 min read

Switch to BankSync for YNAB Without Duplicate Transactions

A practical handover checklist for moving a YNAB account from file imports or Direct Import to BankSync, with balance, currency and first-sync checks.

Read guide

A small home server beside a bank ledger, connected to a British bank model with an orange ribbon.

TutorialOctober 15, 20265 min read

Review UK Bank Accounts in Securo with BankSync

Connect supported UK accounts to a self-hosted Securo instance and verify account scope, freshness, transfers and currency before trusting the overview.

Read guide

A household ledger receiving separate ribbons from two bank models, with neatly arranged account cards.

TutorialOctober 13, 20265 min read

Bring UK Bank Accounts into Sure: A Household Ledger Checklist

Use BankSync's SimpleFIN access for supported UK accounts, then verify Sure's account mapping and household reporting scope.

Read guide

Bank transaction fields mapped into Excel columns with append and overwrite options and an orderly workbook structure

TutorialOctober 11, 20266 min read

MTD Excel Spreadsheet Bank Feed: A Practical Setup

Build a controlled Excel source tab for UK bank transactions, then keep VAT review and the compatible MTD submission route separate.

Read guide

Bank records flowing into a spreadsheet binder before a separate filing gateway

TutorialOctober 11, 20266 min read

The Bank Feed for Your MTD Spreadsheet

Keep an MTD spreadsheet supplied with authorised UK bank transactions while compatible software handles quarterly updates and filing.

Read guide

An archive box of bank statements meeting a current budget ledger across a marked paper divider.

TutorialOctober 10, 20265 min read

Add Older UK Bank History to Actual Budget Without Losing the Thread

Combine older bank exports with a live BankSync connection using a clear cutover date, import checks and account reconciliation.

Read guide

A British bank model connected by an orange ribbon to a household budget notebook and monthly calendar.

TutorialOctober 8, 20265 min read

Your First Month with UK Bank Sync in Actual Budget

Connect supported UK accounts through BankSync, verify account mapping and build a first-month routine around reconciliation rather than import counts.

Read guide

Hand-drawn illustration of authorised bank data passing through a secure permission gate to an AI assistant

TutorialOctober 5, 20266 min read

Connect AI agent to Bank Account

Connect a supported AI agent to authorised, read-only bank data so it can analyse transactions and balances—without giving it payment authority or your bank credentials.

Read guide

Hand-drawn illustration of bank data flowing to a database and webhook-connected application

TutorialOctober 5, 20266 min read

Connect bank data to postgres or webhook

Use BankSync to deliver authorised, read-only bank data to an API or webhook, then store it in Postgres or trigger the workflows your product already relies on.

Read guide

Hand-drawn bank data river crossed by five routes that converge in a spreadsheet ledger

TutorialOctober 5, 20267 min read

How to Get Bank Transactions into Google Sheets Automatically (2026)

Google Sheets has no built-in bank feed. Compare the five real ways to get transactions in: CSV exports, Apps Script, Zapier or Make with Plaid, Sheets add-ons like Tiller, BudgetSheet and BankToSheets, and BankSync.

Read guide

An orderly receipt inbox with three coloured folders and a magnifying glass beside a bank ledger.

TutorialOctober 3, 20265 min read

Build a Missing-Receipt Review Queue in Notion

Turn an overwhelming receipt folder into a focused review queue: unmatched payments, unlinked documents and explained differences.

Read guide

Renewal envelopes and a divided wooden holder beside a household budget book.

TutorialOctober 2, 20265 min read

How to budget for annual bills in Actual Budget with a UK bank feed

A £600 renewal is six paydays away. Work out what to set aside, record it in Actual Budget and check the payment against your UK current account.

Read guide

A household calendar, a small house and organised envelopes linked to a bank ledger.

TutorialOctober 1, 20265 min read

Build a Household Bills and Renewal Tracker in Notion

Combine a forward-looking bills register with UK bank transactions so your household can see what is due, what was paid and what needs a decision.

Read guide

Three project folders connected to bank receipt slips on a warm illustrated studio desk.

TutorialSeptember 29, 20265 min read

Track Project Costs in Notion from UK Bank Transactions

Give each project a reviewed view of paid costs, with bank transactions, project relations and a simple allocation rule for shared purchases.

Read guide

Two orderly paper ledgers connected by matching coloured clips, with a receipt held under a magnifying glass.

TutorialSeptember 27, 20265 min read

Match Bank Transactions to Receipts in Excel with XLOOKUP

Use a reviewed transaction key to bring receipt references into Excel, while surfacing missing and duplicate matches instead of hiding them.

Read guide

One bank deposit slip and three client invoices on a design studio desk.

TutorialSeptember 26, 20265 min

Match One Client Payment to Multiple Invoices in Google Sheets

An Australian agency receives one bank transfer for three invoices. Build a Google Sheets remittance tracker that shows which invoice still has $220 owing.

Read guide

Bank transaction slips arranged into colourful monthly groups beside a hand-drawn bar chart workbook.

TutorialSeptember 23, 20265 min read

Turn UK Bank Transactions into a Monthly Excel Spending Report

Build a category-by-month spending report from bank transactions, with a worked example that handles refunds, transfers and incomplete months.

Read guide

Several bank sources flowing into an accountant's organised client ledger

TutorialSeptember 22, 20266 min read

Your Client Got an HMRC Letter? Get Their Records Current in One Afternoon

When a client receives an HMRC letter, bring the available bank records into a controlled source ledger, identify gaps and give the review work a clear starting point.

Read guide

Property finance accounts flowing into one automated spreadsheet

TutorialSeptember 22, 20266 min read

Mortgage Account, Rent Account, Credit Card: One Landlord Spreadsheet, Filled Automatically

Bring supported mortgage, rent and credit-card account activity into one landlord spreadsheet, while keeping each property, account and review task visible.

Read guide

TutorialSeptember 22, 20266 min read

Keep Your Spreadsheet. Get the Bank Feed. Work With Your HMRC-Recognised Bridging Tool

Keep the spreadsheet your team knows. Use BankSync for authorised UK bank data, then use your chosen HMRC-recognised bridging tool for the filing workflow.

Read guide

Six monthly stacks of bank records flowing into a spreadsheet through a secure sync loop

TutorialSeptember 22, 20267 min read

Got the HMRC letter? Catch up six months of transactions in five minutes - and keep your spreadsheet

Got an HMRC letter and need to catch up? Connect supported UK bank accounts, bring available transaction history into the spreadsheet you already use, and keep it current without CSV exports.

Read guide

A cloud-shaped paper organiser connecting a bank ledger to a neatly arranged three-tab workbook.

TutorialSeptember 21, 20265 min read

Excel Bank Feeds with OneDrive: Set Up a Workbook That Keeps Working

Choose the right workbook, separate incoming bank rows from reports, and make an Excel bank feed easier to maintain for your household or business.

Read guide

Sales, fee and refund slips gathered into a single deposit on an open ledger.

TutorialSeptember 20, 20265 min

Reconcile Stripe Payouts to UK Bank Deposits in Excel

Match the Stripe payments, fees and refunds behind one payout to the deposit in your business current account, with a worked GBP example and Excel formulas.

Read guide

A magnifying glass following a paper transaction from a British bank building to an open workbook.

TutorialSeptember 18, 20265 min read

UK Bank Transaction Missing from Excel? Check These Six Things

Trace a missing UK transaction from bank status to Excel destination, with a practical checklist that avoids unnecessary duplicate imports.

Read guide

A card purchase receipt and two account notebooks connected by a looping orange ribbon.

TutorialSeptember 16, 20265 min read

Stop Double-Counting Credit Card Payments in Your Excel Budget

Separate purchases, card repayments and account transfers in a bank-fed Excel budget, with a worked example and BankSync Transfer Matcher setup.

Read guide

A British high-street bank sending transaction slips into a household budget notebook with an orange ribbon.

TutorialSeptember 14, 20266 min read

YNAB UK Bank Sync: What to Do When Your Bank Is Missing

YNAB already supports selected UK banks. Learn how to investigate a missing connection and when BankSync’s early-access YNAB feed may fit your GBP plan.

Read guide

A magnifying glass and balanced brass scales beside two bank statement sheets and a ledger.

TutorialSeptember 12, 20265 min read

Reconcile a UK Bank Account in Excel: Opening Balance to Closing Balance

Check whether your Excel bank feed is complete using a statement cutoff, signed movements and an exception list before trusting your spending reports.

Read guide

A returned parcel and credit slip beside a household ledger.

TutorialSeptember 11, 20265 min

Track Card Refunds in Notion with UK Bank Transactions

See which household returns still need chasing. Match a retailer’s refund promise to posted UK bank credits in Notion, including part-refunds and reversals.

Read guide

Two purses, a shared grocery basket and paired receipt cards arranged beside an open ledger.

TutorialSeptember 9, 20265 min read

Track Shared Household Expenses and Reimbursements in Excel

Use a bank-fed Excel ledger to separate household purchases, each person’s share, and reimbursements without counting the same expense twice.

Read guide

A household calendar, pay envelopes and small bill cards arranged around a kitchen table.

TutorialSeptember 7, 20265 min read

Build a Payday-to-Payday Budget in Excel for a UK Household

Plan around the days your household gets paid, using UK bank transactions, a bills calendar and a running cash balance between paydays.

Read guide

An Australian weatherboard home alongside two stacks of balance cards and a ledger.

TutorialSeptember 5, 20265 min read

Build an Australian Mortgage Offset Tracker in Google Sheets

A transfer into an offset can make a good month look better than it was. Build a dated balance chart in Google Sheets and keep household spending separate.

Read guide

A long folded planning sheet crosses a desk beside coins, envelopes and a small British shop.

TutorialSeptember 4, 20265 min read

Build a 13-Week Cash-Flow Forecast in Excel with UK Bank Data

Combine a UK bank feed with a separate commitments sheet to see when cash may run short, test late payments, and keep forecasts distinct from actuals.

Read guide

Australian bank transactions flowing into a household budget notebook beside eucalyptus leaves and budgeting envelopes.

TutorialSeptember 3, 20266 min read

YNAB Australia: Bank Sync with BankSync (2026)

Use YNAB with Australian bank accounts: understand the Direct Import gap, check BankSync early access, and set up a posted-transaction feed through CDR.

Read guide

Two illustrated ledgers connect transaction slips and receipts with orange ribbons.

TutorialSeptember 1, 20267 min read

Link Bank Transactions to Receipts: A Cash-Flow Review in BankSync

Build a cash-flow review with linked Transactions and Receipts tables, missing-evidence views, and dashboard widgets that show what needs attention.

Read guide

Bank feeds flowing through a control gate into a business cash flow dashboard

TutorialAugust 28, 202615 min read

How to Build a UK Small Business Cash Flow Dashboard with Automatic Bank Feeds

Build a UK small-business cash flow dashboard from connected bank actuals, controlled forecast assumptions, transfer-aware classifications, alerts and a repeatable review process.

Read guide

Hand-drawn harbour crane sorting bank transaction slips into a structured grid

TutorialAugust 28, 202613 min read

How to Connect a UK Bank Account to Excel Automatically

Connect a supported UK bank to Microsoft Excel through read-only Open Banking, then automate transactions into a OneDrive or SharePoint workbook with controlled mapping and scheduling.

Read guide

TutorialAugust 28, 202613 min read

How to Automatically Export UK Bank Transactions to Google Sheets

Connect a supported UK bank through Open Banking and automatically export transactions to Google Sheets with stable columns, enrichment, scheduling and consent controls.

Read guide

A UK bank account flowing through a secure open banking gateway into a conversational AI assistant

TutorialAugust 22, 202610 min read

How to Connect a UK Bank Account to Claude (2026)

Connect UK current, savings and supported credit accounts to Claude through BankSync, Salt Edge and Open Banking, including the consent and renewal flow.

Read guide

Canadian household and investment accounts converging through a protected gateway into a conversational AI assistant

TutorialAugust 22, 202611 min read

How to Connect a Canadian Bank Account to ChatGPT (2026)

ChatGPT Finances is not yet available for Canadian accounts. Learn the BankSync MCP route for eligible workspaces, including CAD/USD and brokerage handling.

Read guide

Separate company islands feeding a group treasury observatory

TutorialAugust 20, 202614 min read

How to Build a Multi-Entity Treasury Dashboard

Build a group cash dashboard across legal entities while preserving ownership, currencies, restrictions and intercompany transfers.

Read guide

An unusual transaction creating an orange ripple and alert

TutorialAugust 18, 202612 min read

How to Build Unusual Transaction and Cash Flow Alerts

Create explainable alerts for large payments, new merchants, amount spikes, bursts and stale financial feeds.

Read guide

An Australian bank with a closed direct route and an approved path through a user-controlled spreadsheet to a conversational AI assistant

TutorialAugust 18, 202610 min read

Can You Connect an Australian Bank Account to ChatGPT? (2026)

ChatGPT Finances is not available for Australian banks, and BankSync CDR data is not exposed through MCP. Use the supported destination-based analysis route.

Read guide

Hand-drawn accountant reviewing a bank transaction stream that turns a mill wheel and fills a live ledger

TutorialAugust 17, 202611 min read

Give Your Accountant a Live Google Sheet of Your Bank Transactions

Set up a shared Google Sheet that receives scheduled bank transactions, gives your accountant controlled access and keeps review notes separate from source data.

Read guide

Hand-drawn small business cash-flow river passing through forecasting arches into a monitored reservoir

TutorialAugust 16, 202612 min read

Track Your Small Business Cash Flow Automatically in Google Sheets

Build a Google Sheets cash-flow tracker that combines automatically synced bank transactions with a 13-week forecast, low-cash alerts and a practical weekly review.

Read guide

A small bank fee leak detected and routed to a ledger and alert

TutorialAugust 16, 202611 min read

How to Build an Automatic Bank Fee Tracker

Build a bank fee tracker that classifies service charges, watches fee creep and preserves the transactions behind every total.

Read guide

An Australian bank routing secure financial data through a user-controlled spreadsheet before it reaches a conversational AI assistant

TutorialAugust 13, 202610 min read

Can You Connect an Australian Bank Account to Claude? (2026)

Connect an Australian bank account to Claude through BankSync MCP using regulated CDR consent, a scoped API key and read-only finance tools.

Read guide

Vendor stalls feeding a central spend dashboard with concentration signals

TutorialAugust 12, 202612 min read

How to Build a Vendor Spend Dashboard

Create a vendor spend dashboard for concentration, recurring costs, budgets, category analysis and drill-down transactions.

Read guide

Canadian chequing, savings and cross-currency accounts flowing through a secure bridge to a conversational AI assistant

TutorialAugust 10, 202610 min read

How to Connect a Canadian Bank Account to Claude (2026)

Connect Canadian chequing, savings, credit and supported investment accounts to Claude through BankSync and Plaid, including CAD/USD account handling.

Read guide

Invoices moving through status lanes, calendar slots and an overdue alert

TutorialAugust 10, 202613 min read

How to Build an Accounts Payable and Invoice Tracker

Build an accounts payable and invoice tracker with relational Tables, status views, due-date calendars and bank-payment evidence.

Read guide

Planned and actual spending passing through a variance gate

TutorialAugust 8, 202613 min read

How to Build a Budget vs Actual Dashboard

Create a budget versus actual dashboard that aligns plan and bank activity by period, category, department and entity.

Read guide

Several UK bank accounts passing through a secure open banking doorway to a conversational AI assistant

TutorialAugust 7, 202611 min read

How to Connect a UK Bank Account to ChatGPT (2026)

ChatGPT Finances is not yet available in the UK. Learn the current BankSync MCP route for eligible workspaces, plus Open Banking consent and renewal details.

Read guide

TutorialAugust 6, 202612 min read

How to Build an Automatic Subscription Tracker from Bank Transactions

Detect recurring charges, price increases and missed payments from bank data, then organise subscriptions in a searchable dashboard.

Read guide

US bank, credit card and investment accounts flowing through a secure bridge to a conversational AI assistant

TutorialAugust 4, 202611 min read

How to Connect a US Bank Account to ChatGPT (2026)

Connect a US bank account to ChatGPT using Finances or BankSync MCP, with setup steps, a route comparison, account limits and security guidance.

Read guide

Investment holdings observed through allocation and performance instruments

TutorialAugust 4, 202614 min read

How to Build an Investment Portfolio Tracker with Live Brokerage Data

Build an investment portfolio tracker for holdings, allocation, cash and trades while keeping brokerage data and performance assumptions separate.

Read guide

Assets and liabilities balanced into a net worth trend

TutorialAugust 2, 202613 min read

How to Build an Automatic Net Worth Tracker

Build an automatic net worth tracker that combines live balances, investments, loans and manual assets without hiding valuation assumptions.

Read guide

A US bank connecting through a protected data stream to a conversational AI assistant

TutorialAugust 1, 202610 min read

How to Connect a US Bank Account to Claude (2026)

Connect US bank accounts, cards, loans and supported investments to Claude through BankSync and Plaid, with setup steps, limits and security guidance.

Read guide

Hand-drawn Australian client bank streams converging through separate consent channels at an accountant's ledger

TutorialJuly 31, 202612 min read

How Australian Accountants Can Automate Client Bank Data in Excel

A practical guide for Australian accounting firms using client portals and CDR bank feeds to keep Excel working papers updated without chasing statements or sharing credentials.

Read guide

Three-step Claude connector workflow showing how users find BankSync in Claude, authorise a BankSync workspace and use Claude to analyse transactions, balances, holdings, loans and mapped feed tools

TutorialJuly 30, 202611 min read

How to Connect Claude to Your Bank Account with BankSync

Connect Claude to supported bank, card, brokerage and loan data through BankSync’s official directory connector—without uploading CSV files or editing JSON.

Read guide

Hand-drawn venture capital reservoirs feeding a treasury forecasting instrument and long runway

TutorialJuly 29, 202612 min read

How Venture Capital Firms Can Build Better Treasury Models and Cash-Flow Forecasts

A practical framework for venture capital firms to combine live bank actuals with fund assumptions, capital-call planning and scenario-based treasury forecasts.

Read guide

Cash runway guided toward a safe landing by dashboard instruments

TutorialJuly 29, 202612 min read

How to Build a Cash Runway Dashboard for a Startup

Build a startup cash runway dashboard from bank balances, burn-rate assumptions, recurring costs and scenario-ready metrics.

Read guide

A maker assembling a self-hosted SimpleFIN finance application

TutorialJuly 27, 202615 min read

Build a Self-Hosted Finance App with SimpleFIN and BankSync

A practical architecture for a hobbyist bank-sync app: token claim, secure storage, account mapping, idempotent imports and scheduling.

Read guide

Separate bank islands feeding a central treasury dashboard

TutorialJuly 27, 202614 min read

How to Build a Multi-Bank Treasury Dashboard

Design a multi-bank treasury dashboard for cash position, concentration, liquidity and transfer visibility without losing account-level evidence.

Read guide

Hand-drawn brokerage holdings greenhouse automatically arranged into a portfolio grid

TutorialJuly 26, 202610 min read

How to Sync Brokerage Holdings to Google Sheets Automatically (2026)

Connect a brokerage account and automatically sync holdings, trades, balances and settled cash to Google Sheets—without repeated CSV exports.

Read guide

SimpleFIN records entering a MoneyMatter finance observatory

TutorialJuly 25, 202611 min read

Connect MoneyMatter to BankSync with SimpleFIN

Connect MoneyMatter’s self-hosted or cloud app to BankSync through SimpleFIN and verify multi-currency accounts, investments and MCP access.

Read guide

TutorialJuly 25, 202613 min read

How to Build a Business Cash Flow Dashboard with Live Bank Feeds

Build a practical business cash flow dashboard from live bank feeds, structured transaction data, enrichment rules and decision-ready charts.

Read guide

Hand-drawn Australian banks sending data through a user-controlled consent gate into spreadsheet tools

TutorialJuly 23, 202612 min read

How to Sync Australian Bank Transactions to Google Sheets or Excel (2026)

Learn how to sync Australian bank transactions to Google Sheets or Excel through the Consumer Data Right, with setup steps, security details and practical limitations.

Read guide

A SimpleFIN conduit powering the Sparky Budget wheel

TutorialJuly 23, 202611 min read

Connect Sparky Budget to BankSync with SimpleFIN

Configure Sparky Budget’s SimpleFIN token, Docker environment and saved access URL for reliable BankSync-powered imports.

Read guide

A SimpleFIN stream filling practical Buckets budget containers

TutorialJuly 21, 202611 min read

Connect Buckets to BankSync with SimpleFIN

Connect supported bank accounts to the Buckets desktop app through BankSync and SimpleFIN, then reconcile and backfill safely.

Read guide

TutorialJuly 20, 202612 min read

How to Import Bank Transactions Into Excel Automatically (2026 Guide)

Import bank transactions into Excel automatically after Money in Excel: compare CSV imports, Power Query, add-ins and scheduled bank feeds.

Read guide

A SimpleFIN importer wheel carrying records into Firefly III

TutorialJuly 19, 202611 min read

Connect Firefly III to BankSync with SimpleFIN

Configure Firefly III’s separate Data Importer for a BankSync SimpleFIN connection, account mapping, automation and deduplication.

Read guide

Hand-drawn household budget garden automatically watered by a clockwork bank feed

TutorialJuly 18, 202610 min read

How to Build a Budget Spreadsheet That Updates Itself (2026)

Build a self-updating budget spreadsheet in Google Sheets or Excel using automatic bank feeds, transaction categorisation, live totals and a simple weekly review.

Read guide

SimpleFIN records entering a modular Sure finance cabinet

TutorialJuly 17, 202611 min read

Connect Sure to BankSync with SimpleFIN

Use Sure’s native SimpleFIN provider to connect supported accounts through BankSync and import balances, transactions and holdings safely.

Read guide

Hand-drawn Australian bank streams passing through a consent gate to four data tools

TutorialJuly 16, 202610 min read

How to Connect Australian Bank Accounts with BankSync

A step-by-step guide to securely connecting Australian bank accounts through the Consumer Data Right and automatically syncing transactions and balances to Google Sheets, Excel, Notion, Airtable or your own systems with BankSync.

Read guide

A SimpleFIN conduit entering a private Securo self-hosted workshop

TutorialJuly 15, 202611 min read

Connect Securo to BankSync with SimpleFIN

Enable Securo’s SimpleFIN provider, connect BankSync, claim a setup token and verify accounts, balances, transactions and holdings.

Read guide

SimpleFIN transaction records flowing into Actual Budget envelope drawers

TutorialJuly 13, 202611 min read

Connect Actual Budget to BankSync with SimpleFIN

Set up Actual Budget bank sync through BankSync’s SimpleFIN-compatible connection, map accounts and avoid duplicate or stale imports.

Read guide

A mechanic checking the stages of a SimpleFIN data flow

TutorialJuly 9, 202612 min read

SimpleFIN Troubleshooting: Missing Transactions, Stale Balances and 403s

Diagnose SimpleFIN setup-token failures, 403s, quotas, stale balances, missing history and duplicates.

Read guide

A one-time key opening a SimpleFIN data conduit into a handmade application

TutorialJuly 3, 202613 min read

How to Integrate the SimpleFIN API: A Production-Minded Guide

Implement SimpleFIN setup-token exchange, account sync, history windows, deduplication, errors and secure storage.

Read guide

Hand-drawn bank feed and receipt scanner bringing a static bookkeeping grid to life

TutorialJune 27, 20266 min read

Best Way to Sync Bank Transactions to Google Sheets Without CSV Exports

Replace recurring bank CSV imports with a mapped transaction source in Google Sheets, while keeping duplicates, reports and review under control.

Read guide

Multiple financial accounts feeding a secure sync layer, structured spreadsheet rows and budget reporting

TutorialJune 16, 20266 min read

Best Way to Sync Multiple UK Bank Accounts to Google Sheets

Bring multiple bank and card accounts into one Google Sheets workbook without losing account identity, double-counting transfers or repeating CSV imports.

Read guide

Multiple bank transactions flowing through a secure automatic sync into Google Sheets and reporting dashboards

TutorialJune 5, 20266 min read

Best Way to Sync Your UK Bank Account to Google Sheets

The best way to keep a Google Sheets finance workbook current depends on whether you need a one-off import, a custom build or a recurring bank feed.

Read guide

Hand-drawn three paths for recovering a hardware-store receipt converging at a magnifying glass

TutorialDecember 26, 202510 min read

3 Ways to Retrieve Lost Home Depot Receipts for Your Tax Audit

Need a Home Depot receipt for your tax audit or expense report? Learn how to find in-store and online purchase receipts, then automate future receipt collection so you never have to search again.

Read guide

TutorialDecember 25, 202512 min read

Beyond the Template: Automating Google Sheets Bookkeeping with AI

Google Sheets bookkeeping templates are great, but they still require manual data entry. Learn how to automate receipt extraction and transaction syncing to transform your static template into a living financial dashboard.

Read guide

Hand-drawn construction foreman using a clockwork compass to sort receipts against blueprints

TutorialDecember 23, 202512 min read

Why Your Construction Cost Codes are Wrong (and How AI Can Fix Them)

Construction cost code errors kill project profitability. Learn how AI-powered receipt extraction automatically assigns receipts to the correct cost codes in Airtable, eliminating manual errors and bridging the field-to-office gap.

Read guide

Hand-drawn person tracing a lost business receipt through a generic parcel warehouse

TutorialDecember 22, 202510 min read

The Step-by-Step Guide to Downloading Amazon Business Receipts

Need to find an Amazon receipt for your tax audit or expense report? Learn how to retrieve Amazon Business receipts, download VAT-compliant invoices, and automate future receipt collection.

Read guide

Hand-drawn expense management table linking sorted drawers to project boxes and budget jars

TutorialDecember 21, 202512 min read

How to Build a Custom Airtable Expense Management System

Create a powerful expense management system in Airtable with automated receipt extraction. Link expenses to projects, track budgets in real-time, and eliminate manual data entry forever.

Read guide

Hand-drawn receipts folding into paper cranes and landing in a modular archive

TutorialDecember 20, 202512 min read

The Ultimate Guide to Automating Your Notion Receipt Tracker

Stop manually entering receipts into Notion. Learn how to automate your receipt tracking with AI-powered OCR that syncs directly to your Notion database, eliminating hours of data entry.

Read guide