Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello Sue Roberts, so in the self-employed product is not linked to the invoice section. the invoice section is only for your reference only. Only the transactions in the bank section relate to any reports in the self-employed account like profit and loss or tax summary.
Hi. How do I reallocate payments received to the wrong client invoice in error?
Many thanks
Hello Gardendoctorsmike17, thanks for posting on this thread, so to reallocate the payment received to the wrong client in error, it is just a case of going into the invoice, clicking on 1 payment top right-hand corner and then clicking on the date, the received payment page will then open up, click on more at the bottom middle of the page and then select delete, this will then remove the payment from that invoice and open that invoice up again to be then matched against correctly.
Thanks for joining this thread, @Sok Kien Ng
Please check the invoice numbers on your CSV file to make sure that they are all unique. You may also try removing the line containing the 11-231002 reference to see if the file then imports successfully.
Get back to us below if this doesn't fix. :)
Hi
Trying to import an invoice for the first time. Keep getting an Unknown error for the *InvoiceNo I am importing...I'm only using numbers but it keeps being rejected....
Any ideas?
Thanks
Hi, guys! Could you please answer my question? Why my imported sales invoices are not marked as paid?
InvoiceNo | Customer | InvoiceDate | DueDate | ItemAmount | Item(Product/Service) | ItemQuantity | Service Date | Item Description |
1707725968949 | Volodymyr Radush | 2/12/24 | 2/12/24 | 122.55 | One question | 1 | 2/12/24 | Test |
This is the example of my invoice and I have always see the problem, that it is due date, or overdue. Can I somehow change to be already with paid status? Also, can I somehow avoid date format selection and make it by some default value?
Hello Radush_v, thanks for posting on this thread on the Community page, If you are importing as an invoice it will just be an open invoice, no payment will be associated with it. If you are importing sales receipts then it will show as a paid transaction.
Could you please tell me how to import sales receipts?
We're glad that you've joined the thread, @radush_v.
Let me walk you through importing sales receipts in QuickBooks Online.
QuickBooks allows users to upload multiple sales receipts together for business efficiency. With this, sales receipts should not be more than 100.
Before you get started, please remember the following:
To begin with, let's open the Import sales receipts tool. Here's how:
After that, proceed to Steps 2, 3, and 4 to complete the process: How to import sales receipts.
On the other hand, consider reviewing these resources for guidance on organizing and reviewing your transactions to keep our book accurate:
Keep us posted if you have additional questions on importing sales receipts or other related concerns in QuickBooks Online. We'll be around to help.
I have added another column on my invoice template for commodity codes which is visible when I preview the layout but when I raise a new invoice the column is not there?
I know a way we can make your custom field visible for newly created invoices in QuickBooks Online (QBO), Graham.
Custom fields are used to let you add additional details about your business or any product-specific information. On the other hand, this is used to easily track and report information that is important for the transaction.
To make it visible on the next invoice you entered, let's make sure to use or apply the same template where you added this commodity code column. Here's how:
If the field is still unavailable after following the steps above, I recommend performing browser troubleshooting steps to eliminate and address unusual behavior in QBO. To start, we can access your company file using a private window. A private window is a helpful tool for troubleshooting browser-related difficulties as it won't preserve any history. The following are the keyboard shortcuts:
After completing the task, it is recommended to clear your browser's cache or cookies to avoid similar issues in the future. Alternatively, opting for one of the browsers that are supported can also be a wise decision.
In addition, you can visit this resource to guide you in printing multiple sales forms in QuickBooks: Email or print multiple sales forms in QuickBooks Online.
If you have any queries about creating different sales transactions or anything about QuickBooks, please feel free to drop your comments below. I am always here to assist you with just a few clicks away.
Good morning Intuit
Thanks for a good article describing importing invoices from a 3rd party system.
After some testing, we ran into some issues, I hope you can help us with a few answers:
At the start of the article, you say:
Question 1:
Let's say you would like to import an invoice with two lines, a product of 1.000,- and an advance payment of 800,- (an invoice line with -800 as the amount) with an invoice sum of 200,- as the total amount, for example:
Product A 1.000,-
Advance payment -800,-
TOTAL 200,-
How can we do this if the import does not support negative numbers?
Question 2:
Let's say you import an invoice with one line, a product of 1.000,- which works fine.
Then, you need to make a credit note of -1.000,- to make the first one in a zero balance.
Finally, a new invoice with the correct amount 900,- is created and imported successfully.
How can we do this credit note of -1000 automatically using the import function when you say that "Credit notes" are not supported?
Question 3:
A separate invoice number is generated from the 3rd party system generating the invoices to be imported to Quickbooks. For example, the 3rd party system uses "[removed]", "[removed]" ... as invoice numbers. When importing these invoices, QB overrides these invoice numbers and assigns its own numbers "1435", "1436", .... To be able to keep the original invoice numbers, we add this number to the Memo field so we can see both numbers in QB.
But, is there a way to keep the initial invoice number from the 3rd party system after importing data? (Instead of getting a new number from QB?)
Question 4:
Each time you do an import, you must step through the wizard to select data format, tax options, tax code mapping, etc.
The files we receive from the 3rd party system will always have the same date format, tax options, tax codes, etc., so there is a risk of manual errors because these data need to be set each time a file is imported.
Is there a way that these options can be "hardcoded" so that the wizard does not ask for these settings every time a file is imported?
I'll shed some light on how importing invoices works in QuickBooks Online, @amundhaldorsen.
For Questions No. 1 and 2:
We can't import negative numbers since QuickBooks doesn't support it, but we can download the credit note separately and link it to QuickBooks through Receive Payment.
For Question No. 3:
Make sure to enable the custom invoice number from your settings, so that it will reflect on QuickBooks on what you enter in the spreadsheet.
For Question No. 4:
Since there is no option for it to be hardcoded, you still have the option to select the date format when you import the credit note.
For more information, you can check out this link: Limitations of importing data from third-party software to QuickBooks Online.
Moreover, you can visit this article for future reference about the common questions on importing data to QuickBooks Online: Common questions about importing data to QuickBooks Online.
If you have any questions or need assistance with managing imports in QuickBooks Online. Please don't hesitate to reach out. I'll be here to help you out.
Thanks for getting back Eman_E.
I was reading somewhere that you offer an API for integration purposes.
I guess this API also supports importing invoices as an alternative to importing files?
Does it have the same limitations due to negative numbers and credit notes?
I'm here to provide information about the API integration process, @Amund.
To help you with your concern, I'll route you to the best support available.
We have a forum called Intuit Developer where you can get an answer from one of the experts handling integration, such as API, developments, and other related concerns.
I'd suggest posting your situation on their forum, as they are the best gurus to help you with your concerns. I'd be glad to guide you on how:
Moreover, you'll want to check out this helpful article to help manage your invoices and other sales forms for future reference: Customise invoices, estimates, and sales receipts in QuickBooks Online.
Feel free to post anytime if you have questions or want to share your best practices using the product. The Community always has your back. Have a great day.
I find the quickbooks email template really unprofessional when sending my invoices to clients. Is there a way to download the invoice as a PDF and send to the client? Marking the invoice as sent once downloaded.
I don't want to send invoices via the quickbooks email
Hello DPPUK, thank you for your feedback on the email templates. We will pass that on to our product development team. In regard to downloading the invoice, if you go to the print or preview on the bottom black banner of the invoice and click it> then click download. it will give you the option to download as a pdf. You can save and close the invoice with the send later ticked (tick box under the email) so it does not send anything.
Hello I am new to Quickbooks. We have a specific way that we have numbered our invoices in our business.
NEP-ECRE8-B-240522. For tracking I will need to use this format.
I have added all invoices to the excel csv file under the correct column but getting this error message. The Item Amount contains a non-numeric value for the following invoices. Go back to your CSV file and correct the amount before trying again.
Please helpo!
Allow me to step in and help you import invoices to QuickBooks Online (QBO), Joseph.
This error could occur due to an incorrect format in the CSV file or if the template doesn't adhere to specific requirements. Please keep in mind that the maximum file size allowed is 350 KB.
If the file exceeds the limit, shorten the date range and download transactions in smaller batches. To know more about how you can check the format, check out this link: Format CSV files in Excel to get bank transactions into QuickBooks.
Additionally, missing info can be caused by several factors. We can also consider the interrupted connection. When there are connection faults during the download process, some transactions won’t be downloaded successfully. When importing transactions, there are certain factors to consider.
Check out the additional pointers below that will guide you in reformatting your CSV file:
Please know that the standard date format is dd/mm/yyyy (01/02/20). I would also recommend shortening your description so the program can easily read your bank transactions.
Once verified, you can re-import your transactions following the correct format. You can use these articles for more detailed steps in importing your transactions:
Leave a comment again if you need more help importing transactions in QBO. Thanks!
Hi. Are there any forms where the footer can be longer than 400 characters?
Let's make sure that we'll be able to bring this to our developers' attention, Gemma.
For now, you can only enter a maximum of 400 characters in the footer section. You can send a request to let our product team know how this is useful for your business. To do this, follow the steps below:
This helps improve the product experience and provides direction and clarity on how to achieve the feature.
On top of this, after you have created an invoice, learn how to record the payment to connect it to our invoice and balance your account. For more details, check out this article for reference: Record Invoice Payments in QuickBooks Online.
You can always get back to us if you need further assistance with customising sales forms. We're here to cover all your needs.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.