Shopping

Splitting a large purchase across two cards or UPI: record it once

Record a split payment across two cards or UPI without double counting: one entry for the item and linked payment lines, with a ₹45,000 example.

Editorial illustration for Splitting a large purchase across two cards or UPI: record it once

To record a split payment, write the purchase once as the item and then list each payment as a line under it, counting only the payment lines in your totals. With a made-up ₹45,000 refrigerator paid across two cards and UPI, you end up with one item entry and three payment lines that add to exactly ₹45,000.

Why does a split payment cause double counting?

The invoice says ₹45,000. Your statements show three smaller debits. If you log the invoice and also import or type the three debits, your tracker reports ₹90,000 for one refrigerator. The fix is not to avoid either record. It is to decide which one counts.

How do you set up the parent and payment lines?

Use a simple table where every row has a purchase ID, a date, a description, an amount, the account used and a line type of Item or Payment.

Purchase IDDescriptionAmountAccountLine type
P12Refrigerator, invoice total₹45,000-Item
P12Part payment₹20,000Card APayment
P12Part payment₹15,000Card BPayment
P12Part payment₹10,000UPI from bank accountPayment

The payment lines add up: 20,000 + 15,000 + 10,000 = ₹45,000, which matches the invoice. The Item line is a reference, not a cost.

Which formula keeps the totals right?

In Excel or Google Sheets, put Amount in column C and Line type in column E, with rows 2 to 200 as the data. Spending is the sum of Payment lines only.

  • Total spent: =SUMIFS($C$2:$C$200, $E$2:$E$200, "Payment")
  • Invoice total: =SUMIFS($C$2:$C$200, $E$2:$E$200, "Item")
  • Check, should be 0: =SUMIFS($C$2:$C$200, $E$2:$E$200, "Item") - SUMIFS($C$2:$C$200, $E$2:$E$200, "Payment")

If the check is not zero for a purchase, a payment is missing or a cashback or fee has changed the amount. Look at the amount and any fee or discount mentioned on the invoice.

What about paying the card bill later?

This is the second double count. When you pay Card A's bill from your bank account, that bank debit is a settlement of money you already counted as spent. Do not record it as a purchase. Label it Card payment and keep it out of spending totals.

What happens when the statements arrive?

Each leg shows up as its own row on its own statement, which is correct. Match each row to the payment line by amount and date, tick it off, and do not add a second copy. If you use SpendixAI, the account you choose before importing is kept with each transaction, so the Card A and Card B rows stay separate, and possible duplicate imports are flagged when the same amount shows up twice.

What if a payment fails or is reversed?

Split payments are fragile. A UPI leg may fail after the card leg has gone through, or a merchant may reverse one part. Treat each leg separately. Add the Payment line only when the money has actually left, and if a reversal arrives, add a negative or Refund line against the same purchase ID so that the total spent is correct. Then compare the total of Payment and Refund lines with the invoice.

Keep the screenshots of failed attempts until the money is confirmed back, and note the dates. If a reversal takes longer than the merchant or bank said, ask them with the reference in hand.

  • Payment fails: no line added, note the attempt
  • Payment succeeds: add the line with the date
  • Part reversed: add a Refund line with the date
  • Invoice amount changed: update the Item line and note why

A short routine

  1. Record the invoice once as the Item line.
  2. Add a Payment line the same day for each part.
  3. Check that payments equal the invoice.
  4. Tick the lines off against statements.
  5. Keep card bill payments out of the spend totals.
SPENDIXAI JOURNAL

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

Explore your reports