Skip to main content
July 27, 2021
Question

Budget fiscal year selection

  • July 27, 2021
  • 1 reply
  • 0 views

I'm trying to upload our FY 21-22 budget into QBO but there's no place to select the correct fiscal year when you're using the "Import Budget" screen. When I import it, the budget lands in the previous fiscal year (20-21) instead of the current (21-22); not sure why it's doing this.

 

I see there are fiscal year selections only on the "Add Budget" screen. I don't want to have to manually add each budget (we have many for grants), how can I use the Import Budget screen but get the budget into the correct fiscal year??? Our QBO version is Advanced. Any help you 

1 reply

July 27, 2021

Hello, AppleLa2. 

 

In QuickBooks Online Plus and Advanced, you can create budgets based on your accounting data. Once your budgets are in QuickBooks, you can review and adjust everything. Then run financial reports to compare your actual sales and expenses with your budget.  

 

Step 1: Review your business' fiscal year

 

Make sure the beginning of your fiscal year is set in QuickBooks. You can create a budget any time, but it helps if you start at the beginning of the fiscal year.

  1. Sign in to QuickBooks Online.
  2. Go to Settings and select Account and settings.
  3. Select the Advanced.
  4. In the Accounting section, review the First month of the fiscal year field. To change the date, select Edit.

Step 2: Get your budget data

 

If you already have your budget data, you can skip this step. If you don't have any data yet, use your QuickBooks data to get started:

  1. Go to the Reports.
  2. Select and open the Profit and Loss Detail report.
  3. From the Report Period ▼ dropdown, select a timeframe. If you want to use last year's data, select Last year.
  4. Make sure the beginning and end of the year match your fiscal year. If you want to use data from your current fiscal year, select This Year-to-date.
  5. Select Run report.

Use this info as a guide to create your budget.

 

Step 3: Download a budget template

 

Download a budget .csv template from QuickBooks. Use it to create your budget so all of your data is compatible. You can have up to five budget templates:

  1. Go to Settings and select Budgeting.
  2. Select Import budget.
  3. Select the Sample.csv link to download the template. Save it somewhere you can easily find it, like your Downloads folder.

Step 4: Create your budget

 

Open the .csv budget template in Excel or Google Sheets. QuickBooks uses your chart of accounts and fiscal year months to format the template format.

 

Enter your budget for each account for each month. Important: Don't add more columns or rows. If you need more accounts to appear, add them to your chart of accounts before you download the template.

 

Step 5: Upload your template

 

When you're done, import your budget back into QuickBooks:

  1. Go to Settings and select Budgeting.
  2. Select Import budget.
  3. Tap Browse and then select the template.

Now your budget is in QuickBooks. Do a quick review.

  1. Give the budget a name.
  2. Review the cells. Make sure the correct amounts are in each account. If you need to make edits, select a field and make changes.
  3. When you're ready, select Save to save your budget.

I'm also adding these articles for reference in case you need tips and related articles in the future:

Please let me know if you have further questions or concerns. You can reach out to the Community at any time. Take care and have a fantastic day ahead! 

AppleLa2Author
July 29, 2021

Thank you for your response. I just found out that we have not closed out our FY 19-20 yet, we are in the middle of auditing that fiscal year. In QBO settings under Advanced, it says our books were closed for 06/30/2019; since that's the case, do you think this affects my budget upload for FY 21-22 because 2020 is not closed yet?? What can I do to work around this? I don't want to have to manually enter all of my budgets if I can do an easy upload.

July 29, 2021

It's nice hearing back from you, AppleLa2.

 

As of the moment, the option to select a fiscal year when importing your budget is unavailable. You can select the Fiscal Year when you manually create a budget.

 

The imported or created budget will not be affected although your books for 2020 is not yet closed. The only data that will change are those on your reports since it changes upon closing the previous year. You can close the previous year after reconciling the accounts and then upload the budget. 

 

Feel free to check out these articles for more details in handling your books and budgets: 

 

I'll be around the corner if you have other questions. Take care and have a great day!