Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
We have a third party CRM system that creates invoices and then pushes them across to QBO for sending. We have a problem where the VAT is rounding up when the invoice comes across to QBO. Is there anyway we can stop this?
Many thanks,
MjM_Somerset
Hi MjM_Somerset
There is not a way to prevent the system from rounding the VAT up.
Hi,
I'm interested in know how your CRM system invoices is imported into QuickBooks.
We have recently had our CRM system and I would like to action the import above so it still generates an aged debt report as well as allowing of the information to be recorded for VAT.
Kind regards,
MM
Hi Mohini, I'm here to guide you every step of the way for an easy transaction import process.
If you have a downloaded spreadsheet in CSV format from your CRM, QuickBooks Online (QBO) allows you to manually import invoices for your VAT returns. Here are the steps to help you through the process.
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:
For additional guidance, please see this article about importing data to QBO: Common questions about importing data to QuickBooks Online.
Additionally, you can generate an accounts receivable aging report in QuickBooks Online to give you an overview of your customers' outstanding VAT. Here’s how to do that:
If you have any further questions about importing invoices to QBO, feel free to reach out to the Community. We're here to help!
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.