Skip to main content
Must know
  • Every money report needs the View financials permission and your club’s Reports feature.
  • Invoices imported from your previous system as paid count as collected on the Revenue tabs and Tax collection. Payments > Revenue ledger leaves previous-system payments out, and Payments summary keeps them out of Collected.
  • The Ledger reports are not your full books. They leave out what Uplifter posts automatically (sales, tax, payments, card fees, payouts, account credit). Posted balances are under Settings > Financials > Chart of Accounts; all-time totals are on Reports > Accounting.
  • Settlement reconciliation is the bank tie-out report: one block per payout, adding up to the deposit.
Where to find it. In the sidebar’s Operations tab, click Reports (under Dashboard), then pick a type. Each report is a tab across the top. Which report answers what. Revenue. Tabs: By program, By product (only when the Store feature is on), By category, Details, Monthly and By category × location. They count by invoice date; Payments summary counts by the day paid.
  • By program, By product, By category and Monthly count the share collected on paid, partly paid, overdue and partly refunded invoices. Line refunds come off. Payments carried over from your previous system count, and an invoice imported as paid counts in full. The money column is Sales.
  • By program shows Program, Season (when Seasons is on), Status, Athletes, Gross, Discounts and Sales. Category, Levels and GL Code are file only: they print in every export, not on screen.
  • Monthly shows Invoice month, Gross, Discounts and Sales.
  • Details counts every line billed, paid or not (Net billed), except voided invoices that never collected a payment. Guardian, Category, Location, Qty, Unit Price, invoice fees and GL Code are file only too. An athlete’s membership carried over from Uplifter 1.0 reads Memberships in Type when it could be matched to the membership period it paid for; any other carried-over membership line reads Other.
  • By category × location counts only invoices paid in full, at their whole value (Paid in full).
  • A sale stays in the month it was issued. A later change to an invoice counts on the day it was made, so a month you filed never moves. Details lists each change as its own row: the line’s name plus (price changed), (added), (removed), (written off) or (discount removed). See How do invoice changes show up in my money reports?.
  • A monthly charge’s tuition counts toward its program, and the Season, Category and Level filters match it.
Invoices. Tabs: Detailed, Summary, Unbalanced and Aged receivables.
  • Detailed and Summary show statuses as the Invoices page does: Overdue past your grace period, Retrying or Failed when a recurring charge couldn’t collect, Refund pending, and Processing. Their Outstanding card covers only invoices created in the dates.
  • Total Billed leaves out the unpaid amount of cancelled invoices and says so (Leaves out [amount] cancelled). Detailed adds Service Fee, Surcharge and Cancelled, not charged.
  • Both show Overpayment Returned (credit handed back after a class change or an invoice edit, not a refund) and Refunded on Previous System. On Detailed, an invoice edit’s card refund that is still on its way counts in Refunded while the invoice stays Paid.
  • Unbalanced lists invoices with an Issue of Subtotal doesn’t match lines, Total doesn’t add up (tax is left out when your club absorbs it) or Overpaid. What each issue means explains each. Payout Processing Fee is information only: it comes out of your payout, never the family’s total.
  • Paid there leaves out money an invoice change or price adjustment handed back and money kept on the invoice for the family. Refunds are not taken off.
  • Aged receivables (Billed To) sorts each open balance by days past due on the As of date: Not yet due, Current (0 to 30), 31 to 60, 61 to 90 or 90+. With As of in the past, an invoice changed later shows the balance it had that day. It leaves out a cancelled invoice, even for an earlier As of date, unless an invoice change cancelled it; that one shows the balance it had until then. A Credits owed to families card (Refunds not paid out yet) appears when it is not zero.
Payments. Tabs: Payments summary, Invoice reconciliation, Payment reconciliation, Revenue ledger, Payment allocations, Settlements, Settlement reconciliation, Gift cards, Gift card activity and Account credit held.
  • Payments summary has cards for Total payments, Payments, Account credit applied and Collected, plus From your previous system when it isn’t zero. Refunds and Net collected appear only when dates are set and no other filter narrows the list. It also shows Invoice Service Fee and Invoice Surcharge (whole-invoice figures).
  • On Payment reconciliation, only card and bank (ACH) payments should match a processor transaction; the rest show No PSP (expected).
  • Revenue ledger does not subtract refunds and leaves out payments carried over from your previous system. Each payment is split by account as its allocations recorded it when it came in, so a later invoice change never moves an earlier payment.
  • Payment allocations lists money by the item it paid for, dated the day it was assigned. Allocation date starts at the last 30 days. See payment allocation.
  • Settlements has one line per payout, with Payments, Uplifter Commission, Refunds, Other Items and Net, the deposit (payments minus commission, plus refunds and other items), then Txns and Payout Date.
  • Settlement reconciliation lists every item in each payout, with its Processing fee (percentage), Processing fee (flat), Other items, Amount due to club and Deposit. The View filter switches between Summary and Full detail, Settlement # finds one payout, and Paid out starts at the last 30 days. Export > Excel explains every line. See How do I see what’s in a payout and match it to my bank deposit?.
  • Account credit held lists each guardian holding credit today.
  • Gift cards and Gift card activity need the Gift Cards feature. See How do I use the Gift cards and Gift card activity reports?.
Ledger. General ledger lists revenue and gift card spending from invoices paid in full, which stay there after a later refund. Each refund or chargeback of a paid invoice’s line is its own row (Source of Refund or Chargeback), dated the day it settled, so the sale’s month never changes. Each later change to an invoice is its own row on the day it was made, with Source reading Correction, Write-off or Write-off reopened. Beside them are your journal entries (Manual) and gift card comps, adjustments and refunds put back on a card (Automatic). GL by account has one row per account per currency, ending in Balance. It counts each change in the month it was made and each refund in the month it settled. Picking a Location leaves out gift card spending and every Manual, Automatic and System row. Accounting. Reports > Accounting shows all-time figures from your posted books (Total revenue, Total expenses, Net position, Profit margin, Liabilities and Revenue by GL code (all time)), plus a Monthly revenue chart for this year. For a date range, use Ledger. See What does the Accounting report show?. Tax & receipts. Tabs: Tax collection and Payment receipts. Tax collection shows Month, Invoices, Tax Collected, Credit Notes (Tax Decreases outside Canada), Bad Debt Relief, Tax Refunded, Net Tax and Gross Volume by Invoice or refund date. Net Tax is Tax Collected less Credit Notes (or Tax Decreases), Bad Debt Relief and Tax Refunded. Credit Notes holds tax an invoice change took off after the sale’s own month (in that month it nets into Tax Collected). Bad Debt Relief holds the tax backed out when you write off a balance on an invoice that took money. It counts settled invoices, invoices imported as paid, and voided invoices that still hold a completed payment. It subtracts tax returned by refunds and chargebacks in the month they settled, and tax a cancellation took off uncharged. Each named tax gets a card, such as HST Net. The Credit Notes and Bad Debt Relief cards show only when not zero. If your governing body manages memberships in Uplifter. The body’s share of a membership is not your revenue or your tax:
  • The Revenue figures (Sales, Net billed, Paid in full), General ledger and GL by account leave the share out, and take it off each refunded line.
  • Revenue ledger allocates the share and the body’s service fee to Due to Governing Bodies.
  • Tax collection leaves out tax on the share and shows it on a Collected for governing bodies card: “They file it under their own registration numbers.”
  • Your own Bill the club invoice is left out of Invoices > Summary, Aged receivables, Payments summary and the Revenue reports.
Limits. A report at its limit shows This report hit its row limit. See How do I run, filter, and export business reports?. Related: Which reports are available, and what does each one show? · What does the Accounting report show? · How do I see what’s in a payout and match it to my bank deposit? · How do invoice changes show up in my money reports?