Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHas 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
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:
To get updates about the status of your feedback, you may visit the Customer Feedback page.
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.
You can prepare Sales Receipt data with the following template
| RefNumber | Customer | TxnDate | ShipDate | ShipMethodName | TrackingNum | Location | Class | BankAccount | PaymentMethod | PaymentRefNumber | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | Currency | ExchangeRate | BillEmail | ToBePrinted | ToBeEmailed | ShipAmt | ShipItem | TipAmt | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
| 101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | ||||||||||||||||||||||
| 101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | ||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Checking | Cash | paid cash | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | [email address removed] | Y | N | Y | Handhelds | Portable Game Player | 1 | 100 | TAX |
then use an importer tool to proceed
https://get.transactionpro.com/qbo
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here