QuickBooks Online Advanced.
I would like to import excel files worth of invoice data into my QBO account. Additionally, I need to create custom data headers fields in order to map my excel data fields. A lot of the excel data headers in my invoice data files will not align to the default QBO invoice data fields.
Can someone please tell me how to import invoice data into QBO Advanced? I tried using the “Import Data” section and selecting “Invoices,” however, I get an error telling me that SalesTax is not supported and it will not allow me to continue to the import screen.
Also, can someone confirm that the “Custom Data Fields” is where I need to create the data fields to use for importing my invoice data?
I would rather not use a third party application, and I’m hopeful I can accomplish this through using the QBO platform.
What I’m Trying to Accomplish:
I am attempting to automate an invoice and commission data entry process. Today, we have an administrative assistant whose job is to input this data manually. We use this data for reporting purposes and tracking orders across our account base for historical reference. We also use this data to understand our commissions outstanding balance that our manufacturer’s owe us (we are a manufacturer’s representative agency).
I’m leas interested in accounting for these transactions from an accounting perspective, and more interested in logging sales and commissions.
Thanks for the details, Scott32.
First, the reason why you're getting an error upon importing is your Sales tax. In QuickBooks Online, importing Sales tax isn't possible.
What you're going to do is modify your CSV file and then remove the Sales tax column. Then, import your invoices again. Once the invoices were imported, you can edit it to add the Sales tax.
Next, you'll have to turn on the custom field you've created. This way, it helps you align the headers of your invoices inside QuickBooks.
Here's how to create a custom field:
To turn on this field:
Lastly, you're right about the Custom Data Field. It is where you can create the fields when importing your invoices.
This steps will help you continue your work inside QuickBooks. Have a great day!
I resolved the Invoice Import Data issue. I had to cancel my free trial and then create a new free trial. Apparently, I selected the "automate sales tax" when I created the account. Therefore, it assumed my CSV file would contain Sales Tax.
Now that I've resolved that issue, when importing my CSV file, I don't see the custom fields that I created as fields I can map my CSV headers to.
Can you please tell me how to enable my custom fields in the Invoice import process?
Allow me to join the thread and help provide additional clarification about importing invoices to QuickBooks Online (QBO).
QuickBooks set fields that you can map when importing invoices or transactions. These are the following:
As of now, you won't be able to map or enable those custom fields added, you need to track it or them manually after the importing process.
You may check this article for further details about importing invoices: Import invoices in batches.
If you have any other questions about importing custom invoice in QBO, just add a comment below. I'm always here to help.
Please, can you explain from the begining, how I can import invoice or bill (excel file) to QB online. Because when I choose "Import data", I dont have button "Invoice". I only have buttons: Bank data, Customers, Suppliers, Chat of accounts, Products and Services
Thanks for joining this thread, @Malika24.
Importing invoices by batch is only available if you're a QuickBooks Online Advanced user. If you're currently subscribed to our Simple Start, Essentials, or Plus, you can upgrade your subscription within your account:
If you wish to stay with your subscription, you'll have to enter the transactions manually.
Keep me posted if there's anything else you need or you have follow-up questions. I'm still here to help you more. Have a wonderful day.
I am using QBO and having a similar issue. We just upgraded and it says we have the ability to upload invoices. When we try it gives an error that QuickBooks does not support sales tax. We have called support with very little luck. Does this mean since we set our company up with sales tax we have no option to upload invoices? We are fine leaving it blank or 0, but we cannot even get to the upload screen or the mapping part.
Yes, you're right, Srolon. Sales tax isn't supported when importing invoices in batches. This means, you'll have to manually enter the transactions.
I'll walk you with entering invoices:
When your customer paid them already, you're now ready to receive and record the payments.
If you need anything else, we're just around to help you.
You're welcome, Srolon. I'm glad I was able to help.
Regarding your question, we're unable to recommend any third-party apps. I'd suggest exploring our website so you can choose an app which best suits your needs.
If anything arises, please don't hesitate to visit us. Have a good one!
I'm currently subscribed to QB Plus, and I want to upgrade my subscription to QuickBooks Online Advanced.
How can i do this? Because when I
We appreciate you have stated that you paid a Sterling transaction from your Euro account in Sterling however we would be grateful if you can inform us which currecny the transaction is showing as on you bank statement/banking page.
On my bank statement/banking page the transaction is showing as EURO
Thanks for your reply, I look forward to further information.