SummitListing Engine

← Profit

QuickBooks Online: Your Reselling Sales in Your Books, Automatically

Summit already tracks your sales, fees, shipping, cost of goods and expenses on the Profit page. On the Peak plan you can connect QuickBooks Online once, and from then on Summit posts those figures into your QuickBooks company for you, sorted into the right accounts and ready to reconcile. You don't type anything in.

QuickBooks sync is new and is being turned on for Peak accounts in stages. If you don't see Connect to QuickBooks in Summit yet, it's on its way.

How the sync works

  1. Connect. Press Connect to QuickBooks and sign in at Intuit. Summit never sees your Intuit password. Only the account owner can connect.
  2. Accounts are set up for you. Summit looks at your chart of accounts once and matches what it needs to accounts you already have. Anything missing is created with an SLE · prefix so it's easy to spot, such as SLE · Reselling Sales or SLE · Marketplace Fees. You can change any of these in Summit's QuickBooks settings.
  3. Pick a start date. Summit fills in your books from that date. It starts on January 1 of this year unless you choose another.
  4. It keeps going on its own. Summit syncs once a day. A day is posted once it's at least 24 hours old, so late fees have time to settle. If you need it sooner, press Sync now.

Here is what lands in QuickBooks:

  • Sales: the item price, shipping you charged the buyer, marketplace fees, promoted listing and ad fees, and shipping labels you bought through the marketplace, each in its own account.
  • Cost of goods sold: what you paid for the items that sold, moved out of inventory. You can turn this off.
  • Refunds and returns: on the date of the refund, with the cost put back into inventory if the item came back.
  • Expenses: sourcing purchases, shipping supplies and other expenses you record on the Profit page.
  • eBay payouts: a transfer from eBay to your bank account on the payout date.

Sales tax that a marketplace collects and pays for you is left out, since it was never your money. Tax you collect yourself goes to SLE · Sales Tax Payable.

Summit never guesses. A sale or a day is posted only when every amount it needs is known. If a fee or shipping cost is still missing, it waits and shows as waiting on data. A missing amount is never posted as zero. If a figure changes later, say a late fee or a refund, Summit updates the entry it already made instead of adding a second one.

Clearing accounts, in plain English

When you sell on a marketplace, the money doesn't go straight to your bank. The marketplace holds it, takes its fees, and pays you later, often as one deposit covering many sales. If each sale were booked straight to your bank, nothing would ever match your bank statement.

A clearing account is a holding spot for money a marketplace owes you. Summit makes one per marketplace, such as SLE · eBay Clearing or SLE · Poshmark Clearing. Each sale adds what the marketplace owes you to it. When the payout reaches your bank, that money moves out of clearing and into the bank. Once everything is matched, the clearing account sits near zero. If it doesn't, a payout is still on its way or one hasn't been matched yet.

Daily Summary or Per Sale

You choose how sales appear in QuickBooks, and you can switch in Summit's QuickBooks settings:

  • Daily Summary (the default): one journal entry per marketplace per day, such as "14 sales · eBay · Nov 17". Your books stay tidy however much you sell, and it's how most marketplace accounting tools do it.
  • Per Sale: one journal entry for every order. Handy if you want to find a single sale in QuickBooks, but it gets crowded quickly. Best if you sell fewer than about 10 items a day.

Matching payouts in your bank feed

eBay: Summit posts a transfer from SLE · eBay Clearing to your bank account on each payout date. When the deposit shows up in your QuickBooks bank feed, QuickBooks suggests the match. Confirm it and you're done. This needs Summit's access to your eBay payouts; if you connected eBay before that was added, reconnect eBay in Summit's settings.

Other marketplaces: their payouts aren't available to Summit, so Summit posts nothing for them. When a deposit from one of them appears in your bank feed, match it to that marketplace's clearing account. For example, match the Poshmark deposit to SLE · Poshmark Clearing, or the Mercari deposit to SLE · Mercari Clearing.

Mileage stays in Summit

QuickBooks doesn't let other apps add mileage, so your sourcing trips stay on Summit's Profit page and appear in Summit's tax summary. They aren't sent to QuickBooks.

Estimates only, not tax advice

Summit's profit figures and tax summaries are worked out from Summit's own data, not from QuickBooks reports. They are estimates only, not tax advice. Talk to a tax professional. You are responsible for reviewing what Summit posts and for your own books; see section 10 of the Terms. What Summit stores about the connection is in the Privacy Policy.

FAQ

Which plan do I need?

The Peak plan. On Basecamp the QuickBooks card shows what it does and how to upgrade. Your sales are recorded on the Profit page either way, so nothing is lost if you connect later: the first sync can start from any date you pick.

Does Summit read my books?

Only what it needs to set up: your company name, home currency, preferences and list of accounts. It never reads your reports, bank feeds, customers or other entries.

What if a sale is missing a fee or shipping cost?

Summit waits. A sale, or a day of sales, is posted only when every amount it needs is known, and it shows as waiting on data until then. Summit never posts a missing amount as zero or guesses it.

What happens if I edit or delete an entry in QuickBooks?

Summit leaves an entry you edited alone and marks it "Edited in QuickBooks", so it never overwrites your change. If you delete one, Summit marks it deleted and offers a Re-post button.

My books are closed for last month. What happens to late changes?

QuickBooks refuses entries in a closed period, and Summit can't override that. The entry is held and Summit tells you, so you can reopen the period or post it to the first open date instead.

Can my team members connect QuickBooks?

Team members can see the sync status. Only the account owner can connect, disconnect or change account mapping.

What happens when I disconnect?

Syncing stops and Summit's access is revoked at Intuit. Everything already posted stays in QuickBooks; those are your records. Press Disconnect from QuickBooks in Summit, or disconnect from QuickBooks' own app settings.

What if I move from Peak to Basecamp?

Syncing pauses. Summit holds the connection for 90 days, so if you come back to Peak it picks up where it left off and fills the gap. After 90 days the connection is removed.

My QuickBooks company isn't in US dollars. Can I still connect?

Yes, but Summit's amounts are in US dollars, so Summit shows a notice when it connects. Check the entries with your accountant before relying on them.

Is this tax advice?

No. Summit's entries and tax summaries are estimates built from what marketplaces report and what you enter. Talk to a tax professional before you file.

See the Peak plan →