Prepare a balanced journal without rebuilding the spreadsheet.
Connect’s generic journal CSV groups activity by event. You choose a posting date and distinct revenue, fee expense, refund / contra-revenue and ticketing receivable accounts. It produces a preparation file; it does not post to your ledger.
A simple example
For gross revenue of 1,000, fees of 50 and refunds of 100, the journal debits ticketing receivable 850, fee expense 50 and refund / contra-revenue 100, then credits ticket revenue 1,000. Signed revenue adjustments reverse the relevant debit or credit. Every event must balance.
Keep deposits separate
Source payout amounts are excluded from this journal. When a bank deposit actually occurs, your accounting workflow can move the appropriate amount from receivable to bank. Including deposits here could double count a payout. Connect does not perform that reconciliation.
QuickBooks and Xero preparation
The output columns are Journal Number, Journal Date, Account, Event, Currency, Debit, Credit and Description. This is a generic preparation schema, not a validated native QuickBooks or Xero import preset. Check your exact product, country, importer and required fields. Reformat through an approved import template or use manual journal preparation. No direct sync is available.
Accounting review is required
Check whether gross is tax-inclusive, whether ticket sales should remain deferred until the event, whether fees are expenses or net revenue adjustments, and whether reserves or chargebacks are missing. The first release does not automatically handle sales tax, deferred revenue, customer subledgers, FX or posting approvals. Use the event/fee/refund summaries when the generic journal treatment is inappropriate.