cancel
Showing results for 
Search instead for 
Did you mean: 
betsy11
Level 1

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

 
7 Comments 7
RaymondJayO
Moderator

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

I have the additional steps you can perform to eliminate the imported uninvoiced time charges in QBO, @betsy11

 

You're on the right track in reversing the journal entries. Since it doesn't work, I'd suggest deleting them. It helps you ensure your records are accurate. I'll guide you how.

  1. Go to Accounting from the left menu. 
  2. Select Chart of Accounts.
  3. Locate the appropriate account for the journal entries.
  4. Click View register from the Action column. 
  5. Find and select the journal entry. 
  6. Hit Delete.
  7. Choose Yes to confirm the deletion. 
  8. Repeat the process for other transactions. 

 

I've attached a screenshot below to show you the fifth to seventh steps. For more details, see the Delete a journal entry section through this article: Managing Journal Entries

DeleteJournalEntries.PNG

 

To help you verify if the uninvoiced time charges are eliminated, I recommend running and customizing the Journal report. Just make sure to choose Journal Entry as the Transaction Type. They are already removed from your books if you're unable to see them on the report. For more information, view the Print multiple journal entries on one report section through this article: Journal Report Overview

 

I'll be right here to help if you need further assistance. Enjoy the rest of your day, @betsy11

betsy11
Level 1

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

I don't want to remove the data from journal entry as I would like to see job costing in projects.  Also I use a portion of the information to actively invoice some customers.  BUT I would like to eliminate the uninvoiced time charges. 

Other than a journal entry, is there any other way to bring payroll information from Tsheets (where we keep track of time spent on a project) and ADP (how we run payroll) back to QBO?  For companies not using QBO for payroll, how do people accurately keep track of job costing in projects?

SarahannC
Moderator

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

Hello there, betsy11.

 

I can see how important to get job costing in projects.

 

What we can do is open the journal entry and delete the time tracking. Let's not delete the whole journal entry as we still want to get the data for the job costing. Then, add the time charges within the transactions in QuickBooks Online.

 

About adding the payroll information from Tsheets, we can add them by the time we create transactions within QuickBooks Online.

 

I'm always here if you still need help. I would like to help in making the things right in your book. Stay safe and healthy!

betsy11
Level 1

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

We just began using QBO Projects to invoice our customers.  Admittedly, we are having trouble in timing the invoices to coincide with pay periods (which is how journal entries are created).  We were slow in adapting the journal entry format to tie our outside payroll processing back to QBO.  In tying Tsheets, ADP and QBO together I create journal entries tying the labor costs to particular projects.  Once the journal entry is recorded I send timecard information from Tsheets to QBO.  Under Projects, I see the labor costs under hourly time costs and COGS -labor.  I have begun to invoice one customer in particular with this system.  The others, however, I have not been able to do so.  For those customers where I am unable to use this system,  I need to eliminate the uninvoiced time charges without losing the data from the journal entries.  

I have tried to reverse the journal entries and, in those cases, the labor charges under COGS are reversed. So presumably with reversing the journal entries, I can eliminate all labor charges under COGS.  However, those same uninvoiced time charges still remain.   If I simply delete those charges under the project will I lose the data?  Is there any other way to eliminate those uninvoiced time charges without deleting them?

GraceC
QuickBooks Team

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

Hello there, @betsy11

 

I appreciate the details you've given. Allow me to share some clarifications about this project concern. 

 

To start with, the Invoicing option that you have is just the same as the Sales menu that I have on my end. That said this doesn't impact any of the processes that we've been through.

 

Here's an article that you can check out about invoicing customers for project expenses for your future reference: Invoice customers for project expenses.

 

Reach out to me if you have any other concerns or questions. I’m more than happy to assist further.

betsy11
Level 1

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

Sorry to keep bothering you but you still have not answered my question.  I know how to use projects to send invoices.  I know how to add time charges and billable expenses to an invoice.  What I do not understand and cannot find a video to explain is exactly how to get rid of uninvoiced time charges other than simply deleting them.   Furthermore I would like to understand if I should still reverse my journal entries for the uninvoiced time to get rid of the charges under COGS...as my labor costs are now counted twice.

 

What we can do is open the journal entry and delete the time tracking. (What does the above phrase mean specifically...'delete the time tracking'?  Please give details.)  Let's not delete the whole journal entry as we still want to get the data for the job costing. Then, add the time charges within the transactions in QuickBooks Online.

 

.

 

About adding the payroll information from Tsheets, we can add them by the time we create transactions within QuickBooks Online.  What do you mean by this, specifically?  

 

Thank you for addressing the questions and issues in red.

Betsy

 

I'm always here if you still need help. I would like to help in making the things right in your book. Stay safe and healthy!

Ryan_M
QuickBooks Team

I need to eliminate uninvoiced time charges brought to QBO via journal entries from Tsheets/ADP. Reversing the journal entry doesn't work. What am I doing wrong?

Hi @betsy11,

 

I'll provide additional details to the questions you mentioned. 

 

As my colleague @RaymondJayO stated above, you'll have to delete the journal entry containing the uninvoiced time charges. You also said you didn't want to delete the whole journal entry, so my peer @SarahannC suggested to delete only the part of the journal entry that shows the uninvoiced time charges. 

 

A journal entry can contain multiple lines, so you can delete those lines that have the uninvoiced time charges. 

 

Your time activities on TSheets are automatically synced to your QuickBooks Online, and that's what the journal entry is for. 

 

In case you encounter issues or errors while exporting hours from TSheets, take a look at this article: Error exporting hours between TSheets and QuickBooks. It has a step by step guide on how you can fix the mapping of your payroll items so the export process can proceed without any issues.

 

Feel free to leave a comment below if you have other questions in mind. I'll be sure to get back to you. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up