Results 1 to 5 of 5

Checking payments based on partial dates

Threaded View

flat4raanana Checking payments based on... 12-06-2018, 06:21 PM
rcm Re: Checking payments based... 12-06-2018, 09:09 PM
Richard Buttrey Re: Checking payments based... 12-06-2018, 09:11 PM
flat4raanana Re: Checking payments based... 12-11-2018, 09:25 AM
JeteMc Re: Checking payments based... 12-18-2018, 01:12 AM
  1. #1
    Registered User
    Join Date
    12-01-2018
    Location
    london
    MS-Off Ver
    2013
    Posts
    8

    Checking payments based on partial dates

    Hello,

    I was just informed that our payroll department are calculating manually (instead of system based) the base pay differences when:


    1) an employee starts mid month - eg. if the employee starts in Jan 6th - they would pay the full month minus 6 days).
    then they calculate (number of days in month - minus 6 divided total month days *salary - to see how much is due)

    *****If an employee started in the same month at the payroll - then the number of days not worked is deducted

    *****If an employee started in the month before the payroll - then the number of days worked is added.


    2) if an employee leaves mid month -e.g leaving on the Jan 16th- the employee would get 16/(months days)*salary).

    I would like to see if I can automated the process to see how much each person should receive.


    I have added a excel file - where you will see the column for adj amounts of the base pay - this is the column that I want to know
    how to calculate quickly and automatically for 1000s of staff. - there are months with different days... so I am stuck.


    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sum payments based on payment received range, count payments based on ID and package
    By STINSON in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2016, 12:02 PM
  2. Using Excel to Calculate Partial Payments
    By bpatters69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2015, 06:44 AM
  3. Need help calculating interst on invoices with partial payments
    By 000lynx in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-29-2013, 08:24 PM
  4. macro to offset payments against invoices (full and partial)
    By bwaite87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2013, 10:55 AM
  5. Replies: 3
    Last Post: 01-03-2013, 10:42 AM
  6. Replies: 7
    Last Post: 06-02-2012, 05:56 AM
  7. Calculating Due Dates Based on Payments
    By Eric Hanson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1