No automatic journal from row
Adding a bank transaction does not by itself create income, expense or another accounting journal.
Bank reconciliation
Reconcile bank evidence against posted accounting journals
Keep statement data distinct from the ledger, then match each bank movement to the accounting record that explains it.
CSV/XLSX import Duplicate control Journal matching Reconciliation status
Reconciliation purpose
Make the bank statement and the books explain each other.
A ledger balance can differ from a statement because of missing entries, timing, fees or duplicate recording. Reconciliation is the control that surfaces those differences.
Triplem VIP keeps imported or manually entered bank statement rows separate from Accounting journals. That distinction matters: the statement is evidence from the bank, while the journal is the accounting record.
A bank row therefore does not silently become income or expense. Users review it and match it against a posted journal, preserving a visible reconciliation status.
EvidenceStatement rowsCSV/XLSX import or manual entry.
BooksPosted journalsThe formal accounting side of the comparison.
ControlMatch statusConnect statement evidence to the journal that explains it.
Reconciliation workflow
Import, review, match and report.
The workflow keeps bank evidence visible without bypassing the accounting ledger.
01Choose bank contextUse an Accounting cash or bank account where appropriate.
02Import or add rowsBring statement transactions from CSV/XLSX or enter them manually.
03Review duplicatesImported rows are checked for duplicate statement evidence.
04Match journalSelect the posted journal that explains the statement transaction.
05Review statusUse Bank Reconciliation Status to identify matched and unmatched rows.
Important controls
Reconciliation should explain differences, not manufacture entries.
The current design deliberately separates statement data from journal posting.
Duplicate detection
Imported statement rows include duplicate controls to reduce accidental re-import.
Explicit matching
A user deliberately connects a statement transaction to a posted journal.
Reviewable status
The reconciliation report shows date, description, reference, status, amount and matched journal.
Currency context
Statement rows retain their currency context while Accounting books also maintain a base currency.
Auditability
Reconciliation sits inside the Accounting workspace alongside the wider audit trail.
Example
A bank charge that exists on the statement but not yet in the ledger.
The statement row tells you something happened; the journal explains it in the books.
Illustrative bank fee journal
| Account | Reason | Debit | Credit |
|---|---|---|---|
| Bank Fees | Recognize the cost | 25.00 | 0.00 |
| Bank Account | Reduce bank asset | 0.00 | 25.00 |
After the journal is posted, the statement row can be matched to it.
Operational modules
Explore the wider Triplem VIP workspace beyond formal Accounting.
Loans, assets, notes and Bitcoin tools remain first-class operational modules and are not removed when Accounting ERP is introduced.
Loan management
Given, taken, repayments and settlement history.
Read guideAssets & depreciation
Acquisition, income, costs, depreciation, book value and reports.
Read guideNotes & reminders
Searchable notes and scheduled follow-ups.
Read guideBitcoin wallet tools
Watch-only, client-side wallet access, history and PDFs.
Read guide Questions
Practical questions about bank reconciliation.
The answers below describe the current Triplem VIP Accounting workspace and its present boundaries.
What does bank reconciliation do?
It compares statement-side bank activity with posted Accounting journals so unmatched or unexplained items can be identified.
Can I import a bank statement?
The current Accounting workspace supports CSV and XLSX statement-row import as well as manual bank-row entry.
Does importing a bank row create accounting income or expense?
No. A statement row is reconciliation evidence and does not create a journal by itself.
How are statement rows matched?
The current interface lets users select a posted journal and match it to the statement transaction. Imported rows also include duplicate-detection controls.