accruals

Hi guys, Trying to track accruals from different month's tabs in my spreadsheet to determine who has made over 99.99 and needs to be paid. In my spreadsheet, please refer to the June tab. Column N, O and P are the ones I am interested in. I am particularly keen to basically determine whether...

I'm hoping someone has done this already and has some quick formulas to offer - this could be a tough one otherwise. I would like to show accruals for various time periods. Accrual accounting is complex so my request here is a bit simplified, but it's getting the monthly report tied to a...

Hi friends, I am working on a project where I would need below raw data to show expected results as shown below. Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!! I am looking for the formulae without {} brackets, it maybe combination of Index Match...

Hi friends, I am working on a project where I would need below raw data to show expected results as shown below. Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!! I am looking for the formulae without {} brackets, it maybe combination of Index Match...

Hello, I have included the formulae I am using below. The one I am not happy with is the one in bold. Currently this picks up all items with a Vendor (col O) of 'CASH', but this double counts the codes listed (col H). I would like help with a formula to look at the 'CASH' (col O) and EXCLUDE...