Aged Debtors report

[QFDEMO]

Continuing the discussion from Produce Aged Debtors & Aged Creditors showing any credit balances:

@Piranha

Hello Glenn
Thank you for the definition of an aging report, it doesn’t really help though, as I seem to remember learning that an aged debtors doesn’t specifically relate to invoices only. The Chartered Institute of Management Accountants’ state that ‘The accounts receivable ageing schedule (or aged debtors analysis) is a listing of the customers making up your total accounts receivable balance’. What does help though, is you pointing me in the direction of the advanced search. Being able to see the credit balances in a list is exactly what I was looking for and of course, I can dump it into Excel. So thanks for this.
Annamarie

Re: It is always a crucial end of year accounts check to see a list of debtors (aged or not) that matches with the trial balance at that point in time. Most other systems produce this as a matter of course. Is there really no way to do this?

[Parker1090]

If you go to Reports > All Reports > Historical Debtor and Creditor Invoice Report

You can enter the date in question, and it will you any invoices (sales or purchases) that are outstanding at that point in time - regardless of whether they are overdue to not

Hope that helps?

[QFDEMO]

I think the point is being missed. That will show the invoices but not credit balances etc.

It just seems like a very long winded way of getting what is a standard report on most systems. As an accountant I want to see a summary breakdown of the trade debtors or creditors figure at the year end. This includes Credit balances as well as invoices outstanding and even where some have been part paid.

This is a crucial test check to verify that the system is working correctly.

[Parker1090]

That report would show any sales or purchase invoices outstanding, including the balance outstanding (taking into account part payments), and also shows any pre-payments that currently sit on the account.

I don’t work for QuickFile, so there may be one or two little gems hidden that I’m not aware of. But from what you’ve posted, this report seems to offer this?

[QFDEMO]

I can see a bit at the top which says prepayments; however, there does not appear to be a breakdown of those prepayments.

[Parker1090]

To view any prepayments, you can view a list of all those untagged (not assigned to an invoice).

Go to Sales > View Payments

Click on Advanced Search, and set type to ‘Unallocated’

In terms of an actual trial balance, please see @Glenn’s post here:

Chart of Accounts - Bank Balances

We do already have an Extended Trial Balance (ETB) in QuickFile but it never made it into full production and was something we made available to our own accountants and some Affinity users. [image] As I say we will in time bring this functionality into the COA. In the mean time you’d just need to run the COA for two date ranges. Beginning of time to last year-end date (to show balances b/f) Start of accounting period to end of accounting period (to show activity for the accounting period) I…

[QFDEMO]

The unallocated payments does not seem to work historically. Therefore I cannot see a breakdown of the £2,731.82?

[Parker1090]

Hmm… I’m not sure on that one then sorry! But as I said, I don’t work for QuickFile - just a happy user.

@Glenn - do you have any suggestions on this one?

[Glenn]

I’m afraid getting a historic breakdown on the prepayments isn’t supported right now. It is however something we hope to look at shortly.

[QFDEMO]

Are there any other Accountants in the group which have a workaround for this problem?

[Glenn]

We have several 1,000 profiles managed on Affinity, I’ve not seen it come up before as an issue on the forum. I’m not an accountant so not entirely sure what the workaround would entail.

I am happy to discuss this further with an engineer to see how easy it would be to break up that total.