AcctApp Guides

Sales Channels & Payroll

6 topics covering sales channels & payroll in AcctApp.

Version 9.7.0

eBay - connecting your account

Settings → Sales Channels → eBay imports your eBay payouts and fees (read-only, via eBay's Finances API).

You'll need, from developer.ebay.com (Application Keys):

  • App ID (Client ID) and Cert ID (Client Secret) - use the PRODUCTION keyset for real data; Sandbox is test-only.
    • A RuName (Redirect URL name) - from the keyset's "User Tokens → Get a Token from eBay via Your Application". It's an identifier, not a secret. (Dev ID is not needed - that's only for the legacy Trading API.)

Steps: enter the App ID, Cert ID and RuName, set Environment to Production and Marketplace to your country (EBAY_AU), Save, then click Connect and sign in to eBay to authorise. Treat the Cert ID like a password - if it's ever exposed, use "Rotate (Reset) Cert ID" on the eBay site and re-enter the new one.

eBay - importing payouts & fees

Before your first import, map three accounts in the eBay settings: the Bank account the payout lands in, the eBay Fees expense account, and the eBay Sales income account. Then import payouts for a date range - each becomes a balanced journal (gross sales to income, fees to the fee account, net to the bank). Re-imports are de-duplicated. The net payout matches the single deposit on your bank statement, so it reconciles cleanly.

Other sales channels

Settings → Sales Channels connects additional selling platforms - each imports sales, fees, and settlements as balanced GL journals so they flow into your reports automatically.

Live API connections

  • Shopify - enter your store URL and API key. Imports orders, refunds, and Shopify Payments settlements. Each payout maps to a single bank deposit for easy bank reconciliation.
    • Square - imports Square Point-of-Sale transactions (those processed outside AcctApp's own POS) as GL journals. Maps to your Square Bank and Sales accounts.
    • WooCommerce - connect via your WooCommerce REST API key. Imports orders, refunds, and payment gateway fees.

CSV import (Etsy, Amazon, Lightspeed, Vend, BigCommerce, Magento, FreshBooks, Wave, and others)

For channels without a live API, export a settlement or orders CSV from your platform and import it here. AcctApp normalises the format - select your platform from the list, upload the CSV, preview the mapped journal entries, and confirm.

What each channel imports

  • Gross sales → your nominated sales income account.
    • Platform fees → your nominated fees expense account.
    • Net settlement → the bank account the payout lands in.
    • Refunds and adjustments → separate reversing lines.

De-duplication

Re-importing the same date range is safe - all channels detect already-imported records (matched by transaction ID or payout reference) and skip them automatically.

Account mapping

Set the account mapping (bank, income, fees) in the channel settings before importing. Mappings are saved per channel.

eBay - importing products to inventory

The Inventory page has an "Import from eBay" button that fetches your active eBay listings and lets you import them as stock items.

  1. Click "Import from eBay" on the Inventory page. AcctApp calls the eBay Trading API (GetSellerList) to fetch all active listings.
  2. The preview table shows each listing's SKU, title, colour, size, quantity, price, and thumbnail image.
  3. Multi-variation listings (e.g. a shirt in multiple colours and sizes) appear as a parent row with variant sub-rows.
  4. Select the listings you want to import and click "Import Selected".
  5. Imported items are created as stock items (or updated by item code if they already exist). Colour and size are extracted from eBay item aspects. Images are downloaded and saved locally.

Variation images: eBay multi-variation listings can specify a different image per colour via the VariationSpecificPictureSet element. AcctApp reads this and assigns each colour variant its own image during import - a red variant gets the red product photo, a blue variant gets the blue product photo. Size-only variants (no colour) fall back to the parent listing image. All images are downloaded locally at import time so they work offline.

Image display across the app

  • Inventory → Variants tab: each variant row shows its own thumbnail. Click Edit on a variant to see/replace the image.
  • POS (tablet and mobile): variant picker shows per-colour thumbnails when selecting a variant at the point of sale.
  • PC POS: variant selection modal shows per-variant images.

Requires an eBay connection in Settings → Sales Channels with the sell.inventory.readonly scope. Existing connections made before v6.9.0 need to re-connect to gain this scope.

eBay - scheduled product import

The "eBay Schedule" button on the Inventory page lets you set up automatic, unattended eBay imports so your stock items stay in sync without manual intervention.

Setting up a schedule

  1. Click "⏱ eBay Schedule" on the Inventory page.
  2. Tick "Enable automatic scheduled import".
  3. Choose a frequency:
    • Every hour / 4 hours / 12 hours - runs at that interval from the time you saved.
    • Daily - runs once per day at the hour you choose (e.g. 02:00 for 2 AM).
    • Weekly - runs once per week on the day and hour you choose.
  4. Click Save. The next scheduled run is shown immediately.

What the scheduled import does

All of your active eBay listings are imported - equivalent to clicking "Import from eBay" and selecting all listings. New items are created; existing items (matched by SKU) have their name, price, and images updated. Stock quantities are never changed by the import.

Run Now

Click "▶ Run Now" inside the Schedule modal to trigger a full import immediately, without waiting for the next scheduled time. The result (new items, updated items, errors) is shown inline and recorded as the last run.

Last run / Next run

The modal always shows when the import last ran and what it produced, plus when the next automatic run is scheduled.

Note: The schedule runs in the background - the Inventory page does not need to be open. The import runs as long as the AcctApp desktop application is running.

Payroll import (KeyPay / Employment Hero)

  1. Go to Settings → Payroll and connect your KeyPay or Employment Hero account (API key).
  2. Finalise the pay run as normal in KeyPay/Employment Hero - that system still owns STP, PAYG withholding and super.
  3. Back in AcctApp, open the Payroll tab to list finalised pay runs.
  4. Pick a pay run and preview the journal - lines are matched to your chart of accounts by GL code, with anything unmatched routed to a suspense account for you to reclassify.
  5. Post the journal to the GL. Re-importing the same pay run is safe - it's de-duplicated.

W1 (gross wages) and W2 (PAYG withheld) flow through to your BAS automatically once posted.

Can't find what you need? Submit a support request and we will answer it, then add it here.