To reconcile payments in the Philippines you match every credit on your bank, GCash and Maya statements to an invoice number, record fees separately and list what remains unmatched. Do this weekly, not at year end, so overdue invoices appear while a polite reminder can still work.
A typical Philippine business receives bank transfers through InstaPay and PESONet, scans of QR Ph codes, GCash and Maya merchant payments, and cheques. Each channel delivers money at a different time, in a different amount after fees, and with a different reference format. A single monthly sale may therefore be spread across several statements.
Reconciliation is the discipline of tying every credit to an invoice and every invoice to a credit or an open balance. When it is done weekly, the open balance is a short list of customers to call. When it is done at year end, it is an archaeological dig.
Pick one weekday. Download the bank statement and the e-wallet reports, filter credits since the last run, and tick each against the invoice list by reference or amount. Move unmatched credits to a suspense list and unmatched invoices to the overdue list. Then post fees as expenses, not as reductions of the sale.
Assign the routine to one person and a back-up. Record the date, the opening and closing balances and the number of items left open, so that a manager can see at a glance whether the process is keeping up.
Customers rarely pay exactly as expected. One may send half now and half later, another may combine three invoices into one transfer, a third may forget the reference altogether. Allocate partial payments to a specific invoice by agreement, rather than defaulting to the oldest, because the allocation affects which invoice is shown as overdue and which VAT period is closed.
Where a customer withholds tax, the credit will be smaller than the invoice by the amount withheld. Match the net receipt, record the withholding receivable and wait for the Form 2307 certificate.
Set a ladder before you need it. Send a courtesy message a few days before the due date, a firm reminder on the due date, a call after a week and a written demand once the contractual grace period ends. Quote the invoice number, amount, due date and payment instructions in every message.
Late payment interest depends on the contract. If it is silent, the legal interest rate set by the Bangko Sentral may apply in suitable cases. For disputed amounts, document the dispute in writing and keep delivering on undisputed parts. Cheques returned by the bank trigger legal consequences under Batas Pambansa 22, so seek advice before acting.
A coaching business invoices forty clients in a month for amounts between PHP 4,500 and PHP 36,000. Twenty-six pay by bank transfer, eleven by GCash and three by cheque. At the weekly run the bookkeeper matches thirty-three payments by reference. Four have no reference but a unique amount, and two differ from the invoice by exactly the wallet fee.
One customer, a company, deducted tax and paid PHP 34,200 against a PHP 36,000 invoice, so the PHP 1,800 gap is a withholding receivable, not an underpayment. Recording that distinction prevents an unnecessary reminder from going out.
Post-dated cheques are common in Philippine commerce. Record them as received but not cleared, store them securely and deposit them on or after the date written. Do not count a cheque as cash until the bank confirms the credit, and track the ones that bounce separately.
A dishonoured cheque starts a legal clock for notice and demand under Batas Pambansa 22, so tell your lawyer quickly rather than waiting for the next monthly review. Keep the bank's return reason and the dates in the file.
A two-column list is enough to start: invoices open for less than thirty days, and invoices older than thirty days, with the customer name and the owner of the follow-up. Management then sees concentration risk, such as one customer holding forty percent of the balance, and can decide where to spend time.
Reconcile the list to the general ledger control account each month. If the totals differ, the cause is nearly always a payment posted without an invoice, a credit note missed in the list or a duplicate entry, all of which are easy to fix when found early.
Separate duties where possible: one person records receipts, another approves write-offs and credit notes. Review any credit note above a set amount, and look at the list of unmatched credits weekly. Small controls reduce the chance of a mistaken allocation turning into a dispute.
When a customer insists they have paid, ask for the payment reference or screenshot, then check the channel statement rather than the customer's version. Most disputes are solved in one exchange when both sides look at the same record.
4invoices.net issues PDF invoices and keeps an invoice archive, so the list you reconcile against is complete and searchable. It does not import bank statements, connect to GCash, Maya or banks, or match payments automatically. Matching stays in your bank tools or your accountant's software.
4notify.net can send SMS or e-mail messages that you write, which suits payment reminders. It has no scheduled ageing report or automatic dunning, so you choose when each message goes. 4softcrm.net can hold customer contacts and notes about promises to pay if you want one shared record of each conversation.
Matching bank statement lines to invoices manually takes three to four hours every week, with a growing backlog of unmatched items that distort the monthly debtor position.
Reconcile bank, GCash and Maya credits against your invoice archive using invoice numbers, in your bank's tools or your accountant's software. 4invoices does not import statements or match payments automatically.
Overdue customers are not chased systematically — follow-up depends on whoever remembers — stretching average debtor days and eroding cash flow.
Keep your own list of overdue customers and send SMS or e-mail reminders from 4notify when you decide to. Messages are written by you; there is no scheduled ageing report.
A customer pays two invoices with one transfer and no reference, and the bookkeeper allocates it to the oldest invoice by default.
Ask the customer for a remittance advice, allocate by agreement and note the basis. Keep the written confirmation with the receipt in your records.
Ask customers to put the invoice number in the payment reference, which InstaPay, PESONet and most banking apps allow. Without a reference, match by amount and date, then confirm with the customer. A short remittance advice from the customer settles doubtful cases. Record how you matched each payment so that the allocation can be explained later.
They are electronic fund transfer systems in the national retail payment network. InstaPay provides near real-time transfers for lower amounts, while PESONet settles in batches and suits larger or scheduled payments. Fees, limits and cut-off times differ by bank, so check with yours. Reconcile each channel separately, since settlement times and charges affect when funds appear on your statement.
Yes, cheques are still common among corporate buyers. A cheque is not payment until it clears. Issuing a cheque that is dishonoured for insufficient funds can carry criminal exposure under Batas Pambansa 22, and the payee must follow notice requirements before pursuing it. Seek legal advice before taking action, and keep the cheque, the bank return slip and your correspondence.
Record the full invoice amount as the sale and the fee as a separate expense, so VAT on the invoice stays correct. A sale of PHP 10,000 that arrives as PHP 9,750 after a fee is still a PHP 10,000 sale. Reconcile the wallet report to the bank deposit, as wallet balances are usually cashed out in batches.
Set stages in advance: a courtesy message before the due date, a reminder at due date, a firmer call after about a week, and a written demand after the period your contract allows. Check the payment terms and any interest clause before you send a demand. If the amount is significant, consult a lawyer on the options available, including small claims where the rules fit.
PDF invoices and an archive to reconcile against. Matching is done in your bank or accounting tool.
