Blog
How bank statements are laid out, what their codes mean, and how to get yours into a spreadsheet whose balances add up.
-
Bank Statement Loans: How Lenders Work Out Your Income from Deposits
A bank statement loan uses 12 or 24 months of deposits as your income. How lenders do the math, what they leave out, and how to check your figure first.
-
Large Deposits on a Mortgage: Find Them Before the Lender Does
What counts as a large deposit on a mortgage application, what a letter of explanation says, and how to find every large deposit in your bank statements first.
-
Catch-Up Bookkeeping: A Year of Bank Statement PDFs in One Spreadsheet
Behind on the books? Find the months you are missing, turn the bank statement PDFs into rows, and get them into QuickBooks or Excel without duplicates.
-
Bank Statements for Schedule C: From PDF to Totals
Turn a year of bank statement PDFs into one spreadsheet that totals your business income and expenses for Schedule C. 15 pages free.
-
US Bank Statement Codes: What ACH, PPD, POS and the Rest Mean
The codes US banks print beside each transaction, from ACH, PPD and CCD to POS, Zelle and NSF, what each one means, and where it lands in your spreadsheet.
-
Free Bank Reconciliation Template for Excel
A free Excel bank reconciliation template that checks every statement balance and reconciles it to your books. Download it, no email needed.
-
Bank Statements for a Mortgage: Check Them Before the Lender
A lender reads your bank statements for income, outgoings and warning signs. Turn the PDFs into a spreadsheet and see what they will see first.
-
Bank Statements for Self Assessment: From PDF to Totals
Turn a tax year of bank statement PDFs into a spreadsheet that totals your income and expenses for Self Assessment. 15 pages free.
-
BankPDFtoXLS vs DocuClipper: Which Statement Converter?
How BankPDFtoXLS and DocuClipper compare for converting bank statement PDFs: trying them, paying, what you download, and which one suits you.
-
How to Import a Bank Statement PDF into FreeAgent
FreeAgent uploads a bank statement as CSV, OFX or QIF, not PDF. Turn the PDF into the exact CSV FreeAgent reads, upload it, and check it.
-
Rental Income from Bank Statements: A Landlord's Guide
Total a year of rent and property expenses from bank statement PDFs, for your Self Assessment return or your Making Tax Digital records.
-
How to Import a Bank Statement PDF into QuickBooks Online
QuickBooks Online uploads bank transactions from a CSV with three or four columns, not a PDF. How to make that file from your statement and upload it.
-
How to Import a Bank Statement PDF into Xero
Xero imports a bank statement as CSV, not PDF. Turn the PDF into the three-column file Xero reads, import it, and check it balances. 15 pages free.
-
Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
The short codes banks print beside each transaction, from DD and BGC to POS and NEFT, what each one means, and where it lands in a spreadsheet.
-
How to Convert a Bank Statement PDF to Excel
Copying and pasting, Excel's own PDF import, and a converter built for statements. What each one gets right, and how to check the result.
-
Why a Converted Bank Statement Does Not Balance
Each balance should equal the one before it, plus money in, minus money out. Why converted statements break that rule, and how to find the row.