Skip to main content

Set Up

Set up decides how SKU.io's automatic ledger lands in your books. Read the two concept pages first to see how entries are generated and why they're grouped by sales channel. Then work through the settings under Accounting → Settings and your Xero or QuickBooks connection — account mapping, invoice numbering, tax treatment and per-channel accounts — and keep the chart of accounts reference handy for what posts where.

To…Go to…
check costs, purchase orders, receiving, and payout codes before your first entries reach your booksCheck your data before you turn on accounting
see how far your costs and month-end counts can be trusted, and rate your 3PL's recordsCheck how far your costs and counts can be trusted
have your costs checked against your supplier invoices, freight and duty bills, and countsHave your costs checked against your supplier documents
compare SKU.io's income, channels, COGS and inventory with your Xero or QuickBooks books, graded month by monthCheck your books against Xero or QuickBooks
record the counts and purchases from before you started using SKU.io, and see each month's cost of goods soldRecord your history before go-live
see how your operations become a balanced double-entry ledgerHow automatic accounting works
understand why your books show one entry per sales channelHow entries are grouped by sales channel
switch an entry type between Off, Per-document, Daily and Monthly, and choose when the change startsChange how entries are batched
see how deposits, receipts and supplier bills post, and what the clearing accounts holdHow purchases reach your books
find what each accounting setting does, including your accounting system's lock datesAccounting settings at a glance

Connect your books​

Connect Xero or QuickBooks Online, see what syncs, and line up accounts, customers and invoice fields with it. Start at Connect your books.

To…Go to…
connect Xero and line up your chart, tax rates and payment methods with itConnect Xero
connect QuickBooks Online, read its dashboard, choose what syncs, and map payment methodsConnect QuickBooks Online
see what each entry becomes in Xero or QuickBooks, and what syncs backWhat syncs to your accounting provider
choose which QuickBooks account each entry posts toMap your accounts to QuickBooks Online
link QuickBooks customers to yours, review suggested matches, and clear duplicatesMatch customers with QuickBooks
show the sales rep and PO number on QuickBooks invoicesShow the sales rep and PO number on QuickBooks invoices

Accounts and channels​

Choose the accounts and financial line types your entries post to, and split or tag them by sales channel. Start at Accounts and channels.

To…Go to…
send whole categories, brands, suppliers or product types to their own accounts with ordered rulesMap product accounts with rules
post each sales channel's sales and COGS to its own accountsUse different accounts for each sales channel
tag revenue and COGS with the sales channel using Xero tracking categories or QuickBooks classesTag entries by channel with tracking categories
create and edit the financial types on your orders' revenue and cost linesManage financial line types
look up every column of the account rules spreadsheetAccount rules import and export reference
look up the default accounts and what posts to eachChart of accounts reference

Invoices, tax, and revenue​

Set invoice numbering, decide who calculates tax, choose when revenue is recognized, and post foreign-currency bills. Start at Invoices, tax, and revenue.

To…Go to…
choose where your sales invoice numbers come fromSet your invoice numbering
decide whether SKU.io or your accounting system calculates taxChoose who calculates tax
hold revenue in Deferred Revenue until each shipment goes outRecognize revenue at fulfillment
send bills from foreign-currency suppliers to Xero or QuickBooks in the supplier's currencyPost supplier bills in their own currency
Last verified: