Hi, Kulvir. A warm welcome to the QuickBooks Community.
Yes, if you have a downloaded spreadsheet in a CSV file format from Tide, QuickBooks Online (QBO) allows manual importing of invoices for your VAT returns. I can share the steps to achieve this.
Before we start importing, please know that we can import up to 100 invoices, with a limit of 1,000 rows per spreadsheet. It's also possible to import invoices with single or multiple line items. However, we can't add discounts, credit notes, or negative amounts.
To import these invoices with VAT to QBO, please enable VAT first. Then, ensure your spreadsheet has these required columns: Invoice number, Customer, Invoice date, Due date, Item amount, and Item tax code. After this, you can follow these steps to import the CSV file:
- Sign in to your QBO account. Then, click on the Cogwheel.
- Select Import data.
- Choose Invoices.
- Follow the on-screen instructions. Then, hit Next.
- Map all the mandatory QuickBooks fields and VAT codes.
For additional guidance, let me add this article about importing data to QBO: Common questions about importing data to QuickBooks Online.
If you're ready to receive customer payments, refer to this article: Record invoice payments in QuickBooks Online.
We'll be here in the Community if you have further questions about importing invoices to QBO. We'll do our best to assist. Take care!
