http://wiki.freegeek.org/index.php?title=Payroll_and_the_books&feed=atom&action=historyPayroll and the books - Revision history2024-03-29T12:58:02ZRevision history for this page on the wikiMediaWiki 1.35.1http://wiki.freegeek.org/index.php?title=Payroll_and_the_books&diff=69389&oldid=prevMichaelWestwind at 22:47, 20 December 20132013-12-20T22:47:19Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:47, 20 December 2013</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11" >Line 11:</td>
<td colspan="2" class="diff-lineno">Line 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Employer tax liability is taken from the "Payroll summary" report and entered into the memorized transaction "Payroll taxes"</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Employer tax liability is taken from the "Payroll summary" report and entered into the memorized transaction "Payroll taxes"</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Union dues and <del class="diffchange diffchange-inline">retirement </del>checks</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Convert </ins>Union dues<ins class="diffchange diffchange-inline">, retirement, garnishments, etc to bills </ins>and <ins class="diffchange diffchange-inline">write </ins>checks</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*CWA</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*CWA</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Calvert</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Calvert</div></td></tr>
</table>MichaelWestwindhttp://wiki.freegeek.org/index.php?title=Payroll_and_the_books&diff=69383&oldid=prevMichaelWestwind at 01:15, 20 December 20132013-12-20T01:15:47Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 01:15, 20 December 2013</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#Open the books in gnucash and open '''Liabilities:A/P:Gross pay'''</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">(In Progress)</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#Have the Paychex </del>payroll <del class="diffchange diffchange-inline">report in front of you.</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#Get the gross pay numbers, the total </del>and <del class="diffchange diffchange-inline">subtotals for each staff category from </del>the <del class="diffchange diffchange-inline">Paychex reports. The total is easy to get</del>, <del class="diffchange diffchange-inline">but you have to add up the individual people </del>in <del class="diffchange diffchange-inline">each category to get the subtotals. Currently there are three categories, each with a different pay scale:</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Our </ins>payroll <ins class="diffchange diffchange-inline">provider is GNSA</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* Collective (salaried)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* Committed (12.55</del>/<del class="diffchange diffchange-inline">hr)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Payroll reports are downloaded and as pdf files </ins>and <ins class="diffchange diffchange-inline">placed on </ins>the <ins class="diffchange diffchange-inline">application server</ins>, <ins class="diffchange diffchange-inline">currently "beak" </ins>in <ins class="diffchange diffchange-inline">"/srv/fgstaff</ins>/<ins class="diffchange diffchange-inline">beancounters</ins>/payroll<ins class="diffchange diffchange-inline">/GNSA reports/</ins>".</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* Everything else (11.55</del>/<del class="diffchange diffchange-inline">hr)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># Create an entry called "Regular </del>payroll" <del class="diffchange diffchange-inline">dated for the last day of the pay period. This should autopopulate so the debit side should be the expense lines for the individual staff categories. The credit side should be the total of those lines and be the Gross pay liability</del>.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The <ins class="diffchange diffchange-inline">payroll expense is recorded as a single transaction using a QuickBooks memorized transaction </ins>of <ins class="diffchange diffchange-inline">that name</ins>. The <ins class="diffchange diffchange-inline">expense is divided </ins>by <ins class="diffchange diffchange-inline">worker category </ins>and the <ins class="diffchange diffchange-inline">information for </ins>it is taken from <ins class="diffchange diffchange-inline">a custom report called "Employee earnings by type"</ins>. <ins class="diffchange diffchange-inline">Starting in 2014, the expense instead will </ins>be <ins class="diffchange diffchange-inline">recorded by class using a spreadsheet created by Richard</ins>, <ins class="diffchange diffchange-inline">details to be arranged</ins>.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># Then go through the register for the individual checks and make an individual entry for each staff member who got paid, dated for the paycheck date. </del>The <del class="diffchange diffchange-inline">splits will vary depending on the individual. The debit side will be the gross pay. The credit side will include some </del>of <del class="diffchange diffchange-inline">the following:</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Liabilities:Paychex Direct Deposits''' </del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Individual checks </ins>and <ins class="diffchange diffchange-inline">accompanying deductions are entered using </ins>the <ins class="diffchange diffchange-inline">memorized transaction "Employee paycheck", then info taken </ins>from <ins class="diffchange diffchange-inline">the "</ins>Payroll <ins class="diffchange diffchange-inline">register" report</ins>.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Assets:Bank:4817 Main Checking'''</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Liabilities:Employee Withholding''' Lump the tax withholdings together</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Employer tax </ins>liability is <ins class="diffchange diffchange-inline">taken </ins>from the <ins class="diffchange diffchange-inline">"Payroll summary" </ins>report <ins class="diffchange diffchange-inline">and entered into the memorized transaction </ins>"Payroll <ins class="diffchange diffchange-inline">taxes</ins>"</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Liabilities:A/P:Valic''' employee retirement contribution</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Assets:A/R:Health care owed:<whoever>''' added choice health care</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Union dues </ins>and <ins class="diffchange diffchange-inline">retirement checks</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Assets:A/R:Advances:<whoever>''' repayments on advances</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*<ins class="diffchange diffchange-inline">CWA</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># Now go to '''Liabilities:Paychex Direct Deposits''' and make an entry titled "direct deposits"</del>. The <del class="diffchange diffchange-inline">value will be the amount taken out </del>by <del class="diffchange diffchange-inline">Paychex for the direct deposits </del>and the <del class="diffchange diffchange-inline">date is the date they made the withdrawal, which will be in the Paychex report, and </del>it is taken from <del class="diffchange diffchange-inline">'''Assets:Bank:4817 Main Checking'''</del>. <del class="diffchange diffchange-inline">The direct deposit liability should </del>be <del class="diffchange diffchange-inline">at zero after this is done. If it is not</del>, <del class="diffchange diffchange-inline">double check your previous entries</del>.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*<ins class="diffchange diffchange-inline">Calvert</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># Next you need to enter the employer side tax liability </del>and the <del class="diffchange diffchange-inline">tax payment. This is best done </del>from <del class="diffchange diffchange-inline">'''Liabilities:</del>Payroll <del class="diffchange diffchange-inline">Taxes'''</del>. <del class="diffchange diffchange-inline"> The </del>liability is <del class="diffchange diffchange-inline">gotten </del>from the <del class="diffchange diffchange-inline">Paychex </del>report<del class="diffchange diffchange-inline">. Make an entry for </del>"Payroll <del class="diffchange diffchange-inline">Taxes</del>"<del class="diffchange diffchange-inline">, dated for the end of the pay period, </del>and <del class="diffchange diffchange-inline">populate the debit side with the employer side numbers. The accounts should be in there automatically, but if they are not, use the following:</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*<ins class="diffchange diffchange-inline">other?</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#</del>* <del class="diffchange diffchange-inline">'''Expenses:Staffing Expenses:Payroll Taxes:Social Security'''</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#</del>* <del class="diffchange diffchange-inline">'''Expenses:Staffing Expenses:Payroll Taxes:Medicare'''</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#</del>* <del class="diffchange diffchange-inline">'''Expenses:Staffing Expenses:Payroll Taxes:OR SUI'''</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">#* '''Expenses:Staffing Expenses:Payroll Taxes:OR ER Work Ben'''</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># Then make an entry dated for the date the report says the money was withdrawn titled "Tax Payment". The left (debit) side has two entries, one for the amount you just entered above '''Liabilities:Payroll Taxes''', the other for the amount of the employee side tax liability '''Liabilities:Employee Withholdings'''. The other side (credit) is the total withdrawal for the taxes that Paychex takes from the checking account '''Assets:Bank:4817 Main Checking'''.</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"># If the pay period is split between months, the gross pay expenses need to be split between the months. We could make it more complicated, but at this point, we are dividing each gross pay expense by the number of days in the pay period and multiplying by the number of days in each month to come up with the amounts. This also needs to be done for the payroll tax liability (employer side only).</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: Accounting]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: Accounting]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: Procedures]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: Procedures]]</div></td></tr>
</table>MichaelWestwindhttp://wiki.freegeek.org/index.php?title=Payroll_and_the_books&diff=50182&oldid=prevRfs at 21:46, 6 July 20102010-07-06T21:46:00Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:46, 6 July 2010</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21" >Line 21:</td>
<td colspan="2" class="diff-lineno">Line 21:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Then make an entry dated for the date the report says the money was withdrawn titled "Tax Payment". The left (debit) side has two entries, one for the amount you just entered above '''Liabilities:Payroll Taxes''', the other for the amount of the employee side tax liability '''Liabilities:Employee Withholdings'''. The other side (credit) is the total withdrawal for the taxes that Paychex takes from the checking account '''Assets:Bank:4817 Main Checking'''.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Then make an entry dated for the date the report says the money was withdrawn titled "Tax Payment". The left (debit) side has two entries, one for the amount you just entered above '''Liabilities:Payroll Taxes''', the other for the amount of the employee side tax liability '''Liabilities:Employee Withholdings'''. The other side (credit) is the total withdrawal for the taxes that Paychex takes from the checking account '''Assets:Bank:4817 Main Checking'''.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># If the pay period is split between months, the gross pay expenses need to be split between the months. We could make it more complicated, but at this point, we are dividing each gross pay expense by the number of days in the pay period and multiplying by the number of days in each month to come up with the amounts. This also needs to be done for the payroll tax liability (employer side only).</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># If the pay period is split between months, the gross pay expenses need to be split between the months. We could make it more complicated, but at this point, we are dividing each gross pay expense by the number of days in the pay period and multiplying by the number of days in each month to come up with the amounts. This also needs to be done for the payroll tax liability (employer side only).</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category: Accounting]]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category: Procedures]]</ins></div></td></tr>
</table>Rfshttp://wiki.freegeek.org/index.php?title=Payroll_and_the_books&diff=47464&oldid=prevMichaelWestwind: how to enter the payroll2010-03-09T00:33:03Z<p>how to enter the payroll</p>
<p><b>New page</b></p><div>#Open the books in gnucash and open '''Liabilities:A/P:Gross pay'''<br />
#Have the Paychex payroll report in front of you.<br />
#Get the gross pay numbers, the total and subtotals for each staff category from the Paychex reports. The total is easy to get, but you have to add up the individual people in each category to get the subtotals. Currently there are three categories, each with a different pay scale:<br />
#* Collective (salaried)<br />
#* Committed (12.55/hr)<br />
#* Everything else (11.55/hr)<br />
# Create an entry called "Regular payroll" dated for the last day of the pay period. This should autopopulate so the debit side should be the expense lines for the individual staff categories. The credit side should be the total of those lines and be the Gross pay liability.<br />
# Then go through the register for the individual checks and make an individual entry for each staff member who got paid, dated for the paycheck date. The splits will vary depending on the individual. The debit side will be the gross pay. The credit side will include some of the following:<br />
#* '''Liabilities:Paychex Direct Deposits''' <br />
#* '''Assets:Bank:4817 Main Checking'''<br />
#* '''Liabilities:Employee Withholding''' Lump the tax withholdings together<br />
#* '''Liabilities:A/P:Valic''' employee retirement contribution<br />
#* '''Assets:A/R:Health care owed:<whoever>''' added choice health care<br />
#* '''Assets:A/R:Advances:<whoever>''' repayments on advances<br />
# Now go to '''Liabilities:Paychex Direct Deposits''' and make an entry titled "direct deposits". The value will be the amount taken out by Paychex for the direct deposits and the date is the date they made the withdrawal, which will be in the Paychex report, and it is taken from '''Assets:Bank:4817 Main Checking'''. The direct deposit liability should be at zero after this is done. If it is not, double check your previous entries.<br />
# Next you need to enter the employer side tax liability and the tax payment. This is best done from '''Liabilities:Payroll Taxes'''. The liability is gotten from the Paychex report. Make an entry for "Payroll Taxes", dated for the end of the pay period, and populate the debit side with the employer side numbers. The accounts should be in there automatically, but if they are not, use the following:<br />
#* '''Expenses:Staffing Expenses:Payroll Taxes:Social Security'''<br />
#* '''Expenses:Staffing Expenses:Payroll Taxes:Medicare'''<br />
#* '''Expenses:Staffing Expenses:Payroll Taxes:OR SUI'''<br />
#* '''Expenses:Staffing Expenses:Payroll Taxes:OR ER Work Ben'''<br />
# Then make an entry dated for the date the report says the money was withdrawn titled "Tax Payment". The left (debit) side has two entries, one for the amount you just entered above '''Liabilities:Payroll Taxes''', the other for the amount of the employee side tax liability '''Liabilities:Employee Withholdings'''. The other side (credit) is the total withdrawal for the taxes that Paychex takes from the checking account '''Assets:Bank:4817 Main Checking'''.<br />
# If the pay period is split between months, the gross pay expenses need to be split between the months. We could make it more complicated, but at this point, we are dividing each gross pay expense by the number of days in the pay period and multiplying by the number of days in each month to come up with the amounts. This also needs to be done for the payroll tax liability (employer side only).</div>MichaelWestwind