All Collections
QuickBooks Online
1-04 Export data into Expenses or Sales
1-04 Export data into Expenses or Sales

Datamolino supports both Purchase Invoices and Cash Receipt but also Sales Invoice data capture

Jan Korecky avatar
Written by Jan Korecky
Updated over a week ago

When you create a folder, you are prompted to connect the folder to your online accounting. If you have not done so, please connect the folder to your QuickBooks online so you can proceed with the data export.   

Export destination and document status

By default, your Folder will export the data to Purchases -  Bills (or Sales - Invoices). You can change the export destination in the document detail.

First-time export

When you export a document for the first time into QuickBooks Online, you need to pair the supplier names on the invoices with your contacts in QuickBooks Online. Datamolino remembers the pairing for future use. This is necessary, so Datamolino does not create contact duplicates in your online accounting. 

Here are the steps:

  • Under QuickBooks Contact, click 'Select contact' to pair the right contact from the dropdown

  • For any new contacts, click 'Add contact' to create them in QuickBooks directly from Datamolino.

  • To finalise the export, select the ledger account, tax code and tracking categories if you use them in your accounting.

  • Click 'Save changes'

  • After you review and select all invoice details, click 'Export' to send your data to QuickBooks company.

Datamolino will remember the 'supplier name, ledger account, tax code, tracking categories combination for the future. This means that the 'hard work' of coding invoices happens only for the first time. The next time you import invoices from the same supplier, Datamolino will automatically suggest remembered coding. You only need to quickly review the settings and adjust them where necessary.

Important Note:

  • Datamolino will export the Total of the invoice as Tax inclusive and QuickBooks calculates the tax based on the Tax Code selected in the dropdown.

  • For line items that contain only NET amounts, Datamolino exports NET as Tax exclusive and QuickBooks calculates the tax based on the Tax Code selected in the dropdown.

Individual export

You can review the invoices one by one and export them as you go. This is preferable if you suspect there could be OCR-based errors in the data due to invoice image quality. 

  • Just click on the first invoice in the invoice list, review the data in the invoice detail, adjust the coding and click export if everything is OK. 

If the document has no immediate errors, Datamolino will show you the next invoice in line that is ready for export. This is a quick way to review the invoices that you need to process and export into QuickBooks Online. (This method also works when you filter out a subset of invoices by using the search and filter function.)

Bulk export

Another option is to export multiple invoices at once. This is a good choice if you know the extracted data is correct and do not need adjustments in the figures or invoice descriptions.

Here are the steps:

  • To export all ready invoices, simply click 'Review & Export' button.

  • To export only selected invoices, click the checkboxes next to the invoices and then 'Review & Export' button.

  • In the Bulk export screen, review your invoices and adjust the coding preferences.

  • To finalise the export, click 'Export all'.

Did this answer your question?