Cards and UPI

How to track a Paytm or Amazon Pay wallet next to your bank accounts

Track wallet balance and spending alongside bank accounts: add the wallet as its own account, treat top-ups as transfers, and reconcile monthly in rupees.

Editorial illustration for How to track a Paytm or Amazon Pay wallet next to your bank accounts

Someone asked on a forum: I keep money in a Paytm or Amazon Pay wallet and have no idea what is in it or what I spent from it, how do I track it? Treat the wallet as an account in its own right, with an opening balance, money going in as transfers, money going out as spending, and a monthly check against the balance shown in the wallet app.

Why wallets quietly break your totals

A wallet sits between your bank and the shop. When you add ₹3,000 from your bank, that is not spending; it is moving money. The spending happens later, when the wallet pays a merchant. If both movements are counted as spend, your month looks ₹3,000 heavier than it was. If neither is recorded, the wallet is a hole where money disappears.

The steps

  1. Open the wallet app and note today's balance. That is your opening balance.
  2. Create the wallet as a separate account in your sheet or tracker, with that opening balance.
  3. Record every top-up as a transfer: the bank account goes down, the wallet goes up, and neither counts as spending.
  4. Record each wallet payment as spending under its real category, with the wallet as the account.
  5. Record cashback or refunds that come back to the wallet as money in, linked to the original category where you can.
  6. Once a month, compare your running balance with the figure in the wallet app.

A worked example

Say the wallet started the month at ₹1,200. These numbers are invented.

EventIn (₹)Out (₹)Balance (₹)
Opening balance--1,200
Top-up from bank3,000-4,200
Cab rides-6403,560
Recharge and bills-4103,150
Online order-1,1502,000
Cashback80-2,080

Real spending from the wallet is 640 + 410 + 1,150 = ₹2,200. The closing balance is 1,200 + 3,000 + 80 - 2,200 = ₹2,080, and that should match the wallet app. If you had counted the ₹3,000 top-up as spending as well, the month would show 3,000 + 2,200 = ₹5,200 for what was really ₹2,200.

Where does the data come from?

Check whether your wallet app lets you download a statement as PDF, CSV or Excel. If it does, you can import it. If not, you can add the entries by hand from the app's history once a week. SpendixAI treats a bank account, a card and a wallet as accounts, and you choose the account before importing, so each transaction keeps the wallet it came from. It does not connect to wallet apps or read SMS, so what you import or type is what it knows.

What if the numbers do not match the wallet app?

  • Look for a payment that was reversed or a refund that came in later.
  • Check whether cashback landed in the wallet or in your bank.
  • See if an auto-payment drew from the wallet without a notification you noticed.
  • Compare dates; a payment late on the last day may fall in next month's statement.

An honest limit

A wallet balance can be small enough to feel unimportant, and the cost of tracking it by hand is real. It is worth it when you use the wallet for regular spending, such as daily commute or bills. If you only use it occasionally, a quick balance check each month and a note of anything big may be plenty.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports