When dealing with a reconciliation issue, it’s best to start by looking backward. Often, discrepancies occur because something from a previous reconciliation was edited or voided.
Even if cleared checks and deposits match the statement, the account (Checkbook or Credit Card) may still not balance due to prior changes.
Step 1: Review Prior Reconciliation Activity
To identify potential issues:
Go to the Reconcile Checking/Credit Card tab
Select the appropriate account from the dropdown
Click on the History tab
Use this information to run a Transaction Search.
Transaction Search Criteria
Enter the following:
Account: The account you are trying to balance
Entry Date:
Start date: Several years back (the earlier, the better)
End date: Statement ending date from the last balanced reconciliation
Keyed Date:
Start date: One day after the Keyed Date from the Reconciliation History
End date: Today’s date (or far in the future)
What to Look For
Transactions returned in this search are considered “suspicious”:
Edited after reconciliation
Voided after reconciliation
These may need to be:
Re-entered
Corrected
Reviewed carefully
Step 2: Review Future Transactions
If no issues are found in the past, the next step is to look forward.
Run an Account Inquiry Report
To do this effectively:
Select one account at a time (do not set an Account Range)
Set the starting fiscal month to the month after your current reconciliation
Set the ending fiscal month far into the future
What to Check
Transactions posted to the incorrect date
Transactions posted to the incorrect fiscal month
Any unexpected or duplicate entries
Common Scenarios That Cause Issues
1. Incorrect Credit Card Vendor
Credit card payments must be made to the correct vendor (CC payee)
Check the Account Glossary for the correct payee
Verify bills in Bills & Invoices are assigned properly
2. Credit Card Used as Both Expense and Payment Account
If the credit card is used for both:
Expense account, and
“Pay With” account
➡️ The net effect becomes $0, and the transaction:
Will not appear in reconciliation
Should be corrected
3. Wrong Account Used for Payment
Payments must be applied to the correct credit card account
Using the wrong account:
Prevents proper reconciliation
Causes imbalance
Still Having Trouble?
If issues persist after reviewing both past and future transactions, & the common scenarios, additional help may be needed. You will want to first confirm that you're reconciling properly by referring to the helpful articles linked below. If you're comfortable with reconciliations, feel free to reach out to support@designmanager.com.
Credit Card Reconciliation
Checkbook Reconciliation
When reaching out to support, include:
Account name
Statement ending balance
Statement ending date
A copy of the statement
This will help resolve the issue more quickly.