Articles and updates on bank statement conversion, reconciliation and automation.
Cash App reports business payments to the IRS on a Form 1099-K once you pass the threshold, which the 2025 law reset to more than $20,000 and 200 transactions. Here is who gets a form and what to do.
Read articleACH and wire transfers both move money electronically, but they differ in speed, cost, reversibility, and how they read on your statement. Here is how to tell them apart and categorize each.
Read articleA bank statement is a cash-basis record: it shows money only when it moves. Here is how cash basis and accrual accounting differ, why accrual books never match your statement, and how to pick one.
Read articleAn intraday bank statement is an interim report of transactions posted so far today, delivered before the end-of-day statement. Learn the MT942, camt.052, and BAI2 formats and how to convert them.
Read articleAn MT940 file is a plain-text SWIFT bank statement built from numbered colon tags. Learn to read tags 20, 25, 60F, 61, 86, and 62F, and how to decode a statement line.
Read articleCopy a bank statement PDF into Excel and everything jams into one cell with the numbers stored as text. Here is why it happens and three ways to fix the columns.
Read articleThe best software to categorize bank transactions automatically depends on your volume: a converter with built-in categorization for statement PDFs, accounting bank rules for live feeds, or an expense platform for receipts and cards.
Read articleExcel's Power Query can pull a PDF into a sheet with Get Data, From PDF, but borderless bank statement tables often break the columns. Here is the exact process and where it falls apart.
Read articleCategorize bank transactions in Excel by adding a Category column, then auto-assigning categories with a keyword lookup that matches words in each description, and summing the totals with a PivotTable.
Read articleMT940 is an end-of-day SWIFT statement with final booked balances. MT942 is an interim, intraday transaction report with no closing balance. You reconcile against MT940 and track cash intraday with MT942.
Read articleFrom the same family of tools
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
