Reconcile my bank account
Here you match the bank statement with the book's entries.
How to
- Open Bank, then the account (or « Add an account »).
- Import the month's statement, check the preview, then « Import n lines ».
- Review the proposals: amount, date, invoice or account.
- Click « Validate selection » or « Validate all (n) ».
- Handle the rest by hand, or create a bank rule.
Learn more
Reconciliation explains the gap between the 521 account balance in the ledger and the statement balance. Comptia reads the statement, proposes for each line the existing entry, the open invoice to settle or the bank rule that applies, and posts nothing without your validation.
Import the statement
« Import statement »: PDF, Excel, CSV, CFONB 120 / 240 or MT940 (.pdf, .xlsx, .xls, .ods, .csv, .tsv, .sta, .txt). For a CFONB or MT940 file, Comptia checks that opening balance + transactions = closing balance on each statement: at the slightest gap the import is refused and the statement concerned is named; if the file holds several accounts, pick the one to import. For the other formats, title rows, balances, Debit / Credit columns, amounts like « 1 250 000,00 » and DD/MM/YYYY dates are recognised. A preview (lines read, period, money in, money out) shows before the import. For a scanned PDF, « Extract with AI » reads the pages; check the totals against the statement. Lines already imported are skipped. For a statement you type yourself, « Download the template » gives an Excel file (or « or as CSV ») with the columns Date, Description, Reference, Debit and Credit and a « Notes » sheet.
Money received with no invoice in Comptia
If you invoice in another tool, money received may have no invoice to match. On the line, « Create the sale » opens the form: Customer (or « New customer »), « Number of the invoice issued », VAT rate and Revenue account. « Create the sale and reconcile » records the sale (411, 70x, output VAT), its receipt on this account, and reconciles the line. The invoice is marked « Issued outside Comptia »: it is not certified again. For many sales, see « Import my sales invoiced in another tool ».
Right after the upload
As soon as a statement is uploaded (file or AI extraction), Comptia reconciles its lines that have an entry already posted for the same amount, within 3 days: it posts nothing, it only links. Then it computes the proposals of the other lines. The message shows « N lines imported · X reconciled automatically · Y proposals ready to validate · Z to handle ». « See the proposals » opens the « Automatic proposals » panel limited to the lines of this upload; « Show all » removes the filter. Uploading the same statement again, even twice at the same time (two tabs), adds no line and reconciles nothing twice. An entry is linked to one statement line only: to link it to another line by hand, first unmatch the first one.
Automatic proposals
The « Automatic proposals » panel lists the lines to reconcile that have a proposal: • Existing entry: same amount, within 3 days. • Customer receipt or Supplier payment, with automatic lettrage: the open invoice is settled and matched (invoice reference or third party named in the label, or the only open invoice of this amount). • Rule: suggested by a bank rule. • Settlement difference: when the book has a difference tolerance (Accounting settings), an invoice with a close amount is also proposed when the label names it or the customer; the difference is shown and posted with the payment (658 or 758 by default). Proposals marked « to check » (including those with a difference) stay out of « Validate all » and are validated one by one.
Lines without a proposal
In the account's « ⋯ » menu, « Exact match » matches identical amounts and « Match with AI » proposes matches to accept or reject. For a recurring transaction (fees, Mobile Money, rent), create a rule from the line: see « Bank rules ».
Undo a match
« Undo the match » puts the statement line back to reconcile. If the entry was created from this line, undoing alone would leave it in the books: the recommendation proposes to reverse it on its date, then undo the match, with one click on « Approve ». Above the book's approval threshold, the reversal waits for a second person and the line stays matched until then; once the reversal is approved, « Undo the match » works directly. A line covered by a completed reconciliation, or in a locked period, is not changed.
Frequently asked questions
Only existing entries are proposed; invoice settlement and rules do not apply.