payable

Hi, My first post and I would request the esteemed members to provide me with a basic Salary Sheet in Excel for my salary calculation purposes. I run a Take-away, online ordering and delivery ******* and my basic requirements for salary calculations are:- 1) CTC 2) Number of days absent. (To...

Hi all, kindly advice me for a VBA code so that to run through col. “A” and where find the row which contains text “Deductions” the number in adjacent cell in col. “J” should be minus (-). I present below the original data and the expected result. Thanking you in advance <!--[if gte mso...

What is the easiest way to sum all "GL No" from 1000-1099 in range A2:D9 relating to cash in Table 1 and place total into cell A2 in Table 2? ...2200-2299 in "Inventory" on Table 2 and 5000-5099 in "Payable" on Table 2 . I have created a helper column but there must be a better way.....any...

Below is an inter-company analysis I am working on. It shows that the books of Company A has a $10 receivable from Company B. However, on Company B books, there is a payable to Company A in the amount of $9. I need to include an analysis showing A receivable compared to B payable, and then...