Payroll Remediation

Payroll Remediation#

title="Financial Summary"

[[log]]
date=11/08/2024
description="Found outstanding balance to Paychex for County Road Services, 3927.94"

[[salaryEmployee]]
name=Zachary Jarvis
start=1/1/24
end=9/9/24
annualSalary=114400

[[salaryEmployee]]
name=Kyle Winans
start=1/1/24
end=12/30/24
annualSalary=62400

[[salaryEmployee]]
name=Alexander Denbaugh
start=1/1/24
end=12/30/24
annualSalary=140400

[[hourlyEmployee]]
name=Bradon Beck
start=1/1/24
end=9/20/24
hourlyRate=22

[[fringeBenefits]]
name=Kyle Winans
amount=4800

[[hoursWorked]]
payPeriod=01/15/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=01/29/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=02/12/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=03/11/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=03/25/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=04/08/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=05/06/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=06/03/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=06/17/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=07/15/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=07/29/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=08/26/24
employee=Bradon Beck
hours=

[[hoursWorked]]
payPeriod=09/23/24
employee=Bradon Beck
hours=

date,[[startTime,endTime]],holidayPay,project,description
09/30/24,[[15:00,17:00]],"No","devop","Worked on provisioning the Network Prototype"
10/02/24,[[09:00,12:00]],"No","devop","Worked on provisioning the Network Prototype"
10/03/24,[[09:00,17:00]],"No","devop","Worked on provisioning the Network Prototype"
09/23/24,[[09:00,12:00],[15:00,17:00]],"No","devop","Worked on provisioning the Dell Server"
09/24/24,[[09:00,17:00]],"No","devop","Worked on provisioning the Network Prototype"
09/25/24,[[09:00,12:00]],"No","devop","Worked on provisioning the Network Prototype"
09/16/24,[[09:00,12:00],[15:00,17:00]],"No","devop","Troubleshot bug in Active Directory server configuration"
09/18/24,[[09:00,12:00]],"No","devop","Troubleshot bug in Active Directory server configuration"
09/19/24,[[09:00,17:00]],"No","devop","Troubleshot bug in Active Directory server configuration, gave up and went with sloppy workaround temporarily. Troubleshot scanner for HL Fraas. Began studying REST API for Juniper Firewall"
09/20/24,[[09:00,13:45]],"No","devop","Troubleshot bug in Active Directory server configuration, continued preparations for Juniper Api, began configuration for Dell Server"
09/09/24,[[09:00,12:00],[15:00,16:30]],"No","devop","Troubleshot bug in Active Directory server configuration"
09/10/24,[[09:00,16:30]],"No","devop","Troubleshot bug in Active Directory server configuration, facilitated purchase of TeamViewer Tensor, set up a juniper firewall"
09/13/24,[[09:00,17:15]],"No","devop","Troubleshot bug in Active Directory server configuration. Created a sloppy work-around"
09/03/24,[[09:00,17:00]],"No","devop","Added Rclone functionality"
09/04/24,[[09:10,12:10]],"No","devop","Worked on development environment"
09/04/24,[[09:00,17:00]],"No","devop","Added functionality so that windows computers can automatically join a domain"
08/21/24,[[15:00,16:00]],"No","devop","Updated Workstation VM"
08/22/24,[[12:00,13:00]],"No","devop","Updated Workstation VM"
08/26/24,[[09:00,12:00],[14:30,16:00]],"No","devop","Updated Workstation VM"
08/27/24,[[09:00,14:00]],"No","devop","Added configuration for Active Directory"
08/12/24,[[07:00,15:00]],"No","devop","Troubleshot Active Directory server"
08/13/24,[[07:00,15:00]],"No","devop","Troubleshot Active Directory server"
08/14/24,[[07:00,15:00]],"No","devop","Troubleshot Active Directory server"
08/15/24,[[07:00,15:15]],"No","devop","Scripted Active Directory server. Documented Troubleshooting journey."
08/16/24,[[07:00,11:30]],"No","devop","Added Active Directory configuration functionality"
08/5/24,[[07:00,15:30]],"No","devop","Finished scripting automatic Windows Dhcp Server. Continued Work on Active Directory"
08/6/24,[[07:00,15:00]],"No","devop","Continued work on Windows Active Directory"
08/7/24,[[07:00,15:00]],"No","devop","Troubleshot Windows 11 VM. Got TeamViewer installing automatically. Got a Windows Fileserver up and running and began scripting."
08/8/24,[[07:00,15:00]],"No","devop","Automated Windows File Server."
08/9/24,[[07:00,15:00]],"No","devop","Automated Windows SQL Server. Troubleshot Active Directory server"
07/29/24,[[07:00,15:00]],"No","devop","Expanded and refined the caching system. Began looking into automating factory talk restore (dead end). Built a vm for Zach."
07/30/24,[[07:00,15:00]],"No","devop","Configured a Windows Active Directory Server"
07/31/24,[[07:00,15:00]],"No","devop","Configured a Windows Active Directory Server via Powershell and began scripting it"
08/01/24,[[07:00,15:00]],"No","devop","Continued automating Windows Active Directory Server. Helped Zach get TeamViewer going. Made sure Latitude was good to go to ElDorado "
08/02/24,[[07:00,15:00]],"No","devop","Signed up for a trial of Team Viewer Tensor and set it up. Trouble shot automated Active Directory Server"
07/22/24,[[07:00,15:00]],"No","devop","src/factory","Continued working on metacrud server, working toward devop consistently building a working server"
07/23/24,[[10:00,18:00]],"No","devop",".dist","Continued work on metacrud server, and began work on organizing deliverables"
07/24/24,[[07:00,15:15]],"No","devop","src","Organized deliverable and automated devop distribution"
07/25/24,[[07:00,15:30]],"No","","Began provisioning the Dell Latitude Computer, and created backups of our files"
07/26/24,[[07:00,15:00]],"No","","Finished provisioning the Intel Nuc for Western Forge and the Dell Latitude for the El Dorado wastewater plant. Fixed VMware installer."
07/15/24,[[07:00,16:00]],"No","Fixed caching system, began experimenting with mac, and helped Alex attempt to get metacrud working on his computer"
07/16/24,[[07:00,15:00]],"No","Experimented with metacrud apt package and server"
07/17/24,[[07:00,16:00]],"No","devop","src/factory/script","Got a metacrud server running again, and began to add support for it in devop"
07/08/24,[[07:00,15:00]],"No",,"Continued research on installation images"
07/09/24,[[07:00,15:00]],"No",,"Prepared eldorado virtual machine and continued developing/testing installation images"
07/10/24,[[07:00,15:30]],"No",,"Ordered devices, continued research on installation images, and wrangled a fish"
07/11/24,[[07:00,15:40]],"No","devop","src/devop/factory/operatingSystemInstallerImg","Implemented a working installation image builder into devop"
07/12/24,[[07:00,15:15]],"No","devop","src/devop/","Fixed bugs and began reworking the caching system"
07/01/24,[[07:00,15:15]],"No","devop","src, Fixed various bugs within the repository and began work on a Debian MetaCRUD server."
07/02/24,[[07:00,15:00]],"No","devop","src, Got devop building 32bit windows servers and MetaCRUD servers. Got Zach vms with Legacy Tag Database Converter installed"
07/03/24,[[07:00,15:00]],"No","devop","src,Polished 32bit and Debian builders and added apps to the library. Began work on img installers"
07/04/24,[[07:00,15:00]],"No","devop","src/factory/operatingSystemInstallerImg","Continued work on .img installers"
06/24/24,[[07:00,15:30]],"No","Continued work on Windows UEFI iso."
06/25/24,[[07:00,15:00]],"No","Got Windows UEFI iso working and automatically provisioned Intel Nuc."
06/26/24,[[07:00,15:00]],"No","devop","/src/devop/factory/","Implemented UEFI ISO in devop. Added customization to Debian Preseed. Resumed testing and researching Studio 5000 offline install. Finished setting up Broadcom account and got Zach his VMWare Key"
06/27/24,[[07:00,16:15]],"No","devop","src/devop/","Added more complicated processing to the script factory in exchange for simpler jsons. Cleared out redundant information, and made it so anything interfacing with it via json doesn't need to understand how things need to happen, only what needs to happen."
06/28/24,[[07:00,15:00]],"No","Made a 32bit Windows vm with FTView version 5 for Zach."
06/17/24,[[07:00,15:00]],"No","devop","/","Added support for Windows 10 and Factory Talk View. Got preseed.cfg working, and continued moving Debian support further."
06/19/24,[[07:00,16:30]],"No","Created a factory talk view vm, and began adding support for factory talk view version 5"
06/20/24,[[07:00,15:00]],"No","devop","/lib"," Uploaded ftv version 5 vm and explored and documented configuration. Continued research on windows efi iso."
06/21/24,[[07:00,15:00]],"No"," Attempted Windows provisioning on the Intel Nuc and continued research on windows efi iso (unproductive)."
06/10/24,[[07:00,16:30]],"No","metacrud","/","Worked with Zach on installing metacrud and fixed bugs with the package"
06/11/24,[[07:00,15:30]],"No","devop","/src","Restored the devop repository from latest backup, and began getting it into a usable state (mainly fixed inconsistencies in the library)"
06/12/24,[[07:00,15:30]],"No","devop","/src","Added file dependencies, fixed the Windows setup script, and cleaned up a bit"
06/13/24,[[07:00,15:00]],"No","devop","/","Reorganized the data to allow for version control, and modified the source to accommodate"
06/14/24,[[07:00,15:00]],"No","devop","/src","Finished implementing version control, and began to bring customized Debian over from developmentEnvironment"
06/03/24,[[07:00,15:00]],"No","metacrud","/","Fixed apt package and made it less reliant on pip. Continued work configuring permissions. Returned metacrud to a testable/developable state"
06/04/24,[[07:00,15:30]],"No","metacrud","/","Cleaned up some documentation. Troubleshot issue with Slack not running in development environment. Worked on metacrud tracking and verifying pids."
06/05/24,[[07:00,16:00]],"No","Did a little troubleshooting on metacrud nginx processes. Built a virtual machine with rslogix for Zach."
06/06/24,[[07:00,15:15]],"No","metacrud","/src/metacrud/core","Fixed nginx not running without sudo, and incorportated in the apt package. Troubleshot the api and got restAPI running (but not quite working) ."
06/07/24,[[07:00,15:00]],"No","metacrud","/docs"," Made changes to the readme, got development.rst and module docstrings incorporated into sphinx docs, improved the makefile for better dependency tracking and simplified cleans."
05/27/24,[[07:00,17:30]],"Yes","metacrud","/","Streamlined make processes. Organized repository. Added pip and apt package builders."
05/28/24,[[07:00,15:15]],"No","metacrud","/","Worked further on the apt package installer."
05/29/24,[[07:00,12:00]],"No","metacrud","/","Reworked the make file from scratch, allowing it to track dependencies for the apt package."
05/30/24,[[07:00,15:15]],"No","metacrud","/","Got the new make file working, doing various bug fixes. Did a bit of work in metacrud, the metacrud apt package, and developmentEnvironment."
05/31/24,[[07:00,15:15]],"No","metacrud","/","Worked on a metacrud dev install."
05/20/24,[[08:00,16:45]],"No","developmentEnvironment","etc","Edited the preseed file and adjusted some isolinux files so Debian self-installs. Also began experimenting with adding Gnome Desktop and adding a post install script."
05/21/24,[[07:00,15:00]],"No","developmentEnvironment","/","Got the post install script working, and added features to it. Now creates a useable Debian environment"
05/22/24,[[07:00,16:00]],"No","developmentEnvironment","/"
05/23/24,[[07:00,17:00]],"No","developmentEnvironment","/","Got the development environment into a useable state, deployed it on my laptop, and began work on other features"
05/24/24,[[09:00,17:00]],"No","developmentEnvironment","/","Continued work on customizing the development environment and testing features"
05/14/24,[[09:30,15:45]],"No","Devop","src","Began work on copying the Windows Filesystem, and worked with Charlie on cleaning up the repository."
05/03/24,[[09:00,16:00]],"No","Devop","log,factory","Fixed errors in logging, and began incorporating the new cloud file server and caching."
05/03/24,[[09:00,16:00]],"No","Devop","answerFile","Adopted the answer file script to current format and added error checking."
04/26/24,[[09:00,15:15]],"No","Devop","Computer,ScriptFactory","Workstation webserver demo, workstation training virtual machine"
04/18/24,[[10:30,16:00]],"No","Devop","Computer","Added functionality to delete unwanted users from answer file, re-began work on disabling windows updates, and troubleshot virtual machines"
04/19/24,[[10:15,15:00]],"No","Devop","Computer, ScriptFactory","Troubleshot virtual machines and got the script builder working"
04/12/24,[[09:00,16:45]],"No","Devop","Computer","Added a static initialization script to startup and began dynamically formatting the answer file"
01/02/24,[[07:00,15:00]],"No",""
01/04/24,[[07:00,15:00]],"No",""
01/05/24,[[07:00,15:00]],"No",""
01/08/24,[[07:00,15:00]],"No",""
01/11/24,[[07:00,16:00]],"No",""
01/12/24,[[07:00,16:00]],"No",""

[[hourlyNotes]]
note="On 05/27/24 (Memorial Day) I worked 10.5 hours of holiday time. The holiday time didn't get applied to my recent Paystub, so Charlie Winans wanted me to make a note of it here."

[[hourlyNotes]]
note="5/3/24(Charlie): Next payroll add 2 hours to Bradon’s payroll. I got the weeks mixed up and he caught it."

[[payrolls]]
Date, Status
01/15/24, Withdrawn 1/18/24,10107.85
01/29/24, Withdrawn 2/1/24,10147.26
02/12/24, Withdrawn 2/15/24,10162.02
02/26/24, Withdrawn 2/29/24,10083.25
03/11/24, Withdrawn 3/14/24,10117.69
03/25/24, Withdrawn 3/28/24,10127.55
04/08/24, Withdrawn 4/12/24,10186.66
04/22/24, Withdrawn 5/9/24,10162.04
05/06/24, Withdrawn 5/23/24,10562.88
05/20/24, Withdrawn 6/5/24,12353.29
06/03/24, Paid to employees not paid to paychex?,
06/17/24, Missing,
07/01/24, Missing,
07/15/24, Missing,
07/29/24, Missing,
08/12/24, Missing,
08/26/24, Missing,
09/09/24, Missing,
09/23/24, Missing,
10/07/24, Missing,
10/21/24, Missing,
11/04/24, Missing,
11/18/24,,
12/02/24,,
12/16/24,,
12/30/24,,
Total Withdrawn,,104010.49

[[netPayments]]
Date, Name, Amount
09/05/24, Kyle Winans, 2000
08/12/24, Kyle Winans, 2000
07/24/24, Kyle Winans, 4000
11/6/24, Alexander Denbaugh, 3160.5
11/5/24, Alexander Denbaugh, 4000
9/18/24, Alexander Denbaugh, 3600
9/5/24, Alexander Denbaugh, 4000
8/12/24, Alexander Denbaugh, 4000
7/24/24, Alexander Denbaugh, 4000
7/17/24, Alexander Denbaugh, 2000
9/20/24, Zachary Jarvis, 5000
9/5/24, Zachary Jarvis, 4000
8/12/24, Zachary Jarvis, 2500
8/12/24, Zachary Jarvis, 1500
8/2/24, Zachary Jarvis, 1000
7/24/24, Zachary Jarvis, 4000
9/20/24, Bradon Beck, 2000
8/16/24, Bradon Beck, 2000
Total Withdrawn,,54760.5

[[rent]]
Date, Name, Amount
2/26/24, Alexander Denbaugh, 1000(Rent)
2/16/24, Alexander Denbaugh, 1000(Rent)
Burns(Paid off in full)

[[paymentOwedToPaychex]]
Date, Name, Amount






[[priorityNotes]]
recipient="Jennnifer"
note="Here are my November priorities if at all possible starting with duplicate tax filing resolution:"

Exact Controls, LLC:
        1. Resolve the issues with duplicate tax filings with the IRS

County Road Services, LLC.
        1. I am aiming to make sure that the Payrolls completed by Paychex for County Road Services have all tax filings reported and paid by the end of the year. No additional payrolls will be run via W-2 for the year via this organizations.
        2. Copy of all paystubs and financial summary done for all completed payrolls to-date for our records.
        3. Work with Ryan to ensure all tax accounts exist fully for this company.
        4. Work with Ryan to verify all filings completed Q1-Q3 for this organizations.
        5. Work with Ryan to ensure all payments are completed Q1-Q3 for this organization
        6. By year end, report Q4 as no payrolls run, etc. to finish year end on time.

Exact Services, Inc:
        1. We did downsize and now only have 2 employees.
        2. The last date of employment for Zachary Jarvis was Sept. 9, 2024 and the last date of employment for Bradon Beck was Sept. 20, 2024
        3. I will provide a report of hours worked for Bradon for the year to reconcile any outstanding amounts by the end of next week.
        4. I will provide a report of net payment made to each employee since the last payroll

The priorities are as follows:
1. Ensure all tax accounts exist and are documented on Onvio
2. Ensure all tax filing completed for Q1 and all tax payments made
3. Ensure Q2-Q4 complete to date as much as possible
        1. Missing payrolls ran taking into account any credit for payments sent directly to employees
        2. Missing net pay to employees according to payroll
        3. Missing tax filings for each tax account
        4. Missing tax payments for each account

Thank you,
Charlie Winans
(775)224-5322


[[priorityNotes]]
recipient="Ryan"
note="Good morning, Ryan(Accountant)!

This week priorities by next Monday:
        1. Charlie: Make money via sales and document policies for sales, billing, A/R, and collections according to standard service contracts via Onvio
        2. Ryan: Duplicate IRS tax filing resolution
        3. Charlie: Documentation of company filing and formation information via Onvio
        4. Charlie: Documentation of invoicing via Onvio
        5. Ryan: Verify all payroll tax accounts and provide records/certificates via Onvio for incorporation into documentation

End of year priorities:
        1. Charlie: Make money via sales
        2. Charlie: Balance paid in full to Ryan
        3. Charlie: Balance paid in full for Paychex
        4. Ryan: Duplicate IRS tax filing resolution
                1. Kyle notice
                2. Everyone else
        5. 2023 Taxes done for personal/Exact Controls, LLC
                1. Charlie: Pending expense reporting completion
                2. Ryan: Submit taxes
        6. Charlie: Filings and formations(incl. beneficial owner reporting)
                1. Review and document Exact Controls, LLC
                2. Review and document Exact Controls, Inc
                3. Review and document Exact Services, Inc
                4. Review and document Exact Systems, Inc
                5. Review and document Amity Tutoring, LLC
                6. Review and document County Road Services, LLC
        7. Charlie: External invoicing
                1. Review all issued invoicing from each company and financial reporting on such for each company
                2. Reconcile invoices issued to external companies
        8. Charlie: Sales Tax Accounts, Filing, and payments
                1. Document and very each company, each tax account, each filing, and each payment for completion
        9. Charlie: Payroll for each company
                1. Document and verify each company
                2. Document and verify each employee
                3. Document and verify each tax account for each company and each jurisdiction/tax
                4. Resume payroll
                        5. Integrate clockify to Paychex as well
                5. Run missed payroll period for each employee for each quarter.
                6. Verify each quarter(Q1-Q4)
                        1. Each payroll period paystub and report
                        2. Each net payment
                        3. Each tax filing
                        4. Each tax payment
        10. Charlie: Inter-company invoicing
                1. Verify and reconcile each inter-company invoice
                2. Ensure no balance between companies
        11. Charlie: Prepare year end financial statements
        12. Ryan: File all taxes and year end stuff
        13. Charlie: Document accounting and bookkeeping policies and procedures for targeted automation
        14. Charlie: Development of accounting application according to policies and procedures to allow for implementation and growth throughout next year
        15. Ryan: Provide feedback on documented accounting and bookkeeping practices that are basis of application development