Tax and GST

Matching a business card statement to purchase bills

Reconcile credit card statement with bills: pair each swipe with its bill line by line, flag swipes without a bill, and chase the missing ones.

Editorial illustration for Matching a business card statement to purchase bills

To match a business card statement to purchase bills, list every swipe on the statement, tick off the bill that goes with it, and then check the reverse: every bill in your folder should have a swipe. Swipes with no bill and bills with no swipe are your two follow-up lists. A statement with eighteen swipes and sixteen bills leaves two to chase.

How do I pair them line by line?

  1. Download the statement and put each swipe on its own row: date, merchant, amount.
  2. Put your bills in a folder, in date order, and number them.
  3. For each swipe, find the bill with the same amount and a close date, then write the bill number against the row.
  4. Mark rows without a bill with a question mark.
  5. Go the other way: every bill number should appear against a swipe. Any that do not were paid another way.

Allow for date differences. The merchant's bill carries the day you shopped, while the card statement often shows the day the charge was posted, which can be a day or two later. Match on amount first, then on date.

Example: eighteen swipes, sixteen bills

Say last month's statement has eighteen swipes. Sixteen match a bill. Two do not.

FindingCountWhat you do
Swipe with a matching bill16Write the bill number against the swipe
Swipe with no bill: ₹3,450 at a hardware shop on the 12th1Message the shop or look in the bag, email and WhatsApp
Swipe with no bill: ₹1,180 at a courier counter on the 20th1Ask for a duplicate receipt, or write a note
Bills with no swipe0None this month

Those two rows are the only ones that take your time. Everything else is already closed.

What if the amount on the bill is different from the swipe?

  • A tip added at the table makes the swipe larger than the bill.
  • A foreign-currency purchase shows a converted rupee amount on the statement, so the amounts will not match the bill.
  • A single swipe for two bills, such as one billing for two orders from the same vendor, needs both bills attached.
  • A swipe partly refunded later shows as two lines on the statement; keep both.

What about swipes by other people?

If a partner or a staff member also carries the card, ask them to drop a photo of each bill into one shared place on the same day. A bill that reaches you three weeks later, after the statement has closed, is much harder to pair, and the person who bought it may no longer remember the purpose.

Who chases the missing bill?

The person who made the purchase should do it first, because they remember the shop. If it was you, message the seller the same week, quoting the date and amount. Waiting until year-end makes the shop less likely to find it. If a bill truly cannot be recovered, write a note with the date, amount, merchant, purpose and the date you tried to chase, and tell your CA.

Where does an expense tracker help?

In SpendixAI you choose the card as the account before importing the statement, so each swipe keeps its account, and you review the rows before saving. Receipts can be kept with their transactions, so a bill photo sits next to the swipe it belongs to. The Possible duplicate charges report lists the same amount to the same merchant within two days, which is useful for spotting a card swiped twice.

A short checklist to finish

  • Each swipe has a bill number or a question mark.
  • Each bill has a swipe or a note saying how it was paid.
  • The two chase lists have names and dates beside them.
  • Statement and bills are saved together for the month.
SPENDIXAI JOURNAL

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

Explore your reports