To get a Venmo statement to Excel, download the monthly statement from the Statements page in the app or on the website, open the file in Excel, and sort each row into a payment, a transfer or a fee. Then give money you received a positive sign, money you sent a negative one, and keep the note column.
Downloading a Venmo statement from the app or the website
Venmo statements are organized by month and year, and Venmo's help article on transaction history and statements describes them as a downloadable CSV file. On the website you pick the month and click Download CSV. In the app you pick the month and choose to download the file or have it emailed.
Step by step
The steps below follow Venmo's help page at the time of writing. Menu names can change, so check the page if a label looks different.
- On the web: sign in at venmo.com and choose Statements in the sidebar.
- Use the dropdown to pick the month. To change the year, click the year at the top of the dropdown.
- Choose Download CSV. The file lands in your downloads folder.
- In the app: open Settings, then Statements, and pick the year and month.
- Choose to download the file to the phone or have it sent to your email.
Venmo's help page adds that a file too large to download is sent to your email address instead. If you are pulling a busy month for a side business, expect that and watch the inbox.
Opening the CSV in Excel
A CSV, or comma-separated values file, is plain text with one row per line and commas between the fields. Excel opens it directly, but double-clicking lets Excel guess each column's type. That guess can turn a long transaction ID into scientific notation and read amounts with currency symbols as text. A safer route is Data, then From Text/CSV, which shows a preview and lets you set the ID column to text before the import.
Download one month at a time and keep each file named by month, such as "venmo-2026-09.csv". When you want a full year, stack the twelve files on one sheet and keep a "Statement month" column so you can tell where each row came from.
What if your Venmo statement is a PDF?
A Venmo statement ends up as a PDF when someone prints the statement page to PDF or sends a copy as an attachment. A PDF is a picture of the page layout, so the rows have to be extracted rather than opened. If you can still sign in, downloading the CSV for the same month is faster and exact.
When the PDF is all you have, check whether it holds real text. Try selecting a word with the cursor. If the word highlights, the PDF is digital, and a PDF to Excel converter can lift the table out. If nothing highlights, the file is an image, and it needs OCR (optical character recognition), which reads the letters from the picture and adds some risk of misread digits.
Watch for two things in a PDF copy. First, long notes may wrap onto a second printed line and come out as a separate row with no amount. Second, a printed page can cut off columns that do not fit the paper width, so compare the column headings with what you expect before trusting the totals.
Some people mark up a statement PDF with sticky notes and highlights before passing it on. Those markups are annotations, not part of the printed page, and a converter usually ignores them. To keep them, see pulling comments and annotations out of a PDF into Excel.
If you also send money with Cash App and only have its statement as a PDF, the same extraction route applies, and turning a Cash App monthly PDF into rows walks through that layout.
Venmo payments, transfers and notes as columns
Every Venmo row is one of three kinds of event: a payment between people, a transfer between Venmo and a bank or card, or a charge such as a fee. Only payments change what you own; transfers just move your own money. Put the kind in its own column, so a filter can separate spending from shuffling.
The three kinds of row
- Payments. You paid a friend for dinner, or a roommate paid you for utilities. These are real income or spending, and they belong in a budget.
- Transfers. You moved your Venmo balance to your checking account, or Venmo pulled money from your bank to fund a payment. The money stays yours.
- Fees. An instant transfer to a bank can carry a fee, and that fee is a real cost. Keep it as its own row, not hidden inside the transfer amount.
The note column is the description
Venmo payments carry a note written by the person who sent or requested the money, often a word and an emoji. That note is the only description you get, so keep it in full. Excel displays most emoji, and if a cell shows a box instead, the character is still there for searching.
Add a "Category" column beside the note and fill it yourself: "Rent share", "Groceries", "Gift". Notes such as "🍕" are clear to you today and puzzling in six months, so a category written in words is worth the minute it takes.
An example month
The rows below are an example, made up for illustration, with a type and a category added by hand.
| Date | Type | From or to | Note | Signed amount | Category |
|---|---|---|---|---|---|
| 2026-09-02 | Payment received | Sam (roommate) | September rent share | 850.00 | Rent share |
| 2026-09-05 | Payment sent | Lee | Dinner | -42.00 | Eating out |
| 2026-09-06 | Transfer to bank | Checking ending 2231 | -850.00 | Transfer | |
| 2026-09-18 | Payment sent | Garden club | Annual dues | -30.00 | Hobbies |
| 2026-09-18 | Bank funding | Checking ending 2231 | 30.00 | Transfer | |
| 2026-09-25 | Payment received | Lee | Concert ticket | 65.00 | Paid back |
Which sign should a Venmo amount carry?
Give every Venmo amount a sign from your own point of view: money that arrives in your Venmo balance is positive, and money that leaves it is negative. A payment received is positive. A payment sent is negative. A transfer out to your bank is negative on the Venmo sheet, and the matching deposit is positive on the bank sheet.
Converting text amounts to numbers
If the amount column arrives with a plus or minus sign, a space and a dollar symbol in each cell, Excel may treat the whole value as text. A quick test: select the column and look at the status bar. If it shows a count but no sum, the cells are text. Use Find and Replace to remove the dollar sign and the spaces, then multiply the column by 1 in a helper column to turn it into numbers.
When the file has no sign at all
Some exports, and most PDF copies, show every amount as a positive number and leave the direction to another column, such as who sent and who received. In that case, build the sign with a formula. If the "From" field is your own name, the amount is negative. If the "To" field is your name, it is positive. Check the formula on two or three rows you remember before filling it down.
A sign rule by type
| Row type | Sign on the Venmo sheet | Counts toward a budget? |
|---|---|---|
| Payment received | Positive | Yes, as income or a pay-back |
| Payment sent | Negative | Yes, as spending |
| Transfer to bank | Negative | No |
| Funded from bank or card | Positive | No |
| Instant transfer fee | Negative | Yes, as a fee |
Venmo rows that double count against your bank
Venmo rows double count when you put both the Venmo sheet and the bank statement into one budget. A transfer to checking shows up leaving Venmo and again arriving at the bank. A payment funded straight from your bank shows up as a Venmo payment and a bank withdrawal for the same amount. Count each event once.
Pick one record for each event. A simple policy is to count payments from the Venmo sheet and leave transfers out of both totals. Mark Venmo transfers and the matching bank lines with the category "Transfer", and exclude that category from every sum. The example month above shows why: the 850.00 rent share arrives on Venmo, then moves to checking. Counting both would show 1,700.00 of income from one roommate.
Rent paid through a payment app is a common case. If roommates send their share by Venmo and one person pays the landlord or the lender, the Venmo rows are the shares and the bank row is the full payment. For a household that owns, breaking a mortgage statement into principal, interest and escrow shows what the full payment covers, so each share can be split the same way.
Card funding is the other trap. If Venmo pulled a payment from a credit card instead of the bank, the matching row is on the card statement, not checking. Keep a column noting which account funded each payment so you know where to look.
Matching a Venmo month to the linked bank account
Matching a Venmo month to the linked bank account means pairing every Venmo transfer or bank-funded payment with one bank line for the same amount within a few days. When every pair is found, the two records agree. A Venmo transfer with no bank line is either still in transit or went to a different account.
Put the Venmo transfers and the bank lines that mention Venmo side by side. Sort both by amount. Most pairs line up at once. Transfers usually reach the bank one or more days after they leave Venmo, so match on amount first and allow a gap of a few business days on the date.
Getting the bank side into rows is the other half of the job. FastBankConvert is made for that part: it turns a checking or savings statement PDF into a spreadsheet with dates, descriptions, amounts and balances, and tells you when the balances do not add up. It is not open yet, and the homepage has a sample run you can watch. Once both sheets exist, a lookup on amount and a date window finds the pairs, and anything left over is the short list to investigate.