Bank Statement Conversion for an SBA Form 413
Filling out SBA Form 413 for a loan? Convert bank statements to CSV to document cash-in-bank assets as of the date, your income, and the debts to list.
TL;DR - Quick Summary
SBA Form 413, the personal financial statement for a 7(a) or 504 loan, lists your assets, liabilities, and income as of a date, and you supply supporting paperwork. Convert your bank statements to a CSV to document the cash-in-banks balances, total your income sources, and surface the debt payments behind your liabilities.
What Form 413 needs from your bank
SBA Form 413 is the personal financial statement the SBA requires for a 7(a) or 504 loan, and it is a net-worth snapshot: your assets on one side, your liabilities on the other, plus your sources of income, all as of a stated date. The instructions also ask you to gather supporting paperwork up to that date to back the values you report. Your bank statements are the primary support for several of those lines, but the figures you need are buried in printed pages. Converting the statements to a CSV pulls the balances, deposits, and payments out as data, so the numbers on the form trace to something you can hand an underwriter.
Cash-in-banks assets as of the date
The clearest thing bank statements prove is the cash line: cash on hand and in banks, one of the first assets on Form 413. Because the form is a snapshot as of a date, you report the balance on that date, not an average, so you pull the ending balance from the statement period that covers it, across every checking and savings account. A converted CSV lets you confirm that balance and see the activity behind it, which matters if an underwriter questions a large recent deposit. Listing each account's cash as of the same date is what makes the assets section tie to the statements you attach.
Income sources and the supporting record
Form 413 asks for your sources of income, salary, net investment income, real estate income, and other, and the deposits corroborate them. With the statements in a CSV you total the recurring income deposits by type and separate them from transfers or one-off credits that are not income, giving a figure you can defend for each source line. Keeping that categorized record alongside the form is exactly the supporting paperwork the SBA expects, and it lets you answer a question about a specific deposit by filtering to it rather than paging through statements.
Reading liabilities from the payments
The statements help on the other side of the balance sheet too. The liabilities section lists notes payable to banks and others, installment accounts, and real estate mortgages, and the recurring payments clearing your account are a map of those debts. Filtering the converted payments for loan, mortgage, and card payments surfaces the obligations you need to list, and can catch one you might otherwise forget. The payment does not give the balance owed, which comes from the lender statement, but it confirms the debt exists and is being serviced, which keeps the liabilities section complete.
Guarantors, the 'as of' date, and privacy
A Form 413 is required from each proprietor, partner, or managing member, every owner of twenty percent or more, and any guarantor, so a single deal can mean several statements. The information has to be current as of the submission date, within ninety days for a 7(a) or 504 loan, so the statement you pull the balance from has to cover that window. A converted CSV makes assembling each person's cash, income, and debt figures quick. Because these are sensitive personal records, statements are processed to build the CSV and then deleted automatically, with nothing kept on a server afterward.
How it works
- Convert the statements: Convert the statements covering the form's as-of date, across every account, into a CSV.
- Pull the cash balances: Record each account's ending balance on the as-of date for the cash-in-banks asset line.
- Total the income: Sum the recurring income deposits by source, excluding transfers and one-off credits.
- List the liabilities: Filter the payments for loan, mortgage, and card debits to confirm the debts to list.
Comparison
| Form 413 section | From the statement | Supports |
|---|---|---|
| Cash in banks | Ending balances as of the date | Asset value |
| Income | Recurring deposits | Sources of income |
| Notes / mortgages payable | Recurring loan payments | Liabilities |
| Contingent liabilities | Not on the statement | Listed separately |
Statements for the as-of date convert to a Form 413 support CSV in about 2 minutes. Convert your statements now.
See pricing