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

Can I download invoices into QBO with a mixed supply VAT - this gives each one a unique VAT amount. Can I add the VAT amount and not a rate?

 
3 REPLIES 3
John C
QuickBooks Team

Can I download invoices into QBO with a mixed supply VAT - this gives each one a unique VAT amount. Can I add the VAT amount and not a rate?


Hi john75

 

Are you referring to when you are adding transactions from you banking/for review page of importing them using an Excel/.CSV spreadsheet?

john75
Level 1

Can I download invoices into QBO with a mixed supply VAT - this gives each one a unique VAT amount. Can I add the VAT amount and not a rate?

Both I think. I'm trying to import from Excel our invoices for the last few months which are from our product which is a mixed supply, so no one vat rate is appropriate for these amounts. I believe I need to import the invoices without vat then do a vat only transaction to get the totals right. (Thanks to Jorge F for my online chat answer).
So I now think I can't indicate on any banking income transactions what the vat is - since QB only allows rates and not amounts.
Am I correct?

Thanks,

Anonymous
Not applicable

Can I download invoices into QBO with a mixed supply VAT - this gives each one a unique VAT amount. Can I add the VAT amount and not a rate?

Hello @john75,

 

I can provide some clarification about assigning tax amounts on the CSV file for importing invoice transactions into QuickBooks.

 

Importing data or transaction into QuickBooks requires specific file formats and headers. The placement of these headers defines a field in the company file to prevent issues during the import.

 

It also serves as a command on what information is transferred into QuickBooks. While there isn't an option to assign a VAT amount during the import, you'll have to generate the percentage manually and add it to the spreadsheet. 

 

To give you a quick peek of the import templates, check out this link: Import invoices in batches.


Please let me know if you have any other questions or need further assistance with QuickBooks. I'm here to lend you a hand anytime.

Need to get in touch?

Contact us