I am hoping that someone will be able to answer this very simple question for us. We work with 90 day income. Often times applicants may only have part of their income with them and we average what is missing. We also see that along with the missing income they may have had one or two pay periods that they received no pay. This is how the database calculates income IF we ask it to average. I would like to know if this is the correct or incorrect way of averaging the income. Should the pay periods that were ZERO be included in the averaging of the missing 8/28 check?
If a customer is paid biweekly and brings in four of the seven checks due to the fact that he cannot find the check dated 8/28 and he did NOT work at this job on 7/17 and 7/3…
If you leave the 8/28 check amount blank and populate the 7/17 and 7/3 check with $0 (since he did not work at that time) and place a check in the Average checkbox, the database will add all the checks together (including those set at $0) divide by 12 (12 weeks) and multiply by 13 (weeks in a quarter). The total quarterly amount should be $812.50 (rounded up).
Thank you in advance for your expertise.
Karen
If a customer is paid biweekly and brings in four of the seven checks due to the fact that he cannot find the check dated 8/28 and he did NOT work at this job on 7/17 and 7/3…
| Check Amount | Check Date |
| $200 | 9/25/15 |
| $300 | 9/11/15 |
| $- | 8/28/15 |
| $150 | 8/14/15 |
| $100 | 7/31/15 |
| $0 | 7/17/15 |
| $0 | 7/3/15 |
If you leave the 8/28 check amount blank and populate the 7/17 and 7/3 check with $0 (since he did not work at that time) and place a check in the Average checkbox, the database will add all the checks together (including those set at $0) divide by 12 (12 weeks) and multiply by 13 (weeks in a quarter). The total quarterly amount should be $812.50 (rounded up).
Thank you in advance for your expertise.
Karen