Solved

Is there an way to get an report showing unbilled items

17 replies
0 views

How can I get and report showing AP items that has not been billed ?

Right now I have been going one by one and takes too long

QuickBooks Desktop

Thanks for explaining further what you're trying to accomplish, @nnsuzuki.

Allow me to join this conversation and provide you with steps on how to pull up a report that will show the status of your COGS.

You can pull up a Journal report and filter it to you COGS transactions.

Let me guide you how:

Click on Reports at the top menu bar.
Select on Accountant and Taxes.
Click on Journal.
Select on Customize report.
Click on Filters.
Under the choose filter section, select on Transaction Type.
Choose Invoice as the transaction type.
Click on OK.
Click on Filter then select Account.
Under Account, click on All ordinary income/COGS.

I've attached some screenshots below to guide you with the steps:

Also, for more insights about transaction journal, please check out this article: View the Transaction Journal report in QuickBooks Desktop.

That should do it.

Please let me know how it goes. I'll be around if you need further assistance with pulling up reports. Have a great day!

Adrian_A

Hello there, nnsuzuki.

Yes, there's a way to pull up the unbilled AP items report, please follow these steps:

Click the Reports menu.
Choose Jobs, Time & Mileage.
Then, select Unbilled Costs by Job.

Let me know if you need anything else. Take care!

N

nnsuzukiAuthor

Thank you adrianrose

I ran that report but it was still missing all the items under cogs

some item we paid the vendor but what I need was to see which cog item

that was not billed

I went to P&L and pick and random item and did and search by the reference number which

is used for both AP and AR and only can find the invoice from the vendor, so I need to bill the customer for that charge. Is there an way to get all Cogs to see if they were billed or not. I am more interested in not billed as I feel we are missing billing our customers

S

ShangY

UPDATE- SOLVED!!!!!

I don't know whether to be embarrassed or frustrated but the answer to all my above problems: Reports have to be set to Accrual. Everything was on Cash and just not pulling info correctly.

Thank you to everyone for contributing to this post.

Thank you for sharing your update, @SunshineShull. I truly appreciate your efforts in working through this and I’m glad to hear you found the solution to your issues with the reports.

As a future resource, I recommend checking out: Export reports as Excel workbooks in QuickBooks Desktop. This guide will teach you how to take your reports out of QuickBooks and view them in Microsoft Excel whether you're using a Windows or a Mac computer.

If you have any more questions or encounter any other challenges while using the program, please feel free to reach out. My team and I are always available to assist you and would be happy to provide further support. Have a great day!

Sign up

Login with SSO

Login to the community

Login with SSO