Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello, @houstonwb-elswor.
I'm here to assist with creating an 18-month budget for your organization in QuickBooks Online (QBO).
In QBO Plus and Advanced, you can create a profit and loss budget to track income and expenses, and a balance sheet budget to track your financial position. I suggest creating one for profit and loss budget.
Next, to account to the cyclic patterns of your organization and project through the cash low point, you can use QBO's Cash flow planner in identifying regular fluctuations in financial data that occur over time and use the planner as a forecasting tool in making necessary preparations and adjustments in your budget plan. Here's how you can do this:
To learn more about using the cash flow planner, let me add this article as a guide: Use the cash flow planner in QuickBooks Online.
Moreover, as a future guide, I'm adding this reference on customizing your reports to emphasize information that matters to you the most and get valuable insights for your business: Customize reports in QuickBooks Online.
If you need further assistance creating a budget and project through the cash low point in QBO, we're always here in the Community to help. Take care.
Here is a basic outline of how to do this:
1) Verify you have QB Plus or Advanced. Budgeting is only available in one of those versions.
2) Click on Financial Planning
3) Click Create Budget
4) QuickBooks as an option to import a budget. This is what you want to do.
4.1 - You are going to download the template .
4.2 - Then you are going to to the budget in Excel. This is going to allow you to put together a budget through either a traditional approach (calls to departments, etc.) or a data science approach (predictive models) in order to capture the cyclical nature of your business.
4.3 - To do 18 months, you are going to input information for the 12 months of the first year and the 6 months of the next year.
5) As mentioned in https://www.youtube.com/watch?v=5crjyrTEOEQ , once you create a budget, there should be an option to compare Budget against Actuals.
Hope this helps.
Best,
Ralph Brooks
PS: I have a finance and a data science background. Happy to help anyone who has additional questions on this. My email is [email address removed] .
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here