The default list of categories is the common list that may show up on your credit card statement (Fees Charged, Interest Charged, Payments, Cash Advances, Balance Transfers, etc.). The categories that show up in the drop down lists in the table can be customized in the Settings worksheet. The Cleared Balance at the top of the worksheet includes only the transactions with a 'c' or 'R' so you can use that balance to compare to your statement. So keep that in mind as you are comparing to your official statement.Įnter an 'R' (for 'Reconciled') for those transactions that you have compared and matched to your statement. Like the account registers in the money management template and checkbook register, in this template a negative balance means you owe money. Your credit card statement will probably show your current balance as a positive number even though it represents an amount that you OWE.