Spreadsheet: 269697d1381250037-multiple-logic-functions-in-one-cell-wip-calculator
Sheet: WIP Report

 |  |  |  |  |  |  |  | Enter beginning calendar month of your fiscal year: | January
 |  |  |  |  |  |  |  | Enter the Work In Progress Adjustment for the last period of your previous fiscal year: | 0
REPORT PERIOD #1 | January | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 10000 |  |  | 33000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru January
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #2 | February | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 33000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Balance Sheet
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #3 | March | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 30000 |  |  | 33000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Balance Sheet
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #4 | April | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru April
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #5 | May | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru May
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #6 | June | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru June
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #7 | July | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru July
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #8 | August | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru August
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #9 | September | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru September
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #10 | October | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru October
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #11 | November | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru November
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.
REPORT PERIOD #12 | December | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | I
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Underbilled(+)      or             Overbilled(-)
 |  | test | 100000 |  | 0.4 | 20000 |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  | WIP Status:
 |  | Report Total |  |  |  |  |  |  |  |  |  | Thru December
 |  |  |  |  |  |  |  |  | Report total prior period:
 |  |  |  |  |  |  |  |  | Adjustment
 |  | Once you have given your final invoice for a project, take the project off this report.