Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
Prepare your 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 (one time license)
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
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