Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Debtors Control balance does not equal aged debtors value

Sage 50 general help forum - Free help and support for all general issues
Post Reply
pfenn1

Debtors Control balance does not equal aged debtors value

Post by pfenn1 » 15 Nov 2006, 07:22

Should the net value of transactions for a defined period, taken from the Day Book equal the sum of values taken from Daily Transactions (for the same defined period)?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 15 Nov 2006, 14:19

Which net values?

Are you including all transactions, journals, bank acocunts and so on?

There is no day book, so I assume you are talking about the balances on the daybook reports.

It would be helpful to know what you are comparing and perhaps why?

In general, it would be safe to assume that the net value of the transactions in the sales part of the nominal ledger would match with the day book totaals (all of them added together invoices discounts and credits) however, if you have invoices going to expensea accounts or bank recipts going to sales accounts then this would not be the case.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

pfenn1

Post by pfenn1 » 16 Nov 2006, 16:38

Many thanks for such prompt reply apologies for lack of clarity!
Perhaps the following is an improvement-
1. At the end of Month 1 the value of Debtors outstanding according to the Trial Balance, agreed in value with the Aged Debtors Report at the same date
2. At the end of Month 2, the value of Debtors outstanding according to the Trial Balance is less in value than the value in the Aged Debtors Report.
3.The value of the movement in the Trial Balance values between Months 1 and 2 for the Debtors Control, is equal to the movement in the Nominal Ledger Debtors Control Account, as would be expected.

In short, the value of debtors according to the Aged Debtors report at the end of Month 2 is greater than the value according to the Control Account at the same date.

How can i identify the individual transactions that account for the movement in the Aged Debtors Report in Month 2 so that i can compare them with the transactions in the Nominal Ledger Debtors Control Account for the same period?
The Trial Balance at the end of Month 2 is still in 'balance'

I'm baffled :!:

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 17 Nov 2006, 00:10

Thanks for the added clarification.

Which trial balance are you talking of, the balance of the nominal account or a date filtered balance for a period?

If you go to the customers module and use the aged option (with no search applied) then at the bottom it gives you the control and the ledger balances which should be the same.

Is this the case for you?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

pfenn1

Post by pfenn1 » 17 Nov 2006, 19:58

Thank you for your continuing help. It is a date filtered TB, (the debtors control figure is the figure which also appears in the Balance Sheet)

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 21 Nov 2006, 11:48

If you go to the customers module and use the aged option (with no search applied) then at the bottom it gives you the control and the ledger balances which should be the same.

Is this the case for you?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

pfenn1

Post by pfenn1 » 21 Nov 2006, 21:26

Yes-many thanks for your help

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest