Use Cases
24 guides. Each one lists the official pages it was checked against.
Why Your Ledger Balance Differs From Your Bank Statement
Why a company ledger balance and a bank statement balance often differ: deposits in transit, outstanding checks, bank fees and errors, with a worked example.
Bank Statements for a Mortgage Application: What Lenders Ask For
What Fannie Mae's Selling Guide says about bank statements in a mortgage file, including what a statement must show and how large deposits are treated, plus how to organise them.
Organising Bank Statements for CRA Record Keeping in Canada
What the Canada Revenue Agency says about keeping receipts, documents and records, and how converting statements to a spreadsheet can help you keep them organised.
How to Check a Bank Statement for Fraud and Errors
What the CFPB and FTC say about reviewing statements and reporting unauthorized transactions, and how a spreadsheet can make unfamiliar charges easier to spot.
Credit Card vs Bank Statement: Differences in a Spreadsheet
How credit card statement fields differ from bank statement fields, and how those differences affect the columns and formulas in your spreadsheet.
Freelancer Expense Tracking from Bank Statements: IRS Basics
What IRS publications say about records for self-employed income and expenses, and how converting bank statements to a spreadsheet helps freelancers categorise spending.
How Long to Keep Bank Statements for Taxes (US): IRS Guidance
What the IRS says about how long to keep tax records, including the 3, 6 and 7 year periods, employment tax and property records, and how to keep statements organised.
Bank Statements and Passbooks When Filing an Indian Income Tax Return
What the Income Tax Department e-Filing help pages say about bank statements, passbooks and interest income, and how a spreadsheet can help you organise them.
Preparing Bank Statements and Records for an IRS Audit
What the IRS says about audits, record retention and supporting entries on a return, plus how a spreadsheet of bank transactions can help you organise your own records.
SBA Loan Documents: What SBA Says and How to Organise Statements
What the U.S. Small Business Administration says about loan application documents, and how to organise bank statement data in a spreadsheet before you talk to a lender.
Small Business Bookkeeping from Bank Statements: IRS Basics
What IRS Publication 583 says about business records, a separate business account and monthly reconciliation, and how a spreadsheet of statement rows supports simple bookkeeping.
Tracking Rental Income and Expenses from Bank Statements
What the IRS says about keeping records of rental income and expenses, and how a spreadsheet built from bank statements helps you organise rent, repairs and other costs.
Keeping Bank Statement Records for UK Self Assessment
What GOV.UK says sole traders and partners should record and keep for Self Assessment, and how turning bank statements into a spreadsheet can help you organise them.
Bank Statements for the UK Skilled Worker Visa Financial Requirement
What GOV.UK says about bank statements as financial evidence for the Skilled Worker route: the 28-day period, the 31-day window and what a statement must show.
Business Meals and Travel Records from Bank Statements
What IRS Publication 463 says about records for travel and meals, and how a spreadsheet built from bank statements helps you pair each charge with the details it lacks.
Canada Rental Income: Records the CRA Guide Mentions
What the CRA rental income guide says about keeping records of rent and expenses, and how a spreadsheet built from bank statements can help you organise them.
Canada Self-Employed Records: Income and Expenses (CRA)
What the CRA says sole proprietors should keep to support income and expense claims, and how a spreadsheet built from bank statements can help you organise them.
Charitable Donation Records and Bank Statements
What IRS Publication 526 says about bank records for cash gifts, and how a spreadsheet built from bank statements helps you list donations alongside acknowledgments.
Estimated Tax and Income Records from Bank Statements
What the IRS says about estimated tax and business income records, and how a spreadsheet built from bank statements helps self-employed people organise deposits and payments.
Home Office Deduction Records and Bank Statements
What IRS Publication 587 says about records for the business use of your home, and how a spreadsheet built from bank statements helps you organise utilities, rent and insurance.
Medical Expense Records and Bank Statements
What IRS Publication 502 says about medical and dental expenses and keeping records, and how a spreadsheet built from bank statements helps you list what you paid.
UK Landlord Records: Rent, Expenses and Bank Statements
What GOV.UK says landlords should record and keep for rental income, and how a spreadsheet built from bank statements can help you organise rent and expenses.
Tracking Allowable Expenses From Bank Statements (UK)
What GOV.UK says about allowable expenses for the self-employed and the records to keep, and how a categorised spreadsheet from bank statements can help you organise them.
UK VAT Records: Where Bank Statements Fit
What GOV.UK says VAT-registered businesses should keep, including bank statements, for how long, and how a spreadsheet built from statements can help you organise them.