Mapping Square Invoices to QBO

[StephaniePrima]

I've asked Accountant Support for help on this issue and they were unable to come up with solutions - told me to ask the Pro Advisors.

I'm doing current year clean-up in QBO for a CASH reporting non-profit Grange. Part of their member benefits is for members to sell their foods and hand-made goods at the Grange's Farmers Market booth. Some of their products are taxable, some not. The Grange charges the members a percentage of the sale, then pays them the net. But the Grange is covering the Square and Market fees and wants the sellers to cover them. Also, the Grange has never been paying sales tax, and somehow all those vendors' sales will need to be tracked in QBO, especially so they can be billed for the Sales Tax that the Grange didn't include in their vendor refund calculations. All sales are created in Square at the market, but Square has never been connected to QBO so the revenue is not recorded properly.

I will be using Dext e-commerce for the connection but need to set up the mapping. Currently in Square these 'member sellers' are listed as ITEMS and show as items on the sales receipts/invoices.  Should I set up each member/seller as a sales item in QBO? Then also set them up as vendors? Then export the item sales summary report from Square and upload to the Vendors in order to track the sales? And how would I track the portions of the Market Fees and payment processor fees for each Vendor?

What is the best way to go about this mess?

Thank you for any suggestions,

Stephanie Prima