[GNC] Is there a Report for All Expenses Paid between Date A & Date B

Adrien Monteleone adrien.monteleone at lusfiber.net
Fri Sep 11 20:18:04 EDT 2020


I'll add that if you are posting bills in order to utilize the Due 
Reminder feature (and track your account with a Vendor), you can still 
do this on a cash-basis with a work around.

Let's take the example of vendor that has you on Net30 terms.

You receive a bill dated today, 9/11/20, due on 9/21/20 and you 
reasonably expect to make payment in 30 days by 10/21/20, in full.

Enter the bill as normal.

Post the bill with the 10/21/20 date, which is your expected date of 
payment, and 30 days from the due date. But put the Date Due as the 
correct 9/21/20.

It will now show up in the Due Reminder and in the Payables Aging report 
correctly.

When you make actual payment, if not on 10/21/20, unpost and repost with 
that days date, prior to entering the payment in GnuCash, otherwise just 
process the payment. (If you don't pay in full, you'll have more 
gymnastics to do.)

The expense accounts will still get posted to, but with a future date 
(10/21/20) to match the expected payment date. (which will eventually be 
the actual payment date when it happens)

Those transactions in AP and in the various Expense accounts will show 
up underneath a blue line, indicating they are in the future. (their 
dates will reflect this too, but the blue line makes it easy to spot)

Note, there is a preference for 'Blank Transaction before Future 
Transactions' so you can make new entries 'today' without having to 
scroll past the future dated transactions.

Now, a simple Transaction Report for a date range ending in 'Today' will 
show you all expenses (or whatever else) that are 'paid'.

You can now also run a report to show future expenses if desired.

Regards,
Adrien



More information about the gnucash-user mailing list