Implementation Balance – CM Outstanding Entries

Getting Started #

If you have outstanding checks or other cash transactions that have not yet cleared the bank at the time of conversion, be sure to import these records to accurately reflect your uncleared balances.

Template Info #

  • Required Source Data
    • CMTransType
      • 0 – Adjustments
      • 1 – Checks
      • 2 – Deposits
    • Check #
    • Check Date
    • Description
    • Check Amount
  • Optional Source Data
    • N/A
  • Additional Tips
    • Make sure Adjustment and Check amounts are negative, and Deposit amounts are positive.
  • Basic Steps
    • Download TAD Template
    • Copy the Source Data
    • Import the Records
    • Post Open Batch
    • Validate Imported Data

Download TAD Template #

Open your source data file in Excel.

Click the Templates button on the left side of the ribbon.

If you’ve signed into TAD before, then you should receive the message below. Click Yes.

If you have not signed into TAD before, follow the Get Connected instructions.

Select the Implementation Balance – CM Outstanding Entries template.

Click the Download Selected button.

This template includes multiple tables, so make sure to check the Skip Remaining Parameter Entry box and click the Download button to download them all at once.

You’ll see multiple worksheets, as shown below.

The CM Outstanding Entry sheet is used to import the transactions.

The CM Accounts sheet is used to pull the Cash GL Account.

Copy the Source Data #

Copy and paste the source data into the CM Outstanding Entry sheet. If your source data layout matches the example above, this will be a single copy and paste since the CM Outstanding Entry columns are already in the same order.

Enter the CM Account in the CMAcct column. Refer to the CM Accounts worksheet if you’re unsure of the values.

Enter your Suspense or Clearing GL Account in the GLAcct column.

Import the Records #

Go to the CM Outstanding Entry worksheet.

Click the submenu of the Format Table button on the ribbon and choose the Regenerate Excel Formulas button. This will apply XLOOKUP and other formulas to multiple columns pulling default values from the CM Accounts worksheet.

The Mth column defaults to the current month. Update this value if you’re loading balances as of the prior month.

Click the Format Table button to format the data you copied and to apply missing default values.

The *Result column will show Formatted for every record. You will see the default Company number applied.

Click the Get Batch # button to assign the next batch number.

The *Result column will show Batch #XX Assigned for every record.

Click the Assign Batch Sequence button to assign a sequential value to each record.

The *Result column will show Batch Sequence Assigned for every record.

Click the Validate Import button.

The *Result column will show Validated for every record. If this says Failure, then the *ErrorMsg column will provide the error.

Click the Execute Import button.

The *Result column will show Imported for every record.

That completes all steps needed in TAD. You can now open the batch in Vista to validate and post.

Post Open Batch #

Before opening the CM Outstanding Entries batch, you need to turn off Interfacing to the General Ledger. This prevents the batch from posting GL activity, which we do not want when loading these balances.

In Vista, go to Cash Management → Programs → CM Company Parameters.

On the Info tab, write down your existing value for the GL Interface Level. Then select No Update, click Save and minimize the form.

Now you can open the batch in CM Outstanding Entries.

With the batch open, go to File → Process Batch, then click the Validate button followed by the Post button.

Once the batch posts, make sure to change your Interface Levels back to their normal values.

Validate Imported Data #

You can validate the Outstanding Entries by running the CM Transactions Report report in Vista.

Enter your Company, the CM Account and the Ending Month for the month that you just imported.

Make all other parameters look like the image below.

Verify the Total at the end of the report matches the transactions that you imported.