Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
Phoscrete
Level 1

Quickbooks Cash Planner Ending Balance Changes for Previous Months

Why does the monthly ending balance change week to week for previous months in the QB Cash Planner? 

4 Comments 4
AbegailS_
QuickBooks Team

Quickbooks Cash Planner Ending Balance Changes for Previous Months

Hi there, @Phoscrete.

 

I can help clarify why the Cash planner ending balance in QuickBooks change.

 

It depends on the bank account you connected and the money in and out transactions that you add, edit, or delete. The ending balance of the cash planner will change if you make certain adjustments each week.

 

I suggest you to manually edit items or change the preferences in your planner if you want to have the same ending balance.

 

Here's how: 

  1. Go to Business overview or Cash flow, then select Planner.
  2. Select the item you want to edit.
  3. Change the date, name, amount field, money in or out, or the repeat details.
  4. Click Update to save your changes.


Check out this guide for more information: How QuickBooks calculates your cash flow.

 

Additionally, these articles provide an overview of how to get acclimated to the Cash Flow menu/planner.

 

Reach out to me again on this thread if you have additional questions or concerns. I’ll pop right back in assist further. Have a good one.

Phoscrete
Level 1

Quickbooks Cash Planner Ending Balance Changes for Previous Months

Thank you for your response! Just want to clarify/confirm, I am referring to the ending balances in cash planner for previous months. Each week we review and of course make adjustments/edits but the ending balances are changing each week for August and all the way back through January of this year. 

 

Does your response and information provided below still apply to previous months or is that just looking forward?

 

Thanks!

Phoscrete
Level 1

Quickbooks Cash Planner Ending Balance Changes for Previous Months

Thank you for your response! I just want to confirm...I am referring to ending balances for previous months. We review the cash planner report each week and each week the ending balances for August, all the way back through January of this year, change.

 

Just want to understand if your response and information below applies for previous months or if it's just looking forward.

 

Thanks!

AlcaeusF
Moderator

Quickbooks Cash Planner Ending Balance Changes for Previous Months

Hello @Phoscrete,

 

I appreciate you taking the time to get back to us about the changes to the ending balance. Allow me to step in and provide some clarification about the previous balance amounts on your Cash flow planner.

 

The ending balance from the previous months all depends on the added items in the planner. Ideally, the projected balances in the past should retain if there are no changes from your end.

 

I recommend reviewing your cash flow details to figure out the cause of the changes. It may be possible that there are items removed from the planner.

 

Here's how:

 

  1. Go to the Cash flow planner section.
  2. Scroll down to filter your transactions.
  3. Select the In the past option under the drop-down.

 

Additionally, you can change the planner's preferences to view the specific data you want. For more details, check out this link: Use the cash flow planner in QuickBooks Online.

 

Feel free to get back to me if you have more questions about the ending balances showing in the Cash flow planner. I'm always ready to lend a hand. Take care.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us