Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Best answer April 27, 2023
Solved
Best Answers
I appreciate for getting back, @nja1327.
I'm here to help you fix the Budget and Actual Report in QuickBooks Desktop (QBDT).
As I replicated your concern, if we filter the report by unselecting the depreciation accounts the amount should be correct in the report. I'll show you how:
- Open the P&L report.
- Tap Customize Report and click Filters.
- Choose Multiple accounts.
- Unselect the Depreciation Expense and hit Ok.
If we've done this part and the issue still persist, I'd recommend running the Verify and Rebuild Data utility. The tool scans data issues within the company file and self-resolves them. Beforehand, make sure QuickBooks is up-to-date.
Follow the steps below on how to verify data:
- Go to the File menu.
- Choose Utilities from the drop-down option.
- Select Verify Data.
- Click Ok to continue.
Next, here's how to rebuild data:
- Go to the File tab at the top.
- Select Utilities from the drop-down option.
- Choose Rebuild Data.
- Click Ok on Rebuild has completed.
If you want to customize the details of your report, you can export it to Excel. This way, you can remove or add the details you need. I'm adding these links to learn more about the process:
Aside from your reports, you can also open the topics from these articles to keep track of your customer and vendor transactions in QuickBooks Desktop:
- Get started with customer transaction workflows in QuickBooks Desktop
- Accounts Payable workflows in QuickBooks Desktop
If you have other questions about managing reports, please feel free to click the Reply button and add a comment below. I'll be right here to provide additional assistance. Keep safe!
I'll help you achieve your reporting task in QuickBooks, @nja1327. So, you can always look at and monitor your budget data.
I appreciate how hard you worked to make the reports fit your needs and how you shared the steps you took. No worries, I have a solution so you have a report that will add only the budget items used to pay for actual expenses.
Depending on your filters, the depreciation expenses will show in the Profit and Loss Budget vs. Actual report. With this, let's ensure the Report period and Accounting method is correctly customized. This way, the depreciation expense does not show up on the report you customized.
Once confirmed and the issue persists, I'd recommend exporting the report and manually removing the depreciation amount from there.
Here's how:
- Go to the Reports menu and select Budgets and Forecasts.
- Choose the Budget vs. Actual report.
- Pick the account and click Next.
- Select the report layout, then Next, and hit Finish.
- Customize the Dates and Report basis.
- Click the Excel drop-down, then Create New Worksheet or Update Existing Worksheet.
- If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox.
- Hit OK.
To learn more about customization, check out this link: Customize reports in QuickBooks Desktop.
Furthermore, check out the following article below on how to manage budgets data and reports in QuickBooks:
You can reply to this thread anytime if you have follow-up questions or other QuickBooks concerns. I'm happy to provide a solution. Keep safe always, @nja1327.
I appreciate for getting back, @nja1327.
I'm here to help you fix the Budget and Actual Report in QuickBooks Desktop (QBDT).
As I replicated your concern, if we filter the report by unselecting the depreciation accounts the amount should be correct in the report. I'll show you how:
- Open the P&L report.
- Tap Customize Report and click Filters.
- Choose Multiple accounts.
- Unselect the Depreciation Expense and hit Ok.
If we've done this part and the issue still persist, I'd recommend running the Verify and Rebuild Data utility. The tool scans data issues within the company file and self-resolves them. Beforehand, make sure QuickBooks is up-to-date.
Follow the steps below on how to verify data:
- Go to the File menu.
- Choose Utilities from the drop-down option.
- Select Verify Data.
- Click Ok to continue.
Next, here's how to rebuild data:
- Go to the File tab at the top.
- Select Utilities from the drop-down option.
- Choose Rebuild Data.
- Click Ok on Rebuild has completed.
If you want to customize the details of your report, you can export it to Excel. This way, you can remove or add the details you need. I'm adding these links to learn more about the process:
Aside from your reports, you can also open the topics from these articles to keep track of your customer and vendor transactions in QuickBooks Desktop:
- Get started with customer transaction workflows in QuickBooks Desktop
- Accounts Payable workflows in QuickBooks Desktop
If you have other questions about managing reports, please feel free to click the Reply button and add a comment below. I'll be right here to provide additional assistance. Keep safe!
