Accounting reports
Curling IO records sales, payments, refunds and deposits in a ledger you can review and export to your accounting system. Set up your accounting codes before relying on the entries.
How the ledger works
Curling IO uses accrual accounting: revenue is recorded when an order is submitted, even if the customer hasn't paid yet. The amount owed goes into accounts receivable, labelled A/R. A payment reduces A/R; it doesn't record the revenue again.
Each event creates a journal entry group with debit and credit rows. In double-entry accounting, the debits and credits in a group balance. The transaction examples show both sides. For a Premium purchase, if a code is blank, Curling IO leaves that line out, so the group won't balance. Add the missing line in your accounting system.
When entries are recorded
Curling IO records ledger entries whenever Accounting codes is on, whether or not your organization has Premium. You need Premium to view the Ledger and download its exports. Without Premium, Curling IO may remove older entries. Accounting codes is on by default for new organizations. Payout deposit entries need active Premium and Accounting codes on.
Turning Accounting codes off stops new entries and clears the codes on the Accounting Codes page after confirmation. Tax account codes and product and product type codes are kept. Existing entries keep their codes. Turning it back on doesn't normally create entries for the missing period. A later refund or scheduled-payment cancellation on an order with no entries can rebuild that order's original sale and payments, plus a deposit for each payment with a deposit date, including the fee line for Stripe deposits. See refunds and corrections.
Corrections leave a record
Corrections don't edit existing entries. A correction adds a reversal with the debit and credit sides swapped, keeping the original amount, account code and label. The reversal is dated when you make the correction. Changing a code affects later entries; it doesn't recode existing entries. Fill Blank Codes can fill missing codes on older entries.
Amounts are recorded in cents. Imported history from the previous system retains its original four-decimal amounts; exports display two decimals.
Account labels and codes
The label tells you what an entry represents. The account code connects it to your chart of accounts. Most codes come from Settings > Accounting Codes.
| Account label | Setting that supplies the code | What it records |
|---|---|---|
| Revenue | Product code, then product type code, then Product revenue | Product sales after discounts |
| Revenue | Association fee revenue | Association fees |
| Revenue | Convenience fee revenue or Late fee revenue | The corresponding fee |
| Revenue | Adjustment | Order adjustments and payment requests |
| A/R | Accounts receivable | Money owed on submitted orders |
| Tax name, such as GST, HST, PST or QST | Settings > Taxes > Tax account codes, separately for each tax | Tax collected and reductions to that tax |
| Undeposited Funds | Undeposited funds | Money received before it reaches the bank |
| Cash | Cash received | Bank deposits and refund withdrawals |
| Processing Fees | Processing fee expense | Combined Stripe fees withheld from deposits |
| Club Credit Payable | Club credit liability | Credit owed to account holders |
| Club Credit Given | Club credit expense | Credit you grant or reduce |
| Customer Deposits | Customer deposits | Payments beyond what an order owes |
| Platform Expense | Platform expense | Your organization's Premium purchase before tax |
| HST/GST Paid | Ontario HST code in Tax account codes | Tax on that Premium purchase |
| Cash/Bank | Cash received | Payment for that Premium purchase |
Older entries may use Accounts Receivable for A/R or Club Credit Expense for Club Credit Given. Those labels identify the same accounts.
Journal entry group IDs
A group ID starts with a three-letter prefix followed by its source number. Use it to follow an event through the CSV or an accounting export.
| Prefix | Event | Reversal prefix |
|---|---|---|
| REV | Revenue, one group per item | RRV |
| PMT | Payment | PVS |
| CCA | Club credit applied | CVS |
| DEP | Deposit | DVS |
| RFI | Refund initiated | RVS |
| RFW | Refund withdrawn | RWV |
| CCG | Club credit granted or reduced | CGV |
| PRD | Price reduction | PRV |
| PRE | Premium purchase |
A PRD group that cancels an unpaid remainder after a refund ends in -refund-line. A manual refund settlement group ends in -refund-replacement.
What you record elsewhere
Curling IO doesn't record tax remittances, SportsPay's separate processing-fee invoices or your other club expenses. Record those in your accounting system. Its ledger covers activity recorded by Curling IO, so it isn't your club's complete set of books.
Accounting pages
- Accounting transactions: sales, taxes, payments, deposits and club credit, with examples.
- Refunds and corrections: refunds, cancellations, reversals and payment corrections.
- Reconcile your books: compare the ledger with orders, payouts, taxes and club credit.
- Ledger: filters, summaries, CSV download and missing codes.
- QuickBooks Desktop export: download and import journal entries.
- Sage 50 export: download and import journal entries.
- Accounting codes: configure revenue, balance sheet and expense codes.
- Tax settings: configure a code for each tax.
- QuickBooks Online integration: connect QuickBooks Online.