Skip to main content
OctopusPDF Guide

organize a year of bank statement pdfs into monthly folders for a bookkeeper on a shared office computer

organize a year of bank statement pdfs into monthly folders for a bookkeeper on a shared office computer To organize a year of bank statement PDFs into monthly …

To organize a year of bank statement PDFs into monthly folders on a shared office computer, you need to create 12 folders (one per month), sort your PDFs by statement date, move each file into its corresponding month folder, and—if any statement contains multiple pages or covers multiple months—split or rename those files before filing them. The entire process takes about 20–30 minutes for a typical year of monthly statements and requires only a file manager plus a browser-based PDF tool if splitting is needed.

What You Will Need

  • A shared office computer with write access to the folder where statements are stored (e.g., S:\Accounting\Bank Statements\2025\)
  • The complete set of bank statement PDFs for the year you are organizing — confirm you have all 12 months before starting
  • A file manager (Windows File Explorer, macOS Finder, or a Linux file manager)
  • A PDF tool that runs in the browser — one option is OctopusPDF (octopuspdf.com), which offers a Split PDF tool that processes files locally with no upload; alternatives include Adobe Acrobat's Split tool, smallpdf.com, or the built-in "Print to PDF" feature on macOS for manual splitting
  • A naming convention you will apply consistently, such as YYYY-MM_BankName_Statement.pdf (e.g., 2025-03_Chase_Statement.pdf)
  • Read access to the original PDFs and permission to move or copy them

Step-by-Step Instructions

Step 1. Create the 12 monthly folders

  • Open your file manager and navigate to the parent folder where the organized statements will live (for example, S:\Accounting\Bank Statements\2025\).
  • Create one new folder for each month of the year. Name them using a sortable format: 01-January, 02-February, 03-March, 04-April, 05-May, 06-June, 07-July, 08-August, 09-September, 10-October, 11-November, 12-December.
  • Using the leading 01–12 prefix ensures the folders sort chronologically, not alphabetically (alphabetical sorting would place April before August, which is confusing for a bookkeeper).

Why: A bookkeeper needs to locate a specific month's statement quickly. The numeric prefix makes the folder order self-explanatory.

[Insert screenshot: Windows Explorer showing the 12 folders created in the 2025 directory with numeric prefixes]

Step 2. Inventory all statement PDFs before moving anything

  • Create a temporary checklist. On paper or in a text file, list the 12 months and mark off each statement as you find it.
  • Sort the existing PDFs by date. In Windows File Explorer, click the "Date modified" column header to sort; on macOS Finder, use View → Sort By → Date Modified. Statements are usually named with the statement period (e.g., March 2025.pdf), but if they are not, the date modified is a reliable fallback.
  • Identify any PDF that covers more than one month. This happens when a bank sends a quarterly statement or when a statement period spans two calendar months. Set these aside — you will split them in Step 4.

Why: Rushing to move files without an inventory is the most common cause of missed or misplaced statements. A bookkeeper needs all 12 months; a missing file can delay tax filing or reconciliation.

[Insert screenshot: File list sorted by date with the 12 monthly statements highlighted]

Step 3. Rename each PDF with a consistent convention

image
  • For every statement, rename the file using the pattern YYYY-MM_BankName_Statement.pdf. For example, 2025-03_Chase_Statement.pdf.
  • If the bank's name contains spaces (e.g., "Bank of America"), replace spaces with underscores: 2025-03_Bank_of_America_Statement.pdf.
  • Keep the original statement period visible in the filename. Do not shorten "Statement" to "Stmt" — clarity matters more than brevity when a bookkeeper is reconciling accounts.

Why: Consistent naming prevents duplicate files with generic names like statement(2).pdf and makes it possible to search for a month using the file manager's search box.

[Insert screenshot: Rename dialog showing 2025-03_Chase_Statement.pdf being applied]

Step 4. Split any multi-month or multi-page statements

  • Open your browser-based PDF tool. One option is OctopusPDF's Split PDF tool, which runs entirely in the browser with zero uploads — your files never leave the shared computer. Other options include Adobe Acrobat's "Organize Pages" tool or smallpdf.com's Split tool.
  • Upload the multi-month statement. In OctopusPDF, drag the file into the browser window.
  • Use the split controls to separate the PDF. You have two choices:
    • Split by page range: If the statement for January ends on page 2 and February begins on page 3, extract pages 1–2 as one PDF and pages 3–5 as another.
    • Split every page: If each month is exactly one page, select "Split every X pages" and enter 1.
  • Name the output files according to the convention from Step 3 (2025-01_BankName_Statement.pdf and 2025-02_BankName_Statement.pdf).
  • Download the split files to the same folder where the original statements are stored.

Why: A single PDF that mixes two months cannot be filed into one monthly folder without creating confusion. Splitting produces clean, single-month files.

[Insert screenshot: OctopusPDF Split PDF interface showing page range selection]

Step 5. Move each PDF into its corresponding monthly folder

  • Drag each renamed and split PDF into the folder that matches its statement period: 2025-03_Chase_Statement.pdf goes into 03-March.
  • Work month by month, starting with January and ending with December. Do not skip around — a sequential pass reduces the chance of dropping a file.
  • After moving all files, return to your checklist from Step 2 and mark every month as complete.

Why: Moving files one month at a time keeps you systematic. If you move all files at once, it is easy to misplace a statement in the wrong folder.

[Insert screenshot: File drag operation moving a PDF into the 03-March folder]

Step 6. Confirm no files were left behind

  • Navigate back to the original source folder. If any PDFs remain, check whether they are duplicates (same statement period as one already filed) or a month you missed.
  • Compare the number of PDFs now inside the 12 monthly folders against the count from your Step 2 inventory. They must match.
  • If the bank sends statements in multiple formats (e.g., both a PDF and a CSV), verify you only moved the PDFs. The CSV files, if any, can stay in a separate folder.

Why: The final verification is the step that prevents a bookkeeper from discovering a missing statement during month-end close.

image

[Insert screenshot: Empty source folder after all PDFs are moved]

Common Mistakes / Troubleshooting

Problem Likely Cause Fix
A statement covers two months (e.g., Jan 15–Feb 14) and does not fit any single folder The bank's statement period does not align to calendar months Split the PDF by page range so each calendar month becomes its own file, then file each half into its respective month folder. If the statement only contains one page, keep it in the month where most of the statement period falls and note the split in the filename (e.g., 2025-01_Chase_Part1.pdf).
Two files have similar names like statement(1).pdf and statement(2).pdf The bank's download portal auto-renamed duplicates Rename both files using the convention in Step 3 before moving them. Check the statement period printed on page 1 of each PDF to confirm which month each file represents.
The file manager sorts folders alphabetically, showing April before August, confusing the bookkeeper Folder names lack a numeric prefix Recreate the folders with 01- through 12- prefixes, or rename existing folders to add the numeric prefix.
A PDF cannot be opened or appears corrupted after moving The file was partially downloaded or the move was interrupted Re-download the statement from the bank's website and move it again. Do not attempt to repair the corrupted PDF.
The bookkeeper cannot find a specific transaction because the statement scans are rotated 90 degrees The original scan was saved sideways Use the browser-based tool's Rotate PDF feature to turn the page 90 degrees (either 90, 180, or 270), then re-save and re-file the PDF.

How to Verify Success

Run through this checklist after completing Step 6:

  • Twelve folders exist named 01-January through 12-December in the target directory.
  • Every folder contains exactly one PDF for its matching month (unless a month required multiple parts, in which case it should contain clearly numbered part files).
  • Every filename follows the pattern YYYY-MM_BankName_Statement.pdf with no spaces or generic names.
  • No PDFs remain in the original source folder other than non-PDF files or intentional duplicates.
  • A quick search for *.pdf within the year's parent folder returns exactly the number of PDFs you inventoried in Step 2.
  • A bookkeeper can open any monthly folder and identify the statement period within 5 seconds by reading the filename alone.

FAQ

Q1. What if my bank sends statements that cover a quarter (three months) instead of one month?

You need to split the quarterly PDF into three separate monthly PDFs. Use a browser-based PDF split tool (one option is OctopusPDF, which processes files locally without uploading to a server). Identify the page where each month's transactions begin, then extract page ranges: January pages, February pages, and March pages. Name each output file using the YYYY-MM_BankName_Statement.pdf convention and file them into the respective month folders.

Q2. Can I use a PDF tool that requires uploading files to a server on a shared office computer?

Technically yes, but be cautious. Bank statements contain confidential financial information. On a shared or company device, you should prefer tools that process files locally. OctopusPDF advertises that its tools run in the browser with zero uploads, which keeps files on the local machine. If you must use an online tool, check its privacy policy and ensure the office's security policy permits uploading financial documents to third-party servers. Some offices explicitly forbid this, so verify before proceeding.

Q3. Should I keep the original PDFs after moving them into monthly folders?

No. If you have confirmed that each monthly folder contains the correct statement (via the verification checklist above), delete the original files from the source folder. Keeping duplicates increases the chance that a bookkeeper will accidentally reconcile against an outdated file. If you need an archive for audit purposes, keep a single backup ZIP of the monthly folders on a separate drive, but do not maintain a second loose set of PDFs.

Key Facts

  • The core workflow has six steps: create 12 month folders, inventory PDFs, rename with a YYYY-MM convention, split multi-month files, move each file into its folder, and verify nothing was left behind.
  • Numeric folder prefixes (01-January through 12-December) force chronological sorting in any file manager.
  • Multi-month statements must be split by page range before filing; a single PDF cannot represent two monthly folders.
  • Browser-based PDF tools that process locally (zero upload), such as OctopusPDF, are suitable for confidential bank statements on a shared office computer, but alternatives like Adobe Acrobat or smallpdf.com exist.
  • The final verification step — matching the moved PDF count against the initial inventory — is the single most important control against a missing statement.