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

[qbteachmt]

"told me to ask the Pro Advisors"

You posted under Intuit Tax Advisor. That is a tool provided by Intuit for income tax preparers to use for projections for the upcoming tax year for clients.

You seem to be lost on the internet.

You’ve come to a Peer User community for Intuit Income Tax Preparation products supporting Lacerte, ProSeries, or ProConnect Tax Online products. Please visit the QuickBooks Help site for the answer to your question.

Your sign in user info here is the same one you can use over at the QuickBooks forum.

Thanks.

[StephaniePrima]

Thank you. I tried getting into the other community but no matter how many times I signed in, it kept rejecting my login.

[qbteachmt]

It's supposed to be one Intuit ID login for everything. Perhaps you made a new one here, and that is not the one you also use for QBO, so use your QBO signin.

[StephaniePrima]

That's what was using - the Login/PW for when I sign in to QBO. The whole experience working with Intuit has been pretty frustrating.

Thank you for trying to help. I've pretty much decided what I'm going to do, as soon as I get full access to their Square account. 

Wishing you well....