TSQ Close
Close Portfolio
Demo data · not connected to Supabase
{{ meName }}{{ meRole }}
Could not reach Supabase — showing demo data. {{ connectError }}
Your role could not be read, so you have accountant access only. {{ profileWhy }}

Sign in

Use the email and password from your Supabase account.

{{ loginError }}

{{ loginNote }}

Loading portfolio…
{{ actionError }}
🔒 {{ periodClosedBanner }}
{{ periodLabel }} is not open yet.

A manager opens the month from the Open month tab.
{{ k.label }} {{ k.value }} {{ k.value }} {{ k.sub }}
Status {{ bar.waiting.title }}{{ bar.blocked.title }}{{ bar.reconciling.title }}{{ bar.readyToPost.title }}{{ bar.awaitingTb.title }}{{ bar.reconciled.title }}{{ bar.inReview.title }}{{ bar.delivered.title }}
Communities{{ rowCount }}
Bulk assign to {{ bulkDone }}
{{ r.name }}{{ r.code }}{{ r.blocker }}
{{ r.mc }} {{ r.accName }}
{{ r.stateLabel }} {{ r.stateLabel }} {{ r.stateLabel }} {{ r.stateLabel }}
{{ r.due }}{{ r.due }} {{ r.elapsed }} {{ r.active }} {{ r.exceptions }}
View Open

No communities match these filters.
Accountants · {{ periodLabel }}
AccountantAssignedDeliveredOpenOverdueBlockedMedian activeProgress
{{ tm.name }}{{ tm.assigned }}{{ tm.delivered }}{{ tm.open }} {{ tm.overdue }}0 {{ tm.blocked }}{{ tm.medianActive }}
{{ tm.pct }}
By management company
Management companyCommunitiesDeliveredOverdueDue dayOn time
{{ bm.name }}{{ bm.total }}{{ bm.delivered }}{{ bm.overdue }}{{ bm.dueDay }}{{ bm.onTime }}

Onboard communities

One master sheet onboards the whole portfolio. Rows are matched by community_code: new codes are created, existing ones updated. Nothing is imported until you review the preview.

Only a manager can onboard communities.
{{ ch.name }} · {{ ch.help }}
{{ masterError }}
Bank accounts{{ bankPreviewSummary }}

Replaces the accounts of every community in this sheet. Only the last 4 digits are stored.

{{ be.text }}
Preview{{ previewSummary }}
{{ importError }}
LineActionCodeCommunityMCIssues
{{ pv.line }} SkipCreateUpdate {{ pv.code }}{{ pv.name }}{{ pv.mc }}
{{ e.text }}{{ w.text }}OK
{{ importResult }}
{{ missingText }}

Open {{ nextLabel }}

Creates one close per active community, assigned to its accountant, with the due date from its deadline rule. Bank ending balances from {{ prevLabel }} become the beginning balances — nobody types them again.

{{ os.label }}{{ os.value }}{{ os.sub }}

{{ openWarn }}
{{ openDone }}
{{ openForTitle }}{{ openForNote }}
Go to the close →
Open another month

For a past month a client asked to redo, or a month skipped. Existing closes are never touched.

{{ openPickNote }}
MonthsClose a month when it is delivered: its closes become read-only. Reopen it to correct a past month.
MonthClosesDeliveredPendingStatus
{{ mo.label }}{{ mo.total }}{{ mo.delivered }}{{ mo.pending }} 🔒 {{ mo.status }}{{ mo.status }}
Due dates for {{ nextLabel }}
Management companyCommunitiesBusiness dayDue
{{ ob.name }}{{ ob.count }}{{ ob.day }}{{ ob.due }}
Deadlines

The package is due on the Nth business day of the month after the period. Set it per management company; a community can override it.

CodeManagement companyCommunitiesBusiness day
{{ mr.code }}{{ mr.name }}{{ mr.count }} {{ mr.day }}
Demo data is stored in this browser only.