I am trying to get a creditors and debitors report for my year end date (an at date) to see a list of all showing the outstanding amount that will match the balance at the year end.
How do I do this?
Hello @betty
You can run this report up to any date for historical purposes.
Reports > Show all reports > Other Tab > Debtor / Creditor report
Is there a way to do this from 01 07 2023 - 30 06 2024?
My accountant is asking for a creditors and debtors report as at 30/06/2024. These figures need to match the creditors and debtors control account in chart of accounts. How do I get that?
The reports that @QFSteve has listed will give a list of debtors and creditors at the specific date you request (30/06/2024). It is a report for a fixed point in time only. These reports (one for debtors and the other for creditors) are what your Accountant needs. You could always give him/her access and they can get all the reports they need?
Thanks for your response. Will do that but hope that they will be happy.
Let me know if they need any help obtaining the correct reports (especially if they have access).
Is there a way to get a creditors and debtors report for the 30/06/2024 in a list form by supplier and client name respectively? (QuickBooks has this option)
Hello @betty
You would export the report and sort it in Excel (or similar) by the company name column.
Thanks for your help.
When I sort the figures to only include the year I’m referring to, the final figures don’t match my creditors/debtors control account figure.
Please could you help me run a report that will take the figures from the creditors/debtors control account and sort it out to give a final figure per supplier/client and which should match the full figure as in the chart of accounts.
Many thanks
Hello @betty
You enter the date prior to exporting the report.
All the lines on the report are up to that date which would align to the control account which includes all figures up to the same date.
Thanks for your reply.
When I export the report it uses all information up until the date specified - 30/09/2024, whereas in my chart of accounts they use the dates for the current year being 01/10/2023 - 30/09/2024. Even when I enter the date in chart of accounts to be the from the beginning of the business the balance doesn’t match the figure in chart of accounts.
In the report they write that nominal code balance 2100 is £41,458.98 and in chart of accounts the figure is £7,639.48. Please could you clarify and rectify this problem.
Thanks for always being here to help.
Hello @betty
I will send you a private message to get your account details and take a look for you.
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.