New To The Cash Flow Template

SiphoZulu

Good morning! I’m in South Africa and new to Sheetgo. I recently discovered the above mentioned template. Everything is working as expected, except that I can’t get some cells to add up. On the “Cash flow analysis” tab, my “Receivables” are not adding up as per my “Receipts” tab and as also my “Receipts analysis” is showing zero amount where in fact I have amounts already on the “Receipts” tab?

I have attached some screenshots that would hopefully clarify

m
y explanation above. .
Hope the above makes sense enough to get assistance!

Thank you!

David

SiphoZulu have you already refreshed the workflow?

SiphoZulu

David Yes I have, I think the issue is the reference (the formula) not being correct on the cells? I’m not too familiar with Google sheets also, unfortunately. . But I know a bit of my way around. .

- On the “Cash flow analysis” tab it reads “=ARRAYFORMULA(‘Receipts analysis’!E2:2)”
- On the “Receipt analysis” tab it reads “=IF($A3=”“,”“,IF(E$1=”“,”“,SUMIFS(Receipts!$E:$E,Receipts!$H:$H,$A3,Receipts!$F:$F,”<=“&E$1,Receipts!$F:$F,”>“&EOMONTH(E$1,-1))))”
If you refer to the images I posted above, I think it should get the information from the “G” column on my “Receipts” tab. . I added a couple of columns as I customized my spreadsheets, so I think that’s where the mess up is. But I would like to keep my spreadsheet reading the way that I have it.

All the rest is perfect! It’s just my “Receipts” / “Receivables” that are not reflecting as they should.

Thank you for your prompt response, by the way!

David

SiphoZulu I think I had this issue myself once. Added custom columns and completely messed up. Try adding them to the end, keeping the original structure.

That way the formulas kept working for me.

SiphoZulu

David Thank you for your response David. . I highly appreciate it. . But I’m sure the whole point to this exercise is to understand the structure well enough to customize it to suit my purpose, not much use to keeping to a structure that doesn’t suit my needs. .

To be honest though, I think the issue here is a tiny one, I just need my “Receivables” to reference from the correct place (A matter of changing column references - If it was getting the information from Column “E” on the original formatting, then I would want it to get the information from column “G” on my template, that’s what I’m trying to do). .

None the less, with the little knowledge I have, I’ll try press a couple of things and see if it works. .

Thank you and keep well and safe!

Support from Sheetgo

SiphoZulu happy to help you sort this out if you share the sheet with me (Robert@sheetgo.com). :)

SiphoZulu

Support from Sheetgo Thank you for the offer Bobby, will share in a bit!

SiphoZulu

Support from Sheetgo Just shared. .

SiphoZulu

Support from Sheetgo Verdict?

Support from Sheetgo

SiphoZulu this is indeed weird. I checked the Receipts analysis tab and the formula logic looks correct to me. Also the Receipts tab appears to be correctly formatted.

I suggest you start with a fresh template and when customising go step by step.

After each step, review if it’s still working correctly.

Once it breaks, you will know at which stage it was.

In that case, let me know here and I am happy to provide you with further guidance as to why/when it broke!

SiphoZulu

Support from Sheetgo Thank you for the feedback Bobby. . Will do!

Support from Sheetgo

SiphoZulu curious how the restart went!