Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

How to upload the attachment to QuickBooks Online?

This is for you if you spend a lot of time importing documents into QuickBooks. Importing XLSX, CSV, DOCX, JPEG, PNG, TXT, and PDF attachments one at a time into QuickBooks is the most time-consuming and inconvenient chore for accountants and bookkeepers. Still, a key feature of Saasant Transactions can now handle it with just a zip file. The steps listed below will show you how to achieve them.


Directly uploading files as attachments in accounting platforms like Quickbooks will result in time consumption and it’s a tiring process, whereas uploading files using SaasAnt transactions will help you upload bulk or multiple files as a single entity in a zip file and save a lot of time.



Supported Transactions:


1.   Invoice

2.   Received payments

3.   Estimates

4.   Credit memos

5.   Sales receipts

6.   Refund receipts

7.   Bills

8.   Expenses

9.   Checks 

10. Vendor credits

11. Credit card credits

12. Journal Entries

13) Customers

14)  Vendors 


Supported File Formats:


Note: To add attachments you can only upload using a zip file, and the zip file should contain files within the following formats XLS, XLSX, CSV, TXT, PDF, PNG, Docx, and JPEG.


How to create Attachments:


1. Prepare an Excel file with two distinct headers: "Reference Number" and "File Name."


2. The "Reference Number" corresponds to the invoice number in your QuickBooks, while the "File Name" pertains to the attachment you intend to upload.


3. Ensure that you specify the attachment format within the Excel file (e.g., .png, .jpeg, .pdf, etc.)


4. Place the Excel file and the images within a single folder, then compress the folder into a zip file.


Download Sample Template Zip File


Steps to Import Attachment


Step 1: Log in to SaasAnt Transaction Online 


Step 2:  Select New Import.



Step 3: Select browse file and fetch your Zip file for attachment and select submit.






a.    Note: The file to be imported should exist in QuickBooks already, without the Invoice file in QuickBooks, the system will throw an error as no match transactions are available for the particular line.


b.    Note: The excel file that is attached in the Zip should possess details that match with the invoice accordingly.



Step 4: In the map attachments fields page, select QuickBooks Transaction Type and match your file header with the QuickBooks attribute.




 Step 5: Select import to QuickBooks.




Note: When the upload is complete, check the upload status and the success and error numbers.


  Step: 6 Select Show Results to navigate to the job history page and find out the detailed success and error records.




Step: 7 Check your QuickBooks account to verify the file attachment success or you can also navigate easily from the show results page by just clicking the QuickBooks ID.



Template:


Download Sample Template Zip File


Reference Number
File Name
Test 01Test01.pdf
Test 02Test02.pdf
Test 03Test03.jpeg
Test 04Test04.png
Test 05Test05.png
Test 06mapping.csv or simple_excel.csv



FAQ:


1) Can I use the same image for multiple entities in the attachments?


Ans: Yes you can use it, but you need to use the same file.


2) Can I upload files for multiple entities at the same time?


Ans: No, you cannot, you can only upload one entity at a time.


3) Why should I use the Saasant transaction attachment feature instead of the QuickBooks attachment feature?


Ans: Using the SaasAnt transactions feature will help you save enormous time by helping you upload thousands of transactions with just a single zip file, whereas using QuickBooks will result in uploading one entity at a time.


For more queries related to the Attachment feature, kindly reach out to us at support@saasant.com 


How to import Attachments into Quickbooks online using(New User Interface 2.0)


  • Create an Excel document featuring two clear headers: "Reference Number" and "File Name." Save the file as "Mapping."
  • The "Reference Number" aligns with the transaction number in your QuickBooks, while the "File Name" corresponds to the attachment you plan to upload.
  • Indicate the attachment format within the Excel file (e.g., .png, .jpeg, .pdf, .csv, .xlsx, .txt, .docx).
  • Consolidate the Excel file and attachments into a unified folder, and subsequently compress the folder into a zip file


Step 1: Log in to SaasAnt Transaction Online  


Step 2:  Select New Import. 



3)  Select Let's import 


4) Select the Other Transcation as "Attachment"



5)  Select TransactionList, or Attachment to upload your file into QuickBooks.




6) Select the files and fetch your Zip file for attachment.



a.    Note: The file to be imported should exist in QuickBooks already, without the Invoice file in QuickBooks, the system will throw an error as no match transactions are available for the particular line.


b.    Note: The excel file that is attached in the Zip should possess details that match with the invoice accordingly.



Step 7: In the map attachments fields page, select QuickBooks Transaction Type and match your file header with the QuickBooks attribute.



Note: When the upload is complete, check the upload status and the success and error numbers.


  Step: 8 Select Show Results to navigate to the job history page and find out the detailed success and error records.



Template:


Download Sample Template Zip File


Reference Number
File Name
Type
Test 01Test01.pdf
Invoice
Test 02Test02.png
Invoice
Test 03Test03.docx
Invoice
Test 04Test04.txt
Invoice
Test 05mapping.csv or simple_excel.csv
Invoice



Reference Number -  Transaction reference number (Invoice number, journal number, etc.,)


File Name: Name of the file


Type: Transaction type (  Invoice,  Received payments,  Estimates, Credit memos , Sales receipts ,  Refund receipts,  Bills , Expenses , Checks, Vendor credits , Credit card credits, Journal Entries ,  Customers , Vendors, and other transactions.)



FAQ:


1) Can I use the same image for multiple entities in the attachments?


Ans: Yes you can use it, but you need to use the same file.


2) Can I upload files for multiple entities at the same time?


Ans: No, you cannot, you can only upload one entity at a time.


3) Why should I use the SaasAnt transaction attachment feature instead of the QuickBooks attachment feature?


Ans: Using the SaasAnt transactions feature will help you save enormous time by helping you upload thousands of transactions with just a single zip file, whereas using QuickBooks will result in uploading one entity at a time.


4)  What should be the master file for the attachment?


Ans: The master file should be named exactly as mapping or simple_Excel  in the format of CSV or XLXS or Txt



For more queries related to the Attachment feature, kindly reach out to us at support@saasant.com

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.