[GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

[Fran_3]

 My Bad. Expenses are created when the bill is posted... not when it is paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking Account and relive AP
So to get all expenses paid in 2021 you would create a Transaction Report on the Checking Account for the time period you desire...And set the Sorting Option Primary Key to "Other Account"And then lookup Accounts Payable Total in the results.
And if you know how you could set the Transaction Report Filter to only show Checking Transactions charged to Accounts Payable...I'm posting another thread on that... more properly titled... to help other poor souls... like me :-)






    On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user <gnucash-user at gnucash.org> wrote:  
 
 Situation:
We posted a bill in 2020 but paid it in 2021.
I need to create an Expense report for all expenses paid in 2021... regardless of when the bill was posted...
My attempted solution:I created a Transaction Report on "Expenses" with "All Children"  selected...And with a date range of 1/1/2021 to 12/31/2021
The Problem:The payment for the 2020 bill does not show in the report...Even though the expense was paid in paid in 2021.
How can I create a report that will show all expenses paid in 2021 regardless of when the bill was posted?
Thanks for any help.





_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.