Note: This article covers how to automatically import invoices into QuickBooks online. If you prefer to convert the invoices to Excel first and then import them into QuickBooks, check this other article.
Do you spend a lot of time manually entering invoice data into a database or spreadsheet? There’s a better way. With DocuClipper you can quickly extract fields and line items from scanned and digital invoices and automatically export them to Excel, Google Docs and QuickBooks. Check out this short video to see how:
The first step is to create a template. Invoice templates have 2 types of data: fields and line items.
To extract data from a field click and drag to draw a box around the field. Select “Text”. And choose the field type:
Next step is to extract the line items. Click and drag to draw a box around the line items. Select “Table”. And mark the different columns:
Now that we have a template we can go ahead and extract the data:
Now every time you receive an invoice from a vendor, you can repeat these steps to get the data extracted.
Once the process is finished you can find your data in the “Data Archive”.
The invoices will be available in your QuickBooks account: