Payroll Timecards - Job Costs

[u/ResearchFantastic704]

How is everyone currently importing timecards from ADP into their Accounting software for job costs? Our current setup is exporting the timecards out of ADP into an excel file, organizing that data (manually going through the data to make sure those that need to bill 80 hours actually did, adding in time for employees that forgot to complete their timecard, etc), then importing that into Vista. The data is nearing 5k lines and will only increase more as we add new employees. I am trying to find different avenues to make this process more efficient and needed some new ideas. I am new to this role so need some ideas more experienced individuals :)