For Singapore receivables teams: how NetSuite matches PayNow, GIRO and bank receipts to invoices, and how to treat the awkward ones.
Last reviewed: 25 October 2026. Product details reflect this review date. Availability and behavior can vary by account, role and release.
NetSuite cash application in Singapore starts with a bank statement import. PayNow, FAST and GIRO receipts arrive as bank lines, and Automated Cash Application matches each line to a customer and its open invoices. Most lines close in one step. Short payments, bank charges, USD receipts and prompt payment discounts each need a rule you set once.
Cash application is the work of matching money received to the customer invoices it pays. In NetSuite, that means a customer payment record applied to one or more invoices, and then matched to the line on your bank statement. Unapplied cash is money you have recorded against a customer but not yet tied to any invoice.
Singapore customers pay in a handful of ways. Each one leaves different clues on the bank line.
| How the customer pays | What the bank line usually shows | How it reaches NetSuite |
|---|---|---|
| PayNow to your UEN | Payer name and the reference the payer typed or the QR carried | Bank statement import |
| FAST or interbank transfer | Payer name and a short reference | Bank statement import |
| GIRO direct debit that you collect | Your own batch reference | Direct debit batch from Electronic Bank Payments, then the bank line |
| Overseas telegraphic transfer | Remitter name, the foreign currency amount and sometimes a bank charge | Bank statement import into the matching currency account |
The reference is the part you can control. When an invoice number reaches the bank line, NetSuite can match it exactly. Our post on what a PayNow receipt can tell NetSuite shows which fields banks pass through.
Most Singapore receipts follow the same five steps.
Mapping rules do the heavy lifting over time. When a customer pays from a company account with a different trading name, pick the right customer once and save a rule. NetSuite then remembers it for the next payment from that payer.
GIRO works the other way round. You start the collection, so the customer payments exist before the money lands. NetSuite builds the direct debit file through the Electronic Bank Payments SuiteApp, which includes Singapore formats such as DBS IDEAL DD and UOB BIB-IBG DD. The bank line then matches payments already in NetSuite.
Two details are worth knowing. Automated Cash Application handles one customer per bank line, so a single transfer for two related companies needs a manual split. And any amount left over stays unapplied on the payment until you apply it. Our NetSuite automated cash application guide walks through the match suggestion screens in more detail.
These four cases cause most of the leftover items in a Singapore receivables ledger. A hypothetical Singapore distributor with SGD as its base currency received the five payments below in one week. GST is 9 percent, and the invoice totals include it, except on the zero rated export.
A PayNow receipt of S$5,450 carries the reference INV10231. The invoice is S$5,000 plus S$450 GST. NetSuite matches the invoice number, applies the payment in full and clears the line.
A FAST transfer of S$10,355 pays INV10244 for S$10,900. The customer held back S$545 for one damaged carton, which is S$500 plus S$45 GST. Apply the S$10,355 and leave S$545 open with a note on the invoice.
If you accept the claim, issue a credit memo for S$500 plus GST so the GST comes back out too. Do not write it off as a discount.
An overseas customer pays INV10247 for S$3,270, but the banks take S$20 on the way. Your bank line shows S$3,250. Record the payment at the full S$3,270 on the Accept Customer Payments page.
Then, on Transactions > Bank > Match Bank Data, add a S$20 journal entry to your bank charges account. Match the bank line to the payment and the journal together. The invoice value does not change, so GST normally stays as invoiced.
A USD invoice for a zero rated export was US$8,000, booked at 1.3500, or S$10,800. The customer pays US$8,000 into your USD account when the rate is 1.3300, which is S$10,640. When the payment is applied, NetSuite posts the S$160 difference to your realized gain and loss account as an exchange loss. Nobody needs to calculate it by hand.
INV10250 is S$21,800, which is S$20,000 plus S$1,800 GST, on terms of 2 percent off for payment within 10 days. The customer pays S$21,364 on day 8. IRAS rules since 1 April 2020 say GST is due on the discounted price only when the customer takes up and meets the discount terms.
You then issue a credit note that reduces both the value and the GST. Here that credit memo is S$400 plus S$36 GST, or S$436. Apply it with the payment, and S$21,364 plus S$436 clears the S$21,800 in full.
NetSuite can create that credit memo for you. With SuiteTax, turn on Create Adjustment Transactions for Term Discounts in Accounting Preferences, and Include Tax When Calculating Term Discount for the Singapore nexus. NetSuite then creates the credit memo for the discount and its GST when the payment is saved.
If your account does not use these settings, enter the credit memo yourself with the standard rated tax code, so your GST F5 return stays right. Confirm the treatment with your tax adviser.
By Friday, four of the five lines were closed. Only the S$545 claim stayed open, with a reason and an owner.
Two more cases turn up most weeks. When a customer pays more than the invoice, NetSuite keeps the extra on the payment as an unapplied amount. Apply it to the customer's next invoice, or return it with a customer refund if they ask. Either way, tell the customer which one you chose, so their ledger agrees with yours.
An unknown payer is harder. The bank line has a name NetSuite cannot match and a reference such as "payment". Leave the line unmatched, ask your bank for the remitter details and check recent quotes and sales orders for the amount.
Set a limit, such as five working days, after which the line goes to the finance manager. Keep a short log of each open line, the date you asked the bank and who owns it, so anyone on the team can follow up. Do not park it on a random customer just to clear the screen, because it will surface later as a wrong balance on a statement.
My view is that most cash application problems start before the money arrives. The fix is upstream.
First, put the invoice number in every PayNow QR code and on every invoice as the payment reference. That one habit turns partial matches into exact ones. Second, import statements every working day, not at month end, so unknown payers are still easy to chase.
Third, review unapplied cash every week, using a saved search of payments with an unapplied amount. Our unapplied cash review checklist shows what to look for.
Fourth, write down a small difference policy. Agree the largest bank charge your team may absorb without asking, such as S$30, and who approves anything above it. For a fee your bank charges as its own line every month, turn your first match into an auto create rule on the Match Bank Data page. NetSuite then suggests the charge for future lines like it, so your team creates and submits each one in a click and only reviews the exceptions.
Keep duties apart as well. The person who applies cash should not approve credit memos. A second person who reviews the weekly unapplied cash search also catches payments applied to the wrong customer before statements go out. That is the same split you would build on the buying side with purchase requisition approval routing.
At CuriousRubik, we set up bank imports, matching rules and the GST treatment together, then test them with a month of real statements. CuriousRubik's finance and payments integration team can connect your Singapore bank files to NetSuite and tune the rules. Our NetSuite Singapore page explains how we work with local finance teams.
How to decide whether a short payment is a dispute, a deduction or a write off.
A checklist for clearing payments that sit unapplied on customer accounts.
Why matching bank lines and reconciling the statement are separate steps.