cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Muz123
Level 2

VAT itemized Amount

HELLO,

I AM CREATING A VAT INVOICE. BUT I ALSO WANT TO SEE ITEM WISE VAT AMOUNT AS WELL.

PLEASE PROVIDE A SOLUTION.

CURRENT SCENARIO IS:

QTY RATE AMOUNT VAT%

WHAT I WANT IS

QTY      RATE    AMOUNT    (VAT% IN AMOUNT)       (TOTAL AMOUNT INCLUDING PER ITEM VAT% IN AMOUNT + AMOUNT)

4 Comments 4
RaymondJayO
Moderator

VAT itemized Amount

Thanks for posting in the Community, @Muz123

 

Currently, we're unable to rearrange the columns when creating an invoice in QuickBooks Online (QBO). I'm here to provide two workarounds to help achieve your goal. 

 

First, I'd suggest exporting the invoice to Excel so you can manually calculate the Item Wise VAT amount. Then, rearrange the columns based on your preference. I'll guide you how.

  1. Go to Sales from the left menu and select All Sales
  2. Click Filter
  3. Choose Invoices as the Type
  4. Set the Status, Date, and Customer
  5. Select Apply
  6. Click the Export icon. 
  7. Choose OK
  8. Manually calculate your Item Wise VAT amount and rearrange the columns in Excel. 

 

The screenshot below shows you the sixth to seventh steps. 

ExportTheInvoiceToExcel.PNG

 

Here's a sample screenshot of the result: 

ManuallyRearrangeColumnsInExcel.PNG

 

Second, I recommend looking for an application that's available in your region and can integrate with QBO.

 

In the meantime, you can visit this link to keep track of our product updates: Resource Centre

 

I'd suggest running any VAT reports in the program from the Reports or Taxes menu. This way, we can ensure everything is correct before paying and filing your taxes to the appropriate agencies. 

 

Don't hesitate to leave a comment below if you need anything else. We're always here to help you. Keep safe. 

Muz123
Level 2

VAT itemized Amount

Can't we right VAT Itemized amount instead of writing 20%S ?

And I can't See VAT(20%) written in grand total it only shows VAT not (20%) of the total..

Muz123
Level 2

VAT itemized Amount

I don't want to arrange the fields but I want to increase my number of columns. Include one more which shows itemized VAT amount and the total per Quantity.

JessT
Moderator

VAT itemized Amount

Hi Muz123,

 

Adding another column for the VAT amount of each line item isn't a feature right now. If you really need to show them, you can manually calculate the amounts and add them to the item description. 

 

Let me know if you have other questions.