I am importing my own custom design for invoice. Everything is fine and it maps everything accurately when I have a single line item (Qty, Product, Rate and total).
Now the thing is in many of my invoice i have more then 1 line item.
How to solve this issue. As if create 2 column for line item on my word format it will map that 2nd column with the 1st line item (Qty, rate, product) but it won't map with 2 Row items.
Please answer and resolve this issue.
I'm here to help you resolve the issues you encounter when importing your customised invoice, Muz123.
You can only have one row per line item in the invoice template. You'll want to place table fields inside the table so it won't extract the data from the first row of the field.
You may download the recommended sample file here.
Also, make sure your spreadsheet's column headings match with QuickBooks fields to ensure that it would map the 2 rows items. Please go through this article for more details: Import Custom Form Styles For Invoices Or Estimates.
For future reference, you can import multiple invoices at once so you'll be able to save time.
Please let me know how it goes with the process. I'll be around to assist you anytime as you please.
I have two tables so which separates 1st row with the 2nd row.
For each column i have defined
<Row1> <Item 1> <Qty 1> <Rate 1> <Line total 1>
I can perfectly match first row with fields define by quickbooks. But for table 2
<Row 2> < Item 2> <Qty2> <Rate2> <Line Total 2>
Its matching this 2nd item with the first item when I preview it.
Why is that so? Please help how can it be properly match with table 2 only. I have watched all links share by you still facing issue please help.
I appreciate the update that you gave, @Muz123.
To help narrow down this matter, I recommend recreating your template on a new Excel file. This is to determine if being unable to match the 2nd item is caused by a damaged Excel file. You can always utilize this link to guide you in importing templates into the system: Learn how to import and design custom form styles for your invoices or estimates in Quickbooks Onlin...
However, if doing this doesn't make a difference, I recommend contacting our Customer Care Team. They have advanced tools like the remote-viewing session that can help check your template and identify the root cause of this issue.
To contact them:
Let me know how things turn out or if there's anything else you need. Just drop a reply below. Have a great day!
Just send me a screenshot of matching row 1 and row 2 and your word docx invoice template so I can see where am I going wrong. Send me the matching for invoice having more then 1 item. Secondly the screenshot of how invoice looks afterward.
Thanks for the quick reply, @Muz123.
It's my pleasure to provide sample screenshots for your guidance in importing the invoice template in QuickBooks Online.
For invoice template:
For invoice having 1 item:
For invoice having more than 1 item:
If the issue persists after comparing the screenshots overhead, I'd suggest calling our Customer Care Team. They have tools to do screen-sharing to check your template and investigate the root cause of the problem. You can follow the steps provided by my colleague above on how to contact support.
Also, to ensure we address your concern promptly, check out our support and hours.
Additionally, visit this article about mapping the fields in your template in QBO: Uploading invoice template to QuickBooks
Let me know if you have other questions. I'm always here to help.
I can provide some information about creating a template in QuickBooks Online, @Muz123.
A video reference in creating a template in QuickBooks Online is currently unavailable. Here are some video tutorials that we have: Video tutorials for QuickBooks Online.
But it's a great idea to have such an option in QBO, so I'll take note of it. I'd also recommend you visiting our Blog to learn what new updates and features we have.
However, you can get a sample template by going to the Gear icon and selecting Custom Form Styles. Tap the New style drop-down to choose Import Style. Lastly, choose to download a sample for detailed instruction. You can also import the template that you created from here.
Check this article for more information: Customise invoices, estimates, and sales receipts in QuickBooks Online.
I'm always here if you need more help with your template and or anything else, by leaving a reply below. Have a wonderful day!
Yes, I can share with you a screenshot that matches the second item with the field. When you create an invoice that has multiple items, make sure to select the imported template to reflect them on that form. This should not extract on the first row of the field. With that, there's no need to add another table for the second item on the document.
Let's take a look at these sample screenshots. Downloaded invoice template:
Once done, open the invoice where several items are included. Click the Customise button and select the name of the imported template.
You can click the Print or preview option on the invoice to double-check the outcome. In my case, this is how it looks like:
To learn more about customizing your template, you can check this article from time to time. Also, check this one to get more details about customising sales form, and email sales forms to your customer: Send sales transaction to a customer.
Please comment below if you have other questions or still need assistance with this matter. I'm here whenever you need help. Stay safe and be well!
Just give me the Docx Template for more then 1 item. I think thats will resolve my issue. Let me see how you guys made it and where am I going.
Please give me the Docx format for 2 items set in Ms word template for invoice. Thankyou
Hello there, Muz123.
You can download the sample within your QuickBooks Online account.
Let me show you how:
You can get contact us so you can request a direct MS Word file of an invoice template. Here's the link to connect with us.
I'm just here if you have other questions. Take care!