Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I run our church's bookkeeping in QB desktop and create P&L and balance sheet reports for our board. I track several checking/bank accounts on the balance sheet, but only show the P&L on our operating checking accounts, filtering out the other checking accounts and their expenses/income from the P&L.
We received a transfer from one of those accounts to our operating account (using the transfer function in QB) and paid 2 different expenses from the operating checking account. In essence, one of our groups directed me to send payment from the transfer to two different entities. The expense should be posted back to their expense accounts.
Now those separate fund expenses are showing up in the operating account P&L and I want them not to do so. The balance sheets are OK.
How do I fix this?
Solved! Go to Solution.
Hello there, @Big Dave.
Eliminating the transactions that are not part of your budget within QuickBooks is currently unavailable. The figures on the budget report are base on the entries from your Chart of Accounts.
You can keep this report as it is still going to be available in your QuickBooks. When exporting this information to Excel, you'll be able to exclude the transaction that you don't want to present with the board. You can export the report again on the succeeding months if you need to remove some accounts.
Here are some references that you can visit, to give you more information about exporting report in Excel and how to customize it:
Should you ever have questions or need any concerns with QuickBooks, I'm just a few clicks away. Have a good one!
There is no such thing as a non posting account
The P&L should not, does not, show the bank account at all.
You take in donations, that is income
you spend money on expenses that posts to various expense account
only income and expense show on a P&L
Thanks for the response. I do understand income (donations) vs transfers from one bank account to another. I also understand expenses.
The P&L I prepare for our board is also a budget comparison. Because these 2 transactions were not part of the budget, I have classified them as Non-Budget expenses. I would prefer that these transactions do not show up on the P&L/Budget report, as the budget for these expenses is tied to a separate bank account that isn't shown in this P&L/Budget report.
The particular expenses are labeled Endowment Fund Expense, which currently is a sub account of the Other Expense-Non Budgeted expense account. The P&L/Budget report only shows income and expenses for 2 of our 10+ bank accounts. Please see the attached and let me know how I can exclude these 2 Endowment Fund Expenses transactions from this particular report.
Thanks for the response. I do understand income (donations) vs transfers from one bank account to another. I also understand expenses.
The report I prepare for the board is a P&L that also shows budget amounts. The income for this report is deposited into one of our several checking accounts and the expenses are paid from the same bank account. (I filtered the report to show only the activity on the single operating bank account)
So when I used the transfer function inside QB to move a deposit from a separate bank account to the operating bank account, the income accounts did not change. However, when I paid the 2 transactions from the operating bank account, the transactions show up as expenses on this report. Please see the attached screen shot.
The transactions listed in the expense account labeled Endowment Fund Expense, which is a sub account of Other Expenses-Non Budgeted.
So the question is how can I eliminate these 2 transactions for the report?
Good day, Big Dave,
You can export the report to Excel and manually remove these transactions. Then, adjust the total by deducting the amounts for these expenses. Here's how:
Open the Excel file and remove the expense transactions. Make sure to adjust the total so it will mtach.
You can check this article if ever you encounter issues while exporting to Excel: Fix export to Excel issues in QuickBooks Desktop.
I'll be around if you have more questions.
Thanks Mary. I was hoping I would not need to make this change manually in Excel or otherwise when I run the report, as I need to keep this report going for at least 3 more months (through the end of the year).
Any other ideas?
Hello there, @Big Dave.
Eliminating the transactions that are not part of your budget within QuickBooks is currently unavailable. The figures on the budget report are base on the entries from your Chart of Accounts.
You can keep this report as it is still going to be available in your QuickBooks. When exporting this information to Excel, you'll be able to exclude the transaction that you don't want to present with the board. You can export the report again on the succeeding months if you need to remove some accounts.
Here are some references that you can visit, to give you more information about exporting report in Excel and how to customize it:
Should you ever have questions or need any concerns with QuickBooks, I'm just a few clicks away. Have a good one!
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