Solved

How do I remove a mass amount of unbilled expenses?

Forum|Forum|7 years ago
December 11, 2018
10 replies
0 views

When we buy an item from a vendor we mark the "customer" field in the bill with our customer's name. Doing so checks the box next to it saying "Billable." We didn't know what this meant, but it was automatic so we didn't think much of it. 3 years later and I have over $1,000,000 in "unbilled expense".

I know I can turn this feature off now since we don't need it, but how do I get rid of all of these unbilled expenses? Apart from clicking through every old bill and unchecking the billable box I don't know how to fix this.

The closest thread I could find is here https://community.intuit.com/questions/776246-every-bill-is-not-a-billable-expense

In it someone suggests creating an invoice for all unbilled expenses and then deleting it. Would that be okay? Would it work when the expenses are all under several hundred different customer names?

Does anyone know of a way to remove these unbilled expenses? Thank you for reading!

I am running QuickBooks: Premier Mfg + Wholesale 2013

QuickBooks Desktop

Best answer by qbteachmt

Don't "create an invoice and delete it." That's never necessary. Do it like this: Run the Unbilled Costs by Job report, and your Time by Job report for Unbilled, as well. Now, for each customer:job name, start with an Invoice. Use the Add Time & Costs icon. Here you see the pop up with likely 4 tabs. Click on Each to see all the Unbilled entries waiting. Notice the far right column = Hide? That is not really Hide. That is you, checkmarking here and that tells the Program, "Please go back to that originating transaction and Remove the billable mark for me; I didn't mean to leave it that way." Once you Hide everything on all of the tabs for this name (don't forget to Scroll), Click OK. Now, hit Clear. Now, top left, put in the Next Customer:Job and use the Add Time & Costs button. Keep doing this, and each time, that Report refreshes with fewer entries listed on it.

qbteachmtAnswer

Don't "create an invoice and delete it." That's never necessary. Do it like this: Run the Unbilled Costs by Job report, and your Time by Job report for Unbilled, as well. Now, for each customer:job name, start with an Invoice. Use the Add Time & Costs icon. Here you see the pop up with likely 4 tabs. Click on Each to see all the Unbilled entries waiting. Notice the far right column = Hide? That is not really Hide. That is you, checkmarking here and that tells the Program, "Please go back to that originating transaction and Remove the billable mark for me; I didn't mean to leave it that way." Once you Hide everything on all of the tabs for this name (don't forget to Scroll), Click OK. Now, hit Clear. Now, top left, put in the Next Customer:Job and use the Add Time & Costs button. Keep doing this, and each time, that Report refreshes with fewer entries listed on it.

A

arkvalleyinfoAuthor

Thank you. This will go a lot faster. I was not able to find a "Time by Job report for Unbilled" But I was able to generate the Unbilled Costs by Job. That one shows me bills, but it also shows me customer names. Then if I go and start the process of creating an invoice by typing in one of those customers I was able to find the "Add Time/Costs" icon and check the boxes to hide. This did remove the customer entirely from the Unbilled Costs report. Much faster than clicking through every bill. Thanks again.

qbteachmt

Timesheets are used for tracking Tasks; they can be used for making the tasks Billable or not, as well. They can be passed to Payroll to "pay from time data" for Job Tracked Costing purposes, or not. Timesheets are Not Payroll; they are simply a place to make the data entry, making that data available to Other Steps that might come later.

A

arkvalleyinfoAuthor

Thank you! That is very helpful. I just didn't want to change anything that my bookkeeper would need to use in the future.

qbteachmt

If you don't use timesheets, then you don't have to worry about finding the Unbilled Time :)

A

arkvalleyinfoAuthor

We currently have ADP doing our payroll, but we plan to start doing it in house next year. If I turn off the billable time and expenses preference will that interfere with us wanting to do payroll in-house?

A

arkvalleyinfoAuthor

Update - As of today, 6/29/18, the report for Unbilled costs by job is called "Uninvoiced Charges".

qbteachmt

In Desktop this still is Unbilled Costs by Job. Or, Unbilled time from a "Time By XX" report. I believe QB Online considers the Time to be Uninvoiced Charges. This is a Desktop topic. So, different products entirely.

M

M-BSE

I do want to point out (to the powers that be) that indication of Quickbooks types (QBD vs QBO) on the forum page can be hard to find or notice. This makes learning and participating confusing when arriving from a google search. Intuit has done a sub-par job of labeling their Help articles, too. No need to reply. Just airing frustration.

*EDIT: I finally found the tag for desktop. Organizational approach differs from prior version of forum. I would be so much more helpful if the tag/label was more visible, and just above the post title, instead of at the end of the post. That's the first and most crucial thing I need to know.

qbteachmt

Time by Job report is in Reports menu > Jobs, Time & Mileage reports. Unbilled is a Status that you need to show or filter on, to see it.

A

arkvalleyinfoAuthor

Hmm.. Yeah, I don't have that one. In fact, under the Jobs, Time & Mileage reports none of them say Time... Could be a preference that we had turned off because we don't bill by time.
I tried to get a screen shot of it, but I am not sure how to load one and photobucket is down right now. It's okay though, The Unibilled Costs report helped me well enough.

B

Baehrsden

I'm having this same problem. How or where do you change this setting?

AlcaeusF

Hello @Baehrsden, @arkvalleyinfo,

Thanks for posting here in the Community. I'm here to assist you with running the Time by Job report in QuickBooks Desktop.

You need to enable the Time Tracking feature through the Preferences window for these reports to show.

Here's how:

Click the Edit tab at the top menu bar.
Select Preferences.
Click Time & Expenses.
Go to the Company Preferences tab.
Below Do you track time?, click Yes.
Click OK.

Once done, the Time by Job reports will now show on the Jobs, Time & Mileage section.

Here's how:

Click the Reports tab at the top menu.
Select Jobs, Time & Mileage.
Click Time by Job Summary or Time by Job Detail.

I'm here anytime you have questions concerning the report. The Community team is always around whenever you need assistance.

IntuitHeidi

Hi,

If you have a lot of unbilled expenses, the best way to remove them is to go to your Dashboard. On the top of your screen where the URL is, remove "homepage", and put this in your URL after "/app/" managebillableexpense So your URL will say: c__.qbo.intuit.com/app/managebillableexpense

Then you can choose the date that you want these unbilled charges to be removed!

qbteachmt

To Clarify:

@IntuitHeidi Answered for QB Online.

This originally was a topic for Desktop. In Desktop, if you are asking about Billable, that is when you run one of the Time reports. If you have billable Items and Expenses, you see that my running the Unbilled Costs by Job report. If you have billable Mileage, these reports are in the Mileage tool and in the Jobs, Time & Mileage reports in the Reports menu.

And for All 4 tabs of Unbilled charges seen in Add Time & Costs, you simply use the HIDE column, to checkmark that you want the program to go to that source entry and remove the Billable checkmark for you. That is counter-intuitive: you checking the HIDE, which tells the program to Deselect the Billable box in the originating entry.

IntuitHeidi

Thanks- and you're right! My answer was for QuickBooks Online.

A

andreeank

https://c43.qbo.intuit.com/app/managebillableexpense

try this app for cleaning-up if using on-line version

S

scotch1973

I was looking for an answer for this everywhere and FINALLY found a solution. When we switched from desktop to online, all our inactive clients changed to active because of the old billable expenses we had been using for tracking costs related to employee hours. (I have no idea if we were supposed to do this differently, but that is what we did and had 1000+ records to change). There is a URL you can use to clear out old billable expenses but I was getting an error that "Something is not right". Thanks to a very patient QBO rep, we identified some inactive accounts we had. We activated the accounts and ran the link again and it WORKED. It hid the old billable expenses and switched most of the inactive clients back to inactive. I still have some cleaning up to do, but this was huge. Here is the link:

qbo.intuit.com/app/managebillableexpense

L

lisa1606

How do you get rid of a mass amount of unbilled expenses in QB online?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded