Skip to main content
B
Big Dave
November 13, 2019
Solved

How to create a non posting account for certain transaction

  • November 13, 2019
  • 1 reply
  • 0 views

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?

 

Best answer by BettyJaneB

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!

1 reply

Rustler
Rustler
November 13, 2019

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

    B
    Big DaveAuthor
    November 13, 2019

    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.

    Terms & ConditionsAccessibility statement