How to upload attachments in batch to QuickBooks Online

Overview of uploading attachments

In QuickBooks Online you can attach documents (spreadsheets, pdfs, images, etc..) to customers, items, invoices and bills, so you can keep track of additional paperwork.  With Zed Axis is it possible to upload attachments in batch to QuickBooks Online.  Before starting you need to have a file that contains the full path and file name for the attachment that you want to upload along with the name or reference number for the name or transaction you want to attach to, similar to the example below.

File PathNoteEntity TypeDoc Number
C:\Users\Public\Documents\MyAttachment1.pdfPicture of the red widgetInvoice1001
C:\Users\Public\Documents\MyAttachment2.jpgPicture of the green widgetBill38789

Attachment size must not exceed 25 mb and must be a standard file type like (doc, docx, csv, gif, jpeg, jpg, ods, pdf, png, rtf, tif, txt, xls, xlsx)

Demonstration of uploading attachments in batch



Steps to upload attachments

Follow these steps:

  1. Open Zed Axis and connect to your QuickBooks Online
  2. Browse to the file that contains the list of attachments and transactions or list items that you want to batch upload into QuickBooks Online
  3. Create a mapping in Zed Axis for the columns in your import file to the corresponding fields in QuickBooks Online
  4. Click Import and Zed Axis will batch upload the attachments into QuickBooks Online.

More help?


Where the fields appear in QuickBooks Online


Attachment to an QBO ItemItem attachment
QuickBooks Online AttachmentInvoice attachment

Detailed Description of the fields

QuickBooks Online fieldTypeDescription
File PathStr 1000Mandatory. The file path and file name of the attachment that will be uploaded to QuickBooks Online (for example C:\Users\Public\Documents\MyAttachment.pdf )
Attachment NoteStr 2000Note for the attachment or can be a standalone note for the transaction or list entity
Entity TypeEnumThe type of transaction or list that the attachment is to be attached to (possible values Invoice, Bill, Item, Customer )
Doc NumberStrThe Doc Number of the transaction that the attachment is to be attached to (not applicable if attaching to an Item or Customer)
Full NameStr The Fully Qualified Name of the Customer or Item that the attachment is to be attached to (not applicable if attaching to a transaction)


Add Feedback