Skip to main content

Ledger report

Use the Ledger to review Curling IO's accounting entries and download them as a CSV. Go to Reports > Accounting > Ledger. You need Premium and permission to view financial reports. Data appears only while Accounting codes is on.

Ledger report with transaction filters, summary amounts, account codes, and balanced debit and credit rows.

The report opens from the start of your current season. To is blank, which means no end date. Review accounting codes if the rows have missing or unexpected codes.

Filter the ledger​

FilterHow to use it
From, ToChoose the dates of the accounting entries. Leave To blank for no end date.
TypeChoose a category from the table below.
Order IDEnter the exact order number without #.
Account CodeEnter an exact account code.
Exclude zerosShow only rows with an amount above zero on screen and in the download.

There is no label filter. To check one account, use Account Code or filter the CSV's Account label column in a spreadsheet.

Type filter​

OptionEntries included
AllAll transaction types
RevenueRevenue recognized, tax collected and price reductions
ReceiptsPayments received and club credit applied
DepositsPayment deposits and their reversals
RefundsRefunds initiated and refunds withdrawn
Club CreditClub credit applied, granted or reduced, and their reversals
Processing feesOnly Processing Fees rows from deposits and deposit reversals
ReversalsEvery reversal type

Use the account code or CSV label when reconciling an account across transaction types. For example, a refund to club credit credits Club Credit Payable through a refund entry.

Read the columns​

ColumnWhat it shows
Order IDThe related order number
Date/timeWhen the accounting entry is dated
Item descriptionThe item's description
Line item IDThe item's identifier
Transaction typeThe event that created the entry
ClassThe item's optional class code
ProjectThe item's optional project code
AccountThe saved account code
LabelThe account's purpose, such as Revenue, A/R or HST
Debit, CreditThe amount on that side of the entry

Each row repeats its details. The report shows 12 journal entry groups per page, newest first, so a page can contain more than 12 rows. The group ID is included in the CSV.

Account Code and Exclude zeros can hide part of a group. A filtered group may therefore appear unbalanced. See the account labels and group prefixes and transaction examples to understand the full event.

Understand the summaries​

All three summaries use every active filter and all matching rows, including rows on other pages.

SummaryCalculation
RevenueRevenue credits minus Revenue debits
OutstandingA/R debits minus A/R credits within the selected dates
RefundsAmounts refunded when initiated, less reversals; withdrawal doesn't count them a second time

Tax rows don't count toward Revenue or Outstanding. A/R entries themselves include the tax owed as part of the order total. Imported refund history from the previous system keeps its original summary calculation.

Outstanding is movement in the date range, not a closing receivable balance. To calculate a balance, set From at or before your first entry. At the bottom of the page, below the ledger entries, Totals by account shows each account code and label with debits, credits and net (debits minus credits) for all matching entries. Blank codes appear as No code, grouped by label. The total row adds all accounts. These totals follow every active filter and appear only on screen. Follow Reconcile your books.

Download the CSV​

Set the filters, then select Download below the ledger entries and above Totals by account to save accounting.csv. The file contains every matching row, oldest first, with debits before credits within a group.

The columns appear in this order:

CSV columnFormat or contents
Journal entry groupGroup ID, including its event prefix
Order IDRelated order number
TypeStored transaction name, such as revenue_recognized
Date/TimeYYYY-MM-DD HH:MM:SS in your time zone
ItemItem type
DescriptionItem description
ClassClass code
ProjectProject code
Account CodeSaved accounting code
Account labelAccount label, such as Revenue or Undeposited Funds
DebitTwo decimal places, no currency symbol; empty for a credit
CreditTwo decimal places, no currency symbol; empty for a debit
Paid withPayment method or refund destination for receipts, deposits, refunds and their reversals; empty for other entries

The CSV is still available when codes are missing. The warning says: Included ledger rows with blank account codes: {count}. CSV is still available.

QuickBooks Desktop and Sage 50 downloads are blocked while included entries have blank codes.

Fill Blank Codes​

Use this workflow to fill blank account, class and project codes on existing entries. It never changes a code that is already present. Fill applies to the entries the Ledger page's current filters select: From and To, plus Type, Order, Account Code and Exclude zeros. On the Sage 50 and QuickBooks Desktop pages it uses the dates only. Zero-value entries are included unless Exclude zeros is on. You need Premium, Accounting codes on, permission to view financial reports, permission to manage accounting settings and permission to manage order finances.

For item-linked Revenue entries, Fill uses the item's saved code, then the code on the item's current original sale, then your current settings. A sale that has been reversed is no longer the item's current sale.

  1. Review your accounting codes and tax codes. Filled codes can't be changed later, so check them first.
  2. Set the filters for the entries you want to repair. The page shows how many of those entries have blank codes.
  3. Select Fill Blank Codes, then Confirm Fill Blank Codes. You confirm once for all entries matching the filters. Fill covers the entries that exist when you confirm.
  4. Fill runs in the background and the page shows its progress, refreshed every few seconds. Leaving the page doesn't stop it; come back to check.
  5. When it finishes, the page shows how many entries were filled and how many were skipped, with the filters used. Skipped entries are listed by reason. Add the missing codes in your settings and run Fill again; it skips entries that are already filled. If an entry's code can't be determined, ask an accounting administrator to review it.

Only one Fill can run at a time for your organization, and a running Fill can't be cancelled. If accounting access is lost or an error occurs, Fill stops and keeps the entries it already filled. Run it again to continue.

Fill also saves blank codes on the purchased item, so later refunds and cancellations use those codes. It keeps any code already saved on the item.

Entries whose code can't be determined stay blank. Each filled code is recorded in history. This fills codes on entries that already exist; it doesn't create entries for unrecorded activity.