Getting started

Which statement date ranges to download so months join cleanly

Choose statement date ranges so files neither overlap nor leave gaps, with a worked calendar for a savings account and a card with a mid-month cycle.

Editorial illustration for Which statement date ranges to download so months join cleanly

To make months join cleanly, download each statement so it starts the day after the previous one ended. For a savings account that usually means whole calendar months, such as 1 to 31 January, then 1 to 28 February. For a credit card, follow its own billing cycle, because the card's statement dates will not match the calendar.

Why do overlaps and gaps happen at all?

Net banking portals usually let you pick a custom period, and it is easy to pick it loosely. Choosing 1 January to 5 February one time and 1 February to 28 February the next gives you five days that appear in both files. Choosing 1 to 28 February and then 2 March onward leaves out 1 March entirely.

An overlap makes some spending count twice. A gap makes it vanish. Both quietly change what your monthly totals say.

A calendar for a bank account

For a savings account, the simplest rule is one file per calendar month. Here are three downloads you might make in a quarter.

FileFromToCheck
January1 January31 JanuaryEnds on the 31st
February1 February28 FebruaryStarts the day after the previous file ended
March1 March31 MarchEnds on the last day of the month

In a leap year February ends on the 29th, so look at the calendar rather than assuming 28 days. If you ever download two months at once, you still follow the same rule: the first day of the first month to the last day of the last month.

What about a card with a mid-month cycle?

Many cards bill from one date to another, for example the 16th of one month to the 15th of the next. Your statement already has its own period printed on it, so do not force it into calendar months. Instead, download the statements as the card issues them.

Suppose your card cycle runs 16th to 15th. Your three downloads would be 16 December to 15 January, 16 January to 15 February and 16 February to 15 March. Each starts the day after the last ended, so nothing repeats and nothing is missed.

The catch is that your savings account and card will not line up month by month, and that is fine. Each account is its own run of dates. What matters is that within an account the files chain together.

Which month does a transaction belong to?

A transaction belongs to the date it carries in the data, not the file it arrived in. A card purchase made on 12 January but billed in a statement dated 15 January stays in January once imported, even though the card statement is called the February one. When you compare monthly totals, remember a card's cycle is shifted from the calendar.

A tidy routine to follow

  1. Decide the period before you open the portal, and write the dates down.
  2. Download one file for that period for each account.
  3. Name the file with the account and period, for example savings-2026-01.
  4. Before uploading, check that the first and last dates match what you planned.
  5. Record the last date you imported, so next time you can begin on the following day.

One more habit helps: keep a running note of the last date you imported for each account. Two lines in a notes app, such as savings to 31 March and card to 15 March, tell you exactly where the next download should start, even if you come back to it after a long gap.

If you are starting from scratch, begin from the earliest month you want in your history and work forward. SpendixAI lets you upload files in batches and shows an import history for each, so you can tick months off against your own list as you go. That list is what keeps the chain unbroken.

SPENDIXAI JOURNAL

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

Explore your reports