# PDF Bank Statement Dates Without Year: Fix Them

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: PDF bank statements
- Canonical: https://simplebankconvert.com/blog/pdf-bank-statement-dates-without-year

> Why PDF bank statement dates without year break imports, how a December to January statement goes wrong and how to give every row its right year.
PDF bank statement dates without year, such as 12/28 or Jan 03, get their year from the statement period printed in the header. For each row, pick the year that places the date inside that period. Most months are obvious, but a statement that runs from December into January needs two different years on the same page.

## Why do PDF bank statements print dates without the year?

A bank statement prints month and day only because the year is already stated once, in the statement period near the top of the first page. Repeating it on every row would widen the date column for no benefit to a person reading the page. The year is not missing. It is moved to the header.

That shortcut works for people and fails for files. An import file for QuickBooks or Xero needs a complete date on every row. [Intuit's page on uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) asks for all dates in one consistent format. A cell that says "03/14" gives the software nothing to place it in a year, and whatever fills the gap decides where the transaction lands in your books.

Before you touch a single row, find these two dates on the statement:

- **The period start**, often labelled "Statement period", "Beginning" or "From".
- **The period end**, sometimes printed as "through" or as the closing balance date.

Write both down with their full years. Every row on the statement is filled in from them.

## A December to January statement where the year slips

The year goes wrong when a statement period crosses 1 January. A spreadsheet formula or a hasty conversion often stamps every row with one year, usually the year the period started. Rows from early January then land a full year too early, and nothing in the file looks broken.

Here is an example statement covering 15 December 2025 to 14 January 2026. The payees and amounts are made up for illustration.

| Printed date | Description | Amount | One year for every row | Year chosen from the period |
| --- | --- | ---: | --- | --- |
| 12/16 | ACH CREDIT LINDEN ROW STUDIO | 1,800.00 | 2025-12-16 | 2025-12-16 |
| 12/22 | CARD PURCHASE HARBOR PRINT CO | -146.30 | 2025-12-22 | 2025-12-22 |
| 12/31 | INTEREST PAID | 0.84 | 2025-12-31 | 2025-12-31 |
| 01/02 | ONLINE TRANSFER TO SAVINGS | -500.00 | 2025-01-02 | 2026-01-02 |
| 01/06 | CARD PURCHASE FERNBROOK SOFTWARE | -39.00 | 2025-01-06 | 2026-01-06 |
| 01/13 | MONTHLY MAINTENANCE FEE | -10.00 | 2025-01-13 | 2026-01-13 |

The fourth column puts the last three rows into January 2025, eleven months before the statement began. The fifth column is right. Notice that the totals and the balance check would still pass with the wrong years, because the amounts are untouched. That is what makes this mistake hard to catch. Only the dates are wrong.

## Giving each month-and-day row its year from the statement period

The rule is simple: give each month-and-day row the year that puts it between the period start and the period end. On a statement that sits inside one calendar year, that is the same year for every row. On a statement that crosses new year, the months tell you which side of 1 January each row falls.

Work through it in this order:

1. Write the period start and end with full years, for example 2025-12-15 and 2026-01-14.
2. If both dates share a year, add that year to every row and stop.
3. If they do not, give rows whose month matches the start month the start year.
4. Give rows whose month matches the end month the end year.
5. Check that every finished date sits between the start and the end. List any that do not.

The same rule applies whatever the money columns look like. Fixing dates and fixing signs are separate jobs, and the guide to [debit and credit columns in PDF bank statements](/blog/debit-and-credit-columns-in-pdf-bank-statements) handles the second one. Do the years first, while the printed rows are still in their original order.

SimpleBankConvert is being built to put mixed date styles such as Mar 4 and 2026-03-09 into one format, so nothing lands in the wrong month. It is not open for accounts yet, so for now the steps above are the way to do it yourself, and the [homepage](/) shows a sample of the finished file.

## What happens in QuickBooks or Xero when a row gets last year's date?

A row with last year's date imports without complaint and posts to the wrong year. In QuickBooks it can land in a period you already closed or reported, and it shifts the account balance on every date in between. In Xero it shows up far from the rest of the statement, which makes reconciliation look incomplete.

You usually notice in one of three ways:

- The bank account balance on the statement end date matches, but a report for the earlier year suddenly changes.
- A handful of transactions appear months before the account's other activity, or before the account was opened.
- Reconciling the January statement later finds those same transactions missing, so you import them again and create duplicates.

Xero shows imported statement lines and the transactions you match them to in different places, and a wrong year can make the two disagree. [Xero statement lines versus account transactions](/blog/xero-statement-lines-vs-account-transactions) explains what each view shows. In either program, the cure is the same: remove the misdated rows, correct the years in the file and import those rows again.

### Downloads avoid the problem

A file downloaded from the bank already carries a full date on every transaction, so year-end statements are one reason to prefer it when it covers the months you need. The guide on [how to download a QBO file from Bank of America](/blog/how-to-download-qbo-file-from-bank-of-america) shows that route for one bank. For older months, the [Chase statement to QBO conversion](/blog/convert-chase-bank-statement-to-qbo) walks through a PDF where you supply the years yourself.

## Year-less dates that fall outside the statement period

Sometimes a row still does not fit after you apply the rule. Treat that as a signal to look again, not as a row to force into place. The usual causes are a second date column, a carried-over item from the previous statement, or a misread period in the header.

Check these before you change anything:

- **Two date columns.** Card activity on some statements shows a transaction date and a posting date. A purchase on 30 November can post on 2 December. Use the posting date, which is the one the bank balance reflects.
- **Adjustments to earlier items.** A refund or correction may print the date of the original transaction. Keep it on the date it posted to this statement.
- **A quarterly or longer period.** Savings accounts sometimes get statements covering three months. The rule still works, but more months are in play, so check each one.
- **A header you misread.** If several rows fall outside the period, read the period again before you change a single row.

Any row still outside the period after these checks belongs on a list for a closer look against the bank's own records.