Skip to main content
Share / Export

Set Up Bank Accounts and Import Templates

Save each Vista CM bank account once, assign its default import template, and optionally set an approver. Do this before you create statements.

Where: Mission Control → Company Tools → Bank Reconciliation
Route: /missioncontrol/tools/bank-reconciliation

See Company Tools workflow. After setup, use Import and match a bank statement.

Prerequisite: Select a team with Vista companies synced so CM accounts appear in the company lookup.

Home page layout​

AreaUse it to…
Account cardsOne card per saved bank account: title (CMACCT - name), company/account/GL, Approver, Open Statements, Closed Statements
Manage TemplatesOpen Manage Bank Import Templates without adding an account
Add Bank AccountEmpty state or dashed card — open Add Bank Account
Pencil on a cardEdit Bank Account (template and Hide PII; company/account are fixed after create)
+ on a cardCreate a statement (covered in the next guide)
Archive / trash on a cardArchive (if statements exist) or delete (if none). Disabled while the account has open statements

Create an import template​

Create templates from Manage Templates, or choose Create new template while adding an account (account save opens template creation and assigns the new template).

  1. Click Manage Templates.
  2. In Manage Bank Import Templates, click Add Template.
  3. Set Template Name.
  4. Set Amount Layout:
    • Single amount column — map Date and Amount (required).
    • Separate debit and credit columns — map Date, plus at least one of Debit Amount or Credit Amount.
  5. Upload a Sample Statement File (CSV, TSV, TXT, or XLSX) so column headers (or positions) populate the mapping dropdowns.
  6. Set Header Row (File includes column headers): on = row 1 is headers; off = map by column position.
  7. Map optional fields as needed: Type, Check Number / Reference, Payee, Memo.
  8. If you mapped Type, use Type Cross Reference to map raw file values to imported types (Adjust, Bank Fee, Check, Deposit, etc.), or leave Infer automatically.
  9. Click Save Template. Use Back to Templates to return to the list without saving.

Edit or delete existing templates from the same dialog (Edit / Delete). Delete is blocked until accounts using that template as default are reassigned.

Add a bank account​

  1. Click Add Bank Account.
  2. In Add Bank Account:
    • Company — search and select (required).
    • Bank Account — pick a CM account for that company (required).
    • Import Template — pick an existing template, or Create new template (required on create).
    • Optionally enable Hide PII to mask Outstanding payroll-check descriptions in the workbench cache.
  3. Click Add Bank Account.

Company and bank account cannot be changed later. To change the default template or Hide PII, open Edit Bank Account → Save Changes.

If Vista companies are empty, sync companies first—the dialog notes that CM accounts load from synced Vista companies.

Assign an approver (optional)​

On the account card under Approver:

  1. Open the assignee picker (Assign approver when none is set).
  2. Pick a team member, or No approver to clear.
ApproverPosting behavior
AssignedStatements must be submitted for approval before posting
No approver assignedStatements post directly when reconciliation is ready

Approver changes save immediately. Approval and posting steps are in Approve and post bank reconciliation.

Archive or delete an account​

  • No saved statements: trash removes the account (Delete Bank Account).
  • Has statements: archive hides it from the active list (Archive Bank Account); statements stay on file and return if the same account is added again.
  • Archive/delete controls are hidden while the account has open statements—close or delete those first.

Ready for statements​

When the account card shows the correct template (via edit if needed) and approver choice, use + (Create statement) on that card. Matching and clearing are covered in Import and match a bank statement.