Skip to Content
0
Sep 07, 2023 at 05:59 AM

Method to load YTD balances

243 Views

Hi All,

For flexible upload (and GRDC imports) – How do you load your data from period to period- just movement or YTD?

There is a YTD check box (flex upload) and in GRDC a YTD/periodic option.

A standard scenario:

Assume balance sheet account opening balance of 1,000 in period 23.01 in subtype 900 (coming from 22.12 and BCF to 23.00).

We load 1,200 to subtype 915 as a YTD delete all settings. The expected result should be 1,200 in total.

That is:

900: 1,000 as before

915 200 (1,200- 1000).

However, what is posted is the 1200 to 915.

This means that we have to bring just the bs movement in the period not the YTD amount?

If current behavior is correct, it means that YTD only refers to P&L not to BS

What is done to load the correct amount?

Regards

Eyal