To reconcile a bank statement that ends mid month, reconcile the ledger to the statement's own closing date, such as the 15th, not to month-end. Then roll the agreed balance forward with the ledger activity from the 16th to the 31st. If that extra step costs too much every month, ask the bank to move the statement cycle.
Which date should a mid-month bank statement be reconciled to?
A mid-month bank statement must be reconciled to its own closing date. The bank's balance is only known at that date, so the ledger has to be read at the same point: filter the cash account for activity up to and including the 15th, and reconcile that figure to the statement's closing balance.
Reconciling a 15 March statement to a 31 March ledger balance mixes two cutoffs. Every receipt and payment from the 16th onwards would show as a timing item, and the outstanding list would swell with lines that are not outstanding at all. They simply happened after the bank stopped counting.
Run the ledger report, or set the reconcile screen, as of the statement date. The reconciliation itself then works exactly as for a statement that ends on the last day of the month.
Rolling the mid-month bank statement forward to month-end
A roll-forward carries the reconciled balance at the statement date to month-end using ledger activity for the days in between. It proves that the month-end cash figure in the books rests on a balance the bank has confirmed. Without it, the second half of the month is untested until next month's statement.
The table below is an example for a fictional company whose statement closes on 15 March. All values are examples.
| Line | Amount |
|---|---|
| Adjusted balance per bank, 15 March | 21,150.00 |
| Add: receipts recorded 16 to 31 March | 14,300.00 |
| Less: payments recorded 16 to 31 March | (11,920.00) |
| Expected book balance, 31 March | 23,530.00 |
| Balance per ledger, 31 March | 23,530.00 |
| Difference | 0.00 |
A zero difference shows the ledger is internally consistent from the 15th to the 31st. It does not show the bank agrees with those sixteen days. For that, download the bank's transaction history to 31 March from online banking and tick the activity against it, or wait for the 15 April statement and tick the 16 to 31 March lines when it arrives. Note which evidence you used in the workpaper.
Outstanding items on a statement that ends mid month
Outstanding items on a mid-month statement are listed at the statement date, exactly as for any reconciliation. A check written on the 10th that has not cleared by the 15th is outstanding. A check written on the 20th is not outstanding on this reconciliation at all. It belongs to the roll-forward period.
The rules for which items qualify are the same as on any statement, and they are set out in outstanding checks and deposits in transit, explained. What changes is the age of each item. A mid-month cycle shifts every cleared date by half a month against your close, so a check can look older or newer than it is depending on which date you count from. Age items from the date written and keep the counting rule fixed.
Two kinds of item need extra care on a mid-month cycle:
- Voids. A check voided between the 16th and the 31st was outstanding at the statement date and must come off the list in the next reconciliation, not this one. Voided checks on a bank reconciliation works through the timing of each case.
- Very old items. A mid-month cycle can make it easy to lose track of when a check passed a dormancy date. When uncashed checks become unclaimed property explains the reporting that follows.
Can you ask the bank to move a mid-month statement cycle?
Whether a bank will move a business account's statement cycle to month-end depends on the bank and the account, so ask the branch or business banking team. A month-end cycle removes the roll-forward step for good, which is worth a phone call on any account reconciled monthly.
Watch the switch month closely. Moving from a 15th cycle to a month-end cycle usually produces one short or long statement, for example 16 March to 30 April, or 16 March to 31 March. Reconcile that statement to its own dates like any other, and make sure no days fall between the old and new cycles. Footing the transition statement from its opening to its closing balance confirms nothing was lost in the change.
Some accounts keep a mid-month cycle for good reason. Associations whose dues fall due mid-month, or accounts whose fiscal reporting follows a different calendar, may prefer it. HOA bank reconciliation for operating and reserve accounts is one place where the statement cycle and the board's reporting calendar often differ.
Edge case: a mid-month statement in the year-end month
A mid-month statement in the final month of the fiscal year needs bank evidence for the roll-forward days, not just ledger arithmetic. Year-end cash is the figure auditors test hardest, and a balance confirmed only to the 15th leaves half a month untested at the most important date.
Get one of these for the days from the statement date to year-end:
- A printed or exported transaction history from online banking, covering the period, with the closing balance on the year-end date.
- A bank-issued interim statement or balance letter as of the year-end date.
- For audited entities, the bank confirmation, which states the balance at the year-end date regardless of the cycle.
Reconcile the year-end balance directly to that evidence, then also keep the ordinary mid-month reconciliation. The two together show the bank and the books agree at both points.
PreciseBankFlow foots each statement between its own printed opening and closing balances, whatever dates they fall on, so a mid-month cycle or a short transition statement is checked like any other. You can ask for a spot in early access.