• Solutions for Every Building, Every Stakeholder

    URBI is the first Building OS powered by HERO AI. Whether you manage properties, own them, or operate them day to day, URBI transforms complex, disconnected workflows into a single, intelligent platform that drives efficiency and builds stronger communities.

    Role Benefits

    • For Property ManagersStreamline operations and enhance tenant satisfaction with centralized management tools.
    • For Building OperatorsSimplify daily tasks and maintenance with intelligent automation and workflow management.
    • For OwnersMaximize ROI and property value with comprehensive oversight and analytics.
    • For Finance TeamsClose faster with double entry books, trust accounting, and reconciliation that runs nightly.
    • For BusinessesConnect with building communities and expand your service offerings.

    Building Benefits

    • Residential BuildingsSimplify living with one app for bookings, packages, payments, and community updates.
    • Commercial BuildingsStreamline operations, vendors, and compliance while giving tenants a frictionless experience.
    • Education BuildingsManage facilities, visitors, and compliance for safer, smarter, more connected campuses.
    • Senior LivingAnswer families around the clock, publish life enrichment once, and see every community on one screen.
  • One Platform. Smarter Buildings.

    URBI centralizes daily operations and adds AI intelligence to transform complexity into clarity.

    Products

    • URBI KoreThe central hub where managers, owners, and staff run building operations in one place.
    • URBI KonnectA marketplace that connects buildings with trusted vendors, services, and community events.
    • URBI AccountingAI consolidation, invoices and receipts processed by AI, books pre reconciled before month end. In Beta.
    • URBI AIOne intelligence across URBI. HERO answers your team's questions, Arthur answers your community's calls, texts, and emails 24/7.

    Features

    • Operations & Workflow
    • Amenities & Booking
    • Events & Ticketing
    • Communication & Community
    • Payments & Transactions
    • Data & Compliance
    • HERO AI Intelligence
    • IoT & Hardware Integration
    • Community Experience
    • Accounting (In Beta)
    View All
  • Customers
    • All ResourcesGuides, support, and customer stories in one place
    • Help CenterGuides and answers for every part of URBI
    • BlogWhy URBI works the way it does
    • ReleasesEvery update we ship, in plain language
    • System StatusHow every part of URBI is running right now
    • About UsLearn about our story and mission
    • MilestonesHow URBI got here and where it is going
    • CareersWe're HiringJoin our growing team
    • FAQStraight answers about URBI, HERO and Arthur
    • ContactGet in touch with us

Schedule a Demo

  1. Help Center
  2. /URBI Kore Accounting
  3. /Banking and Payments
  4. /How the National Bank daily file keeps your reconciliation up to date

How the National Bank daily file keeps your reconciliation up to date

For a National Bank account that URBI reads from the bank's daily file, you no longer upload statements. Every business morning the bank's file brings in the previous day's transactions as bank...

Last updated November 18, 2026

URBI Kore Accounting
    • Accounting Settings: Overview
    • Accounting Settings: Troubleshooting
    • Cash Basis vs Accrual Basis in Financial Reports
    • Credit card processing fees in the GL
    • How to Configure the Fiscal Year
    • How to Set the Reporting Basis and Budget Rollover
    • Refund troubleshooting
    • Unallocated Cash and the Suspense Row
    • What a card refund costs your property
    • What is new in accounting: bills, reports, and budgets
    • Where to Find Your Budget
    • Archiving Budgets and the Archived Section
    • Budgets: Overview
    • Editing the budget grid
    • Explaining your budget numbers
    • How to Activate a Budget
    • How to Adjust Budget Amounts by Percentage
    • How to Create a Budget
    • How to Create Groups
    • How to Duplicate, Rename, Archive, or Delete a Budget
    • How to Edit or Resume a Budget
    • How to Enter Amounts: Split or Monthly
    • How to Make a New Budget When One Is Already Active
    • How to Read Budget Performance and Variance
    • How to Reallocate Budget Funds
    • How to Use Spreadsheet Shortcuts
    • Modelling budget scenarios
    • Review and export budget performance
    • Starting a budget from last year
    • The AI Assist Tab
    • The Full-Page Budget Editor
    • Troubleshooting: Saving a Budget
    • Understanding the Budget Hierarchy
    • Why Can't I Activate This Budget?
    • Amending a contract's amount
    • Automatic payment and bank details
    • Billing Residents to the Reserve Fund
    • Bypassing board voting on a VARIABLE contract
    • Charging Back an Expense: The New Recovery Model
    • Choosing a Fund on a Journal Entry or a Payment
    • Choosing a Fund on an Expense
    • Choosing the payment date when you mark something paid
    • Choosing which account the money moved through
    • Contract approval and how it expires
    • Creating a recurring contract
    • Direct Deposit payout questions
    • Direct Deposit payouts
    • Enter a tax rate as a percentage
    • Expense Actions Now Update Instantly
    • Expense and Invoice Void Reliability: Overview
    • Expense System, Troubleshooting
    • Expense System: Frequently Asked Questions
    • Expenses: Dates, Payment References, and Refunds
    • FAQ and troubleshooting
    • Find and use HERO Bills
    • Finding voided expenses
    • For board members
    • Funds: FAQ
    • How a Reserve Expense Posts
    • How to Approve Expenses
    • How to Confirm Expense Actions
    • How to Create a Journal Entry With the Assistant
    • How to Create an Expense
    • How to Create and Manage Reimbursements
    • How to filter Expenses: Bills, Reimbursements and Cheques
    • How to Forward a Receipt by Email
    • How to Record an Expense From a Receipt the Assistant Read
    • How to Require a Board Decision on an Expense
    • How to Review Journal Entry Details
    • How to Set Up a Receipt Email Address
    • How to Set Up the Approval Chain
    • How to Void Invoices
    • If a review rejects something that is already paid
    • Pay several bills at once by Direct Deposit payout
    • Paying an expense from any account
    • Paying instantly when you record a direct payment or quick expense
    • Paying several bills at once
    • Reading the Scheduled tab
    • Recording a Vendor Bill
    • Recurring contracts and board-decision tagging
    • Releasing a bill for payment
    • Renewing an expired contract
    • Reserve in Budgets and Reports
    • Reviewing a HERO-scanned receipt
    • Saving an expense as a template
    • Set up Direct Deposit payouts
    • Setting Up Reserve Spending
    • Tagging an expense to a board decision
    • Tax on an expense and the tax recoverable line
    • The Expense System: Overview
    • Track a Direct Deposit payout
    • Troubleshooting Email Receipts
    • Troubleshooting Expense and Invoice Voids
    • Troubleshooting Funds
    • Understanding recurring contracts
    • Using the Inbound Email Log
    • Voiding an expense
    • Weekly Reminder for Bills Waiting for Review
    • What a Fund Is
    • What approvers see: the commitment summary
    • What changed for bank matching rules
    • What the review step means now
    • AI Assist for Balancing Your Accounts
    • Amenity and Event GL Posting: FAQ
    • Amenity and Event Payments: Automatic GL Posting
    • Attribute Manual-GL Income to a Resident or Unit: Overview
    • Choosing Vendors and Marking Plain Ledger Lines
    • Claiming, releasing, or forfeiting a deposit
    • Closing an Accounting Period
    • Correcting a Journal Entry Keeps Linked Payments and Invoices in Sync
    • Deciding Who an Incoming Payment Is From
    • Delete a Draft Journal Entry
    • Deleting or Deactivating a Chart of Accounts Row: Overview
    • Deposit notices: who is told and when
    • Deposit payouts: how kept deposits reach your bank
    • Draft Journal Entry Deletion FAQ
    • FAQ: Deleting or Deactivating a GL Account
    • FAQ: GL Account Management
    • FAQ: GL Void & Locked-Period Policy
    • FAQ: Recurring Journal Entries
    • FAQ: Why did my payment look detached after correcting a GL entry?
    • Filtering the General Ledger
    • Following a Payment to Its Invoices
    • Former Payer Balances
    • General Ledger and Invoice Display: Overview
    • GL Account Management: Overview
    • GL Period Close: Frequently Asked Questions
    • GL Void & Locked-Period Policy: Overview
    • How a Manual Amenity Booking Posts to Your Books
    • How Deferred Deposits Post to Your Books
    • How deposit money moves: the accounting behind keep and return
    • How the Card Processing Fee Works in Amenity and Event Booking Accounting
    • How to Create a GL Account
    • How to Create a Recurring Journal Entry Schedule
    • How to Delete a Draft Journal Entry
    • How to Delete or Deactivate a GL Account
    • How to Edit a GL Account
    • How to filter General Ledger entries
    • How to Filter the Ledger with the Summary Cards
    • How to Fix an Entry in a Closed or Locked Period
    • How to Import Your Accounting History
    • How to Manage Account Groups
    • How to Reconcile and Close a Cash Account
    • How to Record an Income Journal Entry and Attribute It to a Unit or Member
    • How to Reopen a Closed Period or Account
    • How to Reverse an Import
    • How to Review Drafts and Use Run Now
    • How to Set a GL Account's Opening Balance
    • How to View an Amenity Booking's Invoice from the Booking Drawer
    • How to Void a Journal Entry (Open Period)
    • Import Errors and What They Mean
    • Import History: Bringing Your Existing General Ledger into URBI
    • Import History: Troubleshooting
    • Importing a Previous Fiscal Year
    • Managing Import History
    • Mapping the Columns in a General Ledger File
    • Re-running Matching for a General Ledger Import
    • Reading the Colours on Journal Entries
    • Recording a security deposit
    • Recurring Journal Entries: Overview
    • Renewing a lease
    • Resolving General Ledger Accounts
    • Reviewing and Committing a General Ledger Import
    • See the transactions behind a report or budget figure
    • Setting up a lease with a deposit and first rent
    • Troubleshooting accounting drill down
    • Troubleshooting Draft Journal Entry Deletion
    • Troubleshooting: GL Void & Locked-Period Policy
    • Troubleshooting: Recurring Journal Entries
    • Understanding the Suspense Account (1900)
    • What's Blocking My Period Close?
    • Account Credit - What It Is and Where It Comes From
    • Applying Account Credit to an Invoice
    • Bank debit problems and what they mean
    • Bank debit rows that are refused or need confirming
    • Changing the Account on a Draft Invoice
    • Charges in the Transaction Center
    • Charges: common questions
    • Choosing a billing day and End of month
    • Choosing How Tax Is Added to a Charge
    • Choosing properties and reading totals on accounting screens
    • Choosing Which Account an Invoice Posts To
    • Choosing Which Invoices a Payment Covers
    • Choosing your dates and launch settings
    • Combined payments, accounting and refunds
    • Condo Fee Billing Activation - Overview
    • Condo Fee Owner and Billing Defaults - FAQ
    • Condo Fee Owner and Billing Defaults - Overview
    • Declaring that you already hold signed agreements
    • FAQ: Invoice Debit Account
    • Filtering and Searching Transactions
    • Forwarded Invoices and Where Payments Land
    • Forwarded Invoices: Troubleshooting
    • Frequently asked questions
    • How bank debit agreements work in a bulk upload
    • How to assign or change a unit's primary billing account holder
    • How to create an invoice from a unit
    • How to edit a repeating charge
    • How to filter Collections
    • How to filter transactions with the search bar
    • How to Refund a Payment on an Invoice
    • How to set up condo fees with an Owner
    • How to stop or end a repeating charge
    • How to void or delete a charge on a unit
    • Invoice Debit Account: Overview
    • Matching units and choosing who pays
    • Preparing your bank details spreadsheet
    • Preparing your fee and lease spreadsheet
    • Primary Billing Account Holder, FAQ
    • Primary Billing Account Holder, Overview
    • Problems matching units and leases
    • Problems sending messages to residents
    • Problems with amounts, fees and dates
    • Problems with payers and email addresses
    • Problems with permissions and access
    • Problems with the file you uploaded
    • Reading Forwarded Splits on an Invoice
    • Reading the error report, row by row
    • Recording an Invoice That Was Already Paid
    • Refunding as Account Credit, and What Happens to the Card Fee
    • Resident combined payments, staff overview
    • Sending the messages to residents
    • Setting up condo fees: the three billing modes
    • Setting Up Tax Rates
    • Start here: uploading fees, leases and bank debit agreements
    • Tax on Recurring Charges - Overview
    • The staff declaration, and bank debit problems your residents report
    • The unit Accounting tab
    • Troubleshooting the unit Accounting tab
    • Understanding declined charges
    • Uploading fees, leases and bank debit agreements in bulk: overview
    • Uploading your fees and leases, step by step
    • What every status means, and what stops you committing
    • What exists after you commit, and what you can still change
    • What happens to condo fees on move-out
    • What Tax Looks Like on an Invoice
    • What you need before you start
    • What your residents and owners see
    • When something changed while you were working
    • Banking and Reconciliation: Overview
    • Cheque Alignment Guides, Overview
    • Cheque controls and the Cheques register
    • Cheque Printing: Overview
    • Collecting fees by pre-authorized debit
    • How the National Bank daily file keeps your reconciliation up to date
    • How to Add a Manual Bank Account
    • How to Add National Bank Numbers
    • How to Calibrate and Print a Cheque
    • How to Connect a Bank Account
    • How to filter bank lines on Bank reconciliation
    • How to find a cheque, and what to do when it is locked
    • How to Import a Bank Statement
    • How to Match Transactions
    • How to Reconcile a Statement
    • How to review late bank items
    • How to Set Up Cheque Alignment With the Guides
    • How to Set Up Reconciliation Rules
    • Match a Bank Withdrawal to a Bill You Have Already Paid
    • Printing a batch of cheques
    • Record Money That Arrived in Your Bank Account
    • Tie a Refund to a Bank Line
    • Troubleshooting: Banking and Reconciliation
    • Backfilling your fiscal year
    • Connecting QuickBooks Online to URBI
    • Disconnecting and reconnecting QuickBooks
    • Handling Drift: Using Re-push to Restore
    • How the QuickBooks Online Sync Works
    • Mapping your accounts to QuickBooks
    • QuickBooks Notifications You Will Receive
    • QuickBooks Period Reconciliation Checkpoints
    • QuickBooks Shortcuts and Where to Find Things
    • Reading QuickBooks Sync Status: The Sync Pill
    • Reconnecting a Broken QuickBooks Connection
    • Understanding QuickBooks Sync States and Errors: A Glossary
    • Understanding the post-connect wizard
    • Using the Sync Console and Retrying Failed Transactions
    • What Syncs to QuickBooks Online: Reference
    • When a QuickBooks Checkpoint Goes Stale (and How to Refresh It)
    • AI insights on your accounting reports
    • Answer board questions on the page
    • Ask a question on a page
    • Budget, Cash Flow & Governance Reports
    • Build a board package
    • Build the agenda for a board meeting
    • Choose which columns a report shows
    • Core financial reports
    • Estoppel statements and combined accounts
    • Exporting Reports to PDF, Excel and CSV, and Generating Statements in Bulk
    • Finish and sign the minutes
    • How to ask a question about a report
    • How to issue an estoppel statement for one or two accounts
    • How to read, check and regenerate insights
    • Leasing & occupancy reports
    • Payables & vendor reports
    • Read a board package and vote
    • Reading a statement and the Account Ledger
    • Receivables reports
    • Report figures corrected, September 2026
    • Review and share a board package
    • Run a live board meeting
    • Segment-specific reports (Condo / Commercial / Education)
    • Take the board package tour and practise a meeting
    • The Reports page
    • Troubleshooting AI insights and Ask
    • Troubleshooting estoppel statements
    • Two new registry reports
    • Vote in a live board meeting
    • Who can open accounting reports
    • How the Expense Category Sets Itself
    • How to Add a Vendor
    • How to Archive a Vendor
    • How to Edit a Vendor
    • How to Find a Vendor
    • How to Invite a Vendor Contact to the Vendor Portal
    • How to Request Tax Info from a Vendor
    • How to Set a Vendor's Expense Category
    • Managing Vendors from Accounting
    • Merging duplicate vendor records
    • Troubleshooting Vendor Management
    • Vendor credits
    • Vendor Management: Frequently Asked Questions
    • Where Some Settings Cards Moved
    • Previewing What Is Owed
    • Settling a Departing Owner's Balance: Overview
    • Taking the Payment
    • The Household List and "Also Leaving"
    • Troubleshooting
    • What Happens to Bills After Settlement
    • Who Can Do This
All collections

On this page

  • Which accounts use it
  • Who can use it
  • Find the worksheet
  • Read the worksheet
  • When a file is late
  • When the balance does not follow on
  • Add a transaction the file missed
  • Things you cannot do on these accounts
  • Finalize the month

For a National Bank account that URBI reads from the bank's daily file, you no longer upload statements. Every business morning the bank's file brings in the previous day's transactions as bank lines, URBI matches them with your existing reconciliation rules the same day, and the month's reconciliation worksheet fills itself from the bank's own balances. Your job is to check the worksheet, add anything the bank file missed, and finalize the month.

Which accounts use it

URBI sets up the daily file with National Bank for your property's account. There is nothing to turn on in URBI. If you would like a National Bank account read this way, contact URBI support.

Only Canadian dollar transactions are brought in from the file.

Who can use it

  • Anyone with General Ledger view access for the property can open the worksheet and see the daily file status.
  • Adding a missing transaction and finalizing the month need the same access as any reconciliation: General Ledger Full access (edit, delete and reconcile).

Find the worksheet

  1. Go to Accounting, open the General Ledger page and click Reconciliation.
  2. On the Periods tab, the Source column shows Daily file · through a date for months filled by the daily file, and Statement upload for months reconciled from an uploaded statement.
  3. Open the Reconciliations tab and pick the account. Each month has one worksheet. The next month's worksheet opens by itself on the 1st.

At the top of the worksheet, a blue banner confirms the account is updated daily from the National Bank file and names the last day received.

The Reconciliations tab with the banner Updated daily from the National Bank file, through Nov 13, 2026, and the Finalize period button

Read the worksheet

The summary shows Beginning, Cleared, Bank balance from the file (with the date of the latest file) and Difference. The bank balance always comes from the bank's file, so you never type it.

Below the summary, Daily files shows one box per day of the month:

  • File received (green): the day's file arrived, with the number of lines it brought in.
  • No file expected (grey): a weekend or a bank holiday.
  • File late (amber): the file for that business day has not arrived yet.
  • Balance does not follow on (red): the bank's opening balance for that day does not equal the previous day's closing balance plus the day's transactions.

A worksheet with the balance banner, the summary showing the bank balance from the file and a difference of $0.00, and the Daily files strip for November

When a file is late

Each business day's file is due by noon Eastern time, normally the next morning. Weekends and federal bank holidays expect no file.

If a file has not arrived by noon, the worksheet shows No file for that day yet and says when it was due, for example No file for Tue Nov 10 yet. It was due by noon Eastern on Nov 11. (when the file was due today, it reads It was due by noon Eastern today.), and the people at the property who can view the General Ledger are told. URBI keeps checking every 30 minutes, and the missing day and the days after it come in as soon as the bank sends them. If three business days in a row are missing, URBI support is told as well, so you do not need to chase it yourself.

If the bank's file arrived but could not be read, the alert says so, and URBI support is already working on it.

When the balance does not follow on

If the bank's balance moved with no matching transaction in the files (for example a bank charge or adjustment the file did not include), the worksheet shows a red banner naming the amount and the day. Add what is missing with Create transaction. Lines still come in as usual and nothing is corrected automatically.

Add a transaction the file missed

  1. On the worksheet, click Create transaction.
  2. Fill in the Date (inside the month), Amount, Direction, Fund, Offset GL account and Description.
  3. In Why is this being added?, explain the reason in at least 20 characters (up to 500). The counter under the field shows how many characters you have typed. Add transaction stays off until the reason is long enough.

The Create missing transaction form with Date, Amount, Direction, Fund, Offset GL account, Description and the required Why is this being added? field showing 0 / 20 minimum

  1. Click Add transaction. The new line appears on the worksheet already ticked as cleared.

The added line is marked Added by hand with your name, the time and your reason, so the next person can see why it is there. The worksheet's history lists both the daily file reads and the transactions added by hand.

A worksheet line Bank adjustment with the Added by hand label, the person's name and time, and the reason underneath

Things you cannot do on these accounts

  • Upload statement is turned off for the account. Hover over it to see why: the account is read from the National Bank daily file, and anything the file missed is added with Create transaction.
  • A worksheet cannot be started by hand or discarded. The daily file opens each month's worksheet for you.

Finalize the month

  1. When the Difference is $0.00, click Finalize period.
  2. Read the After you finalize note, then confirm. If late items from an earlier month are still waiting, the window says how many and offers Open Late items. They never stop you finalizing.

The Finalize this period window with Lines cleared, a Difference of $0.00 and the Ending balance, the After you finalize November note, and a notice that 3 late items are waiting for review with an Open Late items link

A month can be finalized once the bank file for the next business day has arrived, because that file confirms the month's last balance. If you try earlier, URBI tells you the month cannot be finalized yet and to try again after the next file arrives (it normally arrives in the morning).

If an earlier month was reopened (for example to match a late item in its own month), the next month's worksheet says so, for example October is reopened. Finalize October first to carry its closing balance into November. Finalize the earlier month again, and its closing balance becomes the next month's beginning balance.

A red notice on the November worksheet reading October is reopened. Finalize October first to carry its closing balance into November.

After you finalize, a bank item dated in that month that arrives later is never added to the finished month. It is kept in Late items for you to decide what to do with it. See How to review late bank items.

Was this article helpful?

Related articles

URBI Kore Accounting

How to Add National Bank Numbers

Collections and Payouts move money through a National Bank account, so URBI needs that account's institution, transit and account numbers before either can be set up. This is a one-time step per...

Read
URBI Kore Accounting

How to filter bank lines on Bank reconciliation

The Bank reconciliation page uses the same filter bar as the other accounting screens. Here it narrows the Bank lines list, and its Property filter picks the property you are reconciling. Who can use...

Read
URBI Kore Accounting

Banking and Reconciliation: Overview

Banking and Reconciliation connects your property's operating bank account to URBI so you can match transactions to expenses and Stripe settlements, set up rules to handle recurring items...

Read
URBI Kore Accounting

How to Add a Manual Bank Account

If your property does not use a live bank connection - or a particular account should be reconciled by uploading statements instead - you can add it as a manual bank account. This is available on...

Read
All URBI Kore Accounting articlesAsk the URBI team
URBI

URBI is the Building OS, founded in Calgary in 2023. One platform with HERO AI built in, running thousands of units for property managers, condo boards and owners.

Solutions

  • All Solutions
  • For Property Managers
  • For Building Operators
  • For Owners
  • For Finance Teams
  • For Businesses

Building Benefits

  • Residential Buildings
  • Commercial Buildings
  • Education Buildings
  • Senior Living

Products

  • All Products
  • URBI Kore
  • URBI Konnect
  • URBI AI
  • URBI Accounting (Beta)

Company

  • About URBI
  • About Us
  • Milestones
  • Reviews
  • FAQ
  • CareersWe're Hiring
  • Contact

Resources

  • All Resources
  • Help Center
  • Blog
  • Releases
  • System Status
  • FAQ
  • For AI assistants

Compare

  • Compare Us to Residential
  • Compare Us to Commercial
  • Compare Us to K-12

Legal

  • Security & Privacy
  • Terms & Conditions
  • Terms of Service for Konnect

© 2026 URBI. All rights reserved.

Privacy PolicyTerms of Service

Schedule a Demo