<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Danish Zulfiqar</title>
    <description>The latest articles on DEV Community by Danish Zulfiqar (@danishzulfiqar).</description>
    <link>https://dev.to/danishzulfiqar</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1479185%2F69b162e9-54e9-4519-b22a-e43736ea275d.png</url>
      <title>DEV Community: Danish Zulfiqar</title>
      <link>https://dev.to/danishzulfiqar</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/danishzulfiqar"/>
    <language>en</language>
    <item>
      <title>I built a finance engine that reconciles bank emails, SMS and PDF statements into one ledger</title>
      <dc:creator>Danish Zulfiqar</dc:creator>
      <pubDate>Fri, 13 Nov 2026 18:08:17 +0000</pubDate>
      <link>https://dev.to/danishzulfiqar/i-built-a-finance-engine-that-reconciles-bank-emails-sms-and-pdf-statements-into-one-ledger-69</link>
      <guid>https://dev.to/danishzulfiqar/i-built-a-finance-engine-that-reconciles-bank-emails-sms-and-pdf-statements-into-one-ledger-69</guid>
      <description>&lt;p&gt;Every month I had the same problem: my money lives in three places — &lt;strong&gt;HBL&lt;/strong&gt;, &lt;strong&gt;ABL&lt;/strong&gt; and &lt;strong&gt;NayaPay&lt;/strong&gt; — and no single app shows the whole picture. Transfers arrive as emails, card spends arrive as SMS, and the "official" record only shows up weeks later in a PDF statement.&lt;/p&gt;

&lt;p&gt;So I built &lt;strong&gt;FinSync&lt;/strong&gt;: a personal finance engine that pulls transactions from every channel, collapses duplicates, reconciles them against bank statements, and turns it all into one clean ledger with analytics and a forecast.&lt;/p&gt;

&lt;p&gt;👉 &lt;strong&gt;Live demo (no signup):&lt;/strong&gt; &lt;a href="https://finsync-green.vercel.app" rel="noopener noreferrer"&gt;https://finsync-green.vercel.app&lt;/a&gt; — click &lt;strong&gt;"View live demo"&lt;/strong&gt;&lt;br&gt;
👉 &lt;strong&gt;Source:&lt;/strong&gt; &lt;a href="https://github.com/danishzulfiqar/FinSync" rel="noopener noreferrer"&gt;https://github.com/danishzulfiqar/FinSync&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxyqhyffwq80691k2ohgl.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxyqhyffwq80691k2ohgl.png" alt="FinSync dashboard" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;


&lt;h2&gt;
  
  
  The problem: no bank APIs in Pakistan
&lt;/h2&gt;

&lt;p&gt;In the US or Europe, a budgeting app connects to your bank in two clicks through &lt;strong&gt;Plaid&lt;/strong&gt;, &lt;strong&gt;TrueLayer&lt;/strong&gt; or a PSD2 open-banking API. In Pakistan, none of that exists for everyday users:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;No public APIs.&lt;/strong&gt; Banks don't offer developer APIs to read your own account data.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;No aggregators.&lt;/strong&gt; There's no Plaid-style service that supports local banks, so global apps like YNAB or Mint simply can't connect.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;No clean exports.&lt;/strong&gt; Most banks give you a PDF statement — not a CSV — and only for past months.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;So your own financial data is locked inside three separate apps, and the only things the banks &lt;em&gt;do&lt;/em&gt; hand you are the notifications they already send: &lt;strong&gt;SMS alerts, emails and PDF statements&lt;/strong&gt;. FinSync is built entirely on those — the data you already legitimately receive — without scraping banking apps, reverse-engineering private APIs or ever asking for a password or OTP.&lt;/p&gt;
&lt;h2&gt;
  
  
  The real problem: one payment, three copies
&lt;/h2&gt;

&lt;p&gt;A single card payment can reach me as:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;a &lt;strong&gt;real-time SMS&lt;/strong&gt; (merchant, exact time, no balance),&lt;/li&gt;
&lt;li&gt;a &lt;strong&gt;notification email&lt;/strong&gt; (reference number, sender name), and&lt;/li&gt;
&lt;li&gt;a &lt;strong&gt;statement line&lt;/strong&gt; a month later (running balance, generic description, posting date — not the transaction time).&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Naively importing all three triples your spending. Naively deduplicating on amount + date merges two genuinely different ₨1,500 payments on the same day. The interesting engineering is everything in between.&lt;/p&gt;
&lt;h2&gt;
  
  
  Architecture
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fmermaid.ink%2Fimg%2FJSV7aW5pdDogeyJ0aGVtZSI6ICJiYXNlIiwgInRoZW1lVmFyaWFibGVzIjogeyJmb250RmFtaWx5IjogIlRyZWJ1Y2hldCBNUywgVmVyZGFuYSwgQXJpYWwsIHNhbnMtc2VyaWYiLCAiZm9udFNpemUiOiAiMTZweCIsICJwcmltYXJ5Q29sb3IiOiAiI2ZmZmZmZiIsICJwcmltYXJ5Qm9yZGVyQ29sb3IiOiAiI2NiZDVlMSIsICJsaW5lQ29sb3IiOiAiIzY0NzQ4YiIsICJjbHVzdGVyQmtnIjogIiNmOGZhZmMiLCAiY2x1c3RlckJvcmRlciI6ICIjY2JkNWUxIiwgInRpdGxlQ29sb3IiOiAiIzBmMTcyYSJ9LCAiZmxvd2NoYXJ0IjogeyJjdXJ2ZSI6ICJiYXNpcyIsICJub2RlU3BhY2luZyI6IDI2LCAicmFua1NwYWNpbmciOiA0MCwgInBhZGRpbmciOiAxNH19fSUlCmZsb3djaGFydCBUQgoKICAgIHN1YmdyYXBoIEJBTktTWyIxIMK3IFdoYXQgUGFraXN0YW5pIGJhbmtzIGFscmVhZHkgc2VuZCDigJQgbm8gcHVibGljIEFQSXMiXQogICAgICAgIGRpcmVjdGlvbiBMUgogICAgICAgIEhCTF9TTVNbIjxiPkhCTDwvYj48YnIvPkNhcmQgJiB0cmFuc2ZlciBTTVMiXQogICAgICAgIEVNQUlMU1siPGI-SEJMIMK3IEFCTCDCtyBOYXlhUGF5PC9iPjxici8-QWxlcnQgZW1haWxzIl0KICAgICAgICBQREZbIjxiPkFsbCBiYW5rczwvYj48YnIvPk1vbnRobHkgUERGIHN0YXRlbWVudHMiXQogICAgICAgIEhCTF9TTVMgfn5-IEVNQUlMUyB-fn4gUERGCiAgICBlbmQKCiAgICBzdWJncmFwaCBJTkdFU1RbIjIgwrcgU2VjdXJlLCByZWFkLW9ubHkgaW5nZXN0aW9uIl0KICAgICAgICBkaXJlY3Rpb24gTFIKICAgICAgICBHQVRFV0FZWyI8Yj5BbmRyb2lkIFNNUyBHYXRld2F5PC9iPjxici8-SE1BQy1zaWduZWQgd2ViaG9vayJdCiAgICAgICAgR01BSUxbIjxiPkdtYWlsIEFQSTwvYj48YnIvPnJlYWQtb25seSBPQXV0aCJdCiAgICAgICAgVVBMT0FEWyI8Yj5TdGF0ZW1lbnQgdXBsb2FkPC9iPjxici8-cGRmcGx1bWJlciBwYXJzZXIiXQogICAgICAgIEdBVEVXQVkgfn5-IEdNQUlMIH5-fiBVUExPQUQKICAgIGVuZAoKICAgIHN1YmdyYXBoIEVOR0lORVsiMyDCtyBSZWNvbmNpbGlhdGlvbiBlbmdpbmUg4oCUIEZhc3RBUEkiXQogICAgICAgIGRpcmVjdGlvbiBMUgogICAgICAgIFBBUlNFWyI8Yj5QYXJzZTwvYj48YnIvPnBlci1iYW5rIHBhcnNlcnMiXQogICAgICAgIEZQWyI8Yj5GaW5nZXJwcmludDwvYj48YnIvPlNIQS0yNTYgaWRlbnRpdHkiXQogICAgICAgIERFRFVQKFsiPGI-RGVkdXBsaWNhdGU8L2I-PGJyLz5leGFjdCDCtyBwcm9iYWJsZSDCtyByZXZpZXciXSkKICAgICAgICBSRUNPTlsiPGI-UmVjb25jaWxlPC9iPjxici8-YWxlcnQg4oeEIHN0YXRlbWVudCJdCiAgICAgICAgQ0FUWyI8Yj5DYXRlZ29yaXplPC9iPjxici8-bGVhcm4tb25jZSBydWxlcyJdCiAgICAgICAgUEFSU0UgLS0-IEZQIC0tPiBERURVUCAtLT4gUkVDT04gLS0-IENBVAogICAgZW5kCgogICAgc3ViZ3JhcGggU1RPUkVbIjQgwrcgUG9zdGdyZVNRTCDigJQgb25lIHJvdyBwZXIgcmVhbCBldmVudCJdCiAgICAgICAgZGlyZWN0aW9uIExSCiAgICAgICAgU1JDWygiPGI-dHJhbnNhY3Rpb25fc291cmNlczwvYj48YnIvPmVtYWlsIMK3IFNNUyDCtyBzdGF0ZW1lbnQiKV0KICAgICAgICBUWFsoIjxiPnRyYW5zYWN0aW9uczwvYj48YnIvPnRoZSBzaW5nbGUgc291cmNlIG9mIHRydXRoIildCiAgICAgICAgU1JDIC0uICJtYW55IOKGkiBvbmUiIC4tPiBUWAogICAgZW5kCgogICAgc3ViZ3JhcGggQVBQWyI1IMK3IFJlYWN0IGRhc2hib2FyZCJdCiAgICAgICAgZGlyZWN0aW9uIExSCiAgICAgICAgTEVER0VSWyI8Yj5VbmlmaWVkIGxlZGdlcjwvYj4iXQogICAgICAgIEFOQUxZVElDU1siPGI-Q2FzaC1mbG93IGFuYWx5dGljczwvYj48YnIvPnRyYW5zZmVycyBleGNsdWRlZCJdCiAgICAgICAgRk9SRUNBU1RbIjxiPkJhbGFuY2UgZm9yZWNhc3Q8L2I-PGJyLz5Nb250ZS1DYXJsbyJdCiAgICAgICAgTEVER0VSIH5-fiBBTkFMWVRJQ1Mgfn5-IEZPUkVDQVNUCiAgICBlbmQKCiAgICAlJSBUaWVyLWxldmVsIGxpbmtzIGtlZXAgZWFjaCB0aWVyJ3MgbGVmdC10by1yaWdodCBsYXlvdXQgaW50YWN0LgogICAgQkFOS1MgLS0-IElOR0VTVAogICAgSU5HRVNUIC0tPiBFTkdJTkUKICAgIEVOR0lORSA9PT4gU1RPUkUKICAgIFNUT1JFID09PiBBUFAKCiAgICBjbGFzc0RlZiBiYW5rIGZpbGw6I2ZmZjdlZCxzdHJva2U6I2Y5NzMxNixzdHJva2Utd2lkdGg6MnB4LGNvbG9yOiM3YzJkMTIKICAgIGNsYXNzRGVmIGluZ2VzdCBmaWxsOiNlZmY2ZmYsc3Ryb2tlOiMzYjgyZjYsc3Ryb2tlLXdpZHRoOjJweCxjb2xvcjojMWUzYThhCiAgICBjbGFzc0RlZiBlbmdpbmUgZmlsbDojZjVmM2ZmLHN0cm9rZTojOGI1Y2Y2LHN0cm9rZS13aWR0aDoycHgsY29sb3I6IzRjMWQ5NQogICAgY2xhc3NEZWYgc3RvcmUgZmlsbDojZWNmZGY1LHN0cm9rZTojMTBiOTgxLHN0cm9rZS13aWR0aDoycHgsY29sb3I6IzA2NGUzYgogICAgY2xhc3NEZWYgYXBwIGZpbGw6I2YwZjlmZixzdHJva2U6IzBlYTVlOSxzdHJva2Utd2lkdGg6MnB4LGNvbG9yOiMwYzRhNmUKCiAgICBjbGFzcyBIQkxfU01TLEVNQUlMUyxQREYgYmFuawogICAgY2xhc3MgR0FURVdBWSxHTUFJTCxVUExPQUQgaW5nZXN0CiAgICBjbGFzcyBQQVJTRSxGUCxERURVUCxSRUNPTixDQVQgZW5naW5lCiAgICBjbGFzcyBUWCxTUkMgc3RvcmUKICAgIGNsYXNzIExFREdFUixBTkFMWVRJQ1MsRk9SRUNBU1QgYXBwCg%3D%3D%3Ftype%3Dpng%26bgColor%3D%21white%26width%3D1600" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fmermaid.ink%2Fimg%2FJSV7aW5pdDogeyJ0aGVtZSI6ICJiYXNlIiwgInRoZW1lVmFyaWFibGVzIjogeyJmb250RmFtaWx5IjogIlRyZWJ1Y2hldCBNUywgVmVyZGFuYSwgQXJpYWwsIHNhbnMtc2VyaWYiLCAiZm9udFNpemUiOiAiMTZweCIsICJwcmltYXJ5Q29sb3IiOiAiI2ZmZmZmZiIsICJwcmltYXJ5Qm9yZGVyQ29sb3IiOiAiI2NiZDVlMSIsICJsaW5lQ29sb3IiOiAiIzY0NzQ4YiIsICJjbHVzdGVyQmtnIjogIiNmOGZhZmMiLCAiY2x1c3RlckJvcmRlciI6ICIjY2JkNWUxIiwgInRpdGxlQ29sb3IiOiAiIzBmMTcyYSJ9LCAiZmxvd2NoYXJ0IjogeyJjdXJ2ZSI6ICJiYXNpcyIsICJub2RlU3BhY2luZyI6IDI2LCAicmFua1NwYWNpbmciOiA0MCwgInBhZGRpbmciOiAxNH19fSUlCmZsb3djaGFydCBUQgoKICAgIHN1YmdyYXBoIEJBTktTWyIxIMK3IFdoYXQgUGFraXN0YW5pIGJhbmtzIGFscmVhZHkgc2VuZCDigJQgbm8gcHVibGljIEFQSXMiXQogICAgICAgIGRpcmVjdGlvbiBMUgogICAgICAgIEhCTF9TTVNbIjxiPkhCTDwvYj48YnIvPkNhcmQgJiB0cmFuc2ZlciBTTVMiXQogICAgICAgIEVNQUlMU1siPGI-SEJMIMK3IEFCTCDCtyBOYXlhUGF5PC9iPjxici8-QWxlcnQgZW1haWxzIl0KICAgICAgICBQREZbIjxiPkFsbCBiYW5rczwvYj48YnIvPk1vbnRobHkgUERGIHN0YXRlbWVudHMiXQogICAgICAgIEhCTF9TTVMgfn5-IEVNQUlMUyB-fn4gUERGCiAgICBlbmQKCiAgICBzdWJncmFwaCBJTkdFU1RbIjIgwrcgU2VjdXJlLCByZWFkLW9ubHkgaW5nZXN0aW9uIl0KICAgICAgICBkaXJlY3Rpb24gTFIKICAgICAgICBHQVRFV0FZWyI8Yj5BbmRyb2lkIFNNUyBHYXRld2F5PC9iPjxici8-SE1BQy1zaWduZWQgd2ViaG9vayJdCiAgICAgICAgR01BSUxbIjxiPkdtYWlsIEFQSTwvYj48YnIvPnJlYWQtb25seSBPQXV0aCJdCiAgICAgICAgVVBMT0FEWyI8Yj5TdGF0ZW1lbnQgdXBsb2FkPC9iPjxici8-cGRmcGx1bWJlciBwYXJzZXIiXQogICAgICAgIEdBVEVXQVkgfn5-IEdNQUlMIH5-fiBVUExPQUQKICAgIGVuZAoKICAgIHN1YmdyYXBoIEVOR0lORVsiMyDCtyBSZWNvbmNpbGlhdGlvbiBlbmdpbmUg4oCUIEZhc3RBUEkiXQogICAgICAgIGRpcmVjdGlvbiBMUgogICAgICAgIFBBUlNFWyI8Yj5QYXJzZTwvYj48YnIvPnBlci1iYW5rIHBhcnNlcnMiXQogICAgICAgIEZQWyI8Yj5GaW5nZXJwcmludDwvYj48YnIvPlNIQS0yNTYgaWRlbnRpdHkiXQogICAgICAgIERFRFVQKFsiPGI-RGVkdXBsaWNhdGU8L2I-PGJyLz5leGFjdCDCtyBwcm9iYWJsZSDCtyByZXZpZXciXSkKICAgICAgICBSRUNPTlsiPGI-UmVjb25jaWxlPC9iPjxici8-YWxlcnQg4oeEIHN0YXRlbWVudCJdCiAgICAgICAgQ0FUWyI8Yj5DYXRlZ29yaXplPC9iPjxici8-bGVhcm4tb25jZSBydWxlcyJdCiAgICAgICAgUEFSU0UgLS0-IEZQIC0tPiBERURVUCAtLT4gUkVDT04gLS0-IENBVAogICAgZW5kCgogICAgc3ViZ3JhcGggU1RPUkVbIjQgwrcgUG9zdGdyZVNRTCDigJQgb25lIHJvdyBwZXIgcmVhbCBldmVudCJdCiAgICAgICAgZGlyZWN0aW9uIExSCiAgICAgICAgU1JDWygiPGI-dHJhbnNhY3Rpb25fc291cmNlczwvYj48YnIvPmVtYWlsIMK3IFNNUyDCtyBzdGF0ZW1lbnQiKV0KICAgICAgICBUWFsoIjxiPnRyYW5zYWN0aW9uczwvYj48YnIvPnRoZSBzaW5nbGUgc291cmNlIG9mIHRydXRoIildCiAgICAgICAgU1JDIC0uICJtYW55IOKGkiBvbmUiIC4tPiBUWAogICAgZW5kCgogICAgc3ViZ3JhcGggQVBQWyI1IMK3IFJlYWN0IGRhc2hib2FyZCJdCiAgICAgICAgZGlyZWN0aW9uIExSCiAgICAgICAgTEVER0VSWyI8Yj5VbmlmaWVkIGxlZGdlcjwvYj4iXQogICAgICAgIEFOQUxZVElDU1siPGI-Q2FzaC1mbG93IGFuYWx5dGljczwvYj48YnIvPnRyYW5zZmVycyBleGNsdWRlZCJdCiAgICAgICAgRk9SRUNBU1RbIjxiPkJhbGFuY2UgZm9yZWNhc3Q8L2I-PGJyLz5Nb250ZS1DYXJsbyJdCiAgICAgICAgTEVER0VSIH5-fiBBTkFMWVRJQ1Mgfn5-IEZPUkVDQVNUCiAgICBlbmQKCiAgICAlJSBUaWVyLWxldmVsIGxpbmtzIGtlZXAgZWFjaCB0aWVyJ3MgbGVmdC10by1yaWdodCBsYXlvdXQgaW50YWN0LgogICAgQkFOS1MgLS0-IElOR0VTVAogICAgSU5HRVNUIC0tPiBFTkdJTkUKICAgIEVOR0lORSA9PT4gU1RPUkUKICAgIFNUT1JFID09PiBBUFAKCiAgICBjbGFzc0RlZiBiYW5rIGZpbGw6I2ZmZjdlZCxzdHJva2U6I2Y5NzMxNixzdHJva2Utd2lkdGg6MnB4LGNvbG9yOiM3YzJkMTIKICAgIGNsYXNzRGVmIGluZ2VzdCBmaWxsOiNlZmY2ZmYsc3Ryb2tlOiMzYjgyZjYsc3Ryb2tlLXdpZHRoOjJweCxjb2xvcjojMWUzYThhCiAgICBjbGFzc0RlZiBlbmdpbmUgZmlsbDojZjVmM2ZmLHN0cm9rZTojOGI1Y2Y2LHN0cm9rZS13aWR0aDoycHgsY29sb3I6IzRjMWQ5NQogICAgY2xhc3NEZWYgc3RvcmUgZmlsbDojZWNmZGY1LHN0cm9rZTojMTBiOTgxLHN0cm9rZS13aWR0aDoycHgsY29sb3I6IzA2NGUzYgogICAgY2xhc3NEZWYgYXBwIGZpbGw6I2YwZjlmZixzdHJva2U6IzBlYTVlOSxzdHJva2Utd2lkdGg6MnB4LGNvbG9yOiMwYzRhNmUKCiAgICBjbGFzcyBIQkxfU01TLEVNQUlMUyxQREYgYmFuawogICAgY2xhc3MgR0FURVdBWSxHTUFJTCxVUExPQUQgaW5nZXN0CiAgICBjbGFzcyBQQVJTRSxGUCxERURVUCxSRUNPTixDQVQgZW5naW5lCiAgICBjbGFzcyBUWCxTUkMgc3RvcmUKICAgIGNsYXNzIExFREdFUixBTkFMWVRJQ1MsRk9SRUNBU1QgYXBwCg%3D%3D%3Ftype%3Dpng%26bgColor%3D%21white%26width%3D1600" alt="FinSync architecture: bank SMS, emails and PDF statements flow through secure read-only ingestion into a reconciliation engine, PostgreSQL and a React dashboard" width="1600" height="1827"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Five tiers, one direction of flow: the signals banks already send → read-only ingestion → a deterministic reconciliation engine → a ledger where every real event is exactly one row → analytics on top.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Backend:&lt;/strong&gt; Python 3.12, FastAPI, SQLAlchemy 2, Alembic, PostgreSQL, pdfplumber&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Frontend:&lt;/strong&gt; React 18, TypeScript, Vite, Tailwind, Recharts&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Infra:&lt;/strong&gt; Render (API), Neon (Postgres), Vercel (dashboard)&lt;/li&gt;
&lt;/ul&gt;
&lt;h2&gt;
  
  
  1. One transaction, many sources
&lt;/h2&gt;

&lt;p&gt;The key modelling decision: a financial event and the &lt;em&gt;evidence&lt;/em&gt; for it are different things.&lt;/p&gt;

&lt;p&gt;There's one &lt;code&gt;transactions&lt;/code&gt; table and a separate &lt;code&gt;transaction_sources&lt;/code&gt; table. When the same payment arrives via email &lt;em&gt;and&lt;/em&gt; SMS &lt;em&gt;and&lt;/em&gt; statement, those become three &lt;strong&gt;sources&lt;/strong&gt; attached to &lt;strong&gt;one&lt;/strong&gt; transaction — never three transactions. Each extra source raises the record's confidence and can fill in blank fields.&lt;/p&gt;
&lt;h2&gt;
  
  
  2. Deterministic fingerprints
&lt;/h2&gt;

&lt;p&gt;Every parsed event gets a SHA-256 fingerprint built from:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;provider + type + amount + currency + account_last4 + reference + rounded time bucket
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Ingestion then resolves to one of four outcomes:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Outcome&lt;/th&gt;
&lt;th&gt;Action&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;unique&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;create a new transaction&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;exact_duplicate&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;same fingerprint → attach the source only&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;probable_duplicate&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;same money, close in time → attach, raise confidence, enrich fields&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;needs_review&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;similar but conflicting reference → &lt;strong&gt;keep both&lt;/strong&gt; and flag&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;That last rule matters: when in doubt, FinSync never silently deletes money. Re-processing the same email or SMS is a no-op, guarded by unique source IDs and content hashes — so every sync is idempotent.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Reconciling alerts with statements
&lt;/h2&gt;

&lt;p&gt;Fingerprints can't catch the alert-vs-statement case, because the statement has a different date and often no reference. A separate reconciliation pass handles it:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;match by &lt;strong&gt;reference&lt;/strong&gt; when both sides have one (strong signal),&lt;/li&gt;
&lt;li&gt;otherwise the &lt;strong&gt;nearest time within a few days&lt;/strong&gt;, same direction and amount,&lt;/li&gt;
&lt;li&gt;keep the &lt;strong&gt;statement row&lt;/strong&gt; (it carries the authoritative running balance),&lt;/li&gt;
&lt;li&gt;enrich it with the alert's merchant and exact time, repoint the alert's source onto it, and drop the duplicate.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The result: balances that reconcile to the rupee, with the rich details from the real-time alerts.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1hrsie12vbw6gjexjq2y.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1hrsie12vbw6gjexjq2y.png" alt="Unified ledger" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Analytics and forecasting
&lt;/h2&gt;

&lt;p&gt;Once the ledger is clean, the fun part is easy:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;per-account balances anchored on the newest statement running balance,&lt;/li&gt;
&lt;li&gt;income/expense flows that &lt;strong&gt;exclude internal transfers&lt;/strong&gt; between my own accounts,&lt;/li&gt;
&lt;li&gt;"learn-once" categorization — re-categorize one merchant and every matching row follows,&lt;/li&gt;
&lt;li&gt;a Monte-Carlo balance forecast for the next few months.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fkjukl5j4wbbhzdgt31kn.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fkjukl5j4wbbhzdgt31kn.png" alt="Forecast" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Security: read-only by design
&lt;/h2&gt;

&lt;p&gt;Handling bank data means being strict about what &lt;em&gt;not&lt;/em&gt; to do:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Gmail access is &lt;strong&gt;read-only OAuth&lt;/strong&gt; (&lt;code&gt;gmail.readonly&lt;/code&gt;), nothing else.&lt;/li&gt;
&lt;li&gt;No scraping of banking apps, no private APIs, never stores passwords, OTPs, PINs or card numbers.&lt;/li&gt;
&lt;li&gt;Raw SMS text isn't persisted — only normalized fields plus a one-way hash for dedup.&lt;/li&gt;
&lt;li&gt;The SMS webhook is authenticated with HMAC-SHA256 and timestamp anti-replay.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What I learned
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Model evidence separately from facts.&lt;/strong&gt; The &lt;code&gt;transaction_sources&lt;/code&gt; split made every later feature simpler.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Make ingestion idempotent from day one.&lt;/strong&gt; Being able to re-run any sync safely is what makes debugging bearable.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Prefer "keep both and flag" over clever merging.&lt;/strong&gt; A false merge is far worse than a visible duplicate.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Test parsers with real (redacted) samples.&lt;/strong&gt; The test suite (71 tests) is mostly parser, dedup and reconciliation cases.&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;Try the demo at &lt;strong&gt;&lt;a href="https://finsync-green.vercel.app" rel="noopener noreferrer"&gt;https://finsync-green.vercel.app&lt;/a&gt;&lt;/strong&gt; and have a look at the code on &lt;strong&gt;&lt;a href="https://github.com/danishzulfiqar/FinSync" rel="noopener noreferrer"&gt;GitHub&lt;/a&gt;&lt;/strong&gt;. I'd love feedback — especially on the reconciliation strategy. How do &lt;em&gt;you&lt;/em&gt; deal with the same transaction showing up in multiple places?&lt;/p&gt;

</description>
      <category>showdev</category>
      <category>python</category>
      <category>react</category>
      <category>fastapi</category>
    </item>
  </channel>
</rss>
