When your income is invoice-based, a date that moves a payment into the wrong month changes which month looks strong and which looks bare. Find the rows where the date is text or shifted, convert the column to real dates, strip any time part and then check the month boundaries first.
Why do freelancers feel the date error more?
A salaried person's money arrives on the same day each month, so a shifted date is easy to spot. A freelancer's credits arrive whenever a client pays. If a ₹60,000 payment received on 02/05 is read as 5 February, February looks like a good month and May looks like the one where the client never paid. You might then chase a client for money you already have.
Which dates break first?
- Dates with a day of 12 or less, which can be read month-first.
- Dates that include a time, such as 02/05/2026 14:32, which stay as text and refuse to sort.
- Entries from the last day of a month, where a one-day shift moves them into the next month and a quarter.
- Statements merged from two banks that print dates differently.
How do you repair the dates and the time part?
- Copy the date column to a spare column so you keep the original.
- If the cells are text like 02/05/2026 14:32, take the first ten characters: =LEFT(A2,10).
- Turn that into a date: =DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2)).
- If the cells are already real dates with times, strip the time with =INT(A2) and format the result as a date.
- Create a month label with =TEXT(C2,"yyyy-mm") so rows sort and group cleanly.
Then get monthly totals with =SUMIFS($D$2:$D$500,$E$2:$E$500,"2026-05"), where column D holds amounts and column E the month label.
A worked check on the quarter boundary
Say a quarter ends on 30 June and three client payments are ₹40,000 on 30/06, ₹25,000 on 28/06 and ₹55,000 on 02/07. A month-first reading puts 30/06 as text, 28/06 as text and 02/07 as 7 February. Your June total shows ₹0 and the quarter looks short. After conversion, June holds 40,000 plus 25,000, which is ₹65,000, and July holds ₹55,000. Correcting three dates changed a ₹0 month into a ₹65,000 month.
| Payment | Printed date | Wrong reading | Right month |
|---|---|---|---|
| ₹40,000 | 30/06/2026 | text | June |
| ₹25,000 | 28/06/2026 | text | June |
| ₹55,000 | 02/07/2026 | 7 February | July |
How can an importer help?
SpendixAI shows parsed rows, with their dates, on a review screen before anything is saved, so a row that landed in the wrong month can be corrected first. You choose the account before importing, and you can use Pro's custom reports and advanced filters to group by month afterwards. If tax or GST figures are involved, treat anything the app shows as an estimate and confirm it with your CA.
How do you handle payments near a month boundary?
A credit that arrives late on the last day of a month can appear in the next month if the bank posts it after midnight, and the statement date can differ from the date you saw in a payment alert. Decide on a rule, such as always using the date printed on your statement, and write it at the top of the sheet. Then the same payment is never in June in one report and July in another.
For quarter-end work, filter the last three days of each month and read those rows one by one. It is a short list, and it is where most date mistakes cost money.
What to do before closing a month
- Confirm the first and last dates against the statement.
- Check that no credit appears under a month in which the statement has no days.
- Re-total the month after correcting dates.
- Keep the original statement file unaltered in a folder for that month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

