Tracking Venmo with Tiller

I love my Venmo account for paying for local services and splitting bills with friends and luckily I have also found that it integrates really well with my Tiller tracking.

I added my Venmo account just like any other bank account, though I have found that it does require me to occasionally re-auth my credentials in my Tiller Console to update my sheet. I like to use the “Balances” tab in my Tiller Sheet to see when my accounts were last updated, then visit my Tiller Console to refresh the account when needed.

I simply categorize my Venmo transactions based on the spending category they relate to, whether they are payments made or received.

For example if my friend Venmos (that’s a word now, right?) me $20 to cover her share of the babysitter we split I categorize the transactions as “childcare” and it reduces my overall childcare expenses for that period, in a sense reducing the $60 cash I took out of my checking account and also categorized as “childcare”.

A payment made to a friend for my new bike would be categorized as “Gear”, similar to any other purchase.

If someone pays you for a service you perform as a job, you can categorize the credit as “income”.

Any debits or credits that hit your other bank accounts (checking or credit card) from Venmo are then categorized as “Transfers” much as you would a payment to your credit card.

The only place where I have gotten a little stuck is when someone pays me for somethings that isn’t a reimbursement, for example if I were to sell a pair of old skis. I didn’t just buy the skis so they aren’t a current “Gear” expense, and it’s also not income because I didn’t really earn the money and I don’t want it to effect my budget … any suggestions here?

I did explore the CSV export options from Venmo, but the data is fairly limited in comparison with what you can get from Paypal, so it didn’t help enough in my tracking to make the effort worthwhile. It could be useful however if you used Venmo for business and wanted to track the fees separately.

I would love to hear how others track their Venmo spending and deal with receiving payment for used goods as well!

3 Likes

Hi @Janelle,
Your workflow with Venmo makes a lot of sense.

Regarding the sale of old skis, I would probably put it into a “Sold Items” (or something like that) Income Category.

You really did make money selling the skis. The balance in your checking account went up, just as it would for other income.

I can see why you don’t want to include it in budgets though. If you set the “Sold Items” income category set to Hide from Reports, that might be one solution. Or you could just not set any budget amount for this category.

One other thought. If you have a lot of transactions where you are getting reimbursed or need to reimburse someone else, you can create a Reimbursements Account and a Reimbursements Due (transfer category.)

When you paid the babysitter $40 and that transactions was categorized as Childcare, you could also add a manual transaction adding $20 to your Reimbursements Due category in the Reimbursements Account.

This would let you know you are owed $20. When the Venmo reimbursement came in, you would add another manual transaction reducing your Reimbursements Due category by $20.

If you only have a few reimbursements, it’s probably not worth the effort. But if you have lots of them, it can help you stay organized.

1 Like

Simple and common sense. Love the way you’re mixing spreadsheets with an app-driven platform like Venmo. Do you ever use Tiller to help split bills or manage other shared expenses?

@jonorlin has an very excellent idea regarding a reimbursement account. It is really like a Due To/ Due From account. Some call it an Intercompany account when you are dealing with parent and subsidiary companies.

I call them transfer accounts (categories) and I have about 20 of them to track different kinds of transfers that I might want to track.

My most used one is called Transfer Zero Out. For example, I buy a $10 lunch for my friend and they pay me back cash the next day. Lets say I deposit the $10 of cash into my checking account. What is the entry?

The $10 lunch on my credit card (outgoing cash) is a debit to the Transfer Zero Out account while the cash going into my checking account (incoming cash) is a credit to the Transfer Zero Out account. These two offset to zero. You could treat the $10 lunch as meal expense and the $10 repayment as reimbursement/other income but that would probably be weird as most people would not want to see these two $10 items on two different rows on their your P&L report.

Another use of these transfer accounts is when you are moving money back and forth between accounts. For example, lets say you move $100 from your savings account to your checking account. Use the transfer account and the two $100 entries net to zero.

I use these transfer categories to track transactions inside my retirement accounts, all of which I have linked up to Tiller. Lets say my mutual fund investment pays a dividend. Code this to a transfer account. It will not zero out but it is not really income (at least not taxable income) because it is inside of a retirement account.

Basically I am using these accounts to track inflows and outflows that I do not want included in my P&L.

Thanks,

Blake

1 Like

Great post @Janelle!

I agree with @jonorlin, your skis sale is a side hustle :wink: count that as an income category, and why not let it increase your monthly spending budget a little or just show it as savings?

I also recently connected my Venmo account to my Tiller spreadsheet. My roommates and I use it to split utility costs, and I use a similar method of just categorizing the inflow from them as “utilities” to net out what was actually my share of utilities. When I pay them for water or Internet it’s usually via Venmo balance so the transaction trail is pretty clean and easy to understand.

One slightly cumbersome area, that’s less clean, is on payments from my bank account passing through Venmo.

Let’s say I pay someone -$100 to help clean my house once a month. I see two outflow transactions. One associated with the Venmo account, and another with my checking account. In reality it’s just leaving my checking account and passing through Venmo. I wish there was an automated way to enter the transfer (+$100 come from checking to Venmo) to balance the transfer. I realize I can manually add it, but sort of a pain.

Anyway, great resource thread for helping folks manage Venmo transactions :slight_smile:

Heather

1 Like

Curious, do you always enter a second “transfer” transaction for both accounts, if so what are the details? I just tag the -$100 leaving my bank as transfer and basically ignore it, but maybe there are consequences to that?

Janelle and Heather, I just noticed the same thing. When I pay someone on venmo, when I don’t have enough funds in my venmo account, my checking account is charged, but I still see an outflow transaction from venmo. For these checking transactions, the description is always “Electronic Transaction Venmo *30 Nyus x0006.” I search for this string in Excel, and then identify the associated venmo outflow payment and just delete it. Kind of tedious, but it keeps things clean. It will probably incentive me to keep some money in Venmo, so I can avoid having to delete the duplicate outflow transaction.

why not let it increase your monthly spending budget a little or just show it as savings?

@heather I like how you put it above regarding the skis sale.

I’m a little unclear about the payments from your bank account passing thru Venmo.
I believe you could Categorize both transactions using a Venmo Transfers. It would be a Transfer type category. The -100 to your bank account transaction would balance out the +100 in your Venmo account. After the transfer, Venmo Transfers category would be zero. Is that not how it is working? Maybe the +100 to the Venmo account doesn’t show up automatically, but i would think it should.