Skip to main content
Share / Export

Import and Code a Credit Card Statement

Create a billing-period statement for a saved card, import the file with the card’s template, then code every row (Job or GL) until the statement is fully coded.

Where: Mission Control → Company Tools → Credit Card Reconciliation
Route: /missioncontrol/tools/credit-card-recon (workbench: /missioncontrol/tools/credit-card-recon/:statementId)

Requires card setup — see Set up credit cards and import templates. For reusable match rules: Use coding rules for credit card recon. When fully coded: Approve and post credit card invoices.

Create and import a statement​

  1. On the card, create the next statement.
  2. In Create Next Statement:
    • Optional Statement Label
    • Statement Start and Statement End
    • Statement File (CSV, TSV, TXT, or XLSX)
  3. Click Import Statement.

The workbench opens on the Coding tab. Use Edit Statement later to change dates/label or append an Import File → Save Changes.

The card must have a default import template before import.

Workbench layout​

ControlPurpose
Back to CardsLeave the workbench
CodingImported rows and coding fields
SummaryGL Summary and Job Summary rollups
Status filter / Show split originalsNarrow the coding grid; optionally show original rows that were split
Apply ToBulk-code the currently filtered rows
ImportImport Coding from Export — apply coding from an export file
Primary actionSubmit / post (disabled until all rows are fully coded)

Coding saves as you edit (wait for saves before posting). Closed/posted statements lock coding.

Code rows manually​

On Coding:

  1. For each row, set Line Type to Job or GL.
  2. Complete the required Job fields (company, job, phase, cost type as shown) or GL fields (GLCo / GLAcct).
  3. Use the status filter to find uncoded or incomplete rows.

Every imported row must be fully coded before submit/post (“All imported rows must be fully coded before continuing.”).

Apply To filtered rows​

  1. Filter the grid to the rows you want to change.
  2. Click Apply To.
  3. In Apply To Filtered Rows, set Line Type and the Job or GL fields (or leave fields as no-change where offered).
  4. Apply the update to the filtered set.

Split a transaction​

When one bank/card charge must become multiple coded lines:

  1. Open the split dialog on the source row.
  2. Set Split Amount lines (quick even splits available). Totals must equal the original amount.
  3. Click Save Split.

Use Show split originals when you need to see the parent row again. Child lines are what you code and post.

Import coding from an export​

  1. Click Import.
  2. In Import Coding from Export, choose the Export File and complete the mapping/apply flow.

Use this when coding was prepared offline from a prior export of the statement grid.

Review Summary​

Open Summary:

  • GL Summary — totals by GL coding
  • Job Summary — totals by job coding

Lines without a line type are excluded from these rollups (the UI notes the count). Fix those on Coding before posting.

When coding is done​

All rows fully coded → primary action enables (Submit for Approval or Post Invoices, depending on approver). Continue in Approve and post credit card invoices.