Debtors control account and aged debtors report

Accounting
1

When I put the dates from the beginning of time to the current date, the debtors control account in the nominal ledger gives the correct balance as the aged debtors.

When I enter the year dates, the debtors control account misses off the previous transactions even though some of the debtors are still owing. Can this be fixed?

2

Are you running these calculations in the Chart of Accounts report? This will only show the aggregate value of all transactions over a given period. If you run a balance sheet report this will show the balance at a specific date.

3

Hi Glenn
I have question that I think is related.
I am looking at my year end (Nov 2013) balance sheet.
How do I quickly identify who the outstanding debtors and creditors were?

4

Hi @thealarmingman,

I think what you may be looking for is the Historical Debtors and Creditors report?

Click on the menu item ā€˜Reportsā€™ and then click on ā€˜Historical Debtor and Creditor Invoice Reportā€™. You can enter a query date and the system will show you what was outstanding at that point in time.

On that note - @Glenn the ā€˜Updateā€™ button seems a little bit messed up on this screen too.

Hope this helps!

1 Like
5

Thank you for the quick response.

For some reason, my version does not have the tab Historical Debtor and Creditor Invoice Report.

Have I missed something?

6

Hello!

Itā€™s not on the drop down menu, itā€™s a little bit hidden!

Click on ā€˜Reportsā€™

Then scroll down and youā€™ll see the option:

:smile:

1 Like
7

Hi Parker1090

Just goes to show how comprehensive the system is!!

Thank you very much for this - wished Iā€™d asked earlier, really appreciate the help.

Best regards

2 Likes
8

No problem at all! :smile:

9

@Glenn
Hi,
I cannot find the Historical Debtor and Creditor Invoice Report in my Custom Reports. When I go on Custom Reports I only see ā€œCreate New Reportā€ button and that does not answer the need.

Could you please help?

Thanks

10

Hi @OvidiuS itā€™s in Reports >> Show all reports.

If you scroll down to the ā€œOther Reportsā€ section you will see it there.

11

Thanks - found it! :slight_smile:

Is there a way to see the Debtor (Clients) Ageing Report (or Creditor for that matter) for a certain date in the past? Instead of having the list of all invoices due at a certain date.

Thanks,
Ovidiu

12

Unfortunately we donā€™t support ā€œpoint in timeā€ ageing reports, the closest we have is the historic debtor/creditor reports.