Results 1 to 3 of 3

Thread: Age Analysis vs Detailed Ledger

  1. #1
    New Member
    Join Date
    Nov 2015
    Kempton Park
    Thanked 0 Times in 0 Posts

    Age Analysis vs Detailed Ledger

    A question for the academics. General accounting principles says that the debtors ledger should always agree to the debtors control account. However, is it a requirement that the debtors age analysis agree to the control account? The reason I am of the opinion it does not have to agree is because the detailed ledger and TB are printed as at the end of a specific financial period. However an Age Analysis can be printed as at a given date, and even if it is printed until the last date of a specific financial period, it should not include transactions that was captured after the date it is printed for. The age analysis should tell us the state of the debtors as at a given date. The same for customer statements for instance. Printing a statement as at the end of September 2015 should not include transactions posted after that date, for instance receipts posted in October, but dated before end September.


    thanks in advance

  2. #2
    Gold Member
    Join Date
    Mar 2012
    Thanked 381 Times in 298 Posts
    Hi Valkiri

    "Sub-systems" generally speaking support the numbers produced by "main systems."

    For example, if you are an independent accountant preparing financial statements, you would want the detailed customer ledger to prove the TB figure. If it were an audit, you would even augment that with a whole slew of other procedures, like debtors confirmation, subsequent payments and so on.

    Then you would want to see an age analysis at the same reporting date to consider whether there is impairment. Having either of the sub-systems report at a different date would be pointless.

    For a manager having to manage cash flow, he would almost certainly start with the TB, receive a shock on noticing his debtors are huge, then want to see the age analysis to identify which accounts are the cause. Having them at different reporting dates will not help.

    A credit controller on the other hand would concern himself (usually) with the age analysis to the exclusion of the TB at least. But I am sure that he makes the assumption that it is representative of the TB and that if it were not, the system would come to a halt because it is out of balance.

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Durban, South Africa
    Thanked 2,393 Times in 2,002 Posts
    Blog Entries
    Whenever one is faced with two balances which purport to be represent the same thing, but are different values, I find myself asking two questions -
    Which one is right, and
    What idiot designed the system that allowed the reporting difference to occur?

    OK. Add one more question -
    What do I need to change to eliminate the error going forward? (Be that software, system or personnel).
    Seeing opportunity changes nothing. Seizing opportunity and running with it changes lives.

Similar Threads

  1. [Question] Emailing Invoices from Detailed Ledger in Pastel
    By HM0511 in forum Accounting Forum
    Replies: 2
    Last Post: 25-May-15, 12:10 PM
  2. [Question] Detailed pastel quote to be reduced to sub-total positions.
    By bumble-beess in forum Accounting Forum
    Replies: 0
    Last Post: 23-Mar-15, 12:10 PM
  3. Debtors Ledger and General Ledger
    By Simimano in forum Accounting Forum
    Replies: 1
    Last Post: 15-Apr-13, 03:24 PM
  4. Teachers need detailed salary advice
    By Dave A in forum General Regulatory Compliance Forum
    Replies: 0
    Last Post: 07-Dec-06, 08:45 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts