Fwd: Re: Receivable Ageing report options?

[Katie Eldridge]

Thank you for your response Wm... The version of gnc I'm using is 2.6.1. 
Perhaps I didn't explain what I wanted clearly enough. I can indeed go 
from the total to the 'customer report' (statement of account), where 
there is a breakdown by invoice, and I can edit the date on the customer 
report to get the amount outstanding from that customer at the year end 
(although the ageing summary at the bottom is then incorrect, as that 
still reports on today). The issue is that at the year end there were 
outstanding invoices from other customers which have now been paid, but 
the receivable ageing report only includes the customers with invoices 
currently outstanding, rather than showing the position on the date 
requested. So it would have worked if I had run it literally at the year 
end, but I cannot use it retrospectively. Whilst I could manually 
collate the customer reports for all our customers, that would take more 
work than just typing out the outstanding invoices at the year end... It 
may be that the receivable ageing report was not intended for anything 
other than showing the current position? Please do let me know if 
updating will solve this, or whether there is a completely different 
report which would be more suitable for the information requested. 
Thanks again, Katie

On 13/10/15 13:55, Wm... wrote:
> Mon, 12 Oct 2015 21:53:48 <561C1DDC.3050406 at yahoo.co.uk>
> Katie Eldridge <eldridgetideswell-katie at yahoo.co.uk> wrote...
>
>> Dear all,
>> I'm a fairly new user of Gnucash and double entry book-keeping, and
>> just went to see the accountant for our company year end.
>> He liked all the reports I'd given him,
>
> That's nice to hear :)
>
>> but also wanted a list of outstanding invoices (with total for each
>> invoice) at the year end as a break down of the Accounts Receivable
>> line on the balance sheet.
>
> If he is a good accountant what he really wants to know is stuff like:
>
> are you owed too much money by one customer or another, are you
> vulnerable to a single customer not paying you because their business
> fails, etc.
>
>> I assumed that this would be in the receivable ageing report options,
>> but that only shows a per customer total for amounts currently
>> outstanding, even when I change the date (ie if the date is the end
>> of August it shows the amount outstanding now of items which had been
>> invoiced by then, rather than the invoices outstanding then, some of
>> which have now been paid).
>
> Which version of gnc are you using? The Receivable Ageing report
> should allow you to click on the Total column for a customer and see a
> Customer Report (in UK-ese we call this a statement of an account or
> similar) which you can print out and show to your accountant.
>
>> Is there an easy way of getting such a report, or would this need a
>> custom report using eguile (which looks rather beyond my limited
>> programming skills)?
>
> Heh.  It should already be there if you look at it from the question
> asked rather than answer expected POV.
>