GC 2.6.3: Apparent inconsistency between reports for a single customer

[Terry Morse]

I am using GnuCash 2.6.3 on a Windows 7 computer to keep records for a friend's business. She has a customer who accrues charges on a weekly basis, which I record on an invoice to Accounts Payable. The customer also pays on a regular basis. I record her payments using the Process Payments dialogue box.

On the latest Receivable Aging report, it shows her owing $240 in the 0-30 days period. Her Customer Report shows all her payments on the dates she made them and her total due as $240 ($3,485.00 due minus $3,245.00 paid). However, it shows her owing $2845.00 in the 0-30 day category and $0 for all other time periods.

Her tax invoice for the current year to date (January through 9/2/14) shows a subtotal of $3,485.00, but only 3 payments totaling $640.00 between July 1 and September 7, with an amount due of $2,845.00. (The September 7 payment was actually made on July 7 but persistently shows up on the tax invoice as on September 7, another inconsistency).

Shouldn't all three reports be showing the same bottom line, $240 owed in the 0-30 day aging period? Shouldn't all her payments show on the tax invoice on the date they were made? I am not an accountant, so the fault may be in my understanding of the different reports. I'd appreciate help resolving the apparent enigma.

Thank you,
Terry Morse
tmorse at teleport.com