Tec-Flows

Bank reconciliation

Link your business bank account and match each line of the statement to the invoice or expense it pays.

Bank reconciliation puts your bank statement next to your paperwork. Every incoming payment is matched to the invoice it settles, every outgoing payment to the expense it pays, and a matched invoice is marked as paid on its own.

Linking accounts happens in Settings › Accounting. The matching happens on the Bank Reconciliation page in the sidebar, under Accounting.

Owners and admins link accounts.

  1. Open Settings › Accounting and click Link a bank account.
  2. A window from Stripe, the payment provider Tec-Flows uses, opens. Choose your bank, sign in there and select the accounts to share.
  3. Back in Tec-Flows, the accounts appear under Bank accounts and the first statement is fetched. If the bank is still preparing the history, Tec-Flows says so; sync again a moment later.

Stripe currently links US bank accounts only. Accounts at European banks cannot be linked yet.

Each linked account shows its balance, the time of the Last sync and one of these states:

StateMeaning
ConnectedWorking. New transactions arrive every day.
Needs relinkingThe bank wants you to confirm access again. Link the account again.
InactiveThe bank stopped answering. Link the account again.
DisconnectedThe connection was ended. The transactions and matches stay.

Keep the statement up to date

The bank reports new transactions once a day, and they appear without you doing anything. To fetch them now, click Sync now, either on the account in Settings or on the reconciliation page. Opening the reconciliation page also syncs, if the last sync was more than a few minutes ago.

Match a transaction

  1. Open Bank Reconciliation. The header shows the balance, how many lines are Reconciled, and the money in and out.
  2. Narrow the list if you like: pick an account, choose Open to see only unmatched lines, In or Out for the direction, or search by partner, purpose or amount.
  3. On an incoming line, click Assign to invoice. On an outgoing line, click Assign to expense.
  4. Under Choose the document, pick the right one. The best candidates come first, and the most likely one is marked Recommended.

The line now shows Matched with and the document's number. An invoice matched this way is marked as paid, and everyone in the workshop gets a notification.

Tec-Flows keeps the two sides apart: money coming in can only settle an invoice, money going out only an expense. Only sent and overdue invoices are offered, since a draft cannot have been paid, and a document that is already matched is not offered again.

Why a document is suggested

Each candidate shows the reasons it scored:

ReasonWhat it means
Amount matchesThe amount is exactly the document's total.
Number in purposeThe invoice or expense number appears in the payment reference. Spaces, dashes and capital letters do not matter.
Name in purposeA word from the customer's or vendor's name appears in the payment reference.
Date fitsThe document date is within 45 days of the payment.
Other currencyThe payment is in another currency. This counts against the match.

Common words are ignored when comparing names, such as legal forms (GmbH, UG) and words half your customers share, like "Kaffee", "Espresso" or "Café".

Let SmartMatch do the obvious ones

Click SmartMatch to match every line where there is no doubt. A line is matched automatically when the amount is exact, it is in your own currency, and either the document number or the name is in the payment reference, or no other open document has the same amount. When two documents fit equally well, SmartMatch leaves the line for you. A message tells you how many lines were matched.

Lines marked Pending have not been settled by the bank yet and can still change. SmartMatch skips them, but you can match them by hand.

Undo a match

Click Unmatch on the line. An invoice goes back to the status it had before, for example Overdue, unless someone has changed its status in the meantime or another payment also settles it.

Export a report

Export report (PDF) creates a summary and a list of the matched lines, exactly as filtered on screen. It is handy for your tax advisor.

Disconnect or remove an account

On the account in Settings › Accounting:

  • Disconnect stops new transactions. Everything already imported and matched stays.
  • Remove deletes the account and all its transactions from Tec-Flows. Invoices that were marked as paid stay paid.

Who can do what

ActionWho
See the statement and the matchesEveryone in the workshop
Match, unmatch, SmartMatch, syncOwners, admins and the Billing role
Link, disconnect or remove accountsOwners and admins

See Team and permissions for the roles.

On this page