Resources
Stop Manual Bank Reconciliations: Save Time October 2026

Stop Manual Bank Reconciliations: Save Time October 2026

Learn how Mercury and Puzzle work together to help startup founders save time and automate their bookkeeping with features automations in bank reconciliations.

Guest Contributor
9.13.23
In article:

Say goodbye to the days of struggling with time-consuming manual accounting tasks, especially if you're a founder or an accountant of an early-stage startup like Flike. Flike (YC S22), a company focused on AI solutions for modern go-to-market teams, has taken a big step towards automating their accounting processes.  

How did they do it? In accounting, the first step involves making sure the matching process of all the financial data between systems is accurate, a process known as bank reconciliation. But what if we told you this can now be done automatically without manual data entry?

TLDR:

  • Manual bank reconciliation blocks your month-end close; a direct API connection automates it without CSV uploads or data entry.
  • AI-native reconciliation tools now report auto-match rates between 90% and 99% (a range cited across vendor benchmarks and independent fintech research), but the real differentiator is audit trail quality on the 1-10% that don't auto-match.
  • PCAOB's amended AS 2201 (effective December 15, 2026) makes reconciliation decisions legally required to be reproducible and attributable, as well as accurate.
  • Mercury added real-time payments to its API on October 15, 2026, so your burn rate and cash position now update as individual transactions settle.
  • Puzzle connects to Mercury's API directly, pulling full transaction metadata in real time and keeping your records audit-ready without manual intervention.

All thanks to Mercury's new statement API integration with Puzzle, Tobias Mueller, co-founder of Flike, no longer has to spend hours on manual bank reconciliation or stress about whether the numbers match — Puzzle automates that work so his bookkeeper and team can focus on higher-value tasks.

‍

“With Puzzle's automation, I can trust that our financial operations are set up correctly, giving me the time steer Flike toward growth. Puzzle has empowered founders like me to work smarter, not harder.”

‍

Today, we’re diving deep into Mercury’s API as a part of our Fintech for Founders series.

Flike's journey towards using AI-native accounting has been possible with Puzzle’s integration of Mercury’s API, part of the Mercury banking platform.

Mercury's API benefits not only founders and CFOs but also accountants by syncing bank account transactions with Puzzle in real time, per Mercury's API documentation. 

This unique integration fully leverages Mercury's API, automating bank reconciliation, statement imports, and transaction categorization. The direct connection ensures reliable data, including metadata not typically found in a traditional bank feed, and access to historical balances through the statements API.

‍

Automated bank reconciliations for improved accuracy and efficiency

For founders, time is a precious resource that should be used wisely. Traditional bank reconciliations are notorious for being a drain on time and energy. 

To put it simply, performing a bank reconciliation is a month-end close process that ensures your company's cash records match your bank statements and bank transactions.

Before this integration, manually cross-referencing transaction matching between your bank and accounting software was a painstaking task. Founders like Tobias spent an eternity matching transactions between their accounting records and bank statements.

Automated Comparison

‍Puzzle effortlessly compares the balances in your accounting system with Mercury statement balances for a specific month.

‍

Validation Checks

‍Puzzle uses Mercury's API to perform automated pre-reconciliation validation checks.

‍

Auto-Population

‍Puzzle's automated reconciliation screen effortlessly populates the "Statement Balance”.

‍Automated Statement and Memo Imports: A Double Boost to Efficiency

Beyond reconciliations, here’s how Puzzle, thanks to its direct Mercury integration, changes the game for founders and finance teams:

Automated bank statement data imports

‍Mercury's API simplifies bank statement imports into Puzzle. This integration streamlines and eliminates manual tasks and the reliance on separate systems, ensuring financial accuracy and bolstering traceability, thus rendering businesses audit-ready.

Automated data imports

The integration extends to syncing meta-data from Mercury, including transaction details like descriptions, memos, and notes. This automated process guarantees meticulous record-keeping without the need for manual journal entries, relying on spreadsheets, saving time and minimizing errors.

Tobias isn't just saving time; he's gaining peace of mind. As a first-time founder, Tobias can now focus his time and energy on the strategic aspects of growing Flike. 

Want the same efficiencies as Tobias? Check out the Mercury and Puzzle integration.

What's changed since we first covered this integration

A lot has happened on Mercury's end since this post was first published — and it makes the Puzzle integration more valuable, not less.

In April 2026, Mercury received conditional OCC approval for Mercury Bank, N.A. — a move that gives Mercury direct control over deposits, compliance, and data rather than routing everything through partner banks. For founders using Mercury, that means more stability and tighter data ownership at the infrastructure level. For the Puzzle integration, it means the API connection you're relying on is backed by an institution building toward a full national bank charter.

Then on August 11, 2026, Mercury launched Mercury Spend — a spend management platform built directly into the Mercury banking dashboard that lets founders issue cards to employees and AI agents, set intelligent budgets, enforce expense policies, and auto-code expenses to the right budget at the point of purchase. Mercury Spend connects to QuickBooks, Xero, and NetSuite, so more transactions arrive pre-coded with less manual review before anything hits your books. For founders already running Puzzle alongside Mercury, the two tools are increasingly designed to work together — live API data from Mercury feeds Puzzle's AI categorization, and Spend tightens the controls upstream.

The Puzzle + Mercury API connection — pulling full transaction metadata in real time — keeps founders at the front of that curve (the 90–99% auto-match range noted above) without switching tools or adding complexity.

One thing worth noting as of September 2026: the audit trail question is getting sharper. COSO's February 2026 guidance on AI-driven internal controls, combined with the PCAOB's amended AS 2201 (effective December 15, 2026), now requires reconciliation decisions to be reproducible and attributable — not just accurate. A direct API connection like Puzzle's Mercury integration matters here not just for speed, but because every matched transaction carries the source metadata that makes your records defensible. That's a different kind of value than a headline auto-match rate.

Where things stand in October 2026

Two developments in the past few weeks sharpen the case for a direct API approach.

On October 15, 2026, Mercury added real-time payments to its API — meaning payment events now post to connected accounting software the moment they clear, not on a batch cycle. For founders running Puzzle alongside Mercury, that means your burn rate and cash position update as individual transactions settle, not at end-of-day. The Puzzle integration reads from this same API infrastructure, so the improvement flows through without any action on your end.

The broader reconciliation category has also hit an inflection point. Auto-match rates across AI reconciliation tools have plateaued at 90–99% — every credible platform now publishes a number in that range. The differentiator in Q4 2026 is no longer the headline match rate; it is what happens in the 1–10% of transactions that don't auto-match, and whether the audit trail explains the resolution clearly enough to satisfy a reviewer. With the PCAOB's amended AS 2201 taking effect December 15, 2026, reproducibility and attribution are becoming compliance requirements, not just nice-to-haves. A direct API connection like Puzzle's Mercury integration carries full transaction metadata through every step of that process — which matters more now than it did when auto-match rate was the only number anyone compared.

FAQ

What tools give a startup founder real-time cash flow visibility without a dedicated finance team?

The fastest path to real-time cash flow visibility — without hiring a controller or CFO — is pairing a bank account that exposes a live API with accounting software that reads from it continuously. The Puzzle + Mercury combination is built for exactly this: Mercury syncs every transaction and balance to Puzzle in real time, so your burn rate, runway, and daily cash position update without anyone logging in to export a file. Founders like Tobias Mueller of Flike (YC S22) replaced manual bookkeeper reconciliation with this stack and got their close time down to near-zero manual effort. Spreadsheets and standalone forecasting tools (Float, LivePlan) can layer on top, but they're only as current as whatever you feed them — Puzzle starts with live data.

What's the best way to automate month-end close for an accounting firm serving early-stage startups?

The highest-leverage move is automating bank reconciliation — it's the task that blocks everything else at month-end. For clients banking with Mercury, Puzzle's native API integration runs automated pre-reconciliation validation checks, compares accounting system balances against Mercury statement balances, and auto-populates the statement balance field before a human touches the file. That removes the first and most time-consuming step of close entirely. From there, automated transaction categorization (Puzzle handles 85–90% of transactions automatically) and metadata imports — memos, descriptions, notes — flow through without manual journal entries. Startups without a full-time accountant can evaluate month-end close automation tools to find the right fit for their stage. For an accounting firm, this means client books are materially complete before the month-end close call, not during it.

What's the best accounting software for early-stage startups that don't have a full-time accountant?

For pre-seed through Series B startups without a dedicated accountant, the right fit depends on your banking stack and complexity. If you bank with Mercury, Puzzle is purpose-built for your situation: AI-native architecture, direct Mercury API integration, automated reconciliation, and daily cash and accrual visibility without manual data entry. For a deeper look at how the options stack up, see our comparison of the best accounting software for Mercury users. QuickBooks Online and Xero work for simpler setups but are built around manual imports and periodic bookkeeper involvement — you'll end up re-creating automation Puzzle ships by default. Wave is free but lacks the accrual-basis infrastructure and integrations early investors expect to see at Series A. The core question isn't which software has the longest feature list; it's which one requires the least manual intervention between your bank and your books. For a Mercury-based startup with no finance team, that answer is Puzzle.

PuzzleQuickBooks Online / XeroWave
Best fitPre-seed → Series B, Mercury-based, no finance teamSimple setups with a part-time bookkeeperBootstrapped / very early, minimal complexity
Mercury API integrationDirect, real-time APIManual imports or aggregator-basedNo native integration
Automated reconciliationYes — pre-reconciliation validation + auto-populated statement balancePartial — still requires manual review stepsNo
Transaction auto-categorization85–90% automatedRule-based; requires manual setupLimited
Cash & accrual basisBoth, simultaneously (see cash vs. accrual accounting for startups)One basis at a timeCash only
Series A investor-ready booksYesYes, with bookkeeper involvementNo — lacks accrual infrastructure

What's the best software for automating bank reconciliation at a seed-stage startup?

For seed-stage startups, the right reconciliation software comes down to one question: does it connect directly to your bank's API, or does it rely on manual CSV exports and periodic imports? The answer determines whether reconciliation is something that happens automatically or something you schedule time for every month. For a broader look at how Mercury-compatible options compare, see our roundup of Mercury bookkeeping software for startups.

If you bank with Mercury, Puzzle is purpose-built for your situation. The direct Mercury API connection syncs every transaction in real time, runs automated pre-reconciliation validation checks, compares your accounting system balances against Mercury statement balances, and auto-populates the statement balance field — all before a human touches the file. The outcome: month-end reconciliation that previously took hours runs with near-zero manual effort. Ramp also has a native Puzzle integration with similar automation for card transactions.

For startups banking elsewhere, QuickBooks Online and Xero offer bank feeds but route most connections through third-party aggregators (Plaid, Finicity) — which introduces re-authentication friction and delays. Brex and Rillet have added reconciliation automation features, but neither has the same depth of direct API integration for early-stage accounting workflows. At the seed stage, where you have no controller and need clean books for your next fundraise, the least-manual path wins — and that path runs through a direct API connection, not an aggregator relay.

How does Puzzle's Mercury API integration handle bank reconciliation automatically?

Puzzle connects directly to Mercury's API to pull full transaction metadata in real time, then compares your accounting system balances against Mercury statement balances, runs pre-reconciliation validation checks, and auto-populates the statement balance field. Reconciliation that previously took hours runs without manual data entry or CSV uploads — and the connection carries over metadata like memos, descriptions, and notes automatically, so your records are complete before a human reviews them.

How do I get real-time burn rate and runway visibility as a seed-stage founder?

Most founders find out their runway is dangerously short weeks after the fact — because their accounting data is only as current as the last manual export. The fix isn't a better spreadsheet; it's eliminating the gap between your bank and your books.

At the seed stage, real-time burn rate and runway visibility requires three things: a bank that exposes a live API, accounting software that reads from it continuously, and AI categorization fast enough to keep up with the feed. The Puzzle + Mercury combination delivers all three. Mercury syncs every transaction and balance to Puzzle in real time; Puzzle's AI categorizes 85–90% of those transactions automatically; and your burn rate, runway, and daily cash position update without anyone logging in to trigger a sync. You see a number you can trust — not a number that was accurate three days ago.

Founders like Tobias Mueller of Flike (YC S22) replaced manual bookkeeper reconciliation with this stack and eliminated the monthly reconciliation bottleneck entirely. For seed-stage founders without a finance team, that's the practical path: pair a live API bank (Mercury) with AI-native accounting software (Puzzle), and your key metrics update themselves.

Can I use Puzzle's automated reconciliation if my startup banks somewhere other than Mercury?

Automated reconciliation works natively with Mercury and Ramp without any manual steps. For most other banks, reconciliation requires manual CSV uploads instead of a live API connection. If Mercury is your primary bank, you get the full automation. If it isn't, expect a more manual workflow until Puzzle expands its native bank integrations.

What tools should a fractional CFO use to deliver real-time financial insights to clients?

The constraint for most fractional CFOs isn't analytical skill — it's data latency. If your client's books are updated once a month by a bookkeeper, your "real-time insights" are actually last-month insights with a fresh timestamp. The tools that change that equation are the ones that eliminate the lag between the bank and the general ledger.

For clients banking with Mercury, Puzzle is the highest-leverage addition to a fractional CFO's stack. The direct Mercury API integration means every transaction flows into the general ledger in real time, AI categorization handles 85–90% of transactions automatically, and bank reconciliation runs without manual intervention. As a fractional CFO, you arrive at the monthly strategy call with books that are materially complete — not halfway through a close. That changes what the conversation is about. For a broader view of how the stack fits together, see our comparison of accounting software for Mercury and Stripe startups.

For reporting and dashboards on top of clean books, tools like Mosaic, Jirav, or Cube layer FP&A and scenario modeling onto the data Puzzle maintains. Power BI and Looker Studio work for custom reporting but require a data pipeline to be useful — they don't replace the underlying accounting layer. The sequencing matters: get the transaction data clean and current first (Puzzle + Mercury), then build dashboards on top of a source you trust. Fractional CFOs who lead with dashboards before fixing the underlying data pipeline end up presenting numbers their clients can't verify.

How does Mercury Spend (launched August 2026) affect what flows into Puzzle?

Mercury Spend auto-categorizes transactions to the right budget and GL category at the point of purchase inside Mercury. When that data flows through the API into Puzzle, more transactions arrive pre-categorized and require less review before hitting your general ledger. The two tools are increasingly designed to complement each other — founders using both get higher straight-through processing rates with fewer manual touchpoints between the bank feed and finalized books.

How does Puzzle automatically categorize transactions, and does the AI learn from my corrections over time?

Puzzle's AI categorizes 85–90% of transactions automatically using a combination of merchant signals, memo text, and your company's historical patterns. When you correct a categorization, Puzzle captures that signal and builds automated rules that apply the same logic to future transactions — so the system gets more accurate the longer you use it. You don't need to set up rules manually from scratch; the AI generates them from your behavior and surfaces them for your review. For founders on Mercury, the live API feed means Puzzle is learning from real-time transaction metadata — not a periodic import — which accelerates the feedback loop.

Can AI automatically categorize transactions and close my books without me logging in every day?

Yes — with a direct bank API connection and AI-native accounting software, the categorization and reconciliation work happens in the background whether or not you log in. Puzzle connects to Mercury's API in real time, so every transaction that clears your account flows into your books automatically. Puzzle's AI then categorizes those transactions using merchant signals, memo text, and your historical patterns — without you triggering a sync or reviewing each one before it lands. When the AI confidence falls below the threshold for a given transaction, Puzzle flags it for your attention rather than guessing and leaving an error buried in your books.

The practical outcome: by the time you do log in — even if that's once a week — the bulk of your transactions are already categorized, your bank balance reconciles against your accounting system, and your burn rate and cash position reflect the actual state of your account. Month-end close becomes a review process, not a data-entry process. Founders using Puzzle typically spend around 15 to 20 minutes per week confirming AI-categorized transactions rather than hours manually entering and matching them. The books stay current in the background; you decide when to review them.

How does Puzzle handle payroll journal entries for payroll providers without a native integration, like ADP?

Puzzle has native payroll integrations with Gusto, Rippling, and Deel — those sync automatically and Puzzle drafts the journal entries for you. For providers without a native connection (ADP, Paychex, Justworks, and others), Puzzle's AI payroll agent takes a different approach: you upload the payroll report or PDF, and the agent reads the file and automatically drafts the corresponding journal entries. You review and confirm before anything posts to your books. This means you get structured, accurate payroll entries without manually mapping every line item from a spreadsheet — even if your payroll provider isn't on Puzzle's direct integration list. One thing worth noting: ADP and Paychex are permanently off the native integration roadmap, so the upload-and-draft workflow is the long-term path for those providers, not a temporary gap.

How does Puzzle handle revenue recognition when a Stripe invoice is issued but payment comes in via bank transfer outside Stripe — and why does this cause double counting?

This is one of the more common rev-rec friction points for SaaS founders. The scenario: you issue an invoice through Stripe, which creates an accounts receivable entry in Puzzle. The customer then pays by ACH or wire transfer directly to your Mercury account — a transaction that also flows into Puzzle through the bank API. If Puzzle doesn't know these two events are the same payment, it records both: the Stripe invoice as revenue, and the incoming bank deposit as additional revenue. The result is double counting.

The fix is matching the bank deposit to the open Stripe invoice so Puzzle clears the AR balance rather than treating the deposit as new revenue. Puzzle's payment matching workflow handles this, but it requires the two events to be explicitly linked — either through automatic matching rules you configure, or a manual match during your review. If Stripe is your primary billing system and you routinely accept payment outside it, setting up those matching rules early prevents the double count from compounding across your entire AR balance. This is also why Puzzle's revenue recognition is described as Stripe-centric: the full automation applies when billing and payment both flow through Stripe. When they don't, the matching step requires your attention.

How does Puzzle give me real-time visibility into profit and loss, including on a per-job or per-project basis?

Puzzle updates your P&L daily as transactions flow in from connected accounts — so instead of waiting for a bookkeeper to run a report, you can see revenue, expenses, and net income in near real-time without logging in to trigger a refresh. Your cash position, burn rate, and runway update on the same cycle.

For per-job or per-project P&L, Puzzle supports class and location tracking (Complete plan and above), which lets you tag transactions, vendors, and expenses to a specific project, customer, or cost center. Once you assign a class or department tag to a vendor, Puzzle automatically applies it to future transactions from that source — so project-level tracking doesn't require manually tagging every line item. You can then filter your P&L by class to see profitability per job, per customer, or per location. If you need customer-level profit and loss specifically, Puzzle also supports customer-level P&L tracking as a standalone capability. For multi-location or multi-entity businesses, this gives you a consolidated view and a segmented view from the same dataset.

Is Puzzle a good fit if my business needs inventory tracking or a POS integration?

No — and it's worth being direct about this. Puzzle has no inventory management module, and that's a permanent product boundary, not a gap on the roadmap. If your business model depends on tracking COGS at the inventory or item level — e-commerce, retail, food service, hardware manufacturing, or any business that needs a POS system reconciling against inventory counts — Puzzle is not the right fit at this stage. Forcing an inventory-heavy business into a tool without an inventory module creates reconciliation problems that compound over time.

Where Puzzle is well-sized: SaaS companies, professional services firms, and tech-forward startups where revenue is service- or subscription-based and COGS is primarily headcount and software. If that describes your business now but you expect to add physical product lines later, plan for a migration at that point rather than assuming Puzzle will grow into inventory support — it won't.

How do founders use real-time financial data in Puzzle differently from waiting on reports from a traditional bookkeeper?

The traditional bookkeeper model runs on a cycle: transactions accumulate for a month, a bookkeeper reconciles and categorizes them after month-end, and you get a report two to four weeks after the period closed. By the time you see the numbers, you're making decisions based on last month's reality. If your burn accelerated in week three, you don't find out until week six.

Puzzle inverts that model. Because Mercury's API feeds transactions into Puzzle in real time and Puzzle's AI categorizes them continuously, your burn rate, cash position, and P&L reflect what happened today — not what happened last month. You don't wait for a deliverable; you check a number you already trust. Founders using Puzzle typically spend around 15 to 20 minutes per week confirming AI-categorized transactions rather than reviewing a monthly report they had no hand in building. The books stay current in the background; the monthly close becomes a review and sign-off, not a reconstruction. For founders making hiring decisions, fundraising timelines, or spend calls in real time, the difference between today's data and last month's data isn't cosmetic — it's the difference between catching a problem and discovering it too late.

How does Puzzle handle bank account syncing when personal and business accounts share the same bank login, and how do I remove incorrectly imported transactions?

If your personal and business accounts are held at the same bank and accessed through a single login, Puzzle will surface all accounts available through that connection during setup — you choose which ones to sync. Only the accounts you explicitly select are imported into your books. If a personal account gets connected by mistake and transactions flow in, you can remove those transactions directly in Puzzle and disconnect the account from your settings. The underlying rule: Puzzle pulls from whatever the bank's API exposes, but you control which accounts are active. If you're unsure whether a connection pulled in the wrong account, check your connected accounts list in Puzzle settings before transactions accumulate.

How does automated transaction categorization work in modern accounting software?

Modern AI-native accounting software categorizes transactions by reading multiple signals at once: the merchant name, the transaction description or memo, the dollar amount, the counterparty type, and your company's historical behavior for similar transactions. When a transaction matches a pattern the system has seen before — a recurring SaaS subscription, a payroll deposit, a vendor you pay monthly — the AI assigns the category automatically and logs the rule so future transactions from the same source get the same treatment.

Where older tools like QuickBooks use rule-based matching that a human must configure and maintain, AI-native tools like Puzzle build and refine those rules from your own transaction history. When you correct a categorization, Puzzle captures that signal and applies it going forward — so accuracy compounds over time without manual setup. The AI also runs a confidence check on every categorization: if the signal is ambiguous, Puzzle assigns no category and flags the transaction for review rather than guessing and leaving an error in your books. That design choice — flagging uncertainty instead of hiding it — is what makes auto-match rates in the 90-to-99-percent range meaningful rather than just a headline. The remaining transactions land in a review queue, not scattered invisibly across your chart of accounts.

For founders on Mercury, this process runs on live transaction metadata pulled through the API — not on a batch import from the prior night — so the categorization happens closer to real time and the feedback loop between corrections and future accuracy is faster.

How does Puzzle match a single bulk bank deposit to multiple individual customer invoice payments — for example, a Stripe payout covering many invoices, or a batch of checks?

Stripe payouts and similar bulk deposits are a common friction point: one deposit hits your Mercury account, but it represents dozens of individual customer payments. Puzzle handles this through its payment matching and revenue recognition workflows. When a Stripe payout lands, Puzzle can split the deposit and match each portion to the corresponding open invoice — so your accounts receivable clears correctly and each customer's payment is recorded individually, not as a single lump sum. For check batches, the same logic applies: you can apply one deposit to multiple invoices manually, or set rules that automate the match for recurring patterns. If you're running Stripe through Mercury, the metadata Puzzle pulls from Mercury's API — including Stripe payout breakdowns — makes this matching more accurate than a bank feed that only shows the net deposit amount.

How do I automate revenue recognition for my SaaS company without using spreadsheets?

The spreadsheet problem in SaaS revenue recognition is structural: you're manually tracking when deferred revenue should flip to recognized revenue across hundreds of subscriptions, often in a separate file that drifts out of sync with your actual books. The fix is accounting software that reads your billing data directly and applies rev-rec rules at the invoice line-item level — so the deferral and recognition happen automatically as time passes, not when someone updates a spreadsheet.

Puzzle handles this for Stripe-based SaaS companies natively. You set a revenue recognition policy by product or subscription type — annual prepay, monthly, milestone-based — and Puzzle defers the revenue to the correct period and recognizes it on schedule without manual journal entries. When a customer upgrades, downgrades, or cancels, the recognition schedule updates automatically. The deferred revenue balance on your balance sheet and the recognized revenue on your P&L stay in sync because they're driven by the same source data, not a parallel spreadsheet someone has to remember to update.

A few constraints worth knowing: Puzzle's revenue recognition is Stripe-centric, so if you bill through another platform (Chargebee, Maxio, Recurly), you'll need manual journal entries for those invoices — the automation applies to Stripe billing. If you're evaluating revenue recognition software for subscription businesses, purpose-built tools like Maxio or Chargebee's own recognition module go deeper on complex multi-element arrangements and contract modifications, but come with ERP-level complexity. For a pre-seed to Series B SaaS company running Stripe, Puzzle's native rev-rec removes the spreadsheet entirely without adding that overhead.

How does Puzzle handle PDF bank statement imports and categorize transactions without a live bank feed?

When a live API connection isn't available, Puzzle's AI Close feature can ingest PDF bank statements directly — no manually prepared CSV template required. Puzzle extracts transactions from the PDF, runs them through the same AI categorization engine, and applies your existing rules and historical patterns to assign GL categories. You review what the AI flagged rather than entering data from scratch. For banks with a native API integration like Mercury, you don't need PDF imports at all — transactions flow in automatically. PDF import is most useful for legacy banks, credit cards, or one-time imports of historical statements.

How does Puzzle's AI Close agent handle reconciliation when transactions come in manually rather than through a live integration?

Puzzle's AI Close agent is designed to work across both live feeds and manual imports. When transactions are imported via PDF or CSV rather than a real-time API, the AI Close agent applies the same pre-reconciliation validation checks, compares your accounting system balances against the imported statement data, and flags discrepancies for your review — the workflow is structurally the same. For a broader look at how to structure AI agent workflows for month-end close, that guide covers the full sequencing. The difference is cadence: with a live Mercury integration, reconciliation can happen continuously; with manual imports, it runs when you upload. Bottom line — manual import doesn't break the automated close workflow, it just means you trigger it rather than the connection triggering it for you.

What's the difference between a basic financial dashboard and an automated close workflow with AI agents?

A financial dashboard shows you where things stand — cash balance, burn rate, runway. It's read-only and only as current as your last sync or manual update. An automated close workflow with AI agents actually does the work: it pulls in transactions, categorizes them, runs validation checks, flags anomalies, and produces a reconciled close — without you logging in to kick anything off. For a founder without a full-time bookkeeper, the practical difference is this: a dashboard tells you your runway is 8 months; an AI close workflow makes sure the number is accurate before you see it. For a step-by-step breakdown of what that process looks like, the month-end close guide for startup founders covers each stage. The Puzzle + Mercury API integration puts you in the second category — your books update in real time and the month-end close is largely automated before you touch it.

How reliable are live bank connections in accounting software?

Most accounting tools connect to banks through third-party aggregators like Plaid or Finicity, which introduces a layer of dependency outside the software vendor's control — connection drops and re-authentication prompts are a known friction point. Puzzle's Mercury integration is a direct API connection, not an aggregator relay, which removes that intermediary layer and gives the connection more stability. Mercury's API infrastructure is built for fintech-grade reliability, and with Mercury's conditional OCC approval to establish a national bank charter (April 2026), the underlying infrastructure is moving toward tighter institutional control. If uptime metrics matter to your firm, ask vendors whether their connections go through an aggregator or a direct API — the answer tells you most of what you need to know.

How does the chart of accounts migration work in Puzzle, including bank account connections and the account-merging step?

Migrating your chart of accounts to Puzzle involves three steps: importing your existing COA structure, connecting your bank accounts, and resolving any duplicate or overlapping accounts through the account-merging step. When you import from QuickBooks or another system, Puzzle maps your existing accounts to its default COA and flags accounts that look like duplicates or near-matches — you review and confirm merges before anything is finalized. Bank account connections happen in the same setup flow: you authorize Mercury (or another supported bank) via the API, and Puzzle links the connected account to the corresponding balance sheet account in your COA. The merging step matters most if you're migrating mid-year with historical balances — Puzzle walks you through reconciling opening balances so your books are clean from day one, not just from the migration date forward. If you're migrating from a system with a heavily customized COA, it's worth doing a dry run before your target go-live date to catch any mapping gaps.

Stay tuned for more guides from our Fintech for Founders series!

Let us help you solve your financial puzzles.

Thank you for being part of our Puzzle community. Stay tuned!
Oops! Something went wrong while submitting the form.
You can unsubscribe at any anytime.

Newsroom