How to Add Billable Time to Invoice in Quickbooks Online
Tracking billable time and adding it to customer invoices is an essential task for many service-based businesses. QuickBooks Online makes this process straightforward, allowing you to accurately bill clients for the time spent on their projects. In this comprehensive guide, we'll walk through the entire process of tracking billable time and adding it to invoices in QuickBooks Online.
Setting Up Time Tracking
Before you can start adding billable time to invoices, you need to ensure time tracking is properly set up in your QuickBooks Online account.
Enable Time Tracking
- Click the Gear icon and select "Account and Settings"
- Go to the "Time Tracking" section
- Click "Edit" in the "Time Tracking" box
- Turn on "Use time tracking"
- Check the box for "Make time billable"
- Click "Save" and then "Done"
Set Up Services
You'll want to set up service items to associate with your billable time entries:
- Go to "Sales" and click "Products and Services"
- Click "New" and select "Service"
- Enter a name for the service (e.g. "Consulting")
- Set the sales price/rate
- Check "I sell this product/service to my customers"
- Select an income account
- Click "Save and close"
Repeat this process to set up all the billable services you offer.
Set Up Employees/Contractors
Make sure all employees or contractors who will be tracking billable time are set up in QuickBooks:
- Go to "Workers" and click "Employees" or "Contractors"
- Click "New employee" or "New contractor"
- Enter their details and set their hourly cost rate
- Click "Save"
Tracking Billable Time
Now that everything is set up, you can start tracking billable time in QuickBooks Online. There are two main ways to do this:
Single Time Activity
For one-off time entries:
- Click the "+" icon and select "Single time activity"
- Select the employee/contractor
- Choose the customer and service
- Enter the date, duration, and description
- Check the "Billable" box and enter the billable rate
- Click "Save"
Weekly Timesheet
For entering time in bulk:
- Go to "Time" and click "Weekly Timesheet"
- Select the employee/contractor and week
- Enter hours worked each day, selecting the customer and service
- Check the "Billable" box for billable entries
- Click "Save"
Adding Billable Time to Invoices
Once you've tracked billable time, you can easily add it to customer invoices:
Creating a New Invoice with Billable Time
- Click the "+" icon and select "Invoice"
- Choose the customer
- If there is unbilled time, you'll see a message asking if you want to add it
- Click "Yes" to open the "Add billable time" window
- Select the time entries you want to add
- Click "Add selected items"
- The billable time will be added as line items on the invoice
- Review and edit the invoice as needed
- Click "Save and send" or "Save and close"
Adding Billable Time to an Existing Invoice
- Go to "Sales" and click "Invoices"
- Find the invoice you want to edit and click on it
- Click "Edit" in the top right
- Click "Add" in the line items section
- Select "Time" from the dropdown
- Choose the billable time entries to add
- Click "Add selected items"
- Review and save the updated invoice
Best Practices for Billable Time
To ensure accurate and efficient billing, follow these best practices:
Enter Time Promptly
Encourage employees and contractors to enter their time daily or weekly at the latest. This ensures all billable hours are captured and nothing is forgotten.
Use Detailed Descriptions
When entering time, use clear and detailed descriptions of the work performed. This provides transparency to clients and justifies the billed hours.
Review Time Before Invoicing
Before adding billable time to an invoice, review the entries for accuracy. Check that all time is accounted for and the rates are correct.
Communicate with Clients
If you're billing for a large amount of time, consider giving the client a heads up before sending the invoice. This can help avoid surprises and potential payment delays.
Set Up Time Tracking Policies
Establish clear policies for time tracking, including what is billable vs. non-billable, minimum time increments, and how to handle different types of work.
Advanced Time Tracking Features
QuickBooks Online offers some advanced features to streamline your time tracking and billing process:
Projects
For complex client engagements, use the Projects feature to organize all billable time and expenses in one place:
- Go to "Projects" and click "New project"
- Enter the project name and select the customer
- Add team members and set their billing rates
- Track time and expenses specifically for the project
- Generate project-specific reports
Classes and Locations
Use Classes and Locations to further categorize billable time:
- Enable Classes and Locations in your account settings
- When entering time, assign the appropriate class or location
- This allows for more detailed reporting and analysis of billable time
Automated Invoicing
Set up automated invoicing for recurring billable time:
- Go to "Sales" and click "Recurring Transactions"
- Click "New" and select "Invoice"
- Set up the recurring schedule and invoice details
- Choose to automatically add unbilled time
- Save the template
Time Tracking Apps
QuickBooks Online integrates with various time tracking apps like TSheets. These can offer more advanced features like GPS tracking, job costing, and mobile time entry.
Reporting on Billable Time
QuickBooks Online provides several reports to help you analyze and manage billable time:
Time Activities by Customer Detail
This report shows all time activities for each customer, including billable status and amount.
Unbilled Time
Use this report to see all unbilled time activities, helping ensure nothing slips through the cracks.
Time Cost by Employee or Vendor
This report breaks down time costs by worker, useful for analyzing profitability.
Project Profitability
For businesses using Projects, this report shows time and expenses vs. income for each project.
To access these reports:
- Go to "Reports"
- Search for the report name
- Customize the date range and other filters as needed
- Run the report
Troubleshooting Common Issues
Here are solutions to some common issues you might encounter when dealing with billable time:
Time Not Showing as Billable
- Check that the "Billable" box is checked for the time entry
- Ensure the service item is set up as billable
- Verify the employee/contractor is set up correctly
Billable Time Not Appearing on Invoice
- Make sure you're creating the invoice for the correct customer
- Check the date range of the billable time vs. the invoice date
- Verify the time hasn't already been billed on a previous invoice
Incorrect Billable Rates
- Review the rate set on the service item
- Check if a custom rate was entered on the time activity
- For projects, verify the team member's project-specific rate
Unable to Edit Billed Time
Once time has been added to an invoice, it can't be edited directly. Instead:
- Remove the time from the invoice
- Edit the original time entry
- Add the updated time back to the invoice
Conclusion
Adding billable time to invoices in QuickBooks Online is a straightforward process that can significantly streamline your billing workflow. By following the steps and best practices outlined in this guide, you can ensure accurate and timely billing for all your billable hours.
Remember to regularly review your time tracking and billing processes to identify areas for improvement. With practice, you'll develop a smooth and efficient system that keeps your cash flow healthy and your clients well-informed about the valuable time you're dedicating to their projects.
Citations: [1] https://www.dummies.com/article/technology/software/money-management-software/quickbooks/how-to-bill-for-time-in-quickbooks-2021-277688/ [2] https://quickbooks.intuit.com/learn-support/en-ca/sales-customers/how-do-i-add-time-activity-billable-time-sheet-to-existing/00/832496 [3] https://quickbooks.intuit.com/learn-support/en-us/help-article/invoicing/enter-billable-time-job-quickbooks-online/L7Rliz6dh_US_en_US [4] https://quickbooks.intuit.com/learn-support/en-us/help-article/manage-customers/create-invoice-billable-time-expenses/L7RYKgXJU_US_en_US [5] https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/how-to-put-billable-time-on-an-invoice-if-using-quickbooks-time/00/1187303 [6] https://quickbooks.intuit.com/learn-support/en-us/other-questions/new-invoice-experience-summary-bills-and-linking-time/00/1359733
Get Your Keep Card
Apply online for a Keep Business Mastercard in just 8 minutes - with approvals in 72 hours or less.