United States United Kingdom Australia Brasil Canada (English) Canada (French) France Mexico Singapore South Africa Global Ireland
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question you would like to ask our community of experts and fellow QuickBooks Accountants and SMB's? Post a question here
Nat-S
Level 1
posted
‎September 14, 2020 11:00 PM
last updated ‎September 14, 2020 6:00 AM

Billing & Reporting for Time and Materials for a Project

Hi.  I'm new to QB and I want to bill time and materials for a project.  The time has been entered on the project and I put the billable rate in ex GST.  When I do a report on the time spent in a week the amount comes up ex GST.  Is there a way for the report to show the time ex GST and with the GST amount?  I need something like this table below - 

DatesPersonRate/DayRate/HourNo. of HoursSub-totalGSTTotal
30/8/20 - 05/09/20Steve Smith$1,980$247.5012$2,970$326.70$3,296.70

 

Next, when I am invoicing time and materials, I want the time to be exclusive of GST and the expenses (imported from bank statement) to be inclusive of GST, but the GST component needs to show for the client. So I want a section of the invoice for time that is GST exclusive which shows the hours, ex GST rate and GST component that I can sub-total and then I want a section for expenses that is GST inclusive that I can also sub-total.  

 

At the moment, I will have to send two invoices - one for time and one for expenses to display them properly and I don't want to do this.

TIA

Nat

Reply
2 Comments 2
Steven_Product Champion
QuickBooks Team
QuickBooks Team
‎September 15, 2020 09:58 AM

Billing & Reporting for Time and Materials for a Project

Hi Nat-S,

 

I will go ahead and do some testing. Let me get back to your shortly with what I can find. 

 

Thanks, 

 

-Steven

Reply
Steven_Product Champion
QuickBooks Team
QuickBooks Team
‎September 15, 2020 10:24 AM

Billing & Reporting for Time and Materials for a Project

When running the report for you Project, there should be a small Gear Icon at the top right of the report which acts as a Settings tool. When selecting this icon, you will get the option to add additional columns such as Taxable Amount and Tax Amount. This would allow you to show the GST added to the report. 

 

With your second part of the question, within the invoice you can include transactions with and without GST options. When creating the invoice, the GST column for each line item you can leave blank, this can be applied even if the Invoice is Exclusive or Inclusive of GST. 

 

If you still require further assistance with the steps above please don't hesitate to reach out to our friendly staff by clicking here.

 

Thanks, 

 

-Steven

Reply
Top