Period-End Cutoff Export

    Bank Reconciliation When Statement Dates Don't Match Month-End

    Bank statements run on bank cycles — the 4th to the 3rd, not the 1st to the 30th. StatementToExcel splits a statement PDF into a clean pre-cutoff file and a post-cutoff outstanding/in-transit file, so your month-end reconciliation ties out the first time.

    Try Period-End Cutoff Export →

    Free to try · processed in memory, never stored

    The cutoff problem

    Your books close at calendar month-end. The bank's statement cycle doesn't. When a statement runs April 4 to May 3, the April 4–30 transactions belong to April's reconciliation, while May 1–3 are outstanding/in-transit items that belong to May.

    Get the split wrong and the reconciliation won't tie out — or worse, transactions get counted in the wrong period. Auditors check exactly this.

    The standard accounting approach

    You reconcile to the book balance at month-end and document a cutoff working paper: one list of transactions through your cutoff date (the current period) and one list of post-cutoff transactions still on the statement (outstanding/in-transit, carried to next period). The post-cutoff list is what keeps both months clean.

    The data-extraction problem

    When the statement is a PDF, doing this by hand means copy-pasting rows, sorting by date, and manually slicing at the cutoff — per client, every month. It's slow and easy to get wrong by a row or two.

    How StatementToExcel handles period-end cutoffs

    1. Upload the bank statement PDF. STE extracts every transaction and detects the statement period.
    2. Turn on Period-End Cutoff Export and set the cutoff date (defaults to the last calendar month-end inside the statement).
    3. Download two clean Excel files — a pre-cutoff file for the current period and a post-cutoff file marked Outstanding/In-Transit.

    Walkthrough: an April 30 cutoff on a May 3 statement

    Statement period: Apr 4 – May 3. Set the cutoff to Apr 30 and you get:

    • {bank}_2026-04-04_to_2026-04-30.xlsx — April transactions for the current reconciliation.
    • {bank}_2026-05-01_to_2026-05-03_OUTSTANDING.xlsx — May 1–3 with a Cutoff Status column for your working paper.

    Frequently asked questions

    Should I reconcile to the bank statement date or calendar month-end?

    Reconcile to whichever date your books close on — almost always calendar month-end. The complication is that bank statement cycles (e.g. the 4th to the 3rd) rarely line up with month-end, so you have to split the statement: transactions through your month-end date belong to the current period, and anything after it is an outstanding/in-transit item carried to next month's working paper.

    How do I handle transactions between the statement date and month-end?

    Treat them as a cutoff adjustment. Transactions dated after your reconciliation cutoff (but still on the statement) are outstanding/in-transit — they're real, but they belong to the next period. List them on a cutoff working paper so the current month reconciles to the book balance and nothing is double-counted.

    What is a cutoff working paper?

    A cutoff (or cut-off) working paper documents which transactions fall on each side of your period-end date when the bank statement spans the boundary. It's what an auditor checks to confirm transactions were recorded in the correct period. In practice it's two lists: pre-cutoff (this period) and post-cutoff/outstanding (next period).

    Can I import the cutoff Excel directly into QuickBooks Online?

    Yes. The pre-cutoff file has the same columns as a standard export, so you import it to QuickBooks Online via Banking → Upload transactions for the current period. Keep the post-cutoff OUTSTANDING file for your working paper, and import it next period.

    How does StatementToExcel split the statement?

    Upload the bank statement PDF, and STE detects the statement period from the transactions. Turn on Period-End Cutoff Export, pick the cutoff date (it defaults to the last calendar month-end inside the statement), and you get two clean files: a pre-cutoff file for the current period and a post-cutoff file marked OUTSTANDING/In-Transit. Everything is processed in memory and never stored.

    Does this do the reconciliation for me?

    No — STE produces the two correctly split export files; you (or your software) do the actual reconciliation. It removes the manual, error-prone step of slicing a PDF statement by date so your current-period file and your outstanding-items file are clean from the start.

    Split your next statement in seconds

    Upload a PDF, set the cutoff, get two clean files. Free to try — Period-End Cutoff Export is included on Starter and above.

    Try Period-End Cutoff Export →