Help with Credit Card reconciliation, please
Options
Xander
Member ✭✭
I have nearly 1800 transactions in my credit card file in Quicken for an account at Citibank, and the balance is off by a small amount. After many months of trouble with downloads, I think I am consistently downloading all amounts. Can anyone suggest an efficient method to compare the transactions in Quicken with Citi, so I can find the duplicates & the missing transactions and remove/enter them? I am happy to export to excel, but seek to avoid manually reviewing many hundreds of transactions. Thanks in advance, Community!
Tagged:
0
Best Answer
-
For that many transactions and since the balance is off by a small amount, trying to find where the errors are (yes, there could be multiple errors) would not, in my opinion, be worth the effort of trying to find them, especially if the other accounts (like the checking account used to pay your credit card bill) are already in balance.I would manually enter a balancing transaction for the amount your account is off:
- A charge transaction if the balance in your account is higher than what it really is.
- A payment transaction if the balance in your
account is lower than what it really is.
- For the Payee I've used
"Account Balancing".
- For the Category I've entered "Account Balancing" (Quicken then set up it up as a new category).
- If the account is now balanced, change the transaction status to "R" and you are done.
(Quicken Classic Premier Subscription: R55.26 on Windows 11)
5
Answers
-
For that many transactions and since the balance is off by a small amount, trying to find where the errors are (yes, there could be multiple errors) would not, in my opinion, be worth the effort of trying to find them, especially if the other accounts (like the checking account used to pay your credit card bill) are already in balance.I would manually enter a balancing transaction for the amount your account is off:
- A charge transaction if the balance in your account is higher than what it really is.
- A payment transaction if the balance in your
account is lower than what it really is.
- For the Payee I've used
"Account Balancing".
- For the Category I've entered "Account Balancing" (Quicken then set up it up as a new category).
- If the account is now balanced, change the transaction status to "R" and you are done.
(Quicken Classic Premier Subscription: R55.26 on Windows 11)
5
This discussion has been closed.