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.
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.
- 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 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?.
- 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.