AnyStatement blog
Straight answers about bank and credit card statements: checking them, getting them into your books or spreadsheet, and making sense of the numbers.
Import checks
9 min read
Keep bank references, account numbers and check numbers intact in Excel. Diagnose scientific notation, missing zeros and lost digits, then import as Text.
Read articleImport checks
9 min read
Fix a bank CSV that opens in one Excel column or shows garbled names. Check delimiters, decimal commas and encoding with a pasteable example.
Read articleHousehold money
9 min read
Total bank fees from a statement CSV in Excel: find charges, separate refunds, review unknown rows and use a checked example with SUMIFS formulas.
Read articleStatement basics
8 min read
Separate pending holds from posted purchases, explain changing amounts and dates, and choose the right CSV rows to reconcile your bank statement.
Read articleSharing records
7 min read
Black boxes can leave PDF text readable. Use applied redaction, check hidden information, and inspect the saved PDF or CSV before sharing a statement.
Read articleStatement records
7 min read
Read GOV.UK's 28-day funds and 31-day evidence wording, then check inclusive dates and daily balances with a fictional example. Arithmetic, not visa advice.
Read articleRecords and evidence
8 min read
What Fannie Mae says about statement periods and large deposits, with a fictional threshold worksheet. The lender decides what evidence is acceptable.
Read articleImport checks
8 min read
Use Quicken Classic for Windows' documented bank CSV layout, with a pasteable example, date and amount rules, and a plan to avoid duplicate imports.
Read articleFreelancers and small business
7 min read
Connect Uber gross earnings, fees and payout timing to bank deposits with a worked bridge table. Keep tax decisions separate from the cash check.
Read articleSpending analysis
8 min read
Split a mixed purchase without double-counting it. Keep the bank row, link receipt allocations, handle the leftover cent, and prepare a partial expense request.
Read articleCatch-up bookkeeping
13 min read
Bring old bank statements into QuickBooks Online or Xero without counting feed rows twice. Set the opening balance, check overlap and reconcile each period.
Read articleTroubleshooting
8 min read
Two wrong amounts can cancel out in a statement CSV. Running balances help you find them, but they don't replace reconciling your books.
Read articleHousehold money
9 min read
Calculate household spending from checking and card statements without counting payments twice. A worked example covers transfers, refunds, cash and dates.
Read articleHousehold money
9 min read
Use a spreadsheet to spot monthly and annual charges, review changing prices, and check whether payments continued after cancellation.
Read articleHousehold money
9 min read
Work out who owes whom from shared purchases, agreed shares and payments already made. Includes a two-person CSV and checked Excel formulas.
Read articleHousehold money
9 min read
Calculate average daily bank balance in Excel or Google Sheets with a checked example, carry-forward formulas and a missing-balance safeguard.
Read articleHousehold money
8 min read
Build merchant rules in Excel or Google Sheets that flag conflicting and missing matches. Copy the formulas and six-row example, then review before totaling.
Read articleHousehold money
8 min read
Use receipts, transaction details and your issuer's own app to investigate an unfamiliar card charge. Know when to stop searching and call the issuer.
Read articleHousehold money
9 min read
Track a promised card refund against posted credits, including partial refunds and changed descriptions. Keep the evidence and know who to contact next.
Read articleFreelancers and small business
8 min read
Match a Stripe payout to its charges, refunds and fees, then to the bank deposit. Includes a worked example and a month-end handoff for your bookkeeper.
Read articleLandlords and organizations
9 min read
Build a monthly club treasurer report with a worked example, copyable layout, outstanding checks, future commitments and practical handover notes.
Read articleLandlords and organizations
8 min read
Match rent payments to processor payouts and bank deposits without counting rent twice. Includes a worked example, CSV, formulas and an exceptions list.
Read articleTroubleshooting
8 min read
Find what's stopping your QuickBooks Online CSV import, from column mapping to account setup, with worked examples and a free local checker.
Read articleImport checks
9 min read
A negative card payment may be right. Check purchases, refunds and payments before importing into QuickBooks Online, Xero, YNAB or Sage 50 Canada.
Read articleChoosing a route
10 min read
Your bank's export may be all you need. Compare it with QuickBooks and Xero PDF uploads, manual preparation and a separate converter before paying.
Read articleCatch-up bookkeeping
8 min read
Overlapping bank exports need a careful merge, not automatic deletion. Review duplicate candidates and totals with a free local tool and a worked example.
Read articleTroubleshooting
9 min read
Prepare a bank CSV for Xero without changing dates or payment signs. Work through an example, check the file locally and review it before importing.
Read articleCatch-up bookkeeping
13 min read
Use Excel Power Query to combine monthly bank statement PDFs. Keep the source filenames and check for missing pages, rows and balance differences.
Read articleFile formats
11 min read
Compare CSV, OFX and QIF samples, see where QBO and QFX fit, and find the bank files QuickBooks, Xero, Quicken, YNAB, GnuCash and Sage accept.
Read articleImport checks
8 min read
Use checked Excel formulas to merge or split bank CSV amounts without losing totals. Check card signs before choosing the layout your importer needs.
Read articleImport checks
10 min read
Check what your bank CSV's dates and amounts mean before importing. Worked examples cover date order, decimal separators, signs and Excel identifier handling.
Read articleTroubleshooting
10 min read
Missing rows in a bank statement export? Check whether the PDF holds readable text or scanned images, then compare the transactions and balances.
Read articleRecords and evidence
9 min read
Getting bank statements ready for US federal tax records? Check date coverage and keep receipts, business context and open questions together.
Read articleRecords and evidence
8 min read
Use a free statement review log to record PDF checks, balance differences and unfinished work. Includes CSV and print downloads and four worked examples.
Read articleImport checks
6 min read
Check your bank statement CSV against the original before importing: dates, signs, missing rows, duplicates and balances, including errors that cancel out.
Read article