Skip to content
Splitfold
All guidesAccounting export

Accounting export

Turn closed months into journal lines you can import into Xero, QuickBooks Online or any double-entry ledger.

4 min readUpdated

The accounting export gives your bookkeeper one balanced journal per closed month. Splitfold does not pay anyone and does not work out tax. The journal only records what your statements already say.

Owners and editors can use it. Open Statements, pick a closed month, then choose Export → Accounting export.

What is in the journal

Every journal uses your workspace currency, the same amounts as your statements, and is dated the last day of the month. Debits always equal credits.

LineSideAccount
Gross sales, one line per storeCreditSales
Store fees, one line per storeDebitStore fees
What the store passes on after feesDebitMoney from stores
Each collaborator's shareDebitRoyalty expense
Costs a collaborator paid and got backDebitCosts paid back
What each collaborator is owed for the monthCreditRoyalties payable
Advances the house paid, recouped this monthCreditAdvances paid out

The house share has no line of its own: it stays as income. Costs the house paid and got back from sales also stay as income. Refunds can turn a line around, so a month with more refunds than sales debits Sales instead of crediting it.

Choosing the options

  • Format: Xero manual journal, QuickBooks Online journal entries, or a plain CSV for any other ledger.
  • From and To: any run of closed months, up to 24. You get one journal per month. If a month in the range is still open or closing, close it first.
  • Date format: match the date format your accounting system expects. Xero reads dates in your organisation's region format, so most organisations outside the US pick 31/12/2026. QuickBooks Online asks which format the file uses when you import it.
  • Accounts: Splitfold remembers the format, date format, tax rate and accounts you last downloaded with, in this browser. The defaults are Sales, Merchant fees, Store clearing, Royalty expense, Royalties payable, Advances to collaborators and Reimbursed costs. Change them to match your chart of accounts, and create any that are missing before you import. Your accountant can tell you which accounts to use.

Importing into Xero

  1. Choose Xero manual journal. Enter Xero account codes instead of names, and the name of a tax rate exactly as it appears in your Xero organisation. A rate with no tax is usually called Tax Exempt, No VAT (UK), BAS Excluded (Australia) or No GST (New Zealand).
  2. In Xero, go to Accounting → Manual journals → Import and upload the file.
  3. The file uses Xero's template columns: *Narration, *Date, Description, *AccountCode, *TaxRate, *Amount, TrackingName1, TrackingOption1, TrackingName2, TrackingOption2. Debits are positive amounts and credits negative. Lines with the same narration and date become one journal. The collaborator's name is in the description.
  4. Xero imports the journals as drafts. Check them, then post.

Xero does not accept its built-in Accounts Payable or bank accounts in a manual journal, so use your own liability account for Royalties payable. Xero manual journals are in your organisation's base currency only, so your Splitfold workspace currency should match it. Xero imports at most 300 lines per file; if the months you pick need more, Splitfold asks you to export fewer months at a time.

Importing into QuickBooks Online

  1. Choose QuickBooks Online journal entries.
  2. In QuickBooks, go to Settings → Import data → Journal entries and upload the file.
  3. The columns are Journal No., Journal Date, Account Name, Debits, Credits, Description, Name, Currency. Check the column matching and pick the date format you chose in Splitfold. Lines with the same journal number become one entry, such as SF-2026-09-USD. Leave Currency unmatched unless multicurrency is on in QuickBooks.
  4. QuickBooks imports fewer than 1,000 rows per file, so a file holds at most 998 lines plus the header. Turn off account numbers before importing, and turn off the duplicate journal number warning if you import the same month twice.
  5. Account names must match your chart of accounts. For a sub-account, write Parent:Sub-account. The Name column holds the collaborator; add them as vendors first if QuickBooks asks.

The plain CSV

The columns are Journal, Date, Currency, Account, Debit, Credit, Description, Name. Every journal sums to zero.

Good to know

  • Closed months never change, so exporting the same months again gives the same journal.
  • A correction made after a month closes lands in a later open month, and appears in that month's journal.
  • Each export is recorded in the activity log.
  • Xero and QuickBooks files have no byte order mark, so their importers read the first heading as written. The plain CSV keeps one so Excel opens accents correctly.
  • Cells that start with =, +, - or @ get a leading apostrophe so spreadsheets don't run them as formulas. Amounts are left as they are.

Still have a question?

We reply by email.

Email