Prior to the Vendor In-Transit Payments feature rolled out in NetSuite version 2019.1, the accounting system would only show the date the payment was created as the date of the payment. Using In-transit Payments allows a more precise accounting by showing the payment across time by recording the date of your intent to pay funds and then confirming the date that a deposit happens at the vendor’s bank. This process has two unique phases:
Enter a bill payment as normal to track that a payment is being made. This record does not post to a bank account but temporarily posts to an interim, non-posting Cash-in-Transit account.
The In-Transit box is checked on this bill, so when saved the transaction status is “IN TRANSIT” and the Confirm or Decline button appear at the top of the page.
The G/L impact of this transaction is non-posting. Accounts Payable account is debited only after you receive notice that the payment amount has been received and deposited by the vendor’s bank. The payment status remains as In-Transit until you receive verification and mark the payment as Confirmed status.
A system journal is created which impacts the CIT and the Clearing Payments account that was created when the In-Transit feature was enabled.
In the next step, the bank processes the payment request.
When you download transactional data from your bank account or your bank sends you a statement or data with the processing results, import the transactions that detail disbursements and rejections.
Reconcile matched General Ledger transactions to clear the actual bank payments against your in-transit payment records.
In-transit payments are resolved in one of two ways:
When you receive verification from your bank account statement data that the payment funds have been processed by both banks and received by the vendor, you mark the payment as Confirmed. Payments can be cleared in your bank ledger as soon as they are confirmed, which assists users in completing bank reconciliations.
When confirmed, the payment amount is reconciled by moving funds out of the interim Cash-In-Transit account, updating the true payment cash account and A/P account. The payment record is then updated with the actual bank accounts’ posting dates and the payment status is updated.
After saving, the status on the bill payment will show as Confirmed.
A system journal is created which reverses the impact of the CIT and Payment Clearing accounts from when the payment was created. The original transaction now becomes a posting transaction which reduces the actual cash account and A/P.
If the bank encounters errors during processing, you can decline the payment and the funds are removed from the Cash-In-Transit account. The process workflow shown below details the transactional processing and G/L impacts made at each phase.
To start using In-Transit Payments in NetSuite, following these steps to enable and setup the feature:
In NetSuite OneWorld accounts, you can set a global preference to use one CIT account for in-transit payments in all subsidiaries, or each subsidiary can use a different CIT account.
If you’d like to learn more about In-Transit Vendor Payments or anything else about NetSuite, please contact us at any time! You can also learn about more great tips for NetSuite on our YouTube playlist or our other blog posts.
This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.