What is the problem you need to solve?
A software program has posted approx 10,000 journals across multiple years in duplicate. In DataDear I can run the Manual Journal Template and scan down the page and identify the duplicates as the same entries have a different Xero Edit ID.
Is there a ways to either
(1) add a column to the Manual Journal Template to include the wording from the ;‘History and Notes’ at the bottom of the Xero wording ie. “Approved by System Generated on 26 Jul 2021 at 15:21p.m.”
(2) add a column with the date that the journal was last approved / modified and the user that did this. (normal transactions post to Xero within 72 hours of the journal date), we know with this issue that journals are posted over a 4 year period, so its easy to identify the duplicates by this modified date.
(3) add a column with the Xero journal reference number
(4) detect where you have a journal narration that appears with more than one Xero Edit ID, to narrow down the duplicates.
What accounting software are you using?