How do you populate gradient statements in Lucanet directly from your source system?

One of the standard dimensions in Lucanet is the Movement Type dimension. This is used to present movement schedules, for example your tangible fixed assets statement. It is a must-have if you want to present a detailed cash flow statement, and it is of course mandatory in the annual accounts.

Roughly speaking, there are three methods for maintaining your movement schedules in Lucanet:

1. Retrieving them from the general ledger based on a specific dimension or module
2. Manual specification of the movement
3. Deriving them from the general ledger based on account combined with debit/credit movements

Only in ERP systems such as SAP and sometimes Microsoft Business Central are the movement types maintained as standard. Manually specifying them by means of journal entries or a breakdown format can simply be a lot of work if you have many companies and want to do this on a monthly basis.

Automatic classification

However, there is a way to avoid having to classify balance sheet movements entirely manually in Lucanet. Using a data transformation, we can split transactions into two types for each general ledger account: debit movements and credit movements.

This approach is not foolproof, but in many cases it is definitely worth considering because it removes a lot of manual work. After this classification, adjustments are still possible if a third option for a movement is required or if corrections have been made.

Arithma advises each customer on the best setup based on their specific situation. Two general recommendations in advance:

• Record the purchase and the cumulative depreciation on separate general ledger accounts.
• Make sure you understand whether you regularly need (in percentage terms) more than two options per general ledger account. If that is the case, another solution may be more appropriate.

By maintaining your movement schedules neatly throughout the year, you can achieve significant savings in time and cost during the annual closing process. Would you like to find out whether this approach is suitable for you? Then contact us! We would be happy to schedule a meeting to discuss it with you.