Getting started

A month-end export routine for freelancers who send data to a CA

A five-step month-end routine for freelancers who send expense data to a CA: import, clear review, attach receipts, export, send, with checks at each step.

Editorial illustration for A month-end export routine for freelancers who send data to a CA

A freelancer's month-end routine can be five steps in a fixed order: import the month's statements, clear the review queue, attach receipts, export, then send. The order matters because each step makes the next one reliable. Do them in the first few days after the month closes, while the memory of what each payment was for is still fresh.

Step one: import every account

List every account you used: each bank account, each credit card, any wallet. Download the statement for the month for each one. In SpendixAI you choose the account before importing, so each transaction keeps its account, and batch uploads let you add several statements together. Afterwards, look at the import history for anything marked failed, and open the review screen to check that rows are what the statement says.

Cash spending needs entering by hand. Several entries can be added at once, which suits a handful of small cash payments from the month.

Step two: clear the review queue

Anything uncategorised or doubtful goes into the queue. Work through it until it is empty. Give each item the category you would give if your CA asked about it. If a payment is part business and part personal, decide how you will record that consistently and tell your CA. When you correct a category, those corrections become history that guides later imports.

  • Fix any possible duplicates, especially if you uploaded overlapping dates.
  • Look at the largest ten transactions first; mistakes there matter most.
  • Do not leave a catch-all category as the destination for everything you were unsure about.

Step three: do receipts and invoices exist?

Attach receipts to their transactions while the month is fresh. Chase missing invoices from vendors right now, not in March. Send a short request that names the date, the amount and the vendor so they can find it quickly. For items below whatever threshold you and your CA are comfortable with, a bank entry may be enough; ask your CA where that line sits rather than guessing.

Step four: export and check

Export the period your CA wants. Then compare the file against your statements before it leaves your hands. Suppose your business account shows debits of ₹62,400 for the month and the file shows ₹59,900 for the same account. The ₹2,500 gap might be one invoice payment still waiting in review, so go back to step two. Never send a file you cannot reconcile.

StepWhat to doHow to know it is done
1. ImportUpload each account's statementImport history shows no failures
2. ReviewClear the queueNothing left uncategorised or flagged
3. ReceiptsAttach and chaseLarge expenses have documents
4. ExportDownload the periodAccount totals match statements
5. SendEmail file and notesYou keep a copy of what you sent

Step five: send it with a short note

Attach the file and write three lines: the period covered, any entries you want your CA to look at, and which receipts are missing. If the figures include GST estimates, say they are estimates. Name the file with the month and year so that twelve emails later nobody opens the wrong one. Keep a copy of exactly what you sent.

What if I skip a month?

It happens, especially after a busy project or a festival fortnight. Do not try to be perfect. Import the missing statement, clear the queue as best you can and export both months together. Tell your CA that the file covers two months. The routine survives a gap far better than it survives guilt about one.

Quick checklist

  • Every account's statement imported for the month.
  • Review queue empty.
  • Receipts attached, missing ones requested.
  • Totals compared with statements.
  • File named, sent and copied.
SPENDIXAI JOURNAL

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

Explore your reports