Including employee tips collected on a sales receipt
Question asked by Felicia Hord - March 8, 2017 at 11:43 AM
We are setting up imports from our e-commerce site which also doubles as our POS system. At one location there are tips collected. The import is mapping items sold, shipping, etc just great, but TIPS are reporting in another separate column. How do I bring these in like it does shipping & tax?

2 Replies

Reply to Thread
Karen Magno Replied
March 8, 2017 at 2:00 PM
Employee Post
There is an option on the e-commerce tab that your items are in columns.  Select this option and you will have many more item fields available on the Transaction Pro Importer mapping screen.
Karen Magno
Transaction Pro for QuickBooks
Felicia Hord Replied
March 8, 2017 at 4:57 PM
I tried to be creative and get that TIPS information to import onto the sales receipt. I checked the option for 'items in multiple columns" under ecommerce options as suggested, then chose Item 2 to be the TIPS column. It created an inventory item for each value of tip (15, 3.48, 24, etc) So I then set Item 2 to be a stagnant field called TIPS which is our QB item for the tips collected and mapped the PRICE of Item # 2 to the column TIP. It pulled in the amount as the RATE but with no quantity, the net was still ZERO.
At this point I have hijacked Online Handling and I have my TIPS column mapping to that, and I edited the ITEM Online Handling to map to my Taps Payable liability GL acct.
Do you have a better solution?

Reply to Thread