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.

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
| Filter | How to use it |
|---|---|
| From, To | Choose the dates of the accounting entries. Leave To blank for no end date. |
| Type | Choose a category from the table below. |
| Order ID | Enter the exact order number without #. |
| Account Code | Enter an exact account code. |
| Exclude zeros | Show 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
| Option | Entries included |
|---|---|
| All | All transaction types |
| Revenue | Revenue recognized, tax collected and price reductions |
| Receipts | Payments received and club credit applied |
| Deposits | Payment deposits and their reversals |
| Refunds | Refunds initiated and refunds withdrawn |
| Club Credit | Club credit applied, granted or reduced, and their reversals |
| Processing fees | Only Processing Fees rows from deposits and deposit reversals |
| Reversals | Every 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
| Column | What it shows |
|---|---|
| Order ID | The related order number |
| Date/time | When the accounting entry is dated |
| Item description | The item's description |
| Line item ID | The item's identifier |
| Transaction type | The event that created the entry |
| Class | The item's optional class code |
| Project | The item's optional project code |
| Account | The saved account code |
| Label | The account's purpose, such as Revenue, A/R or HST |
| Debit, Credit | The 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.
| Summary | Calculation |
|---|---|
| Revenue | Revenue credits minus Revenue debits |
| Outstanding | A/R debits minus A/R credits within the selected dates |
| Refunds | Amounts 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 column | Format or contents |
|---|---|
| Journal entry group | Group ID, including its event prefix |
| Order ID | Related order number |
| Type | Stored transaction name, such as revenue_recognized |
| Date/Time | YYYY-MM-DD HH:MM:SS in your time zone |
| Item | Item type |
| Description | Item description |
| Class | Class code |
| Project | Project code |
| Account Code | Saved accounting code |
| Account label | Account label, such as Revenue or Undeposited Funds |
| Debit | Two decimal places, no currency symbol; empty for a credit |
| Credit | Two decimal places, no currency symbol; empty for a debit |
| Paid with | Payment 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.
- Review your accounting codes and tax codes. Filled codes can't be changed later, so check them first.
- Set the filters for the entries you want to repair. The page shows how many of those entries have blank codes.
- 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.
- 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.
- 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.