Home Credit Card Reconciliation

Credit Card Reconciliation

CleverBalance automates credit card reconciliation by matching statements with books to detect missing expenses, duplicates, errors, and timing gaps—replacing manual Excel processes.
By Vishwesh Sarkar
• 37 articles

How do I run a new credit card reconciliation?

Short Answer: On the Reconciliations page, confirm 'Reconciliation type' is 'Credit card reconciliation' then click '+ New reconciliation' to begin a new run. PreRequisites 1. Be signed in to CleverBalance 2. Open the Reconciliations page (look for the 'Reconciliations' heading and the text 'View past reconciliations or run a new one.') Steps 1. Open the Reconciliations page and confirm you see the heading 'Reconciliations'. You see the filter row and the '+ New reconciliation' button. 2. Click the 'Reconciliation type' dropdown and make sure 'Credit card reconciliation' is selected. The field shows 'Credit card reconciliation'. 3. Optionally set 'Reconciliation for' and 'Run by' to narrow or broaden the scope (for example, 'All reconciliations' and 'All users'). 'Reconciliation for' and 'Run by' reflect your chosen filters. 4. Click '+ New reconciliation'. The new reconciliation workflow opens and you can follow on-screen prompts to run the reconciliation. Troubleshooting 1. Clicking '+ New reconciliation' does nothing or no new workflow appears. LikelyCause: Temporary UI error, network issue, or your account lacks creation permission. Action: Refresh the page, try again, and if it still fails sign out/in. If the button remains inactive, ask your account administrator about reconciliation permissions. 2. You ran a reconciliation but still see 'No reconciliations found'. LikelyCause: Your filters are too narrow or the run hasn't finished/been recorded yet. Action: Set 'Reconciliation for' to 'All reconciliations' and 'Run by' to 'All users', wait a few minutes, then refresh the page. Note: If you are unsure which filters to use, start with 'All reconciliations' and 'All users' to see everything.

Last updated on Apr 29, 2026

The '+ New reconciliation' button is missing or not clickable — what should I do?

Short Answer: If '+ New reconciliation' is missing or inactive, refresh the page and confirm you're signed in and on the Reconciliations page; if it persists, you may not have permission to create reconciliations. PreRequisites 1. Be signed in to CleverBalance 2. Open the Reconciliations page Steps 1. Confirm you are on the Reconciliations page and look for '+ New reconciliation' in the top-right area. Either the '+ New reconciliation' button is visible or it is not. 2. Refresh the page (browser reload) and try again. The button reappears if the issue was temporary. 3. Sign out and sign back in to refresh your session, then check the page again. Authentication issues are resolved if the session had expired. 4. If the button still does not appear or is not clickable, contact your account administrator to confirm you have rights to create reconciliations. Administrator can confirm permissions or resolve account settings. Troubleshooting 1. Button missing only in one browser. LikelyCause: Local browser issue (extensions, caching). Action: Try a different browser or disable extensions, then reload the page. 2. Button visible but clicking does nothing. LikelyCause: Temporary UI or network error or insufficient permissions. Action: Refresh, sign out/in, and if the problem persists ask your administrator to verify permissions. Note: The screenshot shows the '+ New reconciliation' button in orange at the top-right when available.

Last updated on Apr 29, 2026

How do I start a new credit card reconciliation?

Short Answer: Select 'Credit card reconciliation', upload the Credit card statement and Books files, enter the 'Credit card account name', then click 'Run reconciliation'. PreRequisites 1. Be signed in to your account 2. Have your credit card statement file ready (CSV, XLS, XLSX; ≤ 10MB) 3. Have your Books / Books of accounts file ready (CSV, XLS, XLSX; ≤ 10MB) Steps 1. Open the 'New reconciliation' page. Page header 'New reconciliation' and instructions are visible. 2. Under 'Select reconciliation type', confirm 'Credit card reconciliation' is selected (shows 'Credit card statement vs books'). Correct reconciliation type is selected. 3. In the 'Credit card statement' panel, drag & drop your statement file or click 'Edit' to replace an existing file. The panel shows the uploaded filename 4. In the 'Books / Books of accounts' panel, drag & drop your Books file or click 'Upload file'. The Books file appears in the panel. 5. Enter the credit card account name into the 'Credit card account name' field. The field displays the name you typed. 6. Click 'Run reconciliation' (top-right) to start the process. The system begins reconciliation and may prompt you to map required fields. Troubleshooting 1. Clicking 'Run reconciliation' does nothing. LikelyCause: One or both files are not uploaded, or the account name is empty. Action: Upload both files and fill the 'Credit card account name', then retry. 2. A file upload is rejected. LikelyCause: Unsupported format or file exceeds 10MB. Action: Convert to CSV/XLS/XLSX and ensure size ≤ 10MB, then upload again. 3. Wrong file uploaded to the wrong panel. LikelyCause: Files were placed incorrectly. Action: Use 'Edit' in the Credit card statement panel to replace it, and re-upload the correct file in the Books panel. Note: If you're new, use 'New here? Schedule a 10-min guided setup →' under the page subtitle for a walkthrough.

Last updated on Apr 29, 2026

How do I upload or replace the Credit card statement file?

Short Answer: Drag & drop the statement into the 'Credit card statement' box or click 'Edit' in that panel to replace the file; use CSV, XLS, or XLSX and keep file ≤ 10MB. PreRequisites 1. Be signed in 2. Have the statement file in a supported format (CSV, XLS, XLSX) 3. Ensure file size is ≤ 10MB Steps 1. Open the 'New reconciliation' page and find the 'Credit card statement' panel. 'Credit card statement' panel with a dashed upload area is visible. 2. To upload a new file, drag & drop your statement into the dashed box. The file uploads and is displayed with the filename. 3. To replace an existing file, click 'Edit' in the 'Credit card statement' panel and select the new file. The panel updates to show the newly uploaded statement filename. 4. Confirm the displayed filename (example: 'Amex_Credit CardStatement_.xlsx'). The correct file name appears under 'Credit card statement'. Troubleshooting 1. Upload fails or shows an error message. LikelyCause: Unsupported file format or file exceeds the 10MB limit. Action: Convert the file to CSV/XLS/XLSX and reduce the size to ≤ 10MB, then try again. 2. The 'Edit' link isn't visible. LikelyCause: Page didn't finish loading or you may lack permissions. Action: Refresh the page. If 'Edit' still doesn't appear, check your account permissions or contact your administrator. Note: Uploaded credit card statement should appear under 'Credit card statement' with the filename.

Last updated on Apr 29, 2026

How do I map my file columns to the required fields for reconciliation?

Short Answer: Use the 'Required fields' panel to set 'Header row', pick the 'Transaction date', choose 'Date format', map 'Description / Narration', select 'Amount representation', then click 'Save & apply'. PreRequisites 1. Your statement file is loaded and visible in 'Data preview (20 rows)' 2. You can identify column names in the preview (e.g., Post Date, Trans Date, Description) Steps 1. Open the Configure credit card statement modal. You see 'Data preview (20 rows)' and the 'Required fields' panel. 2. Set '1. Header row' to the row number containing your column headers. Column names align correctly in the preview. 3. Under '2. Transaction date', choose the column with transaction dates (e.g., Post Date). This column becomes the date source. 4. Set '3. Date format' by choosing First / Second / Third value (Day / Month / Year) to match your file. Dates parse correctly based on your selection. 5. In '4. Description / Narration', select one or more fields (e.g., Description, Reference, Category). These fields combine to form the narration. 6. Under '5. Amount representation', choose: - Single signed amount column, or - Separate credit and debit columns Then select the correct 'Amount column' (e.g., Debit (USD)). 1. Review the 'Formatted preview (first 5 rows)'. Preview shows how dates, descriptions, and amounts will appear. 2. Click 'Save & apply' to confirm mapping or 'Cancel' to discard. Mappings are applied and the dialog closes. Troubleshooting 1. Dates appear incorrect in preview. LikelyCause: Wrong date format order. Action: Adjust First / Second / Third value to match your file (e.g., Day → Month → Year). 2. Description is empty or incomplete. LikelyCause: Incorrect or missing fields selected. Action: Update selections under 'Description / Narration' and recheck preview. 3. Amounts are missing or incorrect. LikelyCause: Wrong amount representation or column. Action: Select the correct representation and choose the proper Amount column. 4. Columns look misaligned or incorrect. LikelyCause: Wrong Header row selected. Action: Set the correct header row and verify column labels in preview. Note: Always validate using 'Formatted preview (first 5 rows)' before clicking 'Save & apply' to avoid mapping errors.

Last updated on Apr 29, 2026

Why are amounts missing or not recognized in the preview?

Short Answer: Confirm '5. Amount representation' matches your file (single signed column vs separate credit/debit) and that the correct 'Amount column' is selected. PreRequisites 1. You can see the amount columns in 'Data preview (20 rows)' 2. You have selected an amount representation option Steps 1. Open '5. Amount representation' and confirm how your file stores amounts: - Single signed amount column (positive/negative values), or - Separate credit and debit columns The correct option should be selected. 1. If using Single signed amount column, verify the 'Amount column' dropdown is set to the correct column (e.g., 'Debit (USD)'). The selected column should match what you see in the preview. 2. Check 'Formatted preview (first 5 rows)' to confirm amounts appear correctly. Preview should show numeric values with correct signs. 3. If amounts are still missing, verify the 'Header row' so column names are recognized properly. Correct column recognition ensures amounts appear. Troubleshooting 1. Amounts appear as text or are blank. LikelyCause: Selected column does not contain numeric values or header row is incorrect. Action: Ensure the column contains numbers, fix the Header row, and reselect the correct Amount column. 2. Positive/negative signs are incorrect. LikelyCause: Wrong amount representation selected. Action: Switch between Single signed amount column and Separate credit/debit columns, then recheck the preview. Note: Choose the column that truly represents transaction amounts (e.g., 'Debit (USD)' or equivalent in your file) to ensure accurate reconciliation.

Last updated on Apr 29, 2026

Why are transaction dates parsed incorrectly or showing the wrong day/month/year?

Short Answer: Check that you've selected the correct 'Transaction date' column, the correct 'Header row', and the right order under '3. Date format' (First/Second/Third value). PreRequisites 1. You can view the original date strings in 'Data preview (20 rows)' 2. You have access to the '3. Date format' controls Steps 1. Confirm the correct column is selected under '2. Transaction date' (for example 'Post Date'). The transaction date column matches the preview column containing dates. 2. Verify 'Header row' points to the correct header row so column names are detected properly. Column headers display correctly in the data preview. 3. Set the '3. Date format' 'First value', 'Second value', and 'Third value' to match the order shown in the date text (Day, Month, Year or other). Date format matches the string structure of your dates. 4. Check 'Formatted preview (first 5 rows)' to confirm that dates now appear correctly. Preview shows correctly parsed dates. Troubleshooting 1. Dates still incorrect after changing format. LikelyCause: Date strings include unexpected separators or nonstandard text (e.g., time stamps or notes in the same cell). Action: Inspect the original file to ensure the date column contains only date values in a consistent format, then re-import or correct the source file so the date parser can apply the chosen format. Note: The helper text 'Select the order of day, month, and year in your date column.' is shown under 'Date format'.

Last updated on Apr 29, 2026

How do I view individual transactions and the 'Individual transactions breakdown'?

Short Answer: Expand grouped rows (e.g., 'Multiple transactions (2)') or click the row caret to reveal the 'Individual transactions breakdown' in the table. PreRequisites 1. On the reconciliation report page with the table visible 2. The correct tab selected (Matched / Unmatched / Skipped) Steps 1. Ensure the correct tab is selected (e.g., 'Matched'). The table shows rows for that category, including grouped rows like 'Multiple transactions (2)'. 2. Locate a grouped row such as 'Multiple transactions (2) Click to collapse details' and click the row or caret to expand/collapse. 'Individual transactions breakdown' rows appear or collapse beneath the grouped row. 3. To inspect a specific transaction further, click the right-hand arrow (>) if present. Row-level details or deeper transaction info appears (if supported). Troubleshooting 1. Grouped row does not expand or already shows 'Click to collapse details'. LikelyCause: The row is already expanded or UI did not respond. Action: Click again to toggle, or refresh the page if needed. 2. Individual transactions don’t show expected amounts. LikelyCause: Grouped rows may include offsetting entries (e.g., positive and negative values summing to zero). Action: Review each line in 'Individual transactions breakdown' to understand adjustments. Note: Grouped rows help you understand how multiple statement entries map to book entries—expand them for detailed, line-level reconciliation.

Last updated on Apr 29, 2026