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.
Link a bank account
Owners and admins link accounts.
- Open Settings › Accounting and click Link a bank account.
- A window from Stripe, the payment provider Tec-Flows uses, opens. Choose your bank, sign in there and select the accounts to share.
- 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:
| State | Meaning |
|---|---|
| Connected | Working. New transactions arrive every day. |
| Needs relinking | The bank wants you to confirm access again. Link the account again. |
| Inactive | The bank stopped answering. Link the account again. |
| Disconnected | The 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
- Open Bank Reconciliation. The header shows the balance, how many lines are Reconciled, and the money in and out.
- 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.
- On an incoming line, click Assign to invoice. On an outgoing line, click Assign to expense.
- 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:
| Reason | What it means |
|---|---|
| Amount matches | The amount is exactly the document's total. |
| Number in purpose | The invoice or expense number appears in the payment reference. Spaces, dashes and capital letters do not matter. |
| Name in purpose | A word from the customer's or vendor's name appears in the payment reference. |
| Date fits | The document date is within 45 days of the payment. |
| Other currency | The 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
| Action | Who |
|---|---|
| See the statement and the matches | Everyone in the workshop |
| Match, unmatch, SmartMatch, sync | Owners, admins and the Billing role |
| Link, disconnect or remove accounts | Owners and admins |
See Team and permissions for the roles.