Bayable

Reports

The five groups of reports, how parameters work, Excel, PDF, CSV and print, the activity log, and the corporate reports across facilities.

Facilities → Reports has 51 reports in five tabs, with a search box across all of them. Each report has the same shape: tiles with the headline numbers, one or more tables (grouped, subtotalled, totalled), charts, and notes on how the numbers are counted.

The groups

  • Financial (22) – Aging, Rent Roll, General Ledger (summary, by day, detail), Transaction Log, Payments by Type (and detail), Close of Day, Daily Summary, Reconciliation, Refunds, Sales Tax Collected, Prepaid Balances, Rent Rates by Tenant, Annual Revenue and Occupancy, Autopay Roll, Bad Debt Write-Offs, Credits Issued, Discounts, Fees Waived and the Facility Ledger.
  • Insurance (4) – Insurance Status, Insured Tenants Roll, Insurance Statement, Insurance Activity.
  • Management (5) – Management Summary (the one-page monthly), Move-In KPI, Consolidated Occupancy across facilities, the Activity Log and Lien Auctions.
  • Merchandise (2) – Merchandise Sales Detail, Inventory On Hand.
  • Occupancy (18) – Occupancy and Occupancy Summary, Movement Summary, Move-Ins / Move-Outs / Transfers, Delinquency Stages, Auction / Lien Schedule, Gate Access, Lead Activity, Length of Stay, Tenants and the Tenant Contact List, Scheduled Move-Outs, Vacant Spaces, Walk Through, Lease Versions, Ledgers Without Signed Lease, Notes Roll, Moved Out With Balance.

Money in, money back – on the day it happened

The cash reports (Close of Day, Payments by Type, Daily Summary, the General Ledger, the Transaction Log, Refunds, the Facility Ledger) show each payment on the day it came in, in full, and money given back – a refund, a reversal, a chargeback, a bank debit returned, a check that bounced, a counter sale refunded – as its own line on the day it went. A day you've closed never changes afterwards. Walk-in counter sales count as cash and as merchandise sales tax. Days are your facility's own calendar days. Close of Day, Payments by Type, the General Ledger's cash lines, the Reconciliation's cash figures and the Management Summary's Collected this month are the same money and always agree.

  • How money went back. A refund handed over at the counter is filed under the way it was handed back – a cash payment refunded by check is a check given back, not cash out of the drawer – so the drawer count and the deposit slip match. A Stripe refund, reversal or chargeback goes back the way the money came in. A check that bounces after part of it was refunded comes back in full (what it still held and what had been handed out); what was handed out is charged back to the tenant on its own bill – money owed back, not income – and a Returned payment fee, if you charge one, is fee income.
  • Where it was taken. Payments by Type's By source counts cards taken on the card reader, by phone and in the office as Office (the Source column says which), autopay as Autopay, and only what tenants paid themselves as Online. Its Collected is net of what was given back, the same as Close of Day.

Aging puts each invoice's unpaid amount in the bucket of its own days late, so a tenant three months behind shows in three buckets, and it can be run as of any earlier date. Days late count from the due date – or from the day it was owed again when a chargeback reopened it, or from the day a charge was added to a bill already paid – as things stood on the day asked for: a bill paid in January and charged back or added to in February was simply owed since its due date on Dec 31, so last month's Aging doesn't lose it or re-count its days. Its Stage and Gate columns, the Management Summary's Delinquency table and Delinquency Stages (stage, since, days late, gate, overlock) show each rental as it stood at the end of that day too, rebuilt from the dated delinquency steps, the late-fee lines, the lien case and the gate activity – so a closed month's tables read the same after the tenant pays. Its gate column (like Delinquency Stages, the Lien Schedule, Gate Access and the Walk Through) is this facility's gate: a lock-out at another facility doesn't show here. Reconciliation rolls receivables forward from line to line on the days each change happened, to the cent.

What a payment paid – rent, sales tax, plans, fees – is split across the invoice's lines as they stood when it was paid, and that split never changes: a discount, void or refund later shows on its own day. So the rent and sales tax collected in a month you've filed stay the same. Money already on the account that's applied later moves from unapplied to income on that day (General Ledger by day and detail show it, with no cash side).

Charges, credits and voids – on the day they happened

Every report about what was billed or given – the Management Summary and Annual Revenue, Sales Tax, Credits Issued, Discounts, Fees Waived, Bad Debt, the Insurance Statement's premiums, the Transaction Log, the Facility Ledger and the Daily Summary's Charges added – dates each line by the day it went on a bill (a late fee or a credit on last month's bill counts today) and takes a voided invoice back on the day it was voided. So a month you've closed never changes when a bill is waived, voided or written off later; the month it happened in shows it.

  • Credits Issued – credits and waivers typed on bills, protection-plan refunds, a cheaper transfer's difference given back on a paid bill, and account credit when it's given (goodwill, plan refunds, transfer remainders). Account credit used on a later bill isn't a new credit; bad-debt write-offs, rent changes and promotions aren't credits (they're in Bad Debt and Discounts).
  • Discounts – promotions and hand-typed discounts. Account credit applied to a bill's rent is written as a price cut (a discount line with its own sales tax line) but it's credit used, not a discount given, so it isn't listed here.
  • Fees Waived – late, lien, returned-payment and admin fees waived or credited, and fees voided (a fee invoice, or the late fee on a bill voided at move-out) on the void day.
  • Bad Debt Write-Offs – balances written off (Write off on an invoice or the tenant's ledger) on the day they were written off, with the sales tax inside them; what was paid later under Recovered; a write-off taken back by voiding its invoice on the void day. Months cancelled at move-out and abandoned move-ins aren't bad debt. A space left by a transfer isn't a moved-out account while the tenant still rents.
  • Sales Tax Collected – tax billed (by line date), tax collected (cash basis), and per month the tax written off with bad debt (the deduction an accrual filer claims) and the tax recovered when a written-off balance is paid (it's also in tax collected). Account credit on a bill is a price cut: its share of the rent and the tax on it come off billed. With Sales tax on lien sales switched on (Settings → Billing), the Lien sales table lists the tax charged to each sale's buyer – collected for the state when the sale is completed, apart from rent tax and merchandise tax, and never the tenant's money. With Tax-exempt tenants switched on (Settings → Billing), Exempt sales shows what tax-exempt tenants were billed without tax, per month (rent, and merchandise on its own table), and the Tax-exempt tenants table lists each certificate valid in the period – tenant, certificate number, state, dates and their exempt sales – what a state auditor asks for. Rent paid on exempt bills is Exempt rent collected, not taxable rent collected.
  • Merchandise Sales Detail shows the sales tax charged on the period's sales next to the tax collected (money that came in for merchandise – a sale on a tenant's account counts when they pay it). A tenant's purchase whose invoice is voided comes off on the void day, as on the Sales Tax report, whose merchandise table splits the same way: billed (a tenant's purchase when it's charged, a walk-in sale when it's rung up) and collected. Account credit used on a purchase charged to the account (or a credit typed on its bill) is a price cut on the goods and their tax: the report shows the sale net of it, with the cuts listed under Credit applied on account purchases, so its sales and tax agree with the bill, the Sales Tax report and the General Ledger. Sale and return dates are your facility's days.

Transfers, prepaid money and the month end

  • Transfers between spaces are counted as transfers, not as a move-out and a move-in: the Management Summary, Daily Summary, Move-Ins, Move-Ins / Move-Outs / Transfers, Movement Summary, Annual Revenue, the Move-In KPI and the leads counts leave them out of move-ins and move-outs and show them on their own. The Rent Roll, Rent Rates, Length of Stay and Insurance Status keep the tenant's first move-in date. Insurance Activity shows a transfer as the plan carried over, and the Insurance Statement counts the tenant once.
  • Prepaid Balances – what each tenant holds on the account at the end of any day: money paid ahead (refundable), lien-sale proceeds held for them, and account credit (it pays the next bills, it isn't paid out) – and the moved-out tenants who are owed money back. A tenant with a reservation (or an online move-in not finished) open that day shows as Reserved for … / Move-in pending: money they paid on it is held for the move-in (its own tile), not owed back – it becomes refundable only if the reservation is cancelled or lapses. Its money total is the General Ledger's Prepaid / unapplied added up from the start; cash handed back from a check that then bounced is charged back to the tenant and shown in the ledger as Refunds charged back – owed by the tenant (a receivable) until they repay it, so it never pulls that liability below what tenants hold. The Rent Roll shows the same figure per tenant as On account; its Paid through is the date the tenant's page and receipts show (the months that money will pay included – twelve months paid ahead read as twelve months), with Bills paid through for the bills already issued. Scheduled Move-Outs and the Walk Through show the same paid-through date.
  • Security deposits (when the facility takes them): Security Deposits Held lists, at the end of any day, each rental's deposit and what of it is paid and held (owed back to the tenant – not income, and not on Prepaid Balances), with the deposits settled at move-outs that month: what paid the balance, what was kept and why, and what went back on the account to refund. Close of Day and Payments by Type show Security deposits collected as their own tile (part of the receipts, not revenue); the General Ledger carries Security deposits held as a liability – in when paid, out when a move-out applies, keeps or returns it – and Deposit kept as income; the Management Summary shows the deposits held at the month's end.
  • Management Summary for a past month shows occupancy, the rent roll and participation at the end of that month, from the rental history (rent as it was then, plans as they were then), so later move-outs and transfers don't change it. Its Revenue by category lists every kind billed and collected – sales tax on merchandise apart, bad-debt tax apart, and the money paid ahead that no bill has used yet – so the Collected column adds up to Collected this month.
  • Insurance Activity is the monthly premium report for your insurance program: every protection-plan premium collected in the month, one row per transaction, with premiums collected (debits) and premiums given back (credits) in separate columns and a net total. Prepaid money used on a bill counts in the month the bill was issued. Rows carry the facility, its program facility number, the insured's name, space and space type, coverage, transaction date and effective date.
  • Insured Tenants Roll lists everyone covered by a plan at any point in the month, paid up or not, with mailing address, phone and email, coverage, premium, effective date, cancellation date and paid-through date, and totals for insureds, coverage, new and cancelled insureds.
  • Both run for this facility or all facilities, and print the program facility number set under Corporate settings → Insurance.

Parameters

Reports take a date range, an as-of date, a month or a year, and sometimes a choice (space type, staff member, payment method) or a checkbox. Set them at the top and Run report; shortcuts fill today, yesterday, end of last month. The report header states the facility, address, range and when it was generated, in the facility's time zone.

Exporting and printing

  • Excel – one sheet per table with real number and date formats, frozen headers and filters, so pivoting works.
  • PDF – letter size, landscape where the report is wide, page x of y, the same charts as on screen.
  • CSV – for your accountant's software.
  • Print – a clean page without the admin around it.

Emailing a report on a schedule

Any report can be emailed automatically – Reports → Scheduled reports is the calendar of everything that goes out by itself, and the scheduler.

  • New schedule (or Schedule on any report, or the + on a calendar day) opens the scheduler: pick the report, say when, what it covers, and who gets it. A plain-language summary and the next run dates update as you choose.
  • When – daily (or every few days), weekly on any set of weekdays (every week or every 2–4 weeks), monthly on a day of the month / the nth weekday / the last day (every month or every few months), quarterly, yearly, or one time on a date. Every schedule has a time of day on the facility's clock, and optional start and end dates.
  • What it covers – by default the dates follow the rhythm (a daily report covers yesterday, a weekly one the past 7 days, a monthly one last month, a quarterly one last quarter, a yearly one last year). Or pick a period: yesterday, today so far, the past 7/30/90 days, last week, week / month / quarter / year to date, last month, last quarter, last year, the past 12 months. An "as of" report uses the day it runs. Fixed choices (a space type, a payment method) are kept as you set them.
  • Who gets it – one or more addresses, each with their own copy; Excel, PDF and/or CSV attached; an optional note in the email; an optional label for the schedule.
  • Calendar – month or week view shows each planned delivery as a chip (click to edit); List shows every schedule with its next run, last result and history. Up next lists the coming 30 days.
  • Send now sends an extra copy immediately (handy to check the result) without moving the schedule on; Pause keeps it without sending (resume any time); Remove deletes it. A one-time schedule switches itself off after it has gone.

Reports go out within the hour after their time, from the facility's own email address: an hourly check delivers what is due, the nightly run catches anything missed, and opening the admin also sends anything overdue. A delivery covers the day of its slot even when it goes out after midnight – an 11:30 pm Close of Day for "today" sent at 12:05 am is still the day before's, and that night's 11:30 pm slot still goes. A company-wide report sent by email covers the same facilities as on screen (hidden ones included). Managers and owners can schedule; staff see the calendar and the list.

Tenant names open the tenant; space numbers open the space; invoice numbers open the ledger entry. A total you don't believe can be traced in two clicks.

The activity log

Reports → Management → Activity Log (also under Corporate → Activity log) is every change in the system: who, when, what, with filters by actor and group (billing, rentals, gate, communication, settings) and export. It's where you answer "who changed this rate" and "when was that code switched off".

Corporate reports

Owners of several facilities run the same reports for all facilities from the corporate section: Consolidated Occupancy and the Management Summary roll up across facilities, and every facility report can be filtered to one facility or all. Consolidated Occupancy's tenant total counts a tenant who rents at two facilities once. See Corporate: several facilities, one company.