Skip to Content
Cost IntelligenceCredit Card Reconciliation

Credit Card Reconciliation

Construction companies frequently use company credit cards for materials, tool rentals, and small purchases. TrueGrade’s reconciliation module lets you upload monthly statements and match each transaction to a project and cost code.

Uploading a Statement

Export your statement

Download a CSV or OFX export from your bank or card portal. Most major banks (Chase, Amex, Capital One, US Bank) offer CSV exports.

Import to TrueGrade

Navigate to Cost Intelligence → Reconciliation → Import Statement. Select your card account (or create a new card account) and upload the file.

TrueGrade parses the following columns from CSV:

  • Transaction date
  • Description (merchant name)
  • Amount
  • Transaction ID (for deduplication)

Review and match transactions

For each transaction, assign:

  • Project — which project this transaction belongs to
  • Cost code — the cost code to charge
  • Description — clarify the merchant description if needed
  • Receipt — upload the receipt PDF or photo

TrueGrade uses AI (if configured under AI Providers) to suggest project and cost code assignments based on merchant name and historical patterns. Suggestions are always editable before confirming.

Mark statement reconciled

Once all transactions are matched, click Mark Reconciled. Reconciled transactions are converted to Receipt type cost actuals and appear in budget reporting.

For recurring vendors (lumber yards, hardware stores), TrueGrade learns your matching preferences after a few transactions and suggests the same cost code automatically. This significantly reduces reconciliation time on monthly statements.

Managing Card Accounts

Add company card accounts under Cost Intelligence → Reconciliation → Card Accounts. Each account has:

  • Card name / last 4 digits
  • Cardholder name
  • Default project (optional — auto-assigns new transactions if all charges are for one project)

Excluding Personal Transactions

For cards that have mixed personal and business use, transactions can be marked Personal / Exclude. These are hidden from budget reporting and flagged in the reconciliation summary.

Reconciliation Summary

The reconciliation summary report shows:

  • Statement period
  • Total transactions imported
  • Transactions matched vs. unmatched
  • Total amount allocated to each project
  • Any transactions excluded as personal

This report is exportable as PDF for bookkeeper review.

Last updated on