25% of Disposable Pay Minus Amounts Withheld Under Other Wage Withholding Orders with Priority = Total Disposable Pay Minus Amount Above =Ĭ. Amount Equivalent to 30x the Federal Minimum Wage of $7.25 = (based on your pay frequency)ī. Example: If the percentage is 15%, enter. Enter the percentage from section 2(b)(1) of the Wage Garnishment Order (may not exceed 15%). (NOTE: If the employee's wages are not subject to any withholding orders with priority, enter 0.)Ħ.
Enter total Amounts Withheld Under Other Wage Withholding Orders with Priority.
A simple example is adding up the values in a range of cells to provide a total. Excel Balance Sheet with amount formulas And there you have it Note: for recurring-use workbooks, you can set up the mapping in a dedicated worksheet and then use lookup functions to retrieve the report labels into the trial balance, or conversely, use SUMIFS to retrieve the trial balance values into the map itself. Create a business plan using Word with a companion Excel workbook for customizing financial statements. Formulas are expressions that take values from a range of cells or a single cell, and output a value. 25% of Disposable Pay = WAGE GARNISHMENT AMOUNT COMPUTATIONįollow steps 5-7 to calculate the total garnishment amount.ĥ. Accounting Q&A Library Pension Worksheet-Usher Inc.xls Home Insert Page Layout Formulas Data Review View P18 fx A E F 1 2 General Journal Entries Memo Record Annual Projected Benefit Pension 4 Pension OCIPrior OCI- Asset/ Items Expense Cash Service Cost Gain/Loss Liability Obligation Plan Assets 6 Balance, Jan. In Spreadsheets such as Excel, Google Sheets or OpenOffice Calc Formulas provide powerful tools for data analysis. Involuntary retirement or pension plan paymentsĬ. State tax (including income tax, unemployment, disability) Enter dollar amounts without commas or "$"ĭ. If you can read this message, your browser does not support JavaScript.Īs a result, you will not be able to use this calculator.įollow steps 1-4 to calculate disposable pay. If section 2(a) of the Wage Garnishment Order specifies the dollar amount to be garnished, you do not need to use this calculator. Disposable pay includes, but is not limited to: salary, overtime, bonuses, commissions, sick leave and vacation pay. Following is the formula that you will put in cell I2. Step 4: Next is 61-90 days column and on the same concept as used in above step we will adjust the formula to find us the right invoices. Administrative Wage Garnishment CalculatorĪdministrative Wage Garnishment CalculatorĮmployers may use this each pay period to calculate the Wage Garnishment Amount to be deducted from the debtor's disposable pay. Once the formula is in place press Enter and double click or drag the fill handle to apply the formula to rest of the invoices.Please enable JavaScript to use all features. Some features of this site will not work with JavaScript disabled.