Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there,
When I import Sales receipt data there does not seem to be an option to import the class field. How can I get this included? I currently have to go through each sales receipt and add class information manually.
Thanks
Katie
Hi Kwarnaby,
Welcome to the Community page,
There is no way of being able to include classes in the upload, it would be a case of uploading them and going through each one manually and adding it on, we will pass this on to the developers as feedback for you on your behalf.
Prepare the 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 utilize an importer tool
https://transactionpro.grsm.io/qbo
It would be really very useful to be able to add the class to the data import. As a charity, we use classes for everything and currently the import feature is useless to us as we have to go into each transaction afterwards to add the class.
Utilize the importer I mentioned earlier as a workaround.
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.