Bank Statement

Basmavy · ‎February 03, 2021

Hello,

I am a new user and just set up my account. Our company uses a calendar month and year yet our bank statements and credit card statements are not on a calendar date.

I am wondering if I can reconcile to the calendar month.?

JamesM4 · ‎February 03, 2021

I see what you're saying. If you've got the Feb 1 - 28 transaction in your QuickBooks account you can definitely reconcile for that date range. To do this, click on Accounting from the left navigation menu > click on Reconcile > enter the ending balance and the end date > once your reconciliation page comes up, you can customize your transactions so you can view a custom date range. To do this, click on the filter/funnel icon and filter for custom dates. Here's a screenshot for visual reference:

Let me know if this helps. I'll be here.

View solution in original post

JamesM4 · ‎February 03, 2021

Hello Basmavy,

Glad to learn you're a new user. Welcome to the QuickBooks Online family. I'll be happy to give you a hand with reconciling and making sure you're using the right date format.

QuickBooks Online is a user-friendly program which makes it simple to navigate and make the changes you need to make. The program provides the flexibility of being able to change your date format and here's how:

Click on the Gear icon.
Click on Account and Settings.
Go to Advanced.
Click on the pencil icon under Other preferences, select the date format that you want to use.
Click on Save under other preferences.
Click on Done.

This change will also reflect on your reports. Since you're going through the reconcile process, here are some helpful resources to guide you:

I encourage you to check this information out and if you have questions, don't hesitate to reach back to me, I've got your back.

Basmavy · ‎February 03, 2021

Thank you so much. I will do that.

Enjoy the day

Basmavy · ‎February 03, 2021

Sorry I don't think this is what I'm looking for.

Our business is Feb 1 - 28 yet bank statements are Feb 9- Mar 10. Is it possible to only reconcile Feb 1- 28?

JamesM4 · ‎February 03, 2021

I see what you're saying. If you've got the Feb 1 - 28 transaction in your QuickBooks account you can definitely reconcile for that date range. To do this, click on Accounting from the left navigation menu > click on Reconcile > enter the ending balance and the end date > once your reconciliation page comes up, you can customize your transactions so you can view a custom date range. To do this, click on the filter/funnel icon and filter for custom dates. Here's a screenshot for visual reference:

Let me know if this helps. I'll be here.

solytierra · ‎September 18, 2021

Hey @Basmavy did you find the answer to your question? I'm a new user and I have the exact same question right now. Thanks!

Henock K · ‎September 20, 2021

Hey solytierra,

Thanks for joining this thread. Reconciling your account is a great way to ensure that all of your banking transactions are properly recorded in your books. QuickBooks offers the ability to easily reconcile your account to make sure your account is correct. I'll be happy to help you with this.

As mentioned by James, with the screenshot provided above, you can customize the end date before you start your reconciliation even if the company calendar and the bank statement calendar date are different. Here are the steps to follow to start reconciling your account.

1. Click on Accounting from the left navigation menu.
2. Select Reconcile tab.
3. Enter your Ending balance and the End date.
4. Once the reconciliation page appears, click on the funnel/filter icon to customize the date range according to your bank statement in order to reconcile.

Feel free to reach out if you have any questions. I'll be glad to help.

Topics

Training

Community

Resources

Bank Statement

Bank Statement

Bank Statement

Bank Statement

Bank Statement

Bank Statement

Bank Statement

Bank Statement

Need to get in touch?