Expense categories

Tally ledgers and codes for a freelancer's categories: a hand-off guide

Freelancers can save their CA hours by naming categories, ledgers and accounting codes consistently. This guide shows a numbering scheme and a check.

Editorial illustration for Tally ledgers and codes for a freelancer's categories: a hand-off guide

For a freelancer, mapping categories to ledgers comes down to a numbering scheme your CA agrees with, a naming rule for each category, and one test export before you send a year of data. You do not need to know accounting; you need to be consistent and to ask the right questions.

What do I ask the CA before I start?

  • Which ledger names should I use for my usual costs?
  • Should client-reimbursed costs sit apart from my own?
  • Do you want income and expenses in the same file, or separate?
  • Do you need the GST amount shown per row?
  • Is there a code format you already use for other clients?

Ask for a sample from another client, with details removed, so you can copy the layout.

How should the code scheme look?

A simple scheme is a four-digit number, grouped by type. Costs of delivering work in one block, overheads in another, and personal in a third.

BlockMeaningExample codes (made up)
5000sCosts of delivering client work5010 Subcontractors, 5020 Stock assets
6000sRunning overheads6010 Software, 6020 Co-working, 6030 Phone
7000sTravel and meetings7010 Local travel, 7020 Client meals
9000sPersonal or not for the CA9010 Personal

Whatever scheme your CA agrees, keep the gap-of-ten habit, so 6015 can slot in between 6010 and 6020 later.

What about client reimbursements?

If you pay for something on behalf of a client and bill it back, give it its own category, so the cost and the matching recovery can be compared. For example, a stock photo purchase of ₹2,400 that you invoice to the client at cost should not look like a personal expense of ₹2,400. Ask your CA how it should appear in the books.

Check the export before the full send

Export one month and compare three things: the row count with your statement, the total of one category with your own sum, and the codes against the agreed list. Say your month has 76 expense rows and the export shows 76; the software total for software subscriptions is ₹8,430 and your own sum is also ₹8,430. That match is what you need.

Where does SpendixAI fit?

SpendixAI categories hold an accounting code, and the Export centre offers templates for Tally, Zoho Books and QuickBooks, a standard all-transactions file and a categories-and-tax-codes file. It does not do invoicing or GST filing, so treat it as the tidy record, not the books themselves. Check the sample export with your CA first.

Think about recurring versus one-off costs. Subscriptions, co-working fees and phone plans repeat every month and are easy to code once. Equipment, a one-time course or a repair needs a decision each time. Keep a short note beside the one-off items saying why the code was chosen, and show the notes to your CA at the next meeting.

Lastly, remember the April to March financial year. Run your test export on a month inside that year, so that dates, totals and the CA's own working papers line up from the start. Write the scheme and the date you agreed it at the top of the sheet. If the CA changes the format next year, you will know which exports used the old one and can explain any difference in totals quickly. Write the scheme and the date you agreed it at the top of the sheet. If the CA changes the format next year, you will know which exports used the old one and can explain any difference in totals quickly.

Hand-off checklist

  1. Get the CA's ledger list.
  2. Choose a code scheme and write it down.
  3. Give reimbursable costs a separate category.
  4. Export one month and test.
  5. Fix mismatches in the category list.
  6. Send the full period and keep the originals.
SPENDIXAI JOURNAL

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

Explore your reports