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 -
Dates | Person | Rate/Day | Rate/Hour | No. of Hours | Sub-total | GST | Total |
30/8/20 - 05/09/20 | Steve Smith | $1,980 | $247.50 | 12 | $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