Must know
- Bank your cash first. Record the cash, cheques and e-transfers you took with Record deposit on Settings > Financials > Ledgers > Deposits, so your bank account matches your statement.
- Match payouts item by item. Reports > Payments > Settlement reconciliation ties each payout to its bank deposit.
- Take your sales tax figure from Sales Tax. On Settings > Financials > Sales Tax, set the return date to the period’s last day, then click Record tax return (needs Edit financials). No journal entry is needed.
- Close the month last. Books closed through and Allocations locked through are on Settings > Financials > Closing Dates, next to the sales tax return date. Only a Financial admin changes them, with Change.
1
Bank your cash and cheques
Go to Settings > Financials > Ledgers > Deposits and click Record deposit (needs Create financials). The tab appears once your ledger has started and what you took before it is accounted for. With E-transfers go straight to your bank off (Canadian clubs, under Settings > Financials > Checkout & Taxes), recorded e-transfers wait here too. See recording a bank deposit.
2
Match your payouts
Open Reports > Payments > Settlements and set Payout date. Each payout shows Payments, Uplifter Commission, Refunds, Other Items and Net. Net Settled counts paid payouts only. To tie a deposit to your statement, use Reports > Payments > Settlement reconciliation: one block per payout, each item adding up to the deposit. See matching payouts to your bank.
3
Clear unmatched payments
Open Reports > Payments > Payment reconciliation and turn on Unallocated only to see card and Bank (ACH) payments marked Unsettled (never settled) or Missing PSP (no processor transaction). No PSP (expected) on cash, cheque and e-transfer payments needs no action.
4
Record your sales tax
Open Settings > Financials > Sales Tax. Each tax with money waiting shows what you collected and haven’t put on a return; when none has any, the page says “Nothing owing.” Click Change on the return date row (Sales tax return filed through, or GST/HST return filed through in Canadian dollars) and pick the period’s last day. It only moves later. Then click Record tax return, choose the period and fill in your return details. Use Record a payment when you pay the government and Record a refund when it pays you back. A return for a period ending after the return date is refused, so set the date first. A payment plan installment’s tax goes on the return once it is billed or past due. See recording sales tax returns.To cross-check, open Reports > Tax & receipts > Tax collection. Net Tax is Tax Collected less Credit Notes (Tax Decreases outside Canada), Bad Debt Relief and Tax Refunded. A later invoice change counts in the month you make it, so a month you filed stays put. The Tax liability tab on Settings > Financials > Checkout & Taxes shows the same Collected, plus Credited (credit notes and bad debt relief).
5
See what families owe and hold
Open Reports > Invoices > Aged receivables and set As of to the last day of the month. Balances due after that day show Not yet due, and an invoice changed since then shows the balance it had that day. When any are owed, a Credits owed to families card shows refunds from invoice changes not paid out yet. Open Reports > Payments > Account credit held that day, since it always shows today’s balances.
6
Total collections by payment method
Open Reports > Payments > Payments summary for Collected, Refunds and Net collected, plus a subtotal card per payment method.
7
Review the ledger
Open Reports > Ledger > GL by account (or General ledger) for paid-invoice revenue and your journal entries. A later invoice change counts in the month it was made: GL by account adds it to that month, and General ledger lists it as its own row. See invoice changes in your reports. Both reports leave out Uplifter’s automatic postings. For every posted entry, open Settings > Financials > Ledgers > Transactions, pick Last month in Period and click Export (up to 50,000 lines).
8
Close the month
Go to Settings > Financials > Closing Dates. Click Change on Books closed through, pick the last day of the month and click Save. The date must be before today. If entries for those days are still waiting to post, flagged for review or in an open follow-up, the dialog says so: click Wait or Close anyway. See closing dates.