Here is a list of steps I go through to "clean up" a converted specification. The DOS conversion was written before the Adagiuo Financial Reporter had "SmartSheet" technology, and it also sometimes found it difficult to keep track of the "A" and "T" accumulators. However, cleaning up financial statement can be done quickly by following this checklist:
- Import the specification.
- Highlight the whole sheet and unhide all the rows and columns.
- Delete Column B (which is usually empty) and all columns between the account description and the first column of numbers.
- Delete the 4 rightmost columns that contain rounding information.
- Select Formula | Named Ranges and delete all the named ranges in the sheet.
- Edit all the total cell to replace what is normally an unduly complicated formula with a simple =SUM() or cell+cell+cell.
- If there are "Generated rows", then open the source specification and create a line with .Range in column A and the account ranges from the source specification in column B. Copy the formulas to reference the account range. Delete the "Generated Rows".
- Insert ".SmartSheet" in cell A1.
- Save the specification.
- Print out the specification from both systems and proof the numbers. If there are differences, then it is most likely due to an internal restriction of 255 characters in a cell string in the Financial Reporter. I have seen some specifications where the list of accounts was longer than this (although I have always been able to reduce the list length by carefully inspecting the accounts being referenced
I've been meaning to write down this list for some time. Hopefully this will help you get your statements moved.
PS - Don't forget that you can Drill down into the posted detail in Adagio from the financial statement. Right mouse click on a cell containing a number and select "Details" form the pop-up menu.