RELATED IDEAS
Incorrect aging for debtors and creditors on EOM accounts
All our debtors and creditors operate on EOM terms. I have given up trying to get the aging (current, 30 day, 60 day, 90 etc) correct on our debtors and creditors statements and reports, and I am creating statements to our clients on a spreadsheet every month so that I can get these right. This adds to my already frantic workload enormously. Why can't you get the program to calculate these correctly? I have asked Reckon support people about it in the past and have tried many times to get it to work properly. I am pretty confident I have everything set up correctly, so I can't work out how the program comes up with the incorrect figures. I have even had it looking like it’s working okay and then it changes the calculations for no obvious reason. There is no logic to it at all. I am using Reckon Accounts Premier Desktop 2019 edition. I am about to upgrade to the latest edition and don't want to waste any more time trying to sort this problem out. I have one other serious problem that I have spent so much time on and can't solve that either. I am now looking at different programs, so if you don't fix this and my other problem (staff leave entitlements as previously mentioned), you will very likely lose my business.
-
ADMIN RESPONSEJun 1, 2020
Update
After extensive consultation with the Reckon customer who reported this issue, it was discovered the incorrect statement period dates were being set to achieve the desired result. In summary, if an invoice is due on April 30 (for example) and the statement period is set to April 30, the invoice is 0 days overdue and hence will show in the CURRENT column on the statement. This is the expected result.
We have created a help document to explain statement dates in more detail HERE. (https://help.reckon.com/article/u8dg1dsj42)
__________________
May 29, 2020
Hi Chris, this is a common misconception and is related to 3 things.
Your ageing date preference isn't what you expect (ageing from due date vs invoice date). This can be changed in your preferences.
Your statement period is past the due date of the month you wish to show as current. For example, if an invoice is due on March 30 2020, and the statement period TO date is after this date, that invoice will NOT show as current.
Ageing summary vs detail reports and how they are affected by cash vs accrual reporting.
Please see this KB article: https://help.reckon.com/article/qrubx6jplg-kba-1807
Hi Christine, as you can see from my previous post this is working exactly as expected. With over 600,000 customers and a 25+ year old product we would have had many complaints if statements had an issue, so I am confident the issue is on your side. Please email our customer support (customerservice@reckon.com) attention to me and include the following screenshots AS ATTACHMENTS (remove any customer identifiable information):
Your ageing settings
Your statement settings (when you create the statement.. full screen please)
An example statement with those settings
A copy of an invoice on that statement showing the invoice date and the due date.
I know this is frustrating, so we'll get to the bottom of it for you.
All of these things are already correct, and have been from the start. The preferences are set to ‘age from due date’, invoice due dates are always the last day of the month, because I use the terms category EOM (and I have checked each one individually as well), and I always make sure the statement date is set at the last day of the month, in your example 31/3/20, with the statement period from 1/3/20 to 31/3/20, and the aging is exactly as I said it was last time – with both months lumped together in the wrong columns. I am pretty confident I have not missed anything and I am a competent bookkeeper (ask my accountant how good he thinks I am). Since everything you have suggested is already the way I had done it, I hope you have another suggestion that I may have missed.
I have just checked the website and the image is visible, so its likley it's being blocked by your browser or email. Regardless.... the text should be visible at point 1: Your ageing date preference isn't what you expect (ageing from due date vs invoice date). This can be changed in your preferences.
Go to the Edit menu > select preferences > reports and graphs > company preferences and check your Ageing reports settings.
The other issue for statements is you may be setting an incorrect statement period, and based on the invoice due dates this will move the ageing.
For example, if an invoice is due on March 31, and you have the statement period entered ending April 1, the invoice won't show as current. The dates for a March statement should be:
• Statement date: 31/03/2020
• Statement period to: 31/03/2020 (the from date is your choice based on where you want the balance fwd to start).
I have checked this again myself in the 2019 version and it's showing as expected.
See images below:
If the statement period is changed to 1 x day past the invoice due date:
There was nothing in Point 1. It had a blank space with a little red x on it, but nothing would open. Please send it again.
Also check your due dates. If you don't have due dates on your invoice entry screen the due date will default to the date of the invoice.
Hi Christine, did you look at point 1? Age from due date vs age from transaction date??
I already have ‘Accrual’ set and the reports you refer to already agree with each other. THIS IS NOT THE PROBLEM I AM COMPLAINING ABOUT. I changed it to cash, just to see what happened, but it did not solve MY problem. I am talking about the totals of ‘current’, ‘30 days’, ‘60 days’, ‘90 days’ in customer statements and the A/R & A/P reports dated the last day of the month.
As at the end of April, all invoices dated April should be totalled together in the ‘Current’ column, all outstanding invoices dated March should be totalled together in a ’30 days’ column, all outstanding invoices dated February should be in a ’60 days’ column and so on. This is STANDARD for construction industry end-of-month terms and I need this to happen. I have just run statements and also an A/R report on the screen for 30/4/2020 and the March and April totals were lumped together in the 1-30 day column for the first client I looked at: the ‘1-30’ column said $7,370.00 for this client, and it should have been ‘current’ $2,255 and ’30 days’ $5,115. I cannot send out statements like this, as they are totally wrong, which is why I am wasting so much time doing manual statements on a spreadsheet, costing me several hours a month.
Please advise. To say I am totally fed-up with this is an understatement.
Christine Johnson