Conducting The First Bank or Credit Card Reconciliation After Trial Balance Imports

In today's NetSuite guide, we’re going to discuss how to conduct the first bank or credit card reconciliation after trial balance imports.

Data Migration Approach for In-Transit Bank Transactions

Bank Rec Cutover

1. Load Last Trial Balance Journal for data migration – Make sure you have loaded the go-live historical balance JE before starting this step.

2. Create a Journal to offset (‘reverse’) the impact of the Uncleared Checks and Deposits in Transit to be entered in steps below. This can be accomplished in one summary journal; the amount equals the sum of all uncleared checks minus the sum of deposits in transit. Date should be the day prior to cutover.

If the Un-Cleared Checks Amount is greater than the Deposit in Transit

DR Bank Account

CR - Clearing Account

If the Deposit-in-Transit amount is greater than the Uncleared Checks Amount

DR - Clearing Account

CR - Bank Account

3. Conduct a Bank Reconciliation (Match Bank Data) for the date prior to go-live.

4. In the ‘Add Charges’ section, enter each individual check (data migration checks) to the Clearing account. Date should equal the day before cutover.

 5. In the ‘Add Deposits’ section, enter each deposit to the Clearing Account. Date should equal the day before cutover.

6. Clear the TB Import Transaction as well as the reverse entry created in Step 2.

7. For the newly added in-transit transactions added in steps 4 and 5:

1. • Leave transactions unmatched to be available for the first month’s reconciliation.

IMPORTANT: Leave the Data Migration checks and Deposits from Step 4 and Step 5 ‘unmatched’.

8. Complete the pre-go-live reconciliation by doing a reconciliation of the account statement transaction.

 9. In the reconciliation account statement, provide the following details:

2. • Statement Date – date prior to going
   • Set the Ending Statement Balance = Trial Balance Bank Account amount as of the day prior to go live + Un-Cleared Checks – Deposits in Transit amount. (This is also the bank statement balance)

10. The Difference field should be zero between the bank statement balance, the import balance, and the reverse entry. The Uncleared Checks and Deposits are ready to be reconciled at a later date.

11. Save. That's it. That's how you conduct the first bank or credit card reconciliation after trial balance imports in NetSuite.

Wrapping Up

As a highly accredited NetSuite Solution Provider, ScaleNorth is well-positioned to help you with the full scope of your NetSuite customization needs. If you require more NetSuite assistance, contact ScaleNorth today.

Check out more Suite Guides:

• How to Prevent Negative Inventory in NetSuite
• How to Determine if a Native NetSuite Page is Scriptable
• How to Bypass Location Limits in NetSuite