Reconcile a bank account

Reconciliation compares what your bank says happened with what UnitConnect recorded. You bring in the bank's transactions — from a connected bank feed or an uploaded statement file — and then match each one to a ledger transaction, add the ones that are missing to the ledger, or ignore the ones that don't belong.

Before you start

Choose a transaction source

1. In the sidebar, click Banking and select the account.
2. Open the Reconciliation tab.
3. If the account has no source yet, choose one:
   • Connect a bank — sign in to your bank through the secure bank-connection window. Transactions then sync from the bank automatically.
   • Choose a connected bank — shown when your company already has bank connections. Pick the feed for this account, or choose Connect another bank.
   • Upload statement — import a statement file exported from your bank (see below).

Once a source is chosen, its name appears at the left of the toolbar. Click it to switch to another connected account, Re-sync this feed, Connect another bank, Upload a statement, Stop using this feed, or Disconnect the bank.

Stop using this feed takes only this account off the feed, which is how to undo a wrong pick. The bank stays connected for every other account. Disconnect ends a bank login for every account that uses it, and shows which accounts would stop syncing before it does. Neither deletes anything: the transactions brought in so far, and your matches, stay.

Connecting a bank again later, after a disconnect or when a connection can't be repaired, starts a new feed, and the bank sends its recent history again. Lines you already matched, added to the ledger or ignored aren't brought in a second time, and they still show with Show matched and Show ignored. Lines you hadn't reconciled come back, so you can still reconcile them.

While a newly connected bank is still sending its transactions, an hourglass next to Bank Transactions says it was just connected. They usually appear within a day, and the list updates on its own.

Your company can connect more than one login at the same bank, for accounts the first login doesn't show. Choose Connect another bank and sign in with the other login. If it shows accounts that aren't connected yet, it's kept beside the first and its accounts join the same list. If everything it shows is already connected, it isn't kept. With several logins at a bank, Disconnect asks which login to end, and the others keep syncing.

An account another bank account already uses says Used by and that account's name. Two bank accounts on one feed both get its transactions, and its monthly statements go only to the one whose account number on file matches, so this is usually the wrong pick.

Upload a statement file

Use this when your bank isn't available for a direct connection, or to reconcile an older period.

1. Click Upload (or Upload statement).
2. Click Choose a statement file and pick a CSV, TSV or TXT export from your bank.
3. Under Map columns, tell UnitConnect which column holds the Date, Description and amount. Use a single Amount column, or separate Credit (in) and Debit (out) columns. Check / Reference is optional.
4. Check the Preview, then click Import transactions.

The file is read in your browser; only the transaction rows are sent to UnitConnect.

Match transactions

The matcher shows two lists side by side: Bank Transactions on the left and Ledger Transactions on the right, for the dates you choose in the date filter.

1. Choose Debits or Credits. Money going out and money coming in are reconciled separately.
2. Hover over a row. Likely counterparts in the other list are highlighted: green for an Exact match (same date and amount) and amber for a Near match (within tolerance).
3. Select one or more rows on each side, then click Match selected (the = button between the lists). To select a run of rows, click the first one, then hold Shift and click the last. To match a single highlighted pair quickly, click the match badge that appears on the hovered row.
4. In Confirm match, review the pairs and click Match.

Matched rows show a Matched badge. The totals at the bottom of each list show the sum of all rows and of your current selection.

Add a missing transaction to the ledger

When the bank shows a transaction that UnitConnect doesn't have — a bank fee, for example:

1. Select the bank transaction(s) on the left.
2. Click Add to ledger (the → button), or right-click the row and choose Add to ledger.
3. For each transaction, choose How should this post?
   • When viewing debits: Expense (record and pay a vendor bill from this account), Deposit or Transfer.
   • When viewing credits: Withdrawal or Transfer.
4. Fill in the fields for that choice — for example Vendor · account and Category for an expense, Category for a deposit or withdrawal, or Destination account for a transfer.
5. Click Next to move to the next transaction, then Finish. The results list shows what was posted.

Ignore or undo

• Ignore / un-ignore selected (the eye button) marks transactions that should not be matched, such as duplicates. You can also right-click a row and choose Ignore transaction.
• Undo match (the undo button) removes the match from the selected matched rows so you can match them again.

Close the books when you're done

When everything for the dates on screen is matched in both directions, a green strip appears offering Close books through the end date. Click it to see each property that uses this account, check what each one still has outstanding, and close the ones you select. See Close the books.