Tax and GST

A monthly GST-paid summary from your tracker for your CA

How to build a monthly summary of GST paid on purchases from your expense tracker, with a tag column and unmatched list, ready to hand to your CA.

Editorial illustration for A monthly GST-paid summary from your tracker for your CA

A monthly GST-paid summary is a simple table: date, vendor, bill number, taxable value, tax shown, total, and a column saying whether you hold the bill. Build it from your tracker by filtering the month, add the unmatched entries as a separate list, and give both to your CA. It is a working paper, not a return.

What should the summary contain?

ColumnWhy your CA wants it
Date and bill numberTo match against the supplier's records
Vendor and tax numberTo check the supplier is registered
Taxable valueThe base on which tax was charged
Tax shown on the billThe figure the CA will look at
Total paidTo reconcile with your bank or card
Bill held? (yes or no)A bill that is missing is a question, not a figure
CategoryTo see what kind of spending carried the tax

How do you build it from a tracker?

  1. Filter the month, using the dates of the transactions, not the date you entered them.
  2. Keep only the entries that carry a tax amount, and put the rest in a separate list.
  3. Group by vendor or category so the CA can scan it.
  4. Download as CSV and open it in a sheet. Add the bill-held column if it is not there.
  5. Sort so that entries without a bill sit at the top.

In SpendixAI, the report builder lets you filter and group, and reports can be downloaded as CSV. Your categories can carry a GST rate, ITC-eligible and tax-deductible settings, and reports estimate the GST inside spending. These are estimates based on what you set up, so the bills remain the source. The Export centre also offers a categories-and-tax-codes file.

Worked example: three bills

Say three purchases in a month (hypothetical): a stationery bill with taxable value ₹2,000 and tax ₹360; a software invoice with taxable value ₹5,000 and tax ₹900; and a courier receipt for ₹600 with no tax shown. The tax shown is ₹360 plus ₹900, which is ₹1,260, on bills worth ₹7,000 taxable. The courier entry goes on the unmatched list, since no tax is shown and the CA may want to ask the vendor.

What goes on the unmatched list?

  • Purchases with no bill, or with a bill that shows no tax number.
  • Card or UPI debits you cannot identify.
  • Bills where the total does not equal taxable value plus tax.
  • Entries where you are unsure whether they were for business.

What if a vendor's bill never arrives?

It happens: a supplier promises an invoice and it never comes. Record the payment anyway, with the amount, the date and the proof of payment, and put it on the unmatched list with the date you asked for the bill. Follow up once a month. If your CA gets a list that says bill awaited from this vendor, asked on these dates, they can decide what to do. A silent gap in the summary invites questions that take far longer to answer later.

How do you hand it over?

Send the summary and the unmatched list together, with the bills in a folder named by month. Write two lines at the top: the period covered, and any change from last month, such as a new vendor or a change of account. A short note that says three bills are still awaited from the supplier is better than silence.

A monthly routine

  1. Import or enter all transactions for the month.
  2. Check each entry with tax has a bill attached.
  3. Build the summary and the unmatched list.
  4. Compare the summary's total to the month's debits for the same accounts.
  5. Send to your CA by the date you agreed.
SPENDIXAI JOURNAL

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

Explore your reports