cancel
Showing results for 
Search instead for 
Did you mean: 
pjmitchell55
Level 3

General Journal Entries - shows up as to be billed

Using QuickBooks DESKTOP - 2020 Premier Contractor Edition

 

I made a few general journal entries and they all show up in the unbilled costs by job. These are nothing we would be billing.  And the field "billable?" on the general journal entries clearly are not marked.  In fact I can't mark them even if I wanted to.

 

Why is this happening?  How can I make it so they do NOT show up as unbilled.  They will NEVER be billed.  I already have to deal with things that come through the bank feed coming through as billable even when I UNCHECK that field.  THis is just one more frustration with billable status..

 

Thank you

Solved
Best answer September 15, 2021

Best Answers
RenjolynC
QuickBooks Team

General Journal Entries - shows up as to be billed

Hello, pjmitchell55.

 

Let me help you get this sorted out.

 

I checked my test file and noticed that if you add the customer/job on each line, the General Journal will show up in the Unbilled Cost by Job report. 

 

Here are some sample screenshots for a visual reference: 

 

 

You'll want to edit the General Journal and remove the customer/job on the other lines.

 

Here's how:

 

  1. Go to Customers > Customer Center.
  2. In the Customers & Jobs tab, select the the job where the General Journal was posted.
  3. Double-click the transaction and remove the job's name from the Name column.
  4. Click Save & Close.

Otherwise, let's do the Verify and Rebuild Data. This helps identify any data damage on your company file and fix it. Before doing so, please make sure toupdate your QuickBooks Desktop to the latest release.

 

Then, follow the instructions in this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Please keep me posted on how it goes after trying out the steps above. I want to ensure your concern is resolved. Take care and stay safe.

View solution in original post

10 Comments 10
RenjolynC
QuickBooks Team

General Journal Entries - shows up as to be billed

Hello, pjmitchell55.

 

Let me help you get this sorted out.

 

I checked my test file and noticed that if you add the customer/job on each line, the General Journal will show up in the Unbilled Cost by Job report. 

 

Here are some sample screenshots for a visual reference: 

 

 

You'll want to edit the General Journal and remove the customer/job on the other lines.

 

Here's how:

 

  1. Go to Customers > Customer Center.
  2. In the Customers & Jobs tab, select the the job where the General Journal was posted.
  3. Double-click the transaction and remove the job's name from the Name column.
  4. Click Save & Close.

Otherwise, let's do the Verify and Rebuild Data. This helps identify any data damage on your company file and fix it. Before doing so, please make sure toupdate your QuickBooks Desktop to the latest release.

 

Then, follow the instructions in this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Please keep me posted on how it goes after trying out the steps above. I want to ensure your concern is resolved. Take care and stay safe.

pjmitchell55
Level 3

General Journal Entries - shows up as to be billed

Thank you. This DOES work!.  My only problem is our accountant wants EVERYTHING to be put to a class and customer. So I created a "not applicable" customer, and a "not applicable" class.  Also, this helps me easily see what is NOT assigned and correct it.

 

In the case of the several items showing up as unbilled, it was all these "not applicable' transactions.  If I remove the name and class, it doesn't show up on the unbilled but does show up on the "items not assigned to a job" or "items not assigned to a class" reports.

 

I think I will leave them as is for now. It's mostly ME that hates seeing them on the unbilled list.  

I may even see how I can re-do these entries in a way other than as a journal entry.

 

But THANK YOU, because at least I have an answer !  

 

 

AndyZ
Level 3

General Journal Entries - shows up as to be billed

This is bad advice. Removing information means that someone, sometime, will wonder what was done here and why, yet you've just removed important data.

 

The fact that these show up on an Unbilled Expenses by Job report is a bug in Quickbooks. None of mine are marked Billable, yet they show up. Instead of instructing people to mess up their recordkeeping, Intuit should be fixing the bug.

MadelynC
Moderator

General Journal Entries - shows up as to be billed

I understand how removing details can impact your recordkeeping, @AndyZ. I’m here to provide information and ensure this concern gets taken care of.


The recommendation shared by my colleague is a fix, so general journal entries won’t show in your unbilled list. You can transfer the info in the Memo or Description field to keep your transaction details intact.


If the issue persists after trying those fixes, you can contact our support team to check this further. Our representatives have enough tools to determine its cause and help find more solutions.


Here’s how:

 

  1. Open your QuickBooks Desktop account.
  2. Select QuickBooks Desktop Help.
  3. Click Contact Us.


I’ve added a reference to learn more about reports: Understand reports. It includes several articles that contain instructions to combine, modify and set report preferences.


The Community team is always here to help if you have any other questions or concerns managing your transactions. Just leave us a message. Take care!

AndyZ
Level 3

General Journal Entries - shows up as to be billed

The recommendation is not a fix. It's a kludge, i.e., a haphazard or makeshift solution to a problem and especially to a computer or programming problem. The fact that these GJEs show up as unbilled expenses is a BUG. Report it and maybe it will get fixed.

2rsDigital1
Level 2

General Journal Entries - shows up as to be billed

I have the opposite problem and this solution does not work!!! I need to use journal entries and include items that DO NEED TO BE BILLED. Even though these items are included in unbilled reports, they don't actually show up when creating customer invoices in order to add these "unbilled" expenses to invoices!

 

Intuits number 1 mistake and what will eventually be their loss against the competition is the fact that it's focus is as a computer software and not as an accounting software- every support staff at Quickbooks knows how to work the software, but not how software actions will affect accounting.

 

In the 3 years I've been using QB, I've always planned to switch away from them because they never improve their actual accounting flaws, all they do is update software with tiny features that may save time, but don't resolve problems! Like many customers, they only reason I'm still using Quickbooks is because of the nightmare it is too make the switch, but find me a company that does everything QB does but better, and I'd pay double!

GFABlind
Level 1

General Journal Entries - shows up as to be billed

Hello,

I just encountered the same problem you described and stumbled on a workaround (QB still needs to eliminate this issue, but until they do, there is this option).  Open the Journal Entry that's showing in unbilled costs by job, then (temporarily) change the account on the affected line to "Accounts Receivable" - this brings up the "Billable" check box, allowing you to UNcheck it.  Then, change the account back from "Accounts Receivable" to the original account you had for that line and save & close the journal entry.  That line will no longer be on the unbilled costs by job report.  Repeat for each affected line until the report is clear.  I hope this helps you!

AndyZ
Level 3

General Journal Entries - shows up as to be billed

Interesting. So the box actually isn't checked on my transactions. And it can't be checked. But if I changed the account used to Accounts Receivable and save it, then back to the original account, the item disappears from the report. This tells me that this is a true bug that Intuit should fix.

 

Thanks for the info. Unfortunately, I have so many of these, it would be a day's work to just fix them.

accountingMMI
Level 1

General Journal Entries - shows up as to be billed

I have the same problem with Sales Orders involving prepayments. After creating invoice via sales order screen and applying payment, it is still on my unbilled list. How can they show up unbilled if they are paid.

QB needs to correct this. 

RhoiceW
QuickBooks Team

General Journal Entries - shows up as to be billed

Thank you for participating in the thread, accountingMMI.

 

To assist you better, can I ask for further details regarding what type of report that was generated?

 

For now, kindly ensure to double-check if the payment for that invoice is fully paid. Please note that if the payment has been made partially, the invoice will not indicate as paid.

Additionally, kindly ensure that you have filtered the correct date on when the invoice prepayment was processed.

 

You can refer to these steps on how to check the payment:

 

1. Go to Customers.

2. Select Customer Center.

3. Look for the customer, then look for the invoice.

4. Check the Opening balance if how much was paid on the invoice.

 

Also, you can visit our link on how to personalize your reports in QuickBooks Desktop: Customize reports in QBDT

 

If you have more concerns about running your reports, don't hesitate to comment or reply. I'm always here to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us