As most Lucanet users know, in Lucanet you can easily create an alternative worksheet. For example, to present an alternative P&L structure for your annual accounts. You may not want to use this for your monthly reports, but you do want to use it for the annual closing process. However, you naturally want to make sure that all relevant accounts are mapped to this alternative structure. If this is not the case, you might end up sharing the wrong figures with your accountant or board.
For this purpose, Lucanet has developed a very useful script that you can easily add to your own database, namely #4035 – Reference and Exchange Rate Table Review. You can request this script from Arithma free of charge.
Using the script, you can easily check whether all relevant accounts from, for example, the primary P&L statement are present in the alternative worksheet. This can be done by checking whether all accounts are linked, or only the accounts that have been booked in a specific period. The script can even add the missing accounts as references at the bottom of the alternative worksheet.
You load the script on a worksheet that supports the scripts element. Then you indicate that you want to perform a Comparison of accounts (1).
You can do this for all accounts, or only accounts that have a value in a specific period (2). With this option, in addition to the period, you must indicate for which data dimension and organizational structure you want this check to be performed.
Next, you indicate which is the main worksheet and which is the derived worksheet (3).
You can additionally indicate whether missing allocations (and allocations that occur multiple times or have been created with a reversed sign) should be created as references (4).
Use the Execute button (5) to run the script.
Within the script, you can see whether all relevant accounts are linked as references or whether a number of them are missing. After you click the Execute button, you will see this in the second tab:
If you enable the option Create references for additional display of the result, you will also find the accounts that were not yet linked on the alternative worksheet:
With the help of this tool, you can easily safeguard consistency and completeness in your reports. There is less chance of errors, valuable time is saved, and there is more confidence in the figures you share with stakeholders. Need help setting up this assistant?
Then do not hesitate to contact us today!