Bank reconciliation
Automatic bank reconciliation, from the statement to the bill
Reconciling means saying that a bank transaction and a payable or receivable are the same money: the electricity bill due on the 10th and the debit that left the account on the 9th. PhinApp looks for those pairs by itself after every import - and only confirms on its own what somebody has already authorised.
How PhinApp finds the pairs
After every import, of a statement or from the ERP, PhinApp compares the open bills with the transactions not reconciled yet:
- The same amount and nearby dates - for a bill the ERP already reports as paid, the date it looks for is the payment's, not the due date
- The document number: a transaction carrying one of the bill's numbers - the boleto's, the document's, the ERP code - is that bill's pair
- The partner: the name on the statement is compared with whoever the bill was raised against
- A suggestion nobody answered gives way when a pair with more evidence turns up
It confirms on its own only what was already decided
With automatic reconciliation on, a high-scoring pair is confirmed without asking when the partner has a default classification on that side - or when a classification rule allowed to reconcile on its own classified the transaction: how they are booked, somebody has already decided.
Everything else stays a suggestion, most likely first, on cards side by side - the bill on one side, the transaction on the other, with what it takes to decide: partner, document, due date, account and date.
Transfers and card bills, end to end
A transfer between two of your own accounts is recognised at both ends, and a card bill payment is linked to the current-account debit of the same day and amount. Neither becomes income or an expense: the money only changed accounts.
Undoing is one click - and it is remembered
An undone match or a declined suggestion does not come back on the next import: PhinApp keeps the refusal.
One payment that settled several bills
Rent and the condo fee on one boleto, three of a customer's invoices in one PIX: split the transaction across several bills - existing ones, at each one's amount, or new ones, with a partner and a classification. The parts must add up exactly to the transaction, and in the cash flow each part lands under its own classification.
Frequently asked questions
Do I need to connect my bank or give its password?
No. PhinApp reconciles from the files you already download from your bank - OFX, PDF, CSV or Excel - and never asks for your bank password.
What about a transaction with no bill behind it?
It shows as unreconciled. In a company without an ERP, the bill can be raised from the transaction itself, already reconciled, by choosing the classification and the partner.
Can I check everything before confirming?
Yes. With automatic reconciliation off, every pair stays a suggestion for you to confirm or decline.