cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Munir1
Level 1

how to transfer data from POS to Quickbooks

We are using Quickbooks desktop but at the same time using POS RMS version-2. All sales transactions and inventory is recorded in POS while only bills are entered in Quickbooks. What is the appropriate method to transfer sales and inventory related transactions in Quickbooks from POS. Is this a practice in some other companies?

There are three methods in my opinion as under: 

1. Transfer data through some app or excel periodically.

2. Record all transactions in QuickBooks as well

3. Transfer sales figures in in Quickbooks through a journal entry on monthly or quarterly basis.

If I transfer sales figure through journal entry on monthly basis, what would be the journal entry i.e. which accounts to be debited and which accounts to be credited. 

2 Comments 2
4Gal
Level 11

how to transfer data from POS to Quickbooks

Prepare your 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 (one time license)

https://get.transactionpro.com/qbd

Munir uddin
Level 1

how to transfer data from POS to Quickbooks

Hi,

I am very much grateful for the guidance. I would request that the other two options, I submitted may also please be considered for your kind input.

 

Thanks

Munir

Need to get in touch?

Contact us