United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Munir1
Level 1
posted
‎October 26, 2023 05:38 PM
last updated ‎October 26, 2023 2:38 PM

how to import sales transactions and add them into quickbooks desktop

when I import sales transactions through bank feeds and try to add it, it gives a message that there is no invoice in the name of this customer. Then How should I add this sales transaction into QuickBooks desktop.

Reply Join the conversation
2 Comments 2
JamesM4
QuickBooks Team
QuickBooks Team
‎October 26, 2023 06:10 PM

how to import sales transactions and add them into quickbooks desktop

Hello Munir1,

 

Glad to have you back in the Community. QuickBooks offers a versatile accounting program that's designed to help simplify your accounting. I'll be glad to assist and help steer you in the right direction from here. 

 

When it comes to importing data into QuickBooks, it's important make sure you adhere to the importing process. I encourage you to check out the following article that shows you how to: Import and export data in QuickBooks Desktop. 

 

You're more than welcome to ask questions as you browse through the article. I'm here to help you achieve your QuickBooks goals. 

Reply Join the conversation
4Gal
Level 11
‎October 26, 2023 09:44 PM

how to import sales transactions and add them into quickbooks desktop

@Munir1 

You can prepare your Sales Receipt data with the following template

CustomerTransaction DateRefNumberPayment MethodCheck NumberClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceDeposit ToIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000Checking             Non
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50Checking             Non
John's Barber Shope02/09/2020101Check89  Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500Checking             Non
Main St Bank03/09/2020102Check18  N#########Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonDoor1Door300Checking             Non

 

then use an importer tool to proceed. It's a one time license

https://get.transactionpro.com/qbd

 

Reply Join the conversation
Featured
Update billing, subscription and firm info in QuickBooks Online Accountant
Looking to update billing, subscription, and firm information in QuickBooks...
Read more
New ROE submission process in QuickBooks Payroll
To learn more about the new record of employment submission process in Quic...
Read more
Quick-Tips FAQ: International Payroll Week
International Payroll Week FAQ Welcome to our special "International Payrol...
Read more

Need to get in touch?

Contact us