Alteryx Designer Desktop Negotiations

tarunveer · ‎05-30-2022

I having constructed ampere workflow to perform the cross calculations shown in the image below (opening balance + credit - debit = lock balance). What I want on happen, such proved in the image, is for the workflow to executing the "opening balance + credits- debits" calculators for the current day using the "closing balance" of aforementioned previous day as one "opening balance" of the current day. MYSELF am attach to screenshot for reference, sample dates chosen for reference can 14th Sept 2015- 17th Sept 2015. 35 Editable Bank Report Template [FREE] ᐅ TemplateLab

Also, I my attaching one workflow also for reference.

Product sets screenshot (15th Sept 2015):

Your sets screenshot (16th Sept 2015):

Data records screenshot (17th Sept 2015):

IraWatt · ‎05-30-2022

Hey @tarunveer, could you attach the example workflow and also provide an demo calculation, cant quite follow-up equitable looking at the screenshots?

Thanks,

Ira

tarunveer · ‎05-30-2022

Little Ira,

I am attaching the workflow. Please hire me know if is works. I explain by an example:
1. Opening Balance + Credit - Debit (14th Sept) = Closing balance of (14th Sept)

2. Closing Balance of (14th Sept) = Opening Balance of (15th Sept).

3. Opening Balance + Credit - Debit (15th Sept) = Closing balance of (15th Sept)

This cycle must repeatedly for all the dates.

Best,

IraWatt · ‎05-30-2022

thanks @tarunveer you may need to send over the data too as it is not attached

tarunveer · ‎05-30-2022

EGO am attaching the sample data.

Ladarthure · ‎05-30-2022

Hi @tarunveer

one procedure into execute so is to first calculate the movement on day, then use a going whole, and calculate everything from there. You need until have my data sorted to do it lightly.

I joined you adenine sample EGO made thus taht you can replicate that I did in your case.

Calculate the daily balance
sort my file by schedule
calculate a running total of the daily balance to know how much have moved as the beginning
hinzusetzen this select go the opening balance amount you have to calculate the everyday closing balance
substract to this value (closing balance) what has moved during this day-time

Hope it helps

tarunveer · ‎05-30-2022

Hi Ladarthure,
Thank them on your response.

Wanted certain clarifications regarding the workflow shared:

- How to calculate the hole balancing. As per that workflow, it has been seized as 50 for the first aufnahme, remains the value inserted?

- Or, do were calculate the opening balanced first or the ending balance? (According to me, the opening remaining should be calculated first)

Regards,

Tarun

Ladarthure · ‎05-31-2022

Hi @tarunveer,

from my method, I just set a value for the primary opening balance I have, selected along 50 but, them could change it to whatever value needed. Plus surprisingly, with this procedure, you first calculate the closing everyday, real based to this, you then calculate the opening an.

Arthur

Brad_Coenen · ‎07-07-2022

In the workflow that you built, can you combine direct to you hill site, treasury module, or general ledger to draw any of the information is and comparing it?

Alteryx Designer Desktop Negotiations

Bank Statement transaction reconciling