Sign In

Sign in is required before the credit card reconciliation workspace can load data.

Google Sign-In will be enabled here once the Google client ID is configured for staging.
Not signed in.

JWCC Local-Only

Credit Card Reconciliation

This Phase 1 dashboard is intended for local browser access only, including SSH port forwarding to 127.0.0.1:3000.

Secure local access: ssh -L 3000:127.0.0.1:3000 your-user@your-host
Signed in

Workspace Actions

No action run yet.

Import Data

Choose an import type, then drag-drop or browse to select a file for import.
No job budget catalog has been imported yet. The upload form will fall back to historical combinations until a catalog is loaded.

Support Summary

As Yet Unmatched Airtable Rows

Entry Date Vendor Amount Cardholder Job Hint Notes

Raw Statement Summary

Provider Batches Transactions Earliest Latest

Imported Statement Batches

Provider File Statement Label Period Transactions

Exports

Export range will be calculated from your selected month, week, or custom dates.
Approved export inventory will appear here after the dashboard refreshes.
Posted JE records will appear here after a FOR JE export is downloaded.
Use Download Combined System XLSX to merge every provider into one proofing file for the selected date range. Leave Provider on All Providers when you want the combined result. For the final JE, leave Provider on All Providers and keep Row Scope on Approved Rows Only. Every FOR JE download is recorded with an index so it can later be marked as posted in Foundation. Once posted, those rows become canonical and leave the editable workflow. Row 2 in the workbook is the header row, and reviewed imports stamp your name/initials plus the upload timestamp into dedicated worksheet columns.
No override file selected.
After editing the Combined System XLSX, drag-drop the reviewed workbook here, or browse from your local computer, then import it as override truth.

Transaction Coding Queue

Approved Transaction Coding

Canonical Foundation Rows

Correction Requests

Airtable Review Queue

Spend History

Spend history totals will appear here.

Charges By Job

Charges By GL Code

Date Provider Cardholder Merchant Amount GL Job Job Name Cost Code Cost Class Description Basis

My Charges

New Charge / Receipt Upload

No local file selected.
Use this form to submit a new charge or vendor-on-account receipt entry.

Recent Upload Entries

Date Type Cardholder Job Cost Code Total Status Docs
Personal charge history will appear here after sign-in.
Posted Provider Merchant Amount Status Coding / Proposal Documents Source File

Vendor On Account Queue

Vendor on account entries will appear here after refresh.
Date Cardholder Job Cost Code Total Notes Docs Status Foundation TRX-Check

Administrative Panel

Administrative activity will appear here after refresh.

Access Events

When User Roles Provider Event Status IP

Upload Statuses

Uploaded Uploader Cardholder File Scan Review Storage

Cardholder Upload Entries

Created Uploader Cardholder Type Job Cost Code Total Status

Cardholder Charge Entries

Updated Submitter Cardholder Merchant Amount Proposed GL Job Cost Code

Vendor On Account / AP

Date Cardholder Job Cost Code Total AP Status Foundation TRX-Check Recorded By

Corrections

Requested Requested By Cardholder Merchant Status Assignment Resolved By

Data Browser

Select a credit card reconciliation table to inspect its rows.

Users

Roles

Access Control Matrix

User Administration

Select an existing user or choose Add New User.

Statement Tie-Out

No statement analysis run in this session.
Provider Period Previous Balance New Balance Recorded By Recorded At Status
Run Analyze Statement to review balances, cardholder summary, missing posted JE items, and transactions used before recording the statement.
Provider Period Previous Balance New Purchases Credits Payments New Balance Status