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
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.
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.
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 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:

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.
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.

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 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.

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.