I am doing a fresh implementation of NetSuite at our company (they have been using NetSuite for 5 years, but NetSuite Professional Services screwed up and failed the initial implementation twice 5 years ago, and they had a consultant come in to try to rehabilitate the second failure, but the state of the system was still so poor when I cam in, I had to recommend a fresh start).
We have decided on a cutover date of 1 January 2025, which coincides with the fiscal year start. My recommendation is to import opening customer (A/R) and vendor (A/P) balances as of 1 Jan 2025 using the closing balances as of 31 Dec 2024 (https://suiteanswers.custhelp.com/app/answers/detail/a_id/33660/loc/en_US).
The concern that has been raised by our Financial Comptroller is that when the A/R Aging and A/P Aging reports are reviewed in the new system in January, aging information about invoices/credit memos and bills/bill credits that were open as of 31 Dec 2024 will be lost, and the aging will show those balance as of 1 Jan 2025 (all of which is true and correct, and I see the problem, just disagree with our comptroller on how to handle it).
I am looking for any and all suggestions/ideas/best practices for dealing with the concern. The worst case scenario, of course, is that they will want to import historical transactional data for one or more fiscal years, essentially duplicating the books for the overlap period (which I do not believe is ideal and am recommending against for a number of reasons, but the company may well decide not to follow my recommendation in this respect).
Thanks in advance for any ideas.