Note: Ensure that you have a way to filter the invoices to those that need to be imported, a suggestion would be to post the order and then filter by that status and the date range you want. e.g. Export everything for the day or week. QuickBooks Online allows a maximum of 100 invoices and 1000 total lines at a time.


Loom video recording of this process: https://www.loom.com/share/3e6fc569d69c4839ad4645e5f282bbd7


Step 1: Export a CSV file

  • Go to Settings > Admin > Custom Export > Orders/Items 
  • In the search filters, select Order Status > Posted and Invoice Date Range
  • Select the following checkboxes and then click Export


Column CheckboxNotes
Order #
Customer Name
Payment TermsThis is not required but if mapped to payment terms in DocketManager, must be an exact name match to QBO. To ensure the name matches go to Settings > Accounting > Financial > Payment Terms.
Tax RatesThis must be filled out on all orders, it is helpful to match rates already in QBO but you can map it on the import. To customize the rate to match QBO, go to Settings > Accounting > Financial > Tax Rates.
PO NumberIf you want to include in the memo field.
Invoice DateThis is the invoice date of the order.
Invoice Due DateThis must be filled out on all orders, it can calculate off the payment terms. To set this go to Settings > Accounting > Financial > Payment Terms.
Item NameIf using as the description or service.
Item DescriptionIf using as the description.
Quantity
Item TotalThis is the price after graphics and discounts. If you want graphics separately, you must have it as a separate line in DocketManager.



Smart Lists allow you to save your search parameters for future use. Learn more about Smart Lists - Here



Step 2: Importing Invoices into QuickBooks Online


  • Select the settings gear in the top right corner
  • Under Tools Select Import Data
  • Select Invoices
  • Upload the CSV file that was exported from DocketManager
  • Map you column headings



Field NameDescription
InvoiceNoThis is the DocketManager order Number. If you use custom transaction number in QBO these will be your invoice numbers. If you don't use custom transaction numbers, this column will be ignored and the invoices will auto increment.
CustomerThis will look for an exact name match, but can create new contacts on import.
InvoiceDateThis is the DocketManager order Number. If you use custom transaction number in QBO these will be your invoice numbers. If you don't use custom transaction numbers, this column will be ignored and the invoices will auto increment.
DueDate    This must be filled out on all orders, it can calculate off the payment terms. To set this go to Settings > Accounting > Financial > Payment Terms.  
Terms    This is not required but if mapped to payment terms in DocketManager, must be an exact name match to QBO. To ensure the name matches go to Settings > Accounting > Financial > Payment Terms.
Location
Memo    Extra info like the PO Number field can be mapped here.
Item(Product/Service)This is not required but can be setup in DM as a job template, item name, etc. but there is an option to add new services on import if they don't already exist.
ItemDescription    This can be either the item name or description from DocketManager.

ItemQuantity

ItemRate    There is no field for this, not a good idea to try and fill it out.
ItemAmount
This should be Item Total, which is the price after discounts and graphics. If you want graphics to display it should be a new line item in DocketManager. 
ItemTaxCode  This must be filled out on all orders, it is helpful to match rates already in QBO but you can map it on the import. To customize the rate to match QBO, go to Settings > Accounting > Financial > Tax Rates.
ItemTaxAmountLeave blank, we don't calculate tax on a per item basis.


  • Map your tax codes



  • Proceed to confirm if ready. Will show if information is missing and needs to be fixed:


                     

     

  • Click Import



Sample Data


What the CSV looks like:



What the invoices look like in the list:



What an individual invoice looks like: