Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
team-lekkerwine-
February 11, 2023
Question

There are fixed monthly expenses that are not appearing in my Cash Flow Planner. How do I get these expenses to appear in the Cash Flow Planner automatically?

  • February 11, 2023
  • 1 reply
  • 7 views
It seems that the Cash Flow planner is not picking up all the monthly expenses even though there is regular history of these transactions?

    1 reply

    J
    jamespaul
    Level 8
    February 11, 2023

    Hello, team-lekkerwine-.

     

    Ideally, when you enter a money-out or money-in transaction, it would automatically flow to the planner. Though, there are certain things that would prevent us from seeing the entries. I'll drop a few solutions to ensure that the Cash Flow Planner would pick up all of your expenses.

     

    Let's start with the filters. Let's make sure that the Filter setting includes all transactions. 

     

    On the Cash Flow Planner screen, click the Filter button, then make sure the Expenses box is checked. Hit Apply Filters once done. 

     

     

    Next, lets make sure that the bank account is selected so it is included on the planner. On the Cash Flow Planner page, click the small gear icon, then make sure that the banks are checked. Hit Save when done. 

     

     

    Aside from the filter and the bank, let's also update the planner's transactions list. Those expenses may be included in the Overdue transactions. We can manually update this by clicking on the Update button. 

     

     

    I also take it that you've also connected your bank to the Online Banking feature. Let's make sure that those expenses are categorized and added to your books, so they would flow to the planner properly. 

     

    If you need a reference or two about the Cash Flow Planner, I'll add this article: Use the cash flow planner in QuickBooks Online.

     

    After fixing the missing expenses, do you need to reconcile your account after planning out your cash flow? Check out this guide if you need help in the future: Reconcile an account in QuickBooks Online. 

     

    Let me know if you have more questions about using the Cash Flow Planner. If you have other concerns on other entries or when you pull up a report, drop the details below and I'll help you out. 

    T
    team-lekkerwine-Author
    February 11, 2023

    Thanks James for your detailed response.

    I have checked everything you have recommended and there was no need to change anything as it was as you needed it, but nothing has changed on the planner.

    My bank account is reconciled up to Dec 31st with the correct categorization of the expenses.

     

    Anything else you can recommend?

     

    Again thanks for your help.

    J
    jamespaul
    Level 8
    February 11, 2023

    You're welcome, team-lekkerwine-.

     

    Thanks for the update! I would like to dig a little deeper on the missing expenses on the Cash Flow Planner. 

     

    Going back to your original post, you mentioned something about fixed monthly expenses. Are you referring to a recurring expense template? If so, only the future expenses (scheduled but not yet entered in QuickBooks) would appear on the chart. 

     

    Previously entered expenses (from the template) would disappear from the chart. Though, we may still find them on the In the past page, provided that the planner picked them up before (click on the Upcoming drop-down menu, then select In the past). 

     

    If these are fixed monthly credit card transactions, then these won't show up on the chart as well. Here are additional pointers that the cash flow planner won't include:

     

    • Credit card transactions
    • Trust account transactions
    • Transactions you've entered manually into QuickBooks (previously dated transactions). 
    • Multi-currency enabled files
    • Journal entries


    To elaborate further, the Cash Flow Planner would show transactions like bills, expenses (from recurring templates), and invoices. Once these transactions are paid and processed, then they won't show up on the chart. 


    If you'd like to track your financials through reports, I'll add this article in case you need help utilizing the feature: Run reports in QuickBooks Online.

     

    I'm willing to help you out again if you have something else you'd like to clarify. I'll cover topics ranging from the Cash Flow Planner to reports. 

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement