The ticketing CSV is the starting point.
The accounting file is the handoff.

Between those two files sit the same decisions: which columns to use, how deductions are signed, where each amount belongs and which period to post it in.

Prepare the source before mapping

Use detail rows, remove subtotals and confirm that fees, refunds and payouts appear once. Choose either event-level or transaction-level detail. Mixing row types can inflate the result even when a spreadsheet formula is correct.

Save the decisions that stay the same

Column selections and account names often repeat. Connect saves them as a named mapping profile. The next upload can reuse that setup, while changes in the column layout require a fresh review.

Review the decisions that change

Posting date, accounting period, unusual adjustments and source changes still need attention. A saved profile should reduce repetition without hiding those choices.

Choose the output for the task

Event and period summaries support a general accounting handoff. Separate fee and refund files make deductions easier to review. A balanced journal CSV is available when gross, fees and refunds support the selected receivable-account treatment.

Check your accounting importer

QuickBooks, Xero and other accounting tools have their own import requirements. Match or reformat Connect’s preparation CSV for the specific importer you use. No direct posting occurs. Keep the source report and review the prepared totals before importing.

See Connect’s preparation workflow or start with a free Cash report.