QuickBooks Integration Q&A

Common Q&A for Timesheet integration with QuickBooks and Hour Timesheet

Question 1. How does QuickBooks sync data with Hour Timesheet?

Answer. We utilize the Web Connector (provided by QuickBooks) to sync company data between QuickBooks Desktop and Hour Timesheet in real time. The version of QuickBooks Online offers a direct sync between the two systems making timesheet integration with QuickBooks simple!

Question 2. What type of data does QuickBooks sync with Hour Timesheet?

Employees: The sync tool will import all “active” QuickBooks employees and vendors (optional) into your Hour Timesheet account. Only vendors that have a First and Last Name field value in QuickBooks will be imported.
Customers/Jobs: The sync tool will import all “active” Customer/Jobs in to your Hour Timesheet account.
Service Items: The sync tool will import all “active” Service Items in to your Hour Timesheet account.
Classes: (optional) The sync tool will import all “active” Classes in to your Hour Timesheet account.
Payroll Items: (optional) The sync tool will import all “active” Payroll Items in to your Hour Timesheet account.

Question 3. How do I add a new data in Hour Timesheet (employees, customers, jobs, etc)?

Answer. New data will need to be entered into your QuickBooks company file first. Once the new data is entered, you can use the web connector tool to import your new data in to your Hour Timesheet account.

Question 4. How will my employees receive their Hour Timesheet login credentials?

Answer. Hour Timesheet will send an email invitation to each employee with the link and login ID to the Hour Timesheet account included in the body of the email. Once the employee accesses the link, the employee will be prompted to create an initial password to login to Hour Timesheet.

Question 5. Can my employees track time against customers and jobs, service items, classes and payroll items?

Answer. Yes, your employees will be asked to select from a list of authorized charges. Employee authorized charges (EOC) are defined by the admin at the employee level. This feature enables the employees to only see EOC’s that are assigned to each user.

Question 6. How do I delete information in my Hour Timesheet account?

Answer. Once you mark the data (employee, customer, job, etc.) as inactive in QuickBooks, the data will be updated in your Hour Timesheet account upon performing the data sync.

Question 7. How does Hour Timesheet identify billable vs non-billable items on the timesheet?

Answer. By default, any EAC that includes a service item will be marked as billable time in QuickBooks.

Question 8. Can employees add comments to a timesheets?

Answer. Yes, Hour Timesheet includes a feature to allow employees to input general comments and daily comments.

Question 9. I exported my employee’s time into my company QuickBooks file, but now I need to make corrections. How do I do this?

Answer. Hour Timesheet does not allow processed timesheet data to be edited. Hour Timesheet will display a link on the Timesheet Review page that will allow the user to create a “corrected” copy of the timesheet. The detailed audit trail will show the log of all changes made to the revised timesheet.

Question 10. Can multiple supervisors approve a single timesheet?

Answer Yes. Hour Timesheet will allow for multiple supervisors to approve a timesheet.

Question 11. We have a requirement for our employees to enter hours worked daily, does Hour Timesheet include daily reminders?

Answer Hour Timesheet includes the option to turn on daily notifications to serve as reminders for those employees who forget to enter time daily.

Question 12. I track my employee leave balance data manually in an Excel spreadsheet because QuickBooks doesn’t include all of the options I need, can Hour Timesheet manage leave?

Answer – Hour Timesheet has a full-function leave management feature that will allow accrued and earned types of leave tracking.

Learn More

Visit us in the marketplace

QuickBooks Online

QuickBooks Desktop

Additional Resources

QuickBooks Tutorials for Accountants

Attend a QuickBooks Training Class Near You

Top Timekeeping Tips

Top Employee Timekeeping Tips

Insight into how your employees spend time is critical. That’s why employee timekeeping software tools make so much sense.

Knowing how much time your employees spend on overhead tasks, project, training, and unpaid leave is invaluable data for your business’s future. Tools that track employee hours and employee schedules will greatly reduce your hours spent processing manual time cards. Continue reading to find out more about tips for employee time and attendance and how Hour Timesheet is the perfect solution for you.

Employee timekeeping is not just for hourly employees

Nonexempt employees need to track work time for FLSA compliance but having salaried employees keep a time sheet is helpful too. Exception-based time tracking helps employers track employee attendance and improve the overall management of daily resources. Tools and solutions that include the ability for employees to track hours worked on mobile devices will provide real time job costing and absentee management at the supervisor level.

Internal policies & approval workflows are the keys to a successful employee timekeeping software implementation.

Software tools are a dime-a-dozen, but it’s how you use the software that defines your success. It’s important to document your timekeeping policies and required approval workflows before you invest in a time & attendance tool.

Don’t be afraid of internet-based employee timekeeping software tools

A detailed timesheet audit trail will flag when a user inputs timesheet data into your system from anywhere but the office. The activity log shows the IP address as well as each entry into the user’s timesheet with a non-editable time and date stamp. Online employee time tracking software also allows for integration with your payroll system with a 2-way sync to and from your payroll software like QuickBooks Online or QuickBooks Desktop.

Microsoft Excel is for spreadsheet data, not for employee timekeeping

Yes, you can keep your employees timesheet data in Excel but is that really efficient? Don’t be afraid to use the tools available to your organization to make you more productive. Rely on the experts…not Excel.

BOTTOM LINE… it’s just smart business.

Features such as daily timesheet reminders, employee leave management and time card approval processes make Hour Timesheet the perfect choice for your organizations’s timekeeping software needs. Available on the web or your iOS and Android mobile app store.

Visit us in the marketplace

QuickBooks Online

QuickBooks Desktop

Additional Resources

Measure Costs Right: Make the Right Decisions

How To Calculate And Track Overhead Costs

How do I Calculate Overhead Costs?

Schedule a Demo

Advice for Successful Grant Management for Nonprofit Organizations

Nonprofit Timekeeping for Your Organization

Managing grant dollars is one of the weakest links in the grant process chain. Directors tend to have detailed and documented process of researching and developing grant proposals. But frequently, that is where the process stops. Unfortunately, the inability of nonprofits to manage grant funds successfully with nonprofit timekeeping software is the single most important reason why a funder may not fund them in the second or third year. Tracking employee hours and timesheet entries by projects and grants can help with these lingering issues. Locate an automated time tracking software for your employees to track hours and manage projects. With an online solution, you’ll be able to gain instant access into how much time your volunteers and employees are spending supporting each grant and lower level items to be tracked.

Track and document everything

Most government grants require significant documentation of all expenditures related to grants. Grant giving organizations require recipients to submit detailed supporting documents before grant payments are made. An employee time card tracking system that has the capacity to automatically generate grant reimbursements based on grant activity not only saves time but improves accuracy. Employee time clock software should include a business rule that requires employees capture all time worked on grand and “non-grant” related activities.

Understand indirect costs and Non-profit Timekeeping

Grants come with indirect costs. Understand whether operating funds for administrative burdens will be covered or if you need to dig up additional funding. Ask your team if your organization is prepared to reallocate its administrative budget to cover the cost and if so for how long. Cost allocation will allow your organization to share overhead expenses across different programs. A good non-profit Timekeeping solution will include time off requests, real time data capture, and a means to track overhead costs. Look for a solution that includes the ability to track volunteer hours using a mobile app for no additional fees.

Know your stuff

Essential to successful nonprofit timekeeping is understanding and adherence to regulations related to grant management. Regulatory compliance starts with federal guides for Cost Principles and Auditing from the Office of Budget and Management. These regulations impact state and local government grants and sets models of best practices for foundation and other private grantors. Utilize the built-in business rules in your timekeeping software to aid with specific regulations. Features like audit logs, daily reminders, online approvals all help your organization achieve compliance.

Staying on Schedule

Being able to quickly see what is coming up or quickly see a high-level view is critical to keeping the process running smoothly. SaaS based employee scheduling solutions can be utilized to track important deadlines and send email reminders of deadlines when they are approaching. This can be a great time-saver for the person who is organizing all the elements of a grant proposal and responsible for the final submission.

Bottom Line: Hour Timesheet and Nonprofit Timekeeping

Hour Timesheet can help you with all of the above requirements for non-profit timekeeping . Call or email now to see a demo at your convenience

Employee timesheet software
Hour Tracking
Leave Management
Online approvals
Email reminders and alerts
Real-time reporting

Try Now

Start your 30-day free trail

Additional Resources

Nonprofits and Labor Laws

Managing Nonprofit Employees

Breaking down your nonprofit’s obligation to pay overtime

$8/user. NO setup Fees. NO support fees. NO contract.

Employee Leave Management

Hour Timesheet

Employee Leave Management

People are an important resource of any business. Unauthorized absenteeism, lack of proper time/holiday planning, affect the overall efficiency of any organization. Many leave related issues can be addressed by using an automated leave tracking software such as Hour Timesheet.

A uniform application of leave policies and accurately tracking leave balances, can lead to greater employee satisfaction and enables organizations to engage employees better.

A complex leave management software solution can be utilized to automate time off request as well as real-time access to paid leave such as holiday, sick, vacation or comp time. Benefits of an online leave management system include the following:

All employees are able to apply or leave request in a central location
Aids user by having online access to leave balance data and leave transactions
Communication and enforcement of all company leave policies
Enhanced manager insight - supervisors and HR manager receives email alerts when employees request and use leave
Eliminate manual calculations of leave balances and paper-based leave request.
System-managed carry-over values from year to year.
System managed ceiling for each type of leave

Implementing the right employee leave management solution will significantly reduce work by the HR team as well as well as employees. Centralized business processes will reduce the time and effort spent by HR on maintaining accurate leave records in Microsoft Excel or by hand.

Hour Timesheet Leave Management Types

Earned Leave - Leave hours are earned based on the number of hours worked on the employee timesheet.

Accrued Leave - Leave hours are accrued based on the employee's hire date. Accrual options are weekly, bi-weekly, semi-monthly and monthly.

Employee Leave Management Features

Balance is reduced after timesheet is submitted at the end of each timesheet period.
User receives error message upon entering time that exceeds current balance.
User may be allowed to “go into the negative” if feature is configured.
System will stop accruing leave once limit “ceiling” is reached.
System will reset balance to “carry-over” value each year.
Balance will reflect manual adjustments (if any).

For more information on employee leave management, visit our leave management website page or visit us in the QuickBooks marketplace listing.

Additional Resources

Ten states and Washington D.C. currently require paid sick leave
The Family and Medical Leave Act

Learn More

Newer Posts →