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
WickedGreen
Level 1

Entering In Amazon Sales using Point of Sale and Premier

Hi there - Appreciate any help. 

 

I am using Point of Sale and Pro for my financial software. I am having trouble figuring out how to enter in my Amazon sales because Amazon takes the fees and shipping out of the cost of the sale. I want the fees to be shown that it is taking away from my sale but I cant enter in sale and then enter in fee separate via the financial software. So that is the road block I am running into. 

 

I know I see on YouTube people making Journal Entries but don't I have to run the sale through Point of Sale  to take the items out of my inventory..

 

I appreciate all the help with his issue and hope you have a wicked great day!! 

2 Comments 2
BlackRock-Business
Level 3

Entering In Amazon Sales using Point of Sale and Premier

I am going to tell you that the latest integration with Webgility is a solution to much of the issue here.

Webgility does the following:

  • Keeps qty's synchronized
  • Record sales into POS as a receipt
  • Sales processing pipeline with pick, pack, and ship utilities
  • Record Fee Entries from Amazon

Schedule Here for an onscreen question / answer demonstration from Webgility.

 

Thanks,

Peter E. | Point of Sale Expert

BlackRock Business | QuickBooks Advanced Solution Provider

Fiat Lux - ASIA
Level 15

Entering In Amazon Sales using Point of Sale and Premier

Prepare the Sales Receipts 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 CodeItemQuantityDescriptionPriceShippingHandlingDiscountSalesTaxDeposit ToIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100Check123  Y15/09/2020Anne's BakeryOne Harbor StreetAnytownNY12345USAAnne's BakeryOne Harbor Street AnytownNY12345USA(123) 456-7890        NonCabinets10Cabinets1000321 Checking             Non
Anne's Bakery01/09/2020100Check123  Y15/09/2020Anne's BakeryOne Harbor StreetAnytownNY12345USAAnne's BakeryOne Harbor Street AnytownNY12345USA(123) 456-7890        NonHardware10Hardware50321 Checking             Non
John's Barber Shope02/09/2020101Check89  Y15/09/2020John's Barber Shope1 Main Street AnytownNY12345USAJohn's Barber Shope1 Main Street AnytownNY12345USA(999) 888-8888        NonBlueprints1Blueprints500321 Checking             Non
Main St Bank03/09/2020102Check18  N16/09/2020Main St Bank1 State Street AnytownNY12345USAMain St Bank1 State Street AnytownNY12345USA(888) 888-8888        NonDoor1Door300201 Checking             Non
Main St Bank03/09/2020102Check18  N16/09/2020Main St Bank1 State Street AnytownNY12345USAMain St Bank1 State Street AnytownNY12345USA(888) 888-8888        NonHandles1Handle10201 Checking             Non
Main St Bank03/09/2020102Check18  N16/09/2020Main St Bank1 State Street AnytownNY12345USAMain St Bank1 State Street AnytownNY12345USA(888) 888-8888        NonHinges3Hinges5451 Checking             Non
Main St Bank03/09/2020102Check18  N16/09/2020Main St Bank1 State Street AnytownNY12345USAMain St Bank1 State Street AnytownNY12345USA(888) 888-8888        NonLock1Lock15451 Checking             Non
Main St Bank03/09/2020102Check18  N16/09/2020Main St Bank1 State Street AnytownNY12345USAMain St Bank1 State Street AnytownNY12345USA(888) 888-8888        NonPaint1Paint8451 Checking             Non
Gulf Gas Station04/09/2020103Check703  Y17/09/2020Gulf Gas Station1 North Street AnytownNY12345USAGulf Gas Station1 North Street AnytownNY12345USA(777) 777-7777        NonToilet1Toilet50451 Undeposited Funds             Non
Gulf Gas Station04/09/2020103Check703  Y17/09/2020Gulf Gas Station1 North Street AnytownNY12345USAGulf Gas Station1 North Street AnytownNY12345USA(777) 777-7777        NonPump1Pump8451 Undeposited Funds             Non
Gulf Gas Station04/09/2020103Check703  Y17/09/2020Gulf Gas Station1 North Street AnytownNY12345USAGulf Gas Station1 North Street AnytownNY12345USA(777) 777-7777        NonGasket1Gasket5451 Undeposited Funds             Non

 

then utilize one of these importer tools:

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Otherwise, you may utilize a connector to integrate Amazon and QBD/QB POS.

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

Need to get in touch?

Contact us