| Budget-In separate sheet | |||||||||||||||||||
| Department | Account # | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | YTD | ||||||||||||
| Expense | |||||||||||||||||||
| 5100-00 · AC&CS EQUIP DEPT-SALARY (AC&CS EQUIP DEPT-SALARY) | AIR CONDITIONING DEPT-COMMERCIAL | 5100-00 | 23,490.00 | 23,490.00 | 23,490.00 | 23,490.00 | 23,490.00 | 117,450.00 | |||||||||||
| 5100-01 · AC&CS-MANANGEMENT FEES | AIR CONDITIONING DEPT-COMMERCIAL | 5100-01 | 1,980.00 | 1,980.00 | 1,980.00 | 1,980.00 | 1,980.00 | 9,900.00 | |||||||||||
| 5100-02 · Salary | AIR CONDITIONING DEPT-RESIDENTIAL | 5100-02 | 1,910.13 | 1,910.13 | 1,910.13 | 1,910.13 | 1,910.13 | 9,550.65 | |||||||||||
| 5103-00 · AC&CS EQUIP DEPT-COMMISSION (AC&CS EQUIP DEPT-COMMISSION) | AIR CONDITIONING DEPT-RESIDENTIAL | 5103-00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 4,500.00 | |||||||||||
| Actuals-In separate sheet | |||||||||||||||||||
| Account Code | ESSCO-Barbados | Department | Type | Description | Account Code | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Total FY 2024 | |
| 5100-00 · AC&CS EQUIP DEPT-SALARY | 5100-00 | 5100-00 · AC&CS EQUIP DEPT-SALARY | Salaries | Payroll | 5100-00 | 22,874.62 | 24,268.66 | 22,075.80 | 29,721.96 | 3,356.60 | - | - | - | - | - | - | - | 102,297.64 | |
| 5100-01 · AC&CS-MANANGEMENT FEES | 5100-01 | 5100-01 · AC&CS-MANANGEMENT FEES | Management Fees | Operating Expenses | 5100-01 | 1,980.00 | 1,980.00 | 1,980.00 | 1,980.00 | - | - | - | - | - | - | - | - | 7,920.00 | |
| 5100-02 · Salary | 5100-02 | 5100-02 · Carlos Walters Salary | Salaries | Payroll | 5100-02 | 1,910.13 | 1,948.33 | 1,948.33 | 1,948.33 | - | - | - | - | - | - | - | - | 7,755.12 | |
| Final Sheet | |||||||||||||||||||
| PAYROLL & OPEX | Account Code | Department | Type | Description | Budget | Actual | $ Variance | Budget YTD | Actuals YTD | $ Variance | |||||||||
| 5100-00 · AC&CS EQUIP DEPT-SALARY | 5100-00 | AIR CONDITIONING DEPT-COMMERCIAL | Payroll | 23,490.00 | 3,356.60 | 20,133.40 | Need Formula | Need Formula | |||||||||||
| 5100-01 · AC&CS-MANANGEMENT FEES | 5100-01 | AIR CONDITIONING DEPT-COMMERCIAL | Expense | 1,980.00 | - | 1,980.00 | |||||||||||||
| 5104-00 · AC&CS EQUIP DEPT-BONUS | 5104-00 | AIR CONDITIONING DEPT-COMMERCIAL | Payroll | - | - | - | |||||||||||||
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
YTD Dynamic Formula Needed
- Thread starter jpalleyne
- Start date
Similar threads
- Question
- Question
