SoFi Bank Statement to Excel: A Practical Guide

TL;DR To get a SoFi bank statement into Excel, download the monthly PDF statement for each period you need, convert it so every transaction is a single row with one signed amount, and prove the data is complete by checking that the opening balance plus all transactions equals the closing balance. SoFi Checking and Savings is a combined product, so decide early whether you are working with checking, savings or both, and treat moves between them (including Vaults) as internal transfers rather than income or spending. Keep the original PDFs next to your spreadsheet. Once the balance check passes, the data is ready for a budget, a tax return, a loan application or an import into QuickBooks, Xero or another bookkeeping tool.

SoFi started out as a student loan refinancing company and now offers a full online bank, including a combined checking and savings account that many people use as their main account. Like most app-first banks, it's easy to use day to day. The trouble starts when you need the numbers somewhere else: a landlord asks for three months of statements, your accountant wants a year of transactions, or you finally want to build a proper budget.

This guide explains what a SoFi statement usually contains, which file to start from, how to turn a PDF into clean spreadsheet rows, how to deal with savings Vaults and transfers, a worked example, and the problems people run into most often. SoFi updates its app and website regularly, so we describe the options in general terms rather than listing exact menu paths that may change.

What a SoFi statement contains

A bank statement is a record of an account over a fixed period, usually a calendar month. Whatever the exact design of the document, a SoFi statement will generally show:

• Account holder details and a masked account number.
• The statement period, with a start date and an end date.
• Opening and closing balances. These are the two numbers every check in Excel depends on.
• A transaction list, each line with a date, a description and an amount, often with a running balance.
• Interest earned during the period, if the account pays interest.

Because SoFi's checking and savings sit under one product, a single statement may cover more than one account, each with its own balances and transaction list. That matters when you convert it: if you mix the two lists into one column of amounts, the balances will never tie out. Treat each account section as its own little statement.

SoFi also has a feature called Vaults, which lets you split savings into named buckets for goals such as an emergency fund or a holiday. Money in a Vault is still your savings balance, so moving money between Vaults does not change your total, but it may appear as a line on the statement. We deal with this in Step 2.

PDF statement or transaction export?

Depending on your account and the current version of the app and website, SoFi may let you download monthly PDF statements and may also offer a way to export or view transaction history. Check what's available to you. Each type of file has a different job.

PDF statements are the official record. They state the period, the opening and closing balances and the bank's name, and they look like a bank statement because they are one. When a lender, landlord, court or government office asks for "bank statements", this is almost always what they mean.

Transaction exports or screenshots are easier to work with, but they're not proof. An export may cover a date range that doesn't line up with a statement period, it may not show opening and closing balances, and pending transactions may come and go. Screenshots are worse: they're hard to convert and easy to question.

A good rule of thumb:

• For analysis, budgeting and bookkeeping, use whichever source converts most easily, but always reconcile it against the PDF statement for the same month.
• For anything you need to prove, send the PDF statements themselves and use the spreadsheet only as your own working copy.

If you only have PDFs, which is common when you're catching up on old months, you'll need to convert them.

Converting a SoFi PDF into rows

There are three realistic ways to do it.

Copy and paste. Open the PDF, select the transaction table and paste it into Excel. For a short statement this can work. More often, columns merge, long descriptions wrap onto a second row, amounts paste as text, and minus signs disappear. It also gets tedious quickly if you have twelve months to do.

Power Query. Excel for Windows with a Microsoft 365 subscription can import tables directly from a PDF. Results vary with how the PDF was built; some statements come through cleanly and some need a lot of tidying. Our Power Query bank statement guide explains the steps.

A converter built for bank statements. SheetStatement reads the PDF, produces one row per transaction with a signed amount, and checks the opening and closing balances so you know nothing has been dropped. You can export to Excel or CSV. The free plan covers 3 pages a month, which is enough to test a real statement; paid plans are $9, $19 and $39 a month for more volume.

Whichever method you use, aim for a layout like this:

Keep one Amount column, with money in as a positive number and money out as a negative number. If your data arrives with separate deposit and withdrawal columns, combine them with something like =C2-D2. Our guide to separating debit and credit columns shows how to go either way. The Account column (Checking or Savings) and the Source file column (for example sofi-2026-05.pdf) make every row traceable.

Step 1: check the balance

Before you categorise anything, prove the data is complete. For each account on each statement:

=ROUND(Opening + SUM(Amount) - Closing, 2)

The result should be exactly zero. If it isn't, something is missing, duplicated or has the wrong sign, and the size of the difference is a useful clue:

• It equals one transaction. A row was probably lost at a page break, or a line was skipped during copy and paste.
• It's twice one transaction. A sign is flipped: a withdrawal was recorded as a deposit, or the reverse.
• It equals a transfer between checking and savings. The transfer was put under the wrong account, or appears in one account's rows but not the other's.
• It's a small amount near the end of the month. Check whether interest was recorded.

If you have a running balance column, a row-by-row check pinpoints the problem. With balances in column E and amounts in column D, starting from row 3:

=ROUND(E2 + D3 - E3, 2)

Fill it down. The first row that isn't zero is where the trouble starts. Our guide to finding bank reconciliation discrepancies has more techniques for stubborn differences.

Step 2: separate checking, savings and Vaults

This is the step that trips up most SoFi users, because money moves between your own accounts often. Some people sweep their pay into savings, others move cash back to checking before bills are due, and Vaults add another layer.

Here's the approach that keeps things clean:

1. Keep each account's rows separate while you check balances. Checking should reconcile on its own, and so should savings.
2. Add a Type column and tag every movement between your own accounts as Transfer. That includes checking to savings, savings to checking, and any Vault movements that appear as lines.
3. Exclude transfers from income and spending totals. A $500 move to savings isn't spending, and moving it back isn't income.
4. Check that transfers pair up. If you have both accounts in the same workbook, every transfer out of checking should have a matching transfer into savings on the same or a nearby date for the same amount.

A quick pairing check, assuming a table named Tx with columns Date, Account, Amount and Type:

=SUMIFS(Tx[Amount], Tx[Type], "Transfer")

If you've included both sides of every transfer, this total should be zero or very close to it. A non-zero result tells you that one side is missing, perhaps because a transfer went to an account at another bank, which is a genuine outflow and should be tagged differently.

If you only need checking (for example, a landlord only asked about your main account), you can still use this method: tag transfers to savings as Transfer so your spending analysis isn't inflated.

Step 3: clean dates, amounts and descriptions

Converted data usually needs a light tidy before it's useful.

Dates. US statements use month/day/year. If your copy of Excel uses a different regional setting, or if dates came through as text, they may sort wrongly or refuse to work in formulas. Test with =ISNUMBER(A2). If it returns FALSE, the date is text. For text in the form MM/DD/YYYY:

=DATE(RIGHT(A2,4), LEFT(A2,2), MID(A2,4,2))

Our guide to fixing bank statement dates in Excel covers other formats.

Amounts. Look for amounts stored as text (they align left and won't sum), currency symbols, and commas. =VALUE(SUBSTITUTE(SUBSTITUTE(D2,"$",""),",","")) handles most of these. If withdrawals show in brackets, see our guide to converting parentheses to negative numbers.

Descriptions. Card purchases often include a merchant name plus location or reference codes. Keep the original description in its own column and add a shorter Payee column if you want cleaner reports. That way you never lose information you might need later.

Step 4: categorise the transactions

With clean data, add a Category column. For a few months of personal spending, typing categories by hand is quick enough. For a year or more, set up a small lookup table of keywords on a separate sheet:

Then use a formula to find the first keyword that appears in each description. Our guide to Excel formulas for categorising transactions walks through a reliable pattern using SEARCH and XLOOKUP. Whatever you do, keep Transfer as its own category so it can be filtered out.

A worked example

Suppose you need a tidy record of May for your own budget. Your SoFi statement shows checking and savings, with these checking figures:

• Opening balance: $2,140.25
• Closing balance: $2,862.90

After conversion, the checking rows look like this:

Check: the amounts sum to 2,450.00 − 600.00 − 1,450.00 − 86.42 − 74.18 + 2,450.00 − 600.00 − 55.00 − 61.75 − 1,250.00 = 722.65. Opening balance $2,140.25 plus $722.65 gives $2,862.90, which matches the closing balance. The data is complete.

Now the useful part. Filter out transfers and you can see that income was $4,900.00 and spending, including the card payment, was $2,977.35. The $1,200 moved to savings isn't spending at all; it's money you kept. Without the Transfer tag, a quick total would have made the month look $1,200 more expensive than it was.

One caution about the credit card payment: if you also track your credit card transactions, the card payment is effectively a transfer to pay off spending you've already counted. In that case, tag it as a transfer too so you don't count those purchases twice. Our guide to credit card reconciliation in Excel explains how to handle card statements alongside a bank account.

Using SoFi statements for loans, rentals and taxes

Loans and mortgages. Lenders usually want the official PDF statements, often for the most recent two or three months, to check income, spending and where a down payment came from. Send exactly what they ask for. Your spreadsheet is still useful: reviewing it first helps you spot large deposits or transfers that an underwriter may ask about, so you can gather an explanation in advance. Our guide to bank statements for a mortgage application covers what underwriters typically look at, and our guide to bank statements for a car loan covers auto lenders.

Rentals. Landlords and property managers sometimes ask for statements as proof that you can afford the rent. They usually want PDFs. Some applicants choose to redact unrelated details, but whether that's acceptable depends on the landlord, so ask first. See our guide to bank statements for a rental application.

Taxes. If you're self-employed or have side income going into a SoFi account, your statements are part of the records behind your tax return. A categorised spreadsheet makes it much easier to total income and expenses for the year. Add a Year column and filter on it so December and January don't get mixed up. This is general information rather than tax advice; check IRS guidance or ask a tax professional about what you can claim. Our guide to bank statements for tax preparation covers a full-year workflow.

Bookkeeping software. If you run a small business through SoFi, you may want to import transactions into QuickBooks or Xero. Use the bank feed for current transactions if one is available, and a checked CSV for earlier months. Pick a clear cut-over date so nothing is imported twice. See our guides to importing bank statements into QuickBooks Online and the Xero CSV import format.

Common problems

The balance check fails by exactly one transfer. You've probably put a checking-to-savings transfer under the wrong account, or included it in one account's list but not the other's. Re-read the statement section headings.

Interest is missing. Interest is often a single small line near the end of the period. It's easy to drop during copy and paste. If your difference is a few cents or dollars, look for it.

Pending transactions in an export. An export taken mid-month may include pending card authorisations that later change or disappear. Only posted transactions appear on a statement, so reconcile against the statement, not the export.

Duplicates when combining months. If you download overlapping date ranges, some transactions will appear twice. Use statement periods rather than arbitrary ranges, and see our guide to removing duplicate bank transactions in Excel.

Descriptions split over two rows. Long descriptions can wrap in the PDF. If a row has a description but no date or amount, it's probably the second half of the line above. Merge them before you categorise; our guide to cleaning bank statement data in Excel shows a formula-based method.

Several months at once. Convert and check each month separately, then stack them into one table with a Source file column. Our guide to combining multiple bank statements in Excel explains the process.

A short checklist

Before you rely on your SoFi spreadsheet, confirm that:

• Each month's opening balance plus transactions equals its closing balance, for each account.
• Each month's closing balance equals the next month's opening balance.
• Transfers between your own accounts are tagged and excluded from income and spending.
• Dates are real dates and amounts are real numbers.
• Every row has a source file so you can trace it back.
• The original PDFs are saved in the same folder as the workbook.

Convert your SoFi statements to Excel

Upload a SoFi statement PDF to SheetStatement, check the opening and closing balances, and export to Excel or CSV in a minute or two. The free plan covers 3 pages a month, so you can test it on a real statement before choosing a paid plan.

FAQ

Can I download a SoFi statement as an Excel file?

SoFi provides statements as PDFs, and may offer other ways to view or export transaction history depending on your account. If you need a spreadsheet of a statement period, converting the PDF is the most reliable way to get rows that match the official balances.

How do I handle SoFi Vaults in Excel?

Keep any Vault or savings movements as rows so the balance check works, tag them as transfers, and leave them out of income and spending totals. Moving money between your own buckets doesn't change what you earned or spent.

Why doesn't my SoFi spreadsheet balance?

The usual causes are a missing row at a page break, a flipped sign, a transfer placed under the wrong account, or a small interest line that was skipped. Compare the difference to individual transactions to find it.

Will a lender accept my converted spreadsheet?

Lenders generally want the official PDF statements. Use your spreadsheet to review your own finances and prepare explanations, and send the PDFs they request.

Can I import SoFi transactions into QuickBooks or Xero?

Yes. Convert the statement to CSV, check the balances, map the columns in the import screen, and choose a cut-over date if a bank feed is also connected so nothing is duplicated.

Is it safe to upload bank statements to a converter?

Read the provider's security and privacy information first. See SheetStatement's security page for how uploaded files are handled.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.