How to Record Prior Year Transactions in QuickBooks

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

Short answer

To record prior year transactions in QuickBooks, you bring them in from the bank statements rather than the live bank feed, which only reaches back a few months. Download the PDF statements for the months you are missing, convert each one to a QBO file, and import them under Bank transactions. QuickBooks then dates every line correctly so your prior year ties out to the statement totals.

Catching up an old year in QuickBooks is one of the most common bookkeeping jobs, and it trips people up because the bank feed is built for going forward, not backward. Rebuilding a closed period from statements this way is the core of after-the-fact bookkeeping, the write-up work firms do once a period has ended. When you connect a bank, QuickBooks pulls roughly the last 90 days and stops. Anything older has to come from somewhere else, and the cleanest source is the PDF bank statement the bank already keeps on file. This guide walks through how to record those prior year transactions accurately, whether you are closing out last year's books, catching up two years at once, or fixing a period the feed skipped.

Why the QuickBooks bank feed will not pull prior year transactions

The bank feed in QuickBooks Online is a sync, not an archive. When you first link an account it backfills only a short recent window, usually about 90 days, and from then on it only adds new activity. There is no button to ask it for last year. That design keeps the feed fast, but it means a prior year of transactions is simply not available through the connection. The data still exists, just in the monthly statements your bank stores in online banking, often for seven years. To record an old year you go to those statements and import them yourself.

How to record prior year transactions in QuickBooks step by step

Recording an old year is a repeatable loop: pull each statement, convert it, import it, and review. Here is the full sequence.

  1. Download every statement for the period. Sign in to online banking and save the PDF for each month you need to record, including any closed accounts and credit cards.
  2. Convert each statement to a QBO file. Upload the PDF to the PDF bank statement to QuickBooks converter at the top of this page. It reads every transaction and exports a QBO (Web Connect) file with the dates and amounts already formatted.
  3. Import the QBO file. In QuickBooks Online open Bank transactions, choose Upload from file, and select the QBO file. The transactions land in the For Review tab dated to the original statement period, not today.
  4. Categorize and add. Assign each transaction to the right account, then add it to the register. Set up bank rules first if the same vendors repeat across months.
  5. Reconcile each month. Run a reconciliation against the statement's ending balance so the prior year ties out exactly.

If you are bringing in many months at once, you can convert the whole stack together with the batch PDF to QuickBooks converter instead of doing one statement at a time.

Will importing old transactions mess up my opening balance?

It can if the dates overlap with what QuickBooks already has. The safest approach is to record prior year transactions back to a clean starting point and set the account's opening balance to the statement balance on the day before your first imported transaction. If you import a period that overlaps existing entries, you will get duplicates and a wrong opening balance. Import in date order, oldest first, and reconcile each month as you go so any mismatch surfaces immediately instead of compounding.

How far back can you enter transactions in QuickBooks?

There is no hard limit on how far back you can enter transactions in QuickBooks. You can record activity from several years ago as long as you have the source documents, which means the bank statements. The practical limit is your data, not the software. Keep in mind that posting into a year you have already filed taxes for may mean amending a return, so coordinate large historical catch-ups with your accountant before you import. If your accountant is doing the work, it helps to send them the bank statements in a QuickBooks-ready format so they import in minutes instead of re-keying.

Can I import a whole year of bank statements at once?

Yes. You convert each monthly PDF statement to its own QBO file and import them in sequence, or convert them as a batch so a full year is ready in one session. QuickBooks reads the statement dates on each file, so a January transaction posts to January even though you are importing it months later. Importing oldest to newest keeps the running balance correct and makes month by month reconciliation straightforward.

What if I only have paper or scanned statements?

A scanned or photographed statement works as long as the text is legible. The converter reads scanned PDFs with OCR, so an image of a statement still produces a QBO file. For the cleanest result, download the original PDF from online banking when you can, since a born-digital statement reads more accurately than a phone photo. If a scan is faint or skewed, rescan it straight and well lit before converting.

QuickBooks Online or Desktop for a prior year catch-up

Both work. QuickBooks Online imports a QBO file under Bank transactions, while QuickBooks Desktop imports a QBO file through Bank Feeds or an IIF file through File then Utilities then Import. The conversion step is the same either way: turn the PDF statement into the file QuickBooks expects. If you are on Desktop, see the PDF statement to QuickBooks Desktop guide for the exact import path and when to choose IIF over QBO.

When you need a different output than QBO

Recording prior year transactions is not always a QuickBooks-only job. Sometimes you want the raw transactions in a spreadsheet first to clean them up or hand them to a client for review. In that case you can convert the same statements to a worksheet with a bank statement to Excel converter, then bring the reviewed data back in. If your accountant already gave you the data as a spreadsheet, a CSV to QBO converter turns that file into the QBO format QuickBooks imports. And if the statements are not in PDF form at all, a general bank statement to QuickBooks converter covers the other formats banks export.

A clean prior year, ready to reconcile

The whole job comes down to sourcing the data the feed cannot give you. Pull the statements, convert each to a QBO file, import oldest to newest, and reconcile every month against its ending balance. Done that way, a prior year catch-up that looks intimidating becomes a steady rhythm, and your books tie out to the bank to the penny. When you are ready, upload your first statement to the converter at the top of this page and start with the oldest month.

Z tej samej rodziny narzędzi