{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Andersen","Brewster","Ehlert","Rogers","Stephenson","Whitaker","Input Data","Tips"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Andersen","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Jenni Andersen",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"Revenue(D5,E5,F5,G5)","v":0},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":0},{"$f":"KSHold($A$3,J5)","v":1500},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":0},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table218[Revenue])","v":0},{"$f":"SUM(Table218[Broker Comp])","v":0},{"$f":"SUM(Table218[KS Holding])","v":1500},null,{"$f":"SUM(Table218[Advertising Holding])","v":0},{"$f":"SUM(Table218[Other Revenue])","v":0}]

{"sheet":"Brewster","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Ty Brewster",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
["2012-10-26","AZ","Rice",515000,"Lender",null,"Provident","Advertising",{"$f":"Revenue(D5,E5,F5,G5)","v":7725},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":5150},{"$f":"KSHold($A$3,J5)","v":1462},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":1113},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
["2012-10-26","AZ","Patlin",224500,"Lender",null,"Provident","Personal",{"$f":"Revenue(D6,E6,F6,G6)","v":3367.5},2245,1679.6,null,{"$f":"RemainingAd(H6,I6,J6,K6,L6)","v":0},{"$f":"RemainingOtherRev(H6,I6,J6,K6, L6)","v":-557.1}]
["2012-10-26","AZ","Wolfe",345000,"Lender",null,"Plaza","Personal",{"$f":"Revenue(D7,E7,F7,G7)","v":6037.5},3450,1326,null,{"$f":"RemainingAd(H7,I7,J7,K7,L7)","v":0},{"$f":"RemainingOtherRev(H7,I7,J7,K7, L7)","v":1261.5}]
["2012-10-26","AZ","Faulds",120000,"Borrower",2423.6,"Plaza","Personal",{"$f":"Revenue(D8,E8,F8,G8)","v":2423.6},1000,1580,null,{"$f":"RemainingAd(H8,I8,J8,K8,L8)","v":0},{"$f":"RemainingOtherRev(H8,I8,J8,K8, L8)","v":-156.4}]
["2012-10-26","AZ","Ferrini",199000,"Lender",null,"Provident","Personal",{"$f":"Revenue(D9,E9,F9,G9)","v":2985},1990,1659.2,null,{"$f":"RemainingAd(H9,I9,J9,K9,L9)","v":0},{"$f":"RemainingOtherRev(H9,I9,J9,K9, L9)","v":-664.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table21822[Revenue])","v":22538.6},{"$f":"SUM(Table21822[Broker Comp])","v":13835},{"$f":"SUM(Table21822[KS Holding])","v":7706.8},null,{"$f":"SUM(Table21822[Advertising Holding])","v":1113},{"$f":"SUM(Table21822[Other Revenue])","v":-116.20000000000005}]

{"sheet":"Ehlert","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Ben Ehlert",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"Revenue(D5,E5,F5,G5)","v":0},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":0},{"$f":"KSHold($A$3,J5)","v":1500},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":0},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table21823[Revenue])","v":0},{"$f":"SUM(Table21823[Broker Comp])","v":0},{"$f":"SUM(Table21823[KS Holding])","v":1500},null,{"$f":"SUM(Table21823[Advertising Holding])","v":0},{"$f":"SUM(Table21823[Other Revenue])","v":0}]

{"sheet":"Rogers","index":3,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Jonathan Rogers",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"Revenue(D5,E5,F5,G5)","v":0},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":0},{"$f":"KSHold($A$3,J5)","v":1500},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":0},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table21824[Revenue])","v":0},{"$f":"SUM(Table21824[Broker Comp])","v":0},{"$f":"SUM(Table21824[KS Holding])","v":1500},null,{"$f":"SUM(Table21824[Advertising Holding])","v":0},{"$f":"SUM(Table21824[Other Revenue])","v":0}]

{"sheet":"Stephenson","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Rob Stephenson",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"Revenue(D5,E5,F5,G5)","v":0},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":0},{"$f":"KSHold($A$3,J5)","v":1500},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":0},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table21825[Revenue])","v":0},{"$f":"SUM(Table21825[Broker Comp])","v":0},{"$f":"SUM(Table21825[KS Holding])","v":1500},null,{"$f":"SUM(Table21825[Advertising Holding])","v":0},{"$f":"SUM(Table21825[Other Revenue])","v":0}]

{"sheet":"Whitaker","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,5],[2,0,2,2]]}
["KEYSTONE Financial Services Pay Roll"]
[]
["Anthony Whitaker",null,null,null,null,"Borrower Paid",null,null,null,null,null,"Post-Closing","Remaining"," Remaining"]
["Date","St.","Borrower","Loan Amount","Type","Compensation","Lender","Lead","Revenue","Broker Comp","KS Holding","Credit ","Advertising Holding","Other Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"Revenue(D5,E5,F5,G5)","v":0},{"$f":"brokerComp($A$3,D5,E5,F5,I5)","v":0},{"$f":"KSHold($A$3,J5)","v":1500},null,{"$f":"RemainingAd(H5,I5,J5,K5,L5)","v":0},{"$f":"RemainingOtherRev(H5,I5,J5,K5, L5)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table21826[Revenue])","v":0},{"$f":"SUM(Table21826[Broker Comp])","v":0},{"$f":"SUM(Table21826[KS Holding])","v":1500},null,{"$f":"SUM(Table21826[Advertising Holding])","v":0},{"$f":"SUM(Table21826[Other Revenue])","v":0}]

{"sheet":"Input Data","index":6,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lenders","Lender Paid "]
[null,"AFR",1.7500000000000002E-2]
[null,"CMG",1.7500000000000002E-2]
[null,"FPF Whole",1.7500000000000002E-2]
[null,"Icon",1.7500000000000002E-2]
[null,"Oaktree",1.7500000000000002E-2]
[null,"Plaza",1.7500000000000002E-2]
[null,"Provident",1.4999999999999999E-2]
[null,"Security National",0.02]
[null,"Sierra Pacific",1.4999999999999999E-2]
[null,"Stearns",0.02]
[null,"US Bank",1.4999999999999999E-2]
[]
[null,"Type Found","Type of  Loan"]
[null,"Advertising","Lender"]
[null,"Personal","Borrower"]
[]
[null,"States"]
[null,"AZ"]
[null,"CO"]
[null,"OR"]
[null,"UT"]
[]
[null,"Loan Officer","Lender Paid","Borrower Paid","State Tax Rate"]
[null,"Anthony Whitaker",0.01,1000,"N/A"]
[null,"Ben Ehlert",7.4999999999999997E-3,1000,"N/A"]
[null,"Jenni Andersen",5.0000000000000001E-3,500,0.08]
[null,"Jonathan Rogers",5.0000000000000001E-3,500,0.08]
[null,"Rob Stephenson",7.4999999999999997E-3,1000,"N/A"]
[null,"Ty Brewster",0.01,1000,0.08]
[]
[null,"KS Holding"]
[null,"Processing",550]
[null,"Administrative",500]
[null,"Total:",{"$f":"SUM(C35,C34)","v":1050}]

{"sheet":"Tips","index":7,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Key Tips for the KS Pay Roll Calculator"]
[]
["ALWAYS enable macros when you first open the sheet"]
[]
["To add a new line in the calculating box table, just hit \"Enter\" and start with the date on the next row. When you hit \"Enter\" again the line will be calculated. "]
[]
["There is a separate tab (along the bottom of the sheet) for each loan officer. You will find the name of the loan originator in the upper left-hand corner in an orange box."]
[]
["You should never adjust the numbers in the \"Revenue,\" \"Broker Comp,\" and \"KS Holding\" boxes--the program will automatically calculate these numbers for you. "]
[]
["If you need to adjust any of the compensation plans or lender paid percentages, you can adjust these numbers under the \"Input Data\" tab in their respective boxes. "]
[]
["If you are planning on sending out a copy to each loan originator at each pay period, you should consider copying and pasting their data entries without the holding accounts into a separate workbook. This can be done by highlight all the cells you would like (e.g.; \"A1\" through \"K25\"), right click / copy, open a new Excel workbook, click on cell \"A1\", right click, choose \"Paste Special,\" and choose \"Keep Source Column Width.\" You could also choose the \"Paste As Picture\" option which would not allow for editing (the picture could be saved as an actual picture or PDF file as well). Copying the information into a new workbook would also keep each loan officer's compensation plan on the \"Input Data\" tab confidential."]
[]
["The pay roll program will always allocate what should be allocated to the KS Holding account. This is $1050 plus any taxes that should be held for each Arizona W-2ed employee. If not enough revenue has been made on the loan to actually cover that amount, a negative number will be placed in the respective originators holding account (either advertising or other). Once more loans have been added, the total number for the holding accounts will reflect a current balance.   "]