cancel
Showing results for 
Search instead for 
Did you mean: 
Big Dave
Level 1

How to create a non posting account for certain transaction

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
Best answer November 13, 2019

Best Answers
BettyJaneB
QuickBooks Team

How to create a non posting account for certain transaction

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!

View solution in original post

6 Comments 6
Rustler
Level 15

How to create a non posting account for certain transaction

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

Big Dave
Level 1

How to create a non posting account for certain transaction

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.

Big Dave
Level 1

How to create a non posting account for certain transaction

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? 

MaryLurleenM
Moderator

How to create a non posting account for certain transaction

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:

  1. Click Reports on the menu.
  2. Select Reports Center.
  3. Open the report.
  4. Select the Excel on the toolbar.
  5. Select Create New Worksheet.
  6. Select OK. To open the report in Excel, you can also select Export.

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.

Big Dave
Level 1

How to create a non posting account for certain transaction

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?

BettyJaneB
QuickBooks Team

How to create a non posting account for certain transaction

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!

Need to get in touch?

Contact us