cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Lindamc1
Level 1

Is it possible to generate an unbilled charges report for an historic date eg a year end?

 
5 REPLIES 5
MariaSoledadG
QuickBooks Team

Is it possible to generate an unbilled charges report for an historic date eg a year end?

Welcome to QuickBooks, Lindamc1.

 

You'll want to run the Unbilled Charges report and customize the date for the last year. Let me guide you with the steps.

  1. Click Reports on the left menu.
  2. In the Search bar, type Unbllled Charges report.
  3. Under the Report Period, select Last Year.
  4. Click Run Report.

For future reference, you can also customize your report on how it looks like: Customise Reports in QuickBooks Online.

 

If there/s anything else you need, let us know so we can get back to you.

 

 

Lindamc1
Level 1

Is it possible to generate an unbilled charges report for an historic date eg a year end?

Sorry, I replied directly to the email and not through this link. This was my response:

 

Dear Maria,
Thank you.
 
This was this first thing I did. It merely gives me a balance of what was unbilled at the year end less what has been billed in the current year. So I have been able to reconstruct it.  Is it possible that there is a setting that needs to be adjusted?
 
Thank you for your help,
 
Linda Crisp
 
jamespaul
Moderator

Is it possible to generate an unbilled charges report for an historic date eg a year end?

Hello, Linda Crisp.

 

I appreciate your time getting back here. We're always looking to answer more questions from users. That said, I'm here to help you out with the unbilled charges report. 

 

You don't have to adjust a setting. The Unbilled Charges report gives a list of charges that weren't invoiced yet. A charge won't appear if it has been invoiced (regardless of the date and amount). 

 

Although, I'd like some clarifications on the unbilled charge report that you need. Are you trying to see the charges regardless if they are invoiced or not? You can run the Transaction List by Customer report, then filter it to show the charges. Here's how: 

 

  1. Go to Reports, then type Transaction List by Customer in the search box.
  2. Click the Customise button. 
  3. Select Last year for the Report period
  4. Expand the Filter option.
  5. Check Transaction Type, then choose Billable Expense Charge
  6. Hit Run report.

 

UnbilledExp1.PNGUnbilledExp2.PNG

 

If you want to show the detailed billed expenses, then you can run a drilled down Expenses by Supplier Summary report. Here's how: 

 

  1. Go to the Reports menu again, then search Expenses by Supplier Summary.
  2. Click the amount on the supplier to open the Transaction Report overview.
  3. Hit the Customise button.
  4. Select Last year for the Report period.
  5. Expand the Rows/Columns section, then click Change columns
  6. Check Customers.
  7. Open the Filter section.
  8. Tick Supplier and choose All.
  9. Hit Run report

 

UnbilledExp3.PNG

 

You also have the option to save the report's customised settings. This can help you pull up the same report in the future without doing the setup again. Just click on the Save customisation button, name it, then click Save.

 

You can access this by going to the Reports menu, then selecting Custom reports

 

If you need a guide on a specific task in QuickBooks Online, you can always visit our articles. You can click here to go to the general articles website. 

 

Adding more details to the report you need would definitely help us come up with a clear solution. You can always include other questions you might have regarding QuickBooks Online. 

Lindamc1
Level 1

Is it possible to generate an unbilled charges report for an historic date eg a year end?

Thank you so much for your time.

May I just tell you in more detail what report I am trying to create:

I would like to create a report that shows which unbilled charges are outstanding at the company's year end ie 31/03/2020. Charges incurred in the year are posted to Other Debtors - Disbursements and sit as an asset on the balance sheet (less invoiced items) and so the unbilled charges should agree to this figure.

In previous years I have input the 'new year's' invoices after the report was reconciled and a copy given to the accountant who signs the accounts off. This year, however, a colleague has the inputting responsibility and was very efficient in updating the records.

I have run your suggested report giving me the total incurred billable charges for the year which is useful for other things but does not answer my needs.

If it cannot be done, that's fine, I can implement a system to compensate at the next year end but if there is a way around it it would be useful as I had not appreciated that it was a 'rolling' report.  

Once again thank you for your time.

Linda

Mark_R
QuickBooks Team

Is it possible to generate an unbilled charges report for an historic date eg a year end?

Thank you for clarifying your concern, @Lindamc1.

 

At this time, there's isn't a specific report that shows which unbilled charges are outstanding at the company's year-end. As a workaround, you can run the Unbilled Charges and Transaction List by Customer report and export it to Excel. This way, you can manually compare the unbilled charges from there.

 

Firstly, you can follow the steps provided by my colleague MariaSoledadG above to run the Unbilled Charges report. On the report, click the export icon and select Export to Excel.

 

Once done, follow the steps shared by my peer jamespaul to run the Transaction List by Customer report. Then, export the report to Excel.

 

From the Excel, you can compare the billable and unbillable charges to know which charges are outstanding at the company's year-end.

 

Just in case you want to memorise reports, feel free to check out this article for more details: Memorise reports in QuickBooks Online.

 

Please let me know if you need clarification about this, or there's anything else I can do for you. I'll be standing by for your response. Have a great day and stay safe.

Need to get in touch?

Contact us