Period-End Cutoff Export

    Bank Reconciliation When the Statement Doesn't End at Month-End

    Banks close statements on their own cycle — the 4th through the 3rd, not the 1st through the 30th. EasyStatementSheet takes the statement PDF and hands back a clean pre-cutoff file plus a post-cutoff outstanding/in-transit file, so the month-end reconciliation ties out on the first pass.

    Try Period-End Cutoff Export →

    Free to test-drive · runs in memory, nothing saved

    Why cutoffs cause headaches

    Calendar month-end is when your books close — but the bank's cycle pays no attention to that. A statement covering April 4 to May 3 mixes two periods: April 4–30 belongs in April's reconciliation, and May 1–3 are outstanding/in-transit items that are really May's.

    Split it wrong and the reconciliation refuses to tie out — or transactions land in the wrong period entirely. This is precisely the thing auditors test for.

    How accountants normally handle it

    The textbook method: reconcile to the month-end book balance and back it up with a cutoff working paper — transactions through the cutoff date on one list (this period), and post-cutoff transactions still sitting on the statement on another (outstanding/in-transit, rolled into next period). That second list is what keeps both months honest.

    Where the manual work piles up

    With a PDF statement, the hand-done version means copy-pasting every row, sorting by date, and eyeballing where the cutoff falls — repeated for each client, every single month. It eats time, and being off by even a row or two breaks the reconciliation.

    The EasyStatementSheet way to split a statement

    1. Drop in the bank statement PDF — STE pulls every transaction and works out the statement period on its own.
    2. Flip on Period-End Cutoff Export and confirm the cutoff date (it pre-fills with the last calendar month-end the statement contains).
    3. Two tidy Excel files come back: the pre-cutoff file for this period, plus a post-cutoff file flagged Outstanding/In-Transit.

    A worked example: April 30 cutoff, May 3 statement

    Say the statement covers Apr 4 – May 3. Choose Apr 30 as the cutoff and the output is:

    • {bank}_2026-04-04_to_2026-04-30.xlsx — everything from April, ready for this month's reconciliation.
    • {bank}_2026-05-01_to_2026-05-03_OUTSTANDING.xlsx — the May 1–3 items, complete with a Cutoff Status column for the working paper.

    Cutoff questions we hear a lot

    Do I reconcile against the statement date or my calendar month-end?

    Always against the date your books close — for nearly everyone that's calendar month-end. The wrinkle is that a bank's statement cycle (say, the 4th through the 3rd) hardly ever ends on that date, which forces a split: everything through month-end sits in the current period, while anything dated later becomes an outstanding/in-transit item that rolls onto next month's working paper.

    What do I do with transactions that fall after month-end but before the statement date?

    Those are your cutoff adjustment. Anything on the statement dated past your reconciliation cutoff is genuinely posted — it just belongs to the following period, so it gets classified as outstanding/in-transit. Record those items on a cutoff working paper; that way the current month ties to the book balance and no transaction is counted twice.

    What exactly is a cutoff working paper?

    It's the document showing which side of your period-end each transaction landed on when a bank statement straddles the boundary. Auditors rely on it to verify that activity was booked in the right period. Practically speaking, it boils down to two lists — pre-cutoff items for this period and post-cutoff/outstanding items for the next.

    Will QuickBooks Online accept the cutoff Excel file directly?

    It will. The pre-cutoff export uses the same column layout as any standard export, so it goes into QuickBooks Online through Banking → Upload transactions for the current period. Hold the post-cutoff OUTSTANDING file back for your working paper and bring it in when the next period opens.

    What does the split actually look like in EasyStatementSheet?

    You upload the statement PDF and STE reads the statement period straight from the transactions. Switch on Period-End Cutoff Export, choose your cutoff date (the default is the last calendar month-end that falls inside the statement), and two tidy files come back: one pre-cutoff file for the current period, and one post-cutoff file labeled OUTSTANDING/In-Transit. All of it happens in memory — nothing is ever stored.

    Is the reconciliation itself automated?

    No — the actual reconciliation is still yours (or your software's) to perform. What STE eliminates is the tedious, mistake-prone chore of manually slicing a PDF statement at a date, so both your current-period file and your outstanding-items file start out clean.

    Your next cutoff split takes seconds

    One PDF in, a cutoff date picked, two clean files out. Try it free — Period-End Cutoff Export ships with every plan from Starter up.

    Try Period-End Cutoff Export →