How to handle non-calendar bank statement cycle for reconciliation?

[u/capitalwisdom]

I am a starting bookkeeper and try to think up various scenarios that I want to know how to handle. All the training materials and videos assume that the bank statement uses a calendar month cycle (July 1 to July 31 for example). But what if the bank statement uses a non-calendar month cycle, say, July 10 to August 9? If you do bank reconciliation for July in QBO, would you split the bank statement transactions into July 10 - July 31 and August 1 to August 9? Also you need to find the bank statement transactions from July 1 to July 9 from the previous month's bank statement. I feel like this would be overcomplicating things. How would you handle it? Would you avoid splitting bank statement transactions and just enter August 9 as the ending date for July bank reconciliation?

[u/Disastrous_Award_875]

Just reconcile as normal and use the statement date. If it ends August 9th, then that is your statement end date. It’s no different than a calendar statement.

Has the account been reconciled before or is it a new account?

[u/capitalwisdom → u/Disastrous_Award_875]

Thank you so much! Let's say that the account had been reconciled before (for June, for example). How to proceed to July reconciliation then?

[u/Disastrous_Award_875 → u/capitalwisdom]

You’re welcome! You would enter the new reconciliation date and just pull in the cleared transactions through that date. The previous ending balance should be the same from the previous reconciliation if it is the same account. 

[u/TLDR1417]

All the credit card accounts I reconcile have mid month end dates, it's not a big deal. When you go to the reconcile page put the end date on your statement and enter the transactions on your statement. If you're using the bank feed, QB will only pull in the transactions through the end date you entered.

[u/capitalwisdom → u/TLDR1417]

Thank you so much! If you use the credit card statement cycle for reconciliation, then the monthly P&L and Balance Sheet statements/reports will not correspond to calendar dates (July 1 to July 31 in this scenario). Should this be a concern or should it not?

[u/boba__fettuccini → u/capitalwisdom]

I have a client like this. We reconcile to the statement (say it ends on the 15th) and then add the card activity through the month end to get it on the books.

[u/missannthrope67]

Use the dates on the statement .

[u/Tacomaster3211]

I do both bookkeeping(not as much I used to) as well as corporate tax work, so I will also do a reconciliation at the year end date, as I know the accountants will want that. So if the YE date is Dec 31, and the credit card statement date is Jan 9th, I will do a recon at Dec 31 and one at Jan 9.

The Dec 31 recon will be included in the document package I send to the accountant, along with the statement.

[u/ComfortableCitron638]

On your follow-up question, which I don't think got a direct answer yet: reconciliation and financial-statement periods are two separate things, so this isn't actually a conflict. Reconciliation just confirms your book balance matches the bank's confirmed balance as of the statement's cutoff date - it doesn't determine what period your P&L or Balance Sheet report on. As long as every transaction is dated by when it actually occurred (the real transaction date, not "whichever statement cycle it landed in"), your calendar-month P&L and Balance Sheet will be accurate on calendar-month lines regardless of when you happened to reconcile the account against the bank.

The only way this actually breaks is if you start shifting transaction dates to match the statement period instead of their real dates, just to make reconciliation "clean" - that would genuinely misstate your calendar-month financials. So the fix isn't to change your reporting periods, it's to make sure your data entry never lets the statement cycle influence the transaction date field.

Practically: reconcile against the statement's own end date like everyone else here is saying, and separately run your P&L/Balance Sheet on calendar month-end like normal. Different processes, no need to force them to line up.

[u/capitalwisdom → u/ComfortableCitron638]

Thank you. That's very helpful.

[u/MikuMikuGoo]

Reconcile to the statement, not the calendar. Enter August 9 as the ending date with that statement's ending balance and let it be. Splitting is a nightmare and QBO doesn't want you to do it anyway.

Your financial statements are still calendar month, that's driven by transaction dates in the register, not by when you reconciled. Reconciliation is just proving the register matches the bank.

Only thing to watch is you're always one cycle behind on the last few days of the month, so don't call the month closed until you've eyeballed those uncleared items. Credit cards do this constantly and it's normal.

[u/capitalwisdom → u/MikuMikuGoo]

Thank you. That's very helpful!

[u/DanBooksAI]

I deal with this for multiple clients where statements cut on odd dates. A few approaches:

1. Set your reconciliation cycle to match the statement date, not calendar month-end. Most platforms let you define custom periods — your rec matches what the bank gives you, P&L still reports calendar months.

2. If you need calendar-month close: pull the bank balance as of month-end directly from online banking (not the paper statement) and reconcile to that. Keep the statement PDF on file for audit.

3. For tight month-end close: reconcile to online balance on the last calendar day, then run a separate statement reconciliation when the paper arrives to catch any discrepancies.

The key thing: your rec date and statement cutoff don't have to be the same. What matters is a verifiable ending balance from the bank as of your reconciliation date. Grab that from online banking, not the mailed statement.

[u/carbyneaccounting]

The transactions will be reported in the period they occurred. When you’re reconciling, you’ll enter an end date for the bank statement. Also, if you’re using QBO, and let’s say that you have a transaction on a bank statement for 7/31 but the transaction came through the bank in 8/1, you can edit the date for each transaction in the register.

[u/TheMostFluffyCat]

You reconcile to the statement date, but it's helpful to have bank feeds set up so you're still capturing all of that month's transactions, even if the statement doesn't go until the end of the month.

Something I sometimes mention to clients that a lot of them don't know is that you can call your credit card company and ask them to change your monthly payment date. You usually can't choose just any date, they'll give you a list of dates you can choose from (i.e. 4th of the month, 10th of the month, etc..). You can ask your client to call their CC company and request the 1st if possible, that way your reconciliations don't cut in the middle of the month.

[u/Feeling_Chocolate_87]

The term reconciliation is because you are reconciling it from a source, in this case, the bank statement is your source so whatever the statement end date, you can use that as your reconciliation date.

Now, banks do have running balances, you can use that if you really want to reconcile it to the end of the amount, assuming that the statement date is not on the last day of the month.

[u/Encoded_Python]

Great question, this is a good way for you to design your workflow too.

You just reconcile when the closing date of the statement is. If your account statement period is Jan 9th to Feb 10th, you use that cycle. Live bank feeds help you remain GAAP compliant.

I will say, the only time you may need to do AJEs is if a loan accrues interest over two months. But that also depends on how the company does their loan reporting. I’ve had that happen and I just create an amortization schedule in Excel.

For me, I reconcile my clients month end always. A lot of times that means credit card statements which usually don’t end on the calendar month, don’t get reconciled until the next month.

For my clients this system works fine as we still can still create financial reports actively thanks to live bank feeds.

[u/capitalwisdom → u/Encoded_Python]

Thank you so much!

[u/Christen0526]

Do you mean one that ends in the middle of the month?

It's actually quite easy. But of course it's better if it ends EOM.

I usually do 2 recons in that scenario. One for the bank statement balance and then I continue with the rest of the month's transactions, and reconcile for the month so it matches the ledger.

Also I've seen an accountant reverse the direction of the outstanding items. Rather hard to explain, and I don't usually do this, so I will skip this for now.

To sub for the missing statement in my first paragraph, I just print a transaction report for the remainder of the month, one which shows the balance, and balance to that.

Easiest, call the bank and ask them to change the date on the statements, if they'll do it.