Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
hopeforchildrenministriesinc
Level 2

file upload integration

Has anyone found a way to do a file upload with more than the 3-4 allowed columns in Quickbooks?  I need a lot more detail than this in manually integrating my REACH application payout and donation transactions into Quickbooks.  Any help is greatly appreciated!!!  Thank you.  Paul

2 Comments 2
Nicole_N
QuickBooks Team

file upload integration

Hi there, @hopeforchildrenministriesinc

 

To upload more than 3 and 4 columns into Quickbooks, consider using a third-party integration tool or custom development to handle the additional data. QuickBooks Online has limitations on the number of columns that can be imported, so using an integration tool is the best way to achieve the level of detail you need. You can visit our QuickBooks Apps to look for an integration tool that can help you with this.

 

I can see how convenient it is for you to upload a file with more than 4 columns in QuickBooks. For now, it's best to relay your feedback to our Product Development team to improve your QuickBooks Online (QBO) experience. Here's how: 

 

  1. From the Cog Wheel, click Feedback.
  2. Provide your feedback or product suggestions.
  3. Click Next to submit.
     

To get updates about the status of your feedback, you may visit the Customer Feedback page.

 

After downloading the transactions into QuickBooks, familiarize yourself with the process of categorizing them to ensure they are allocated to the correct accounts.
 

You can always get back to us if you have follow-up questions about uploading file transactions in QBO. The Community team is always around to help.

4Gal
Level 11

file upload integration

@hopeforchildrenministriesinc 

You can prepare Sales Receipt data with the following template

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us