Money reports
Day sheet and takings, aged debt, income, patient accounts, payment allocations and their totals, invoice timeline, production and goals, collections, associate pay and its statements, chair utilisation, sundries and invoices — every figure read from the patient ledger.
Open Reports and pick a report under Money. Every money figure comes from the patient ledger in the practice's currency, by the entry's date in the practice's own time zone. Nothing is estimated.
A period you have already reported never changes afterwards. A charge, payment or refund counts in the window it was posted in, and reversing it later posts the correction on the day the correction was made — so last month reads as it did when you closed it, and this month carries the correcting movement. The exception is a figure that answers what is owed now: aged debt, and the outstanding column of associate pay, read the live ledger, where an entry and its reversal cancel out.
A practitioner filter narrows charges only — a payment carries no practitioner — so the cash side of a filtered report stays whole.
If your practice is connected to Open Dental, its money is copied into the patient ledger (see Open Dental's money in Smileline), so these reports read it from there like any other ledger entry. Until the first copy has ended, Day sheet & takings, Aged debt, Income, Patient accounts, Invoices, Invoice timeline, Payment allocations, Payment allocation totals, Monthly accounts, Production, Collections and Associate pay say above their figures Smileline is still bringing in payments and balances from your practice system, so these figures aren't complete yet. The line goes once the first copy has ended, and patients added in Open Dental after that don't bring it back. Sundries reads none of it: a charge copied from Open Dental is never a sundry.
Day sheet & takings
By ledger entry date, counting what was posted in the window; a reversal made later shows on its own day. Production is the charges raised, Takings the payments received, Refunds what went back, and Net collected the difference. Discounts & write-offs are the credit adjustments given; Debit adjustments the charges added by adjustment. Refunds and discounts going up show in red.
The chart is Net takings, running total: what you've collected so far, day by day, with the period before as a dashed line. The line above it says how far ahead or behind you are compared with the same day of the period before: on the 10th day of a 30-day window, the first 10 days against the first 10 days of the 30 before. A window longer than 400 days is drawn by week or month instead, and the line then compares with the whole period before. The tables split takings by payment method and everything by location. If your practice is connected to Dentally, a payment synced from Dentally counts under the method Dentally recorded — Stripe, Online Payment, BACS and the rest — as Dentally's Takings report shows them. A correction counts under the method of the payment it corrects, and a deposit taken online through Smileline counts, once it's in Dentally, under the card Dentally holds it as.
Aged debt
A point-in-time report — the date filter does not apply. Every account with money owing is listed with its balance aged from each charge's entry date into 0–30, 31–60, 61–90 and over 90 days. A payment settles the oldest charges first, so an account's oldest bands clear before its newest. Unallocated credit is money on account not yet applied to a charge. A reversed charge is no longer owed, so it drops out of the ageing.
Income
What the practice earned by treatment. Invoiced items lists each treatment code with how many were charged and their total, largest first; Unallocated payments counts the payments taken in the window that are still allocated to nothing, and what they hold.
If your practice is connected to Dentally, a patient Dentally holds is read the way Dentally's Income report reads by default: the items of the invoices paid in full in the window, leaving out sundries and £0 items. Everyone else is read from the Smileline ledger, by the day each treatment was charged — a Smileline invoice has no single day it was paid.
Patient accounts
A point-in-time report — the date filter does not apply. Every patient account that owes the practice, or holds credit for the patient, is listed with its balance, largest debt first, and the private and NHS treatment still planned on it. The tiles count the accounts in debit and in credit and add up what each side comes to.
If your practice is connected to Dentally, an account Dentally holds shows Dentally's own balance, read once a day — the figure Dentally's Patient Accounts report shows. An account Dentally no longer lists in debit or in credit holds nothing. Every other account shows its Smileline ledger balance, so a patient is never counted twice. The Balance from column says which.
If your practice is connected to Open Dental, every account is the patient's own Smileline ledger balance, copied from Open Dental, and the list has two more columns:
- Billed to names the guarantor when Open Dental bills the patient's account to someone else. It is empty when the patient is billed themselves. A guarantor who has been erased reads Erased patient, and one Smileline holds no patient for reads Not linked to a Smileline patient.
- Figures as of is when Smileline last read that patient's account in Open Dental, in the practice's time zone. It is empty until the account has been read once.
To see one side only, add the Account filter and pick In debit or In credit, as you would in Dentally. The tiles, the rows and their totals all follow it.
Production
Charges raised over time by source — procedures, NHS courses of treatment (UK), memberships, retail, manual, stamp duty (Italy) and imported — and per practitioner and location, with tax shown separately. The chart shows each source that has charges in the window, so its bars add up to the production total. The average charge is production divided by the number of charges. Production counts the charges posted in the window; a charge reversed later comes off on the day of the reversal, and the charge count moves with it.
Goals
With production goals set, Production shows the goal for the window beside the figure:
- With no site filter, Goal is the practice's goal, and the By practitioner table gains each clinician's Goal. A clinician with a goal and nothing charged in the window still has a row.
- Filtered to exactly one site, Goal is that site's goal, and there are no clinician goals.
- Filtered to several sites, there is no goal. Filtered to clinicians, there is no practice goal — the figure is no longer the practice's — and only those clinicians' goals show.
A goal for part of a month is pro-rated by days: ten days of a 31-day month take ten thirty-firsts of its goal. When the window runs past today — This month, for example — Goal to date shows the same goal through today, so you can see whether you're on pace. A practice goal is never the total of the clinicians' goals.
Collections
Cash in and refunds out by payment method and source. The collection rate is net cash divided by the production raised in the same window; a window with no production shows no rate rather than a misleading one. Cash counts on the day it was taken; reversing a payment later takes it back off on the day of the reversal.
Associate pay
Per practitioner: the production they raised in the window (by charge entry date), the cash allocated to their charges in the window (by allocation date, less what refunds took back from those charges, on the refund's day) and what is still outstanding on their charges. Production and cash count what was posted in the window, and a later reversal lands on its own day; the outstanding column is today's figure, so a reversed charge drops out of it. These are gross figures. For pay worked out from each clinician's contract, use the statements below.
Associate pay statements
Owners and managers open Payments, then Month end › Associate pay statements. A statement works out a clinician's pay for a month from their contract. Smileline doesn't pay anyone and posts nothing to the ledger: you pay the clinician as you do today.
Contracts. Under Contracts, set a clinician's terms from a month: Production or Collections, the Percentage, and the Lab fee share (%) taken off their pay. Terms apply at every site from the 1st of the month you choose until a later contract, and earlier months keep theirs. To change terms, save a new contract from a later month. A contract entered by mistake is withdrawn with Retire and a reason; the month then uses the clinician's previous contract.
What a statement pays on. Under Statements, pick the month and open a clinician:
- Production: private treatment the clinician charged in the month, net of VAT, less the discounts and write-offs given against their treatment in the month and the share of refunds that came off the payments for it, in the month of the refund. A charge reversed later comes off in the month of the reversal, less anything a refund already took off, so nothing comes off twice; reversing the refund instead gives its share back in the month of that reversal.
- Collections: payments and insurance payments applied to the clinician's private treatment in the month, net of VAT. A part payment counts its share of the VAT: two £60 payments on a £120 treatment holding £20 VAT count £50 each. A refund takes back the refunded payment's share — first from what the payment hadn't yet paid towards any charge, then from each charge it paid, in proportion — in the month of the refund, and never more than the payment brought in for that charge. Reversing a refund gives its money back to the payment: it counts again once it is paying the clinician's treatment. A payment taken ahead for a treatment plan counts as that payment when it pays the plan's treatment, also after the patient moved to a family account and the payment moved with them.
- Lab fees: cases sent in the month for the clinician's treatment, cancelled cases left out, at the contract's lab fee share.
- Adjustments: lines you add to the month with Add an adjustment (a negative amount takes off). You can remove one until a statement that includes it is approved. If an adjustment, approval or contract isn't confirmed because the connection dropped, its details stay as entered: Retry sends it again exactly as it was and never saves it twice, and Discard drops it.
Pay is the basis times the percentage, less the lab fees times the lab fee share, plus the adjustments, each step rounded to the penny.
These are listed on the statement and never paid on: Other charges (NHS courses, memberships, manual charges and goods on retail codes), Tax unknown (charges whose treatment has no tax rate at their site, posted with no VAT — they count once corrected), Settled by credit (on collections: discounts, write-offs and credit moved from another account) and Moved to another account (on collections: what was still owed on the clinician's treatment when the patient's account closed and its balance moved).
Click a line type to see its lines, a page at a time with Load more: each names its charge, payment, refund, lab case or adjustment, and the patient for people who may see patients. Opening lab fee lines records that you looked at those patients' records.
Not attributed to a clinician, under the month's statements, lists money no statement carries, for you to review: payments against balances moved from a closed account (the moved balance names no clinician), lab fees on cases that name no clinician's treatment, and refunds that name no payment. If one belongs to a clinician, add it to their month as an adjustment.
Approving. Once the month has ended, open the statement, click Approve and confirm. Approving freezes every line and figure exactly as shown, with the contract's terms. If the statement or the contract in force changed while you were looking — or while it was being approved — you're asked to check it again first.
Corrections land in the month you make them, so an approved month normally stays as it was approved. When something does change it — the practice system reverses a charge dated in that month, a lab fee is edited after the case was sent, an adjustment is added, or a contract is retired or added — the statement shows Changed since approval, with the approved and current pay and what moved. Approve it again with a reason to record a new revision. Earlier revisions stay: pick one from the version list to see it as it was approved.
Payment allocations
By the date each allocation was made. Every row is money moving from one place to another: from a patient's account into a site, or from a site to the practitioner or sundry that earned it. Each row shows the date, where the money came from and went to, the patient whose payment it was, the plan (for a Dentally payment, its Dentally payment plan by name; otherwise the treatment's price list), the treatment or item, and the amount under Patient account, Site, Practitioner and Sundry — taken out of the column it came from and added to the one it went to. So a column's total is its net movement over the window: a site that took in £1,000 and passed £800 on to practitioners shows £200.
If your practice is connected to Dentally, a patient Dentally holds is read from Dentally's own allocations — the figures Dentally's Payment Allocations report shows — once Smileline has synced them. Every other patient is read from the Smileline ledger, where a payment goes straight to each charge it pays: to the charge's practitioner, to Sundry for a charge on a retail code or a manual charge, or to the charge's site when no practitioner earned it. A patient is never counted twice; the Recorded in column says which. An insurer's payment shows as coming from Insurer.
A reversed or refunded allocation is its own row, with the money going back, on the day it was made. Search finds a patient, a site, a practitioner or sundry, a plan or a description.
Payment allocation totals
The same allocations, added up for the window:
- Site movements — the money that came into your sites less what they passed on.
- Practitioners total and Sundries total — what was allocated to practitioners and to sundries.
The Per practitioner table splits each practitioner's allocations into Site — a patient's own money, through a site or straight from their account — and Other plans — money from anywhere else, such as a payment plan in Dentally or an insurer's payment in Smileline — with the Total. Anything taken back from a practitioner comes off their figures. Use it alongside Associate pay when paying associates.
Monthly accounts
What patients owe on invoices — your accounts receivable — when a month opens and closes, and what moved it. It opens on this month to date. Pick another month from the Month list beside the title: it lists this month and the 20 before it. When your practice is connected to Dentally, Updated beside it says when Smileline last read Dentally's invoices and allocations; the figures are as of then.
The chart at the top, From what patients owed on 1 …, walks the month from what was owed on its first day to what is owed now (or on its last day, for a month that has ended): Charges add to it, Charge adjustments change it, Payments and Payment adjustments take away from it. Beside the title, Collected is net payments as a share of net charges — green from 95%, amber from 80%, red below.
Totals by type splits the month into treatments and sundries:
- Opening owed and Closing owed — what was still owed on invoices when the month started and ended (today, for this month). Money held on a patient's account and not yet allocated to an invoice, such as a deposit, doesn't reduce it.
- Under Invoices: Charges — what was invoiced that month; Adjustments — changes that month to earlier months' charges, such as a reversed charge or a write-off; Net charges adds them up.
- Under Takings: Payments — money allocated to invoices that month from payments taken that month; Adjustments — money allocated that month from earlier payments, such as a deposit used against new treatment, less any allocation taken back; Net payments adds them up.
- Change — closing less opening owed. A rise shows in amber: you're building up unpaid invoices. A fall shows in green.
- Collected — net payments as a share of net charges.
By practitioner shows the same figures for the practitioner each charge is for, with Collected as a bar. The By month table, last, lists each month of the window on its own row. Each month adds up: closing owed is the opening plus net charges less net payments.
If your practice is connected to Dentally, a patient Dentally holds is read from Dentally's invoices and payment allocations, as Dentally's own Monthly Accounts reads them; everyone else from the Smileline ledger. What's owed is what Dentally says each invoice still owes. Dentally doesn't keep a history of what an invoice was before it changed, so Smileline records each month's figures on the first day of the next. A month from before Smileline started recording is rebuilt from today's figures: a later change to one of its invoices shows in that month rather than as a later month's adjustment. The Figures column of the By month table says which months are Final, Recorded late (Smileline could only record them after the first day, so they include changes made since) and Rebuilt from today's figures. Nothing dated after today counts.
To keep a copy, click the PDF icon (Export PDF) beside the title. Smileline opens your browser's print dialog with the month as shown — the chart in its colours, the tables wrapped to the page, landscape, with the month and Updated beside the title; choose Save as PDF there. See Print or save as PDF.
Chair utilisation
Appointment time booked and attended against the time each practitioner's rota makes bookable: working hours minus breaks, blocks and approved absences, day by day in the rota's time zone. Booked utilisation is booked time divided by bookable time; attended utilisation divides the time of appointments marked attended instead. Cancelled and no-show appointments do not count as booked.
The By period table lists each day, week or month of the window: booked time, bookable time, the Difference (chair time still free) and the booked percentage — the figures Dentally's Chair Utilisation shows, with your rota's bookable time where Dentally asks you to type in a number of practitioners and weekly hours.
A practitioner without a rota shows booked and attended time but no bookable time, so their utilisation is blank until the rota is set up under Settings → Practitioners.
Sundries
What you sold that isn't treatment, by ledger entry date like Production:
- Goods by code — charges on codes set up as Retail in the clinical catalogue, whether charged as a treatment or imported as retail, with how many, the amount and the tax within it.
- Manual charges — every manual charge, one row at a time, with its date, description, patient, amount, tax and who posted it. They load a page at a time; click Load more for the next page.
Treatment never counts as a sundry, and a retail item recorded but never charged doesn't count. Manual charges here equals Production's Manual, and the goods charged as treatment are part of Production's Procedures, so the two reports reconcile. A reversed sale comes off on the day of the reversal.
Invoice timeline
The last twelve months of invoices, whatever dates you pick: each month's invoices, by the day they were issued, split into what has been Paid and what is still Unpaid today, as a chart and a table. If your practice is connected to Dentally, a patient Dentally holds is read from Dentally's own invoices, as its Invoice Timeline shows them; everyone else from the invoices issued in Smileline.
Invoices
Every invoice and credit note issued in the window, by issue date. For each invoice:
- Paid in cash — what payments and insurance payments have paid on it, and Settled by credit — what discounts, write-offs and moved credit have settled. Both are today's figures, so they grow as the invoice is paid. A refund doesn't undo what its payment paid; it shows on Collections.
- Last payment — the date of the most recent payment towards it.
- Still owed — what is left. An invoice whose account has closed shows that amount as Balance moved instead: it moved with the patient to their new account.
- Credited by — the credit note that took it back and its date; Voided — the reason and date for an invoice withdrawn any other way.
- Imported — whether it came from your practice management system.
The tiles add up Invoiced (invoices that stand, and those a credit note took back), Paid in cash, Settled by credit, Still owed and Credited (the credit notes issued). An invoice voided without a credit note is listed but not counted. Each payment to a charge counts once, however many payments it took.
The rows load a page at a time; click Load more for the next page.
Two filters narrow the invoices — the tiles, By site and the rows alike:
- State — Paid keeps the invoices that stand with nothing left to pay; Unpaid keeps those with something still owed, including a Balance moved. A credit note, and an invoice it took back or one voided another way, is neither, so picking a state leaves them out.
- Account — the patient's account as it stands today: In debit (it owes the practice), In credit (it holds credit) or Settled (neither). It reads each account as Patient accounts does, so for a patient Dentally holds it's Dentally's own balance.
Neither filter applies to Charges with no tax rate.
Charges with no tax rate
Charges with no tax rate lists the charges in the window whose tax treatment has no rate at their site — a code set to standard rate at a site whose country has no standard rate in Smileline, for example. They were posted with no tax, and an invoice with one is refused. To correct one, fix the code's Tax treatment in the clinical catalogue, then reverse the charge and charge it again. A corrected charge leaves the list.
Patient reports
New patients per month, age groups, birthdays and lapsed patients — from Smileline's records or Dentally's.
Clinical reports
Radiograph audit (UK), perio coverage, treatment completed, lab turnaround, prescriptions issued, new patient visits and referrals — counted from the clinical record.