Balance in trial balance, but nothing in subledger

Hi all,

How do I fix this problem.

See picture below, this is what I see in the trial balance (that is a credit amount).  But when I ask for the supplier aged, there is nothing in it.

1) How did this happen?

2) How can I fix it?

  • 0

    Hi Coreydotcom,

    Can you go to setup, setting, company, information and get the latest transaction date.

    Then, open both trial balance and supplier aged report with the latest transaction date and compare.  You may have future transactons. 

    Hope this helps.

     

  • 0

    I do not have an answer, but am experiencing the same problem. I have inherited a set of books with a similar issue. It looks like what has caused it is this: an invoice was entered twice, exactly the same (the software does not actually allow this to happen so I don't understand how this happened), both invoices are "paid", but only one payment appears against the bank, the subledger shows no payable for this vendor, but the Trial Balance shows it in the AP balance. I can not find the credit side of the entry for the payment to the duplicate invoice (even though is says it is paid) and the expense side of the duplicate entry is causing an overstatement to the expense. So...I can't find an explanation for how it happened. This is all in a prior year, so I can not simply reverse the duplicate invoice. If I create a credit invoice I end up with a credit balance in the AP subledger which is incorrect. The entry I need to make is a debit to AP (but not to a Vendor balance) and a credit to Retained Earnings, which of course the software won't allow. So....I can't figure out how to fix it??