Bank Reconciliation Cutoff: The Complete Guide to Month-End Splits

Bank reconciliation cutoff is the date your books close when reconciling against a bank statement that runs on a different cycle. This page is the directory of reconciliation cutoffs, by bank. It tells you how each bank’s cycle works and how to split a statement at month-end.

The detailed cutoff guides for 10 major US banks and credit unions are linked below, organized by cycle behavior and the period-end split mechanics.

The reconciliation cutoff is your book close date (calendar month-end for almost every business), not the statement date. When a bank statement spans the boundary, you split it at month-end: pre-cutoff transactions stay in the current period, post-cutoff transactions move to outstanding or in-transit for the next.

Bank statements rarely end on month-end. Banks close statements on their own cycle, anchored to the day the account was opened or to a billing date. The Period-End Cutoff Export tool reads the statement PDF and gives you two clean files: a pre-cutoff file for the current period and a post-cutoff file marked OUTSTANDING.

For specific banks, see the guides below. For the broader conversion workflow, see the converter guide.

What the Bank Reconciliation Cutoff Actually Is

The bank reconciliation cutoff is the date your books close. For almost every small business, bookkeeper, and accountant, that is calendar month-end. The reconciliation ties your book balance (what your accounting software says) to the bank balance (what the bank says) as of that date.

The complication: bank statements rarely end on month-end. Banks close statements on their own cycle, anchored to the day the account was opened or to a billing date, and that cycle almost never lands on the 30th or 31st.

So a statement running April 4 to May 3 mixes two periods. April 4 through April 30 belongs to April. May 1 through May 3 belongs to May, even though everything sits on the same PDF.

The cutoff is the line. The reconciliation is the act of splitting the statement at that line and recording the right items on each side.

Pre-Cutoff vs Post-Cutoff

Pre-cutoff is everything dated through your cutoff date. Those transactions go into the current period’s reconciliation and match the book balance. Post-cutoff is everything dated after your cutoff, even if those transactions appear on the same PDF. Those are outstanding or in-transit items, and they roll onto the next period’s working paper.

The label “outstanding” usually means a check the business wrote that the bank has not yet cleared. The label “in-transit” usually means a deposit the business made that the bank has not yet posted. Both end up in the post-cutoff file. The split keeps both months honest: nothing is double-counted, nothing is missing, and the auditor can trace every transaction to the right period.

What a Cutoff Working Paper Looks Like

The cutoff working paper is a single page or spreadsheet with two columns. The first column lists the pre-cutoff items that hit this period. The second column lists the post-cutoff items that carry forward. The auditor reads the working paper to confirm that the bookkeeper applied the cutoff correctly.

For a typical statement running April 4 to May 3, the working paper has:

• Pre-cutoff column: every transaction dated April 4 through April 30. That is roughly 27 days of activity, often 40 to 80 transactions depending on the account.
• Post-cutoff column: every transaction dated May 1 through May 3. That is 3 days of activity, often 2 to 5 transactions. Each row is marked “Outstanding Check” or “In-Transit Deposit” with a note explaining why it is on the wrong side of the line.

The two columns sum to the full statement period. The pre-cutoff column is what reconciles to the book balance at April 30. The post-cutoff column is the carry-forward that reconciles on May 1’s working paper.

Why Bank Statement Cycles Do Not End on Month-End

Banks close statements on their own cycle because that is how their back-office systems work. The cycle is anchored to one of three things: the day the account was opened, a fixed calendar date (like the 1st), or a billing date (like a credit card cycle). The cycle has nothing to do with your fiscal month-end, and there is no industry standard.

What you can rely on: every major US bank and credit union has a monthly statement cycle (with some CD and IRA exceptions for quarterly cycles). The cycle date is whatever the bank decided, and it is not negotiable except by calling the bank and asking. Even then, the bank may or may not accommodate.

For bookkeepers with multiple clients across multiple banks, the result is a different cycle date for every client. The same calendar month looks different on every statement. The cutoff working paper has to be customized for each account.

The Cutoff Split Mechanics

The split is mechanical. The PDF is in. The cutoff date is set. Two files come out.

1. Open the statement PDF. Confirm the statement period (start and end dates on page 1).
2. Identify the cutoff date. The cutoff is your book close date (calendar month-end) that falls inside the statement period. If the statement is April 4 to May 3, the cutoff is April 30. The next month’s reconciliation starts with May 1.
3. Upload the PDF to the Period-End Cutoff Export tool. The tool reads the statement period and pre-fills the cutoff date with the last calendar month-end inside the statement.
4. Confirm or adjust the cutoff date. Most bookkeepers accept the pre-filled value. Adjust it if your fiscal month-end differs from the calendar month-end.
5. Download the two files. The first is the pre-cutoff file, named with the bank, the pre-cutoff date range, and the .xlsx extension. The second is the post-cutoff file, named with the bank, the post-cutoff date range, the OUTSTANDING marker, and the .xlsx extension.
6. Open the pre-cutoff file in your reconciliation software. Match it to the book balance. The pre-cutoff file should tie out to the bank balance as of month-end, less any outstanding checks and plus any deposits in transit that the bank has not yet posted.
7. Hold the post-cutoff file for next month’s working paper. The post-cutoff file is a carry-forward. Its transactions get imported at the start of next month and applied to that period’s reconciliation.

The whole flow takes about 5 minutes per statement once you have the PDF. Manual split takes 30 to 60 minutes per statement, mostly because of the date sorting and the copy-paste errors. The tool’s value is the elimination of the manual split, not the file generation itself.

Outstanding Checks

An outstanding check is a check the business wrote and recorded in the books, but the bank has not yet cleared. The check is “in flight” between the business and the payee’s bank. It will eventually clear, but the timing depends on the payee’s deposit cycle and the bank’s processing time.

Outstanding checks almost always fall in the post-cutoff column when the cutoff is calendar month-end. The business wrote the check in March, the payee did not deposit it until April 1, the bank did not clear it until April 5, and now it shows up on an April statement.

The cutoff adjustment is to record this check as an April transaction, not a March transaction, and to add it to the post-cutoff column of the March working paper.

Deposits in Transit

A deposit in transit is a deposit the business made and recorded in the books, but the bank has not yet posted. The deposit is “in flight” between the business and the bank. It will eventually post, but the timing depends on the bank’s processing time.

Deposits in transit almost always fall in the post-cutoff column when the cutoff is calendar month-end. The business made the deposit on March 31, the bank did not post it until April 2, and now it shows up on an April statement.

The cutoff adjustment is to record this deposit as a March transaction (since the business

made it in March), and to add it to the post-cutoff column of the March working paper so the bank balance is corrected.

Which Banks Have the Cleanest Cutoff Splits

Some banks have predictable cycle dates, which makes the cutoff split easier. Others have variable cycle dates, which means the bookkeeper has to check the cycle for each account every month. Here is the quick reference for the 10 major US banks and credit unions covered in this guide.

Ally Bank Cutoff Split

Ally Bank statement cycles are anchored to the day each account was opened. Different customers have different cycle dates (3rd, 8th, 19th, 20th, etc.), so the same calendar month looks different on every Ally Bank statement. CDs and IRAs are quarterly, not monthly. Cycle changes require a call to Ally. The detailed guide covers the cycle mechanics and the split step-by-step.

Detailed steps: Ally Bank reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/ally-bank.

JPMorgan Chase Bank Cutoff Split

Chase statement cycles are anchored to the day the account was opened, similar to Ally. Checking, savings, and money market accounts are monthly. Credit cards are on a separate billing cycle. Chase business accounts have a different cycle from personal accounts, often on the last business day of the month.

The split mechanics are the same as Ally. The cycle date lookup is in the Chase app under “Account Details.”

Detailed steps: Chase reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/chase.

Wells Fargo Cutoff Split

Wells Fargo statement cycles are also anchored to the account open date, similar to Ally and Chase. Checking and savings are monthly. CDs are quarterly. Wells Fargo business banking has a separate portal with its own cycle, often ending on the last business day of the month, which makes the cutoff split easier.

The split mechanics are the same. The cycle date is in the Wells Fargo app under “Account Services.”

Detailed steps: Wells Fargo reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/wells-fargo.

Bank of America Cutoff Split

Bank of America statement cycles are anchored to the account open date for most account types. Some BofA accounts have a fixed cycle date (like the 1st or 15th), which makes the cutoff split predictable. BofA Preferred Rewards combined statements have a single cycle for all linked accounts, which is convenient. The split mechanics are the same.

Detailed steps: Bank of America reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/bank-of-america.

Citibank Cutoff Split

Citibank statement cycles are anchored to the account open date. Personal banking, business banking, and credit cards each have their own cycle, so the same customer can have three different cycle dates. The split mechanics are the same. The cycle date is in the Citibank app under “Account Details” or on the first page of any past statement.

Detailed steps: Citibank reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/citibank.

Capital One Cutoff Split

Capital One statement cycles are anchored to the account open date for banking products. Credit cards have a separate billing cycle. Capital One 360 (the online banking product) tends to have cleaner cycle dates than the credit card products, often on the 1st or 15th. The split mechanics are the same.

Detailed steps: Capital One reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/capital-one.

American Express Cutoff Split

American Express statement cycles are billing cycles, not open-date cycles. The cycle is fixed to a specific date (often the 5th, 10th, or 20th of the month), and the statement always closes on that date regardless of when the account was opened. The split mechanics are the same. Amex business accounts have a different cycle from personal accounts.

Detailed steps: American Express reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/american-express.

Charles Schwab Bank Cutoff Split

Charles Schwab Bank statement cycles are anchored to the account open date. Brokerage and bank accounts have separate cycles. The split mechanics are the same. The cycle date is in the Schwab app under “Account Settings” or on the first page of any past statement.

Detailed steps: Charles Schwab reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/charles-schwab.

BMO Harris Bank Cutoff Split

BMO Harris statement cycles are anchored to the account open date. Personal banking, business banking, and commercial banking each have separate cycles. BMO Harris has fewer self-service cycle management options than the bigger banks. The split mechanics are the same. The cycle date is in the BMO app or on any past statement.

Detailed steps: BMO Harris reconciliation cutoff guide. Tool: /bank-reconciliation-cutoff/bmo-harris.

Citizens Bank Cutoff Split

Citizens Bank statement cycles are anchored to the account open date. Personal banking, business banking, and student loans have separate cycles. Citizens Bank has a smaller geographic footprint (mostly Northeast US) but the same cutoff mechanics as the larger banks. The split mechanics are the same.

Detailed steps: Citizens Bank reconciliation cutoff

guide. Tool: /bank-reconciliation-cutoff/citizens-bank.

QuickBooks Reconciliation With the Cutoff Files

QuickBooks Online accepts the pre-cutoff file through the standard banking import. The columns match. The flow is the same as any other statement import.

1. Log into QuickBooks Online. Click “Banking” or “Transactions” → “Banking.”
2. Click the bank account.
3. Click “Upload transactions” or “File upload.”
4. Select the pre-cutoff file for the current period.
5. QuickBooks matches the imported transactions to the book. Unmatched transactions get categorized or added as new.
6. Click “Reconcile.” The pre-cutoff file’s ending balance should match the book balance as of month-end, adjusted for outstanding checks and deposits in transit.
7. Hold the post-cutoff file. Do not import it this period. It goes to next month’s working paper.

For QuickBooks Desktop users, the import is through the “File → Utilities → Import → Web Connect” or “File → Import → Excel” path. The pre-cutoff file imports the same way. The post-cutoff file is held for next month. Our QuickBooks conversion guide covers the import dance for both QFX and QBO files. The reconciliation-specific dance is the same regardless of the file format.

For Xero, Sage, Wave, and other non-QuickBooks software, the pre-cutoff file imports the same way. The columns are standard (Date, Description, Amount, Balance, Cutoff Status). Any reconciliation software that accepts an Excel or CSV import will accept the cutoff files.

Common Mistakes That Break the Cutoff

Five mistakes that bookkeepers make on the first attempt at a cutoff split. Each one breaks the reconciliation. Each one is fixable once you know the pattern.

Mistake 1: Reconciling to the statement date instead of month-end. The statement ends on the 19th, so the bookkeeper reconciles to the 19th. The book balance is for the 30th. The reconciliation refuses to tie out by 11 days of activity.

The fix: always reconcile to the calendar month-end (or your fiscal month-end), not the statement date. The statement date is the bank’s cycle. The month-end is your book cycle. They are not the same date, and the difference is exactly the cutoff adjustment you are trying to capture.

Mistake 2: Skipping the cutoff working paper. The bookkeeper imports the whole statement, marks it as reconciled, and moves on. The bank balance matches. The bookkeeper is happy. The auditor shows up, asks for the cutoff working paper, and there is none. The auditor has to reconstruct it. The audit takes longer. The bookkeeper’s reputation takes a hit.

The fix: always produce a cutoff working paper, even if the statement happens to end on month-end that one time. The working paper is the audit trail. Skipping it is like filing taxes without keeping receipts.

Mistake 3: Double-counting the post-cutoff items. The post-cutoff transactions are sitting on the May 1 working paper. The bookkeeper also imports them as part of the May statement. The total is now wrong by exactly the post-cutoff amount. The reconciliation refuses to tie out.

The fix: the post-cutoff items get imported ONCE, at the start of the next period. They do not get imported again when the May statement arrives. Mark them as “Already imported from April cutoff” in the next month’s working paper.

Mistake 4: Forgetting that the cycle can change. The client called the bank six months ago and changed the cycle from the 8th to the 19th. The bookkeeper is still using the 8th for the cutoff split. Every statement since the change has been split wrong. The reconciliation is off by 11 days of activity for the last six months.

I learned this the hard way the first time a bookkeeper called saying the reconciliation was off by $4,200. We had used the PDF’s “Statement Period” end date, but the client had called the bank two months earlier and changed the cycle. The PDFs still showed the old date. The app showed the new date.

The bookkeeper had to re-split the last two months of statements to match.

The fix: re-check the cycle in the live app at the start of every new reconciliation cycle. Do not trust historical PDFs. The app is live. The PDF is a snapshot.

Mistake 5: Reconciling the wrong account. The bookkeeper has four accounts for the client. The split is done on the savings account. The reconciliation is for the checking account. The numbers do not match. The bookkeeper spends an hour debugging before realizing the wrong PDF was uploaded.

The fix: name the pre-cutoff and post-cutoff files with the account name in the filename, not just the bank name. The Period-End Cutoff Export tool includes the account in the filename by default. Use that.

The fix: name the pre-cutoff and post-cutoff files with the account name in the filename, not just the bank name. The Period-End Cutoff Export tool includes the account in the filename by default. Use that. Do not rename the files to something generic like “April Pre.xlsx” without the account identifier.

The 2am Test for Reconciliation Cutoff Splits

If you are doing a cutoff split at 2am because the client needs the reconciliation by morning, here is the flow that works.

1. Open the bank’s portal. Log in. Download the statement PDF for the period you need.
2. Confirm the cycle date in the app under “Account Details” or “Profile.” The cycle date is the day the bank closes the statement each month.
3. Identify the cutoff date. The cutoff is the last calendar month-end that falls inside the statement period. For a March 19 to April 18 statement, the cutoff is March 31.
4. Upload the PDF to the Period-End Cutoff Export tool. Confirm the pre-filled cutoff date.
5. Download both files. Import the pre-cutoff file into QuickBooks. Hold the post-cutoff file for next month.
6. Reconcile in QuickBooks. The pre-cutoff balance should match the book balance as of month-end, adjusted for outstanding checks and deposits in transit.

If the reconciliation does not tie out, the most common cause is the cycle date changed. Re-check the app. If the cycle date is correct, the second most common cause is an outstanding check or in-transit deposit that the bookkeeper missed. Add it to the cutoff working paper. The reconciliation should tie out within 5 minutes of investigation.

For the broader bank statement workflow, our bank-statement-converter guide covers the major banks, credit cards, and credit unions in one map. The cutoff split is the layer on top of the conversion: the conversion gets the statement into Excel, and the cutoff split separates the pre-cutoff and post-cutoff files for the reconciliation.

For the related large bank reconciliation cutoff: chase, boa, wells fargo, citi page, see the linked article. For the related regional bank reconciliation cutoff: capital one, pnc, us bank, truist page, see the linked article. For more on this, see the accountant workflow page.

For more on this, see the bank statement for small business page.

For more on this, see the bank statement for freelancers page.

For deeper understanding, see: How Bank Reconciliation Mechanism.

Related:

This topic sits inside the bank-reconciliation cluster on this site. The consolidated overview, covering what reconciliation is, why it matters, how each US accounting software handles it, and the quarterly close workflow, lives in the complete how-bank-reconciliation hub.

For related reading on the broader statement-reading clusters, see the
and the
. The expanded bank statement anatomy is a useful primer for first-time readers.