<?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: Petrovich</title>
    <description>The latest articles on DEV Community by Petrovich (@backfillstatements).</description>
    <link>https://dev.to/backfillstatements</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%2F4256380%2Ff89efb13-199e-4170-bc44-f4018fa9b624.png</url>
      <title>DEV Community: Petrovich</title>
      <link>https://dev.to/backfillstatements</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/backfillstatements"/>
    <language>en</language>
    <item>
      <title>Indian bank statement PDF to Excel: handling Cr/Dr, lakh commas and DD-MM-YYYY dates</title>
      <dc:creator>Petrovich</dc:creator>
      <pubDate>Fri, 20 Nov 2026 21:59:57 +0000</pubDate>
      <link>https://dev.to/backfillstatements/indian-bank-statement-pdf-to-excel-handling-crdr-lakh-commas-and-dd-mm-yyyy-dates-2p93</link>
      <guid>https://dev.to/backfillstatements/indian-bank-statement-pdf-to-excel-handling-crdr-lakh-commas-and-dd-mm-yyyy-dates-2p93</guid>
      <description>&lt;p&gt;Converting an Indian bank statement PDF to Excel or CSV breaks most generic converters in three predictable places. If you are writing your own parser (or choosing a tool), test these first.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Lakh/crore digit grouping
&lt;/h2&gt;

&lt;p&gt;Indian statements print &lt;code&gt;1,23,456.78&lt;/code&gt;, not &lt;code&gt;123,456.78&lt;/code&gt;. A regex that expects groups of three digits after each comma silently drops these rows. Accept groups of two or three:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="no"&gt;AMOUNT&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="o"&gt;/^&lt;/span&gt;\&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;?&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;\&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;?:&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;\&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="o"&gt;*|&lt;/span&gt;\&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="o"&gt;+&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;\&lt;span class="p"&gt;.&lt;/span&gt;\&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;\&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="o"&gt;?&lt;/span&gt;\&lt;span class="n"&gt;s&lt;/span&gt;&lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nc"&gt;Cr&lt;/span&gt;&lt;span class="o"&gt;|&lt;/span&gt;&lt;span class="nc"&gt;Dr&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="o"&gt;?&lt;/span&gt;$&lt;span class="o"&gt;/&lt;/span&gt;&lt;span class="n"&gt;i&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. Cr / Dr instead of minus signs
&lt;/h2&gt;

&lt;p&gt;Many statements have a single Amount column with a &lt;code&gt;Cr&lt;/code&gt; or &lt;code&gt;Dr&lt;/code&gt; suffix, and the Balance column can also be &lt;code&gt;Dr&lt;/code&gt; when the account is overdrawn. Treat &lt;code&gt;Dr&lt;/code&gt; as negative for the amount, and as a negative balance in the balance column.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. DD-MM-YYYY dates
&lt;/h2&gt;

&lt;p&gt;&lt;code&gt;03-04-2026&lt;/code&gt; is 3 April, not March 4. Detect the order across the whole statement: if any first component is above 12 it is day-first. If every date is ambiguous, default to day-first for Indian banks and let the user flip it.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Verify with the running balance
&lt;/h2&gt;

&lt;p&gt;The most useful check is free, because every statement prints it:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;previous balance + amount == this row's balance
opening balance + total == closing balance
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;If every row passes, nothing was dropped or misread. If a sign is ambiguous, the balance change tells you whether the row was a credit or a debit.&lt;/p&gt;

&lt;h2&gt;
  
  
  A ready-made option
&lt;/h2&gt;

&lt;p&gt;Disclosure: I built &lt;a href="https://backfill-statements.pages.dev" rel="noopener noreferrer"&gt;Backfill&lt;/a&gt;, which handles all of the above. It runs in the browser (the PDF is never uploaded, useful for client statements), opens password-protected PDFs, verifies every row against the balance column, and exports CSV/Excel, OFX or QIF. Preview and verification are free.&lt;/p&gt;

&lt;p&gt;It reads digital PDFs downloaded from net banking; scanned copies are not supported yet.&lt;/p&gt;

&lt;p&gt;If your bank's layout trips it up, share the column headers (no personal data) in the comments.&lt;/p&gt;

</description>
      <category>javascript</category>
    </item>
    <item>
      <title>Convert a PDF bank statement to QIF for Quicken (and check it balances before you import)</title>
      <dc:creator>Petrovich</dc:creator>
      <pubDate>Fri, 20 Nov 2026 21:59:10 +0000</pubDate>
      <link>https://dev.to/backfillstatements/convert-a-pdf-bank-statement-to-qif-for-quicken-and-check-it-balances-before-you-import-4ml5</link>
      <guid>https://dev.to/backfillstatements/convert-a-pdf-bank-statement-to-qif-for-quicken-and-check-it-balances-before-you-import-4ml5</guid>
      <description>&lt;p&gt;Quicken imports QIF, QFX and OFX, but banks often only give you &lt;strong&gt;PDF statements&lt;/strong&gt; for anything older than a few months. If you are rebuilding a year of history, typing it in is not an option.&lt;/p&gt;

&lt;h2&gt;
  
  
  What a QIF file looks like
&lt;/h2&gt;

&lt;p&gt;QIF is plain text, which makes it easy to generate:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;!Type:Bank
D03/01/2026
T-54.20
PGrocery Mart
^
D03/02/2026
T2540.00
PPayroll ACME
^
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;D&lt;/code&gt; date (MM/DD/YYYY is the safest choice for Quicken)&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;T&lt;/code&gt; amount, negative for money out&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;P&lt;/code&gt; payee&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;^&lt;/code&gt; ends each transaction&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Getting the rows out of the PDF
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Copy-paste into a spreadsheet&lt;/strong&gt;, fix the columns, then build the QIF lines with a formula like &lt;code&gt;="D"&amp;amp;TEXT(A2,"mm/dd/yyyy")&lt;/code&gt;. Fine for one short statement.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Script it&lt;/strong&gt; with pdfplumber or pdf.js: group text by its y-position into rows, detect the date at the start of each row, assign amounts to the Debit/Credit/Balance column by x-position, and join wrapped description lines.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Use a converter.&lt;/strong&gt; Disclosure: I made &lt;a href="https://backfill-statements.pages.dev" rel="noopener noreferrer"&gt;Backfill&lt;/a&gt;, which does step 2 in your browser (nothing is uploaded) and exports QIF, OFX or CSV.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  The step people skip: reconcile before importing
&lt;/h2&gt;

&lt;p&gt;Once Quicken has 300 imported transactions, finding one misread amount is miserable. Check first:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;opening balance + sum(transactions) == closing balance
previous row balance + amount == this row balance   (for every row)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;If both hold, the conversion is complete and correct to the cent. Backfill shows this as a green badge and highlights any row that breaks the chain.&lt;/p&gt;

&lt;h2&gt;
  
  
  Importing into Quicken
&lt;/h2&gt;

&lt;p&gt;File → File Import → QIF File → pick the account. Import one statement first and compare the ending balance with the paper statement before doing the rest.&lt;/p&gt;

&lt;p&gt;Questions about a specific bank layout? Leave the column headers (no personal data) in the comments.&lt;/p&gt;

</description>
      <category>productivity</category>
    </item>
    <item>
      <title>How to import old PDF bank statements into YNAB, Actual Budget or GnuCash (without uploading them anywhere)</title>
      <dc:creator>Petrovich</dc:creator>
      <pubDate>Fri, 20 Nov 2026 21:33:58 +0000</pubDate>
      <link>https://dev.to/backfillstatements/how-to-import-old-pdf-bank-statements-into-ynab-actual-budget-or-gnucash-without-uploading-them-34de</link>
      <guid>https://dev.to/backfillstatements/how-to-import-old-pdf-bank-statements-into-ynab-actual-budget-or-gnucash-without-uploading-them-34de</guid>
      <description>&lt;p&gt;Budgeting apps are great at importing &lt;em&gt;new&lt;/em&gt; transactions: you link the bank and they flow in. The pain is the &lt;strong&gt;past&lt;/strong&gt;. You start YNAB in July and want January–June. You switch apps and the old history is gone. Your bank only keeps 90 days of CSV export, but gives you years of PDF statements.&lt;/p&gt;

&lt;p&gt;YNAB, Actual Budget, GnuCash and Quicken all import &lt;strong&gt;CSV, OFX or QIF&lt;/strong&gt;. None of them read PDFs. Here are the options, from free-and-manual to automated.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 1: Ask the bank for CSV/OFX (free, often impossible)
&lt;/h2&gt;

&lt;p&gt;Look for "Export", "Download transactions" or "Quicken/QFX" in online banking. Many banks limit this to the last 90–180 days, which is why most people end up with PDFs.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 2: Copy-paste into a spreadsheet (free, painful)
&lt;/h2&gt;

&lt;p&gt;Select the table in the PDF, paste into Excel/Sheets, fix the broken columns, then save as CSV with the columns your app expects. For YNAB:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight csvs"&gt;&lt;code&gt;&lt;span class="nc"&gt;Date&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Payee&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Memo&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Outflow&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Inflow&lt;/span&gt;
&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;03&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;01&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Grocery&lt;/span&gt; &lt;span class="nc"&gt;Mart&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mf"&gt;54.20&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;03&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;02&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="nc"&gt;Payroll&lt;/span&gt; &lt;span class="no"&gt;ACME&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mf"&gt;2540.00&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Plain numbers (no currency symbols or thousands separators), one date format, and a real payee name so auto-categorisation works.&lt;/p&gt;

&lt;p&gt;The catch: a 3-page statement is ~60 rows, and PDF text often comes out with wrapped descriptions, merged columns and debits/credits in the wrong place. One missed row and your balance is off forever.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 3: Python + pdfplumber (free, for developers)
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pdfplumber&lt;/span&gt;
&lt;span class="k"&gt;with&lt;/span&gt; &lt;span class="n"&gt;pdfplumber&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nb"&gt;open&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"statement.pdf"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pdf&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;rows&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;r&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;pdf&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;pages&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;extract_table&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="ow"&gt;or&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Fine for one bank's layout; each bank needs its own tweaks (date formats, Cr/Dr markers, (45.00) negatives, Indian 1,23,456.78 grouping, multi-line descriptions).&lt;/p&gt;

&lt;h2&gt;
  
  
  The trick that makes any method trustworthy: reconcile against the balances
&lt;/h2&gt;

&lt;p&gt;Whatever you use, check the result against the statement itself:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;opening balance + sum(all transactions) == closing balance
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;and, if there is a running balance column, previous balance + amount == this row's balance, for every row. If both hold, you didn't drop or misread a single transaction. If one row fails, you know exactly where to look.&lt;/p&gt;

&lt;h2&gt;
  
  
  Option 4: A tool that does all of the above in the browser
&lt;/h2&gt;

&lt;p&gt;Disclosure: I built this one. &lt;strong&gt;&lt;a href="https://backfill-statements.pages.dev" rel="noopener noreferrer"&gt;Backfill&lt;/a&gt;&lt;/strong&gt; converts a PDF statement to YNAB CSV, OFX (Actual, GnuCash, Xero), QIF (Quicken) or plain CSV, and runs the reconciliation above automatically: green if it matches to the cent, red rows if not.&lt;/p&gt;

&lt;p&gt;It runs entirely client-side (pdf.js), so the statement never leaves your machine; load the page, turn off Wi-Fi and it still works. Preview and reconciliation are free; full exports are a small one-time payment. It doesn't handle scanned statements yet.&lt;/p&gt;

&lt;h2&gt;
  
  
  Importing the file
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;YNAB&lt;/strong&gt;: account → Import → pick the CSV → confirm the date format. Rows arrive unapproved, so nothing hits your budget silently.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Actual Budget&lt;/strong&gt;: account → Import → OFX/QIF/CSV. OFX keeps stable IDs, so re-importing won't duplicate.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;GnuCash&lt;/strong&gt;: File → Import → Import OFX/QFX.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Quicken&lt;/strong&gt;: File → File Import → QIF.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If your bank's layout breaks any of these approaches, post the (anonymised) column headers in the comments and I'll take a look.&lt;/p&gt;

</description>
      <category>productivity</category>
    </item>
  </channel>
</rss>
