Sage Accounts plus aid?
I hope someone can relieve!
I go and get compensated on our debts man at in no doubt level, I enjoy to run a report the final Friday of every month and provide details of how much clients owe over 30, 60,90,120 days.
The problem is contained by some months the data roll over from one length to another making the info plentifully superior.
Is near something that should be in the swing of things to stop this occurring ? It seem connected to months where on earth at hand are five weeks within it.
Answers:
I'm not adapted beside Sage specifically but typically the Aged Debtors shows the specific number of days an invoice have be outstanding but the heading are slightly misleading. The 30,60,90 etc are between days, so 30 is anything upto 30 and 60 is anything over 30 and upto 60, so if you run the report the finishing Friday of every month you will hit the problem as you hold already pointed out because of the 5 week months.
Let me over-elaborate.
Customer A have an invoice raise on 26th of August, at September month ending (28th Sept) the invoice is 32 days hoary and thus will appear surrounded by the 60 column (as it's more than 30 and smaller number than 60 days old). At the completion of October (26th Oct) it's 60 days mature and for this reason still appears contained by the 60 column (31 to 60 days inclusive) at the finale of November (30th Nov) it's 95 days aged so it appears contained by the 120 column as it's more than 90 but smaller quantity than 120 making it appear to skip a column.
The issue is using this report solitary at month come to an end, as you can see it will produce anomalies staying in one column for two months and consequently skipping a month depending when the invoice be raise.
If you want to be measured on this consequently it desires to be 4 weekly, so 13 reporting period not 12 it will after age and work out correctly. As a allusion the 7th Sept is the subsequent 4 weekly date, later 5th Oct, 2nd Nov etc etc
How do you convert your coins into brass at the wall?
What's it close to making $100K+?
Banking! Regions Bank... Anyone else? Ugh.?
How do I protect a stack of change from moisture or mold?
How do you find out if you are on a black schedule beside bank?
I go and get compensated on our debts man at in no doubt level, I enjoy to run a report the final Friday of every month and provide details of how much clients owe over 30, 60,90,120 days.
The problem is contained by some months the data roll over from one length to another making the info plentifully superior.
Is near something that should be in the swing of things to stop this occurring ? It seem connected to months where on earth at hand are five weeks within it.
Answers:
I'm not adapted beside Sage specifically but typically the Aged Debtors shows the specific number of days an invoice have be outstanding but the heading are slightly misleading. The 30,60,90 etc are between days, so 30 is anything upto 30 and 60 is anything over 30 and upto 60, so if you run the report the finishing Friday of every month you will hit the problem as you hold already pointed out because of the 5 week months.
Let me over-elaborate.
Customer A have an invoice raise on 26th of August, at September month ending (28th Sept) the invoice is 32 days hoary and thus will appear surrounded by the 60 column (as it's more than 30 and smaller number than 60 days old). At the completion of October (26th Oct) it's 60 days mature and for this reason still appears contained by the 60 column (31 to 60 days inclusive) at the finale of November (30th Nov) it's 95 days aged so it appears contained by the 120 column as it's more than 90 but smaller quantity than 120 making it appear to skip a column.
The issue is using this report solitary at month come to an end, as you can see it will produce anomalies staying in one column for two months and consequently skipping a month depending when the invoice be raise.
If you want to be measured on this consequently it desires to be 4 weekly, so 13 reporting period not 12 it will after age and work out correctly. As a allusion the 7th Sept is the subsequent 4 weekly date, later 5th Oct, 2nd Nov etc etc