Cards and UPI

Buy now, pay later: how to track every due in one list

Track buy now pay later purchases in one simple list: provider, purchase, amount, due date and status, plus two formulas that show what is due this week.

Editorial illustration for Buy now, pay later: how to track every due in one list

To track buy now pay later dues, keep one list with a row per purchase: the provider, what you bought, the amount, the due date, whether it is paid, and the account you will pay it from. Update it once a week. A single list stops small dues in three different apps from turning into a surprise on the same day.

Why one list beats three apps

Each pay-later provider shows only its own dues. None of them knows that another one is also asking for money on the 7th. If you have used two or three, you cannot see the combined demand on your account without opening each app. A single list does that job in one glance, and it is the thing to look at before you make another pay-later purchase.

The columns to keep

ColumnHeadingExample
AProviderProvider 1
BPurchaseHeadphones
CAmount (₹)1,299
DDue date07-12-2026
EStatusUnpaid
FPaid fromSavings account

Use only two values in Status, Unpaid and Paid, so the formulas below can count them. If a provider adds a late fee or extra charge, give it its own row with the same due date, so the amount you pay matches the amount you listed.

A filled-in example

Say your list shows four unpaid items, all hypothetical: ₹1,299 due on the 7th, ₹2,450 due on the 12th, ₹799 due on the 12th and ₹3,100 due on the 20th. The total unpaid is 1,299 + 2,450 + 799 + 3,100 = ₹7,648. The 12th alone asks for 2,450 + 799 = ₹3,249, which is the day you want to see coming.

Two formulas worth adding

With amounts in C2:C100, due dates in D2:D100 and status in E2:E100, the total unpaid is:

  • =SUMIFS($C$2:$C$100,$E$2:$E$100,"Unpaid")

And the amount due within the next seven days is:

  • =SUMIFS($C$2:$C$100,$E$2:$E$100,"Unpaid",$D$2:$D$100,"<="&TODAY()+7)

Both work the same in Excel and Google Sheets. The second also counts anything overdue and still unpaid, because it includes every unpaid date up to a week from today. Sort the sheet by column D so the nearest date is always on top.

How often should you update it?

  1. Pick one day a week, such as Sunday evening.
  2. Add any new pay-later purchases from the week.
  3. Change Unpaid to Paid for anything settled, and check that the payment left the account you noted.
  4. Read the total due in the next seven days and make sure that account can cover it.

It takes five minutes, and it is much easier than rebuilding the picture from several apps on the day a payment fails.

Is a pay-later purchase an expense now or later?

The spending happened when you bought the item. Record it in your normal expense categories on the purchase date, and treat the payment later as clearing the amount you owe. If you only record the payment, your spending shows up weeks late and the wrong month looks heavy.

What if you miss a payment?

Do not hide it from the list. Leave the status as Unpaid, add the late fee as a new row if the provider charges one, and move the due date to the day you plan to pay. A list that shows the real position is useful. A list that has been tidied to look fine is not. If the same provider keeps appearing in your late rows, that is information about how you use it, and worth a calm look at the end of the month.

It also helps to write the provider's name next to the amount in your bank transfer note, if your bank allows one, so the settlement is easy to match later.

When a sheet stops being enough

If the list grows long or you want dues next to budgets, SpendixAI on Pro includes budgets, bills and savings goals, and a Possible duplicate charges report that lists the same amount to the same merchant within two days. For most people, a sheet and a weekly habit are enough to begin.

SPENDIXAI JOURNAL

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

Explore your reports