The 'Aged Debtor Analysis (Detailed)' report should show you which invoices and/or payments on account are included in the 'older' column balance. Is this the detailed report that you said that you already had?
Sorry, I meant the "aged creditor (detailed)" report - I had an aged debtor report on my screen when I was writing the reply!
The positive balances are amounts owed to the supplier, so it looks like the total amount owed is £17,889.05. Are you happy that this balance is correct or, if most of this is a cash account, have payments been misposted or missed? Does the supplier provide any statements that you could use?
Edit: are the figures that you quoted just for the one supplier account or are they the total figures for all suppliers?
-- Edited by Robert Pearce on Tuesday 14th of May 2013 03:40:20 PM
-- Edited by Robert Pearce on Tuesday 14th of May 2013 04:12:01 PM
__________________
Pearce & Co - Chartered Accountant and Chartered Tax Adviser
One of my supplier accounts shows a balance in the "older" column, but I am not sure if there is a quick way to find out which invoices it applies to. As far as we are concerned we should not have nothing in the older column as it is mostly a cash account! I took over from predecessor who has left things in a bit of a muddle, but I am quite new to bookkeeping Los! There are many " payments on account" so receipts are not always specifically linked to invoices. is there a way of finding out by printing a report of some kind? I have the detailed report already. Please help! I am using sage 50
The 'Aged Debtor Analysis (Detailed)' report should show you which invoices and/or payments on account are included in the 'older' column balance. Is this the detailed report that you said that you already had?
__________________
Pearce & Co - Chartered Accountant and Chartered Tax Adviser
I have the "detailed aged creditor analysis " Columns at bottom read as follows Current -£58.92 Period 1 £15720.69 Period 2 -£4541.97 Period 3 -£2134.68 Older £8903.93 Care re where the minus figures are, I am not clear as to whether this means we do not owe anything in the older period as this is not showing a negative figure. Or that we do have an amount owing to the supplier.?
Regrettably no statements are sent as it "should" be a cash account we usually pay on proforma, then they send invoice. We had a few cash flow issues, and they agreed for us not to have to pay straight away, however, the amount of 15720.69 is only the last 2 weeks of April, invoices, which have now been paid by cheque but not shown on sage system yet, , but once these show as paid it still shows this older amount, which I cannot track which invoice/invoices it may be linked to as there are so many payments on account on this particular supplier, and few purchase payments! Sorry if I am sounding dumb! But I am relatively new to bookkeeping! Again I am confused as to why the total balance is £18889.03, and of that £15720 is recent, and yet this still shows this older amount of £8903.93. The figures just don't seem to add up!,
If you add up the column totals from 'current' to 'older', that should give you the total outstanding balance. I can't see where £18,889.03 comes from as the figures that you gave added up to £17,889.05.
It could be that the negative balances in Period 2 and Period 3 represent the payment of the invoices in the 'older' column and you can match them off against each another. You could just go through and match off each payment on account with the oldest outstanding invoice - however, based on your figures, you'd still be left with a creditor balance older than Period 1.
On the other hand, some of the payments might relate to invoices that haven't been posted. Although you don't receive statements, you might want to contact the supplier to see if they can send you their customer activity so that you can check whether all of the payments and/or invoices have been entered at your end.
__________________
Pearce & Co - Chartered Accountant and Chartered Tax Adviser
Thank you, yes I think that may be my best option, to call the supplier, as the office here is sadly quite often in disarray! I don't always get given ALL of the post, plus my boss occasionally pays for stuff from his own personal account , when the business has cash flow issues, which I also don't always get told about! I will have to give your suggestion a go! Thank you for trying to help, I hate not knowing how to resolve issues!
is there a way of finding out by printing a report of some kind? I have the detailed report already. Please help! I am using sage 50 
