Self-employed mortgage applicants lose on paperwork, not affordability. Lenders average variable earnings, discount income they cannot source, and treat personal spending as lifestyle risk — all judgments made from bank statements spanning one to two years. The winning file separates business credits from personal spending cleanly, shows transfers between own accounts marked as transfers rather than income, and presents month-by-month totals a human underwriter can follow without a spreadsheet of their own.
Converted to Excel, that file builds itself in an afternoon. Sort salary-like credits, business-like transfers, and refunds into separate columns so declared turnover matches banked reality; a monthly total per column shows whether earnings held, grew, or dipped across the window. US lenders averaging 24 months and UK lenders stress-testing affordability both read the same signals — consistency, reserves, and obligations covered.
Common rejections are avoidable. Large unexplained deposits in the months before application read as borrowed funds; heavy cash deposits without invoices read as unsourceable; overdraft reliance reads as thin reserves. Each pattern is visible in a sorted spreadsheet months before it reaches an underwriter, which is exactly when it can still be fixed with seasoning and documentation.
Prepare the file early: convert every statement to Excel with the Bank Statement Converter, total income and obligations per month, and put that one-page summary on top of the broker pack.