Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.